CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Monday.com Data in Informatica PowerCenter
Create a simple Workflow for Monday.com in Informatica PowerCenter.
-
Automated Continuous Google Cloud Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Google BigQuery.
-
Automated Continuous QuickBooks Online Replication to AlloyDB
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to AlloyDB.
-
Provide OData Services of Vercel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Vercel by developing a WCF Service Application.
-
Access Live QuickBooks Online Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Online data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create ZohoInvoice Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoInvoice data access from reports, embedded analytics, and more.
-
Integrate SAP Netweaver Gateway Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Netweaver Gateway from Informatica Cloud.
-
How to Visualize PostgreSQL Data in Python with pandas
Use pandas and other modules to analyze and visualize live PostgreSQL in Python.
-
Connect AgileCRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AgileCRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Box Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Box replication to OneLake in Microsoft Fabric.
-
Create Power BI Reports on Real-Time Humanity Data
Use the CData ODBC Driver for Humanity to visualize Humanity in Power BI Desktop.
-
Integrating GitHub Copilot CLI with Templated via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Automated Continuous GitLab Replication to IBM DB2
Use CData Sync for automated, continuous, customizable GitLab replication to IBM DB2.
-
Use Databricks Agent Bricks to Talk to Your Square Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Square for you.
-
Replicate Multiple SendInBlue Accounts
Replicate multiple SendInBlue accounts to one or many databases.
-
Use the CData Software ODBC Driver for Presto in MicroStrategy Desktop
Connect to Presto in MicroStrategy Desktop using the CData Software ODBC Driver for Presto.
-
Provide OData Services of Cvent Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cvent by developing a WCF Service Application.
-
Access Live Tanda Data in Coginiti Pro
Connect to and query live Tanda from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Cloudflare in MicroStrategy Desktop
Connect to Cloudflare in MicroStrategy Desktop using the CData Software ODBC Driver for Cloudflare.
-
Build ZohoPeople-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoPeople.
-
Automated Continuous Azure Blob Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Google BigQuery.
-
Connect to AfterShip Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for AfterShip to connect to AfterShip and execute queries in PowerBuilder.
-
How to load PolarTeamPro data into Elasticsearch via Logstash
Introducing a simple method to load PolarTeamPro data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Consume Office 365 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Office 365 feeds that reflect any changes in SAP Lumira.
-
How to connect to Adobe Target Data in DBVisualizer
Integrate Adobe Target with visual data analysis tools and data connection wizards in DBVisualizer
-
Migrating data from SageHR to Google BigQuery using CData SSIS Components.
Easily push SageHR to Google BigQuery using the CData SSIS Tasks for SageHR and Google BigQuery.
-
Automated Continuous Cosmos DB Replication to MySQL
Use CData Sync for automated, continuous, customizable Cosmos DB replication to MySQL.
-
Automated Continuous Excel Replication to SQL Server
Use CData Sync for automated, continuous, customizable Excel replication to SQL Server.
-
Automated Continuous AdRoll Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AdRoll replication to delimited files (CSV/TSV).
-
Use the CData Software ODBC Driver for Elasticsearch in MicroStrategy
Connect to Elasticsearch in MicroStrategy Developer using the CData Software ODBC Driver for Elasticsearch.
-
Automated Continuous Recurly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Recurly replication to delimited files (CSV/TSV).
-
Connect to SingleStore Data in Aqua Data Studio
Access SingleStore from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Airtable-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Airtable to explore live Airtable Data in Gemini Code Assist to assist with building Airtable-powered applications.
-
Create SSAS Tabular Models from Nuclia Data
How to build a SQL Server Analysis Service Tabular Model from Nuclia using CData drivers.
-
Replicate Amazon S3 Data from PowerShell
Write a quick PowerShell script to query Amazon S3. Use connectivity to the live data to replicate Amazon S3 to SQL Server.
-
Automated Continuous Aweber Replication to Oracle
Use CData Sync for automated, continuous, customizable Aweber replication to Oracle.
-
Create Dynamic Recurly Grids Using the Infragistics XamDataGrid
Learn how you can connect Recurly to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Kiro CLI with Recurly Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Automated Continuous Dynamics NAV Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Databricks.
-
Build Hive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Hive and build web apps with connectivity to live Apache Hive.
-
Query Shopify Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Shopify and perform CRUD operations on Shopify from Node.js.
-
Analyze CockroachDB Data in Cognos Analytics
Use CData Connect AI to connect to CockroachDB Data from Cognos Analytics and analyze live CockroachDB.
-
Easily Integrate Mode Data in Lazarus Pascal IDE
Learn how to easily integrate live Mode in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating OpenCode Terminal with SAP Business One Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Build NetSuite-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for NetSuite Data and create custom apps in Mendix.
-
Natively Connect to Copper Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Copper. Leverage the native support for ODBC in PHP.
-
Freshservice Reporting in OBIEE with the Freshservice JDBC Driver
Deploy the Freshservice JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating LangGraph with Zoho Inventory Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoho Inventory within automated workflows.
-
Automate Office 365 Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Office 365 replication to Azure Synapse.
-
How to Connect to Live Excel Online Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft Excel Online without replication.
-
Migrating data from EmailOctopus to Snowflake using CData SSIS Components.
Easily push EmailOctopus to Snowflake using the CData SSIS Tasks for EmailOctopus and Snowflake.
-
Create Data Visualizations in Cognos BI with Short.io Data
Access Short.io as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to use SQLAlchemy ORM to access Raisers Edge NXT Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Raisers Edge NXT.
-
Migrating data from Access to Google BigQuery using CData SSIS Components.
Easily push Microsoft Access to Google BigQuery using the CData SSIS Tasks for Access and Google BigQuery.
-
Demo: Migrate Data from Salesforce to SharePoint
CData Data Providers offer a wide range of uses, including the ability to migrate data between sources quickly. Download this demo that helps you transfer Salesforce.com data into SharePoint.
-
How to publish and share PDFMonkey Data dashboards with Tableau Server
The CData ODBC driver for PDFMonkey enables you integrate PDFMonkey into Tableau dashboards.
-
Prepare, Blend, and Analyze Highrise Data in Alteryx Designer (Connect AI)
Build workflows to access live Highrise CRM for self-service data analytics.
-
Migrating data from CSV to Google BigQuery using CData SSIS Components.
Easily push CSV/TSV Files to Google BigQuery using the CData SSIS Tasks for CSV and Google BigQuery.
-
Connect to Real-Time Confluence Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Confluence and Dataflow to import and use Atlassian Confluence in Power Apps.
-
Access Live Zoho Recruit Data in Coginiti Pro
Connect to and query live Zoho Recruit from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Snowflake Data in Coginiti Pro
Connect to and query live Snowflake from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Zoho Books-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoho Books Data from Zoho Analytics and import live Zoho Books.
-
How to Query Live ZohoPeople Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoPeople data in natural language using Python.
-
Getting Started with the CData Python Connector for Qualaroo
Learn to install and license the CData Python Connector
-
Getting Started with the CData Tableau Connector for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Box Data in JRuby
Create a simple JRuby app with access to live Box.
-
Bridge Quaderno Connectivity with Apache NiFi
Access and process Quaderno in Apache NiFi using the CData JDBC Driver.
-
Replicate Optimizely Data in Heroku for Use in Salesforce Connect
Replicate Optimizely to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Databricks Replication to SQLite
Use CData Sync for automated, continuous, customizable Databricks replication to SQLite.
-
Migrating data from Certinia to Snowflake using CData SSIS Components.
Easily push Certinia to Snowflake using the CData SSIS Tasks for Certinia and Snowflake.
-
How to connect to Pipeline CRM Data in DBVisualizer
Integrate Pipeline CRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Create ServiceNow-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ServiceNow Data from Klipfolio and build custom visualizations using live ServiceNow.
-
Operational Reporting on Jumpseller Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Jumpseller.
-
Connect to SingleStore Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SingleStore Data and connect to SingleStore in Akorbi Digital RunMyProcess.
-
Build Semantic Layer Views for Timely Data in APOS Live Data Gateway
Use the CData Connector for Timely in APOS Live Data Gateway to build Semantic Layer Views for Timely.
-
Access SurveyMonkey Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SurveyMonkey from HeidiSQL.
-
Perform Batch Operations with SAP SuccessFactors Data in Apache NiFi
Connect to SAP SuccessFactors and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating GitHub Copilot CLI with Procore via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Build Act-On-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Act-On Data and create custom apps in Mendix.
-
Connect to Discourse Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Discourse and work with Discourse in your FileMaker application.
-
Connect to Acumatica Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Acumatica Data and connect to Acumatica ERP in Akorbi Digital RunMyProcess.
-
Automated Continuous RSS Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable RSS replication to PostgreSQL.
-
How to Query Live Basecamp Data in Perplexity MacOS Desktop
Connect to and query live Basecamp Data in Perplexity Desktop using CData MCP Server.
-
Rapidly Develop ZohoExpense-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by ZohoExpense.
-
Validate SAP Ariba Procurement Data with QuerySurge
Access and validate SAP Ariba Procurement in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Couchbase Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Couchbase for you.
-
Integrate Campaigner with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Campaigner with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Campaigner.
-
Query, Visualize, and Share live SQL Analysis Services Data in Redash
Use CData Connect AI to connect to live SQL Analysis Services in Redash for querying, visualizing, and sharing.
-
Connect to Dropbox Data in Jaspersoft Studio
Execute SQL to remote Dropbox in Jaspersoft Studio.
-
Access Live SAP ByDesign Data in Excel 365 Online (Excel for the web)
Connect to SAP Business ByDesign from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for Mistral AI in MicroStrategy Desktop
Connect to Mistral AI in MicroStrategy Desktop using the CData Software ODBC Driver for Mistral AI.
-
Connect to ZohoPeople from Asprova with CData Software ODBC Driver for ZohoPeople
This article shows how to connect faster to ZohoPeople data from Asprova.
-
Create Data Visualizations Based On Salesforce Pardot Data in Mode
Use CData Connect AI to connect to Salesforce Pardot Data from Mode and build visualizations using live
-
Connect to GitHub Data in HULFT Integrate
Connect to GitHub as a JDBC data source in HULFT Integrate
-
Connect to and Visualize Live Avaza Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Avaza.
-
Import and Visualize TigerGraph Data in Power View
Create data visualizations based on TigerGraph in Excel.
-
Connect to Avalara AvaTax Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Rapidly Develop Oracle SCM-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Oracle SCM.
-
Access Live HBase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache HBase into the statistical analysis tools available in SAS JMP. This article shows how to use Apache HBase in the Graph Builder and Query Builder.
-
Create SAP Fieldglass Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Fieldglass from PowerBI.com to create Power BI Dataflows with real-time data.