CData Software - Knowledge Base
Recent Articles
-
How to integrate Opsgenie with Apache Airflow
Access and process Opsgenie data in Apache Airflow using the CData JDBC Driver.
-
Build Agents in Relevance AI with Access to Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Lakebase data within intelligent agent workflows.
-
Automate Recurly Data Replication to Azure Synapse
Use CData Sync to customize and automate Recurly data replication to Azure Synapse.
-
Establish a Live Connection with LightSpeedRetail Data using Tableau Bridge
The CData ODBC Driver for LightSpeedRetail enables you to integrate live LightSpeedRetail data into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind WooCommerce Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for WooCommerce with the DevExpress Windows Forms and Web controls to provide WooCommerce data to a chart.
-
Stream HDFS Data into Apache Kafka Topics
Access and stream HDFS data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Lakebase Data Replication to Teradata
Use CData Sync to Customize and automate Lakebase data replication to Teradata.
-
Access Live ZarMoney Data in AWS Lambda
Connect to live ZarMoney data in AWS Lambda using the CData JDBC Driver.
-
Create Apify-Connected Nintex Workflows
Use CData Connect AI to connect to Apify Data from Nintex Workflow Cloud and build custom workflows using live Apify data.
-
Automated Continuous ChartMogul Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ChartMogul replication to Azure SQL Database.
-
Automated Continuous Monday.com Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Monday.com replication to Google BigQuery.
-
Natively Connect to Google Analytics Data in PHP
The CData ODBC driver for Google Analytics enables you to create PHP applications with connectivity to Google Analytics data. Leverage the native support for ODBC in PHP.
-
Integrate Cline with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Facebook data from within your IDE.
-
Use Agno to Talk to Your Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Outreach.io data for you.
-
Work with Odoo Data in FoxPro
Load Odoo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connecting Agentforce with Azure Table Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Azure Table data for you.
-
Query Aha! Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Aha! data from Node.js.
-
How to load Amplitude data into Elasticsearch via Logstash
Introducing a simple method to load Amplitude data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize Live Mode Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mode data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate Mouseflow Data Replication to Couchbase
Use CData Sync to Customize and automate Mouseflow data replication to Couchbase.
-
Access Live MarkLogic Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MarkLogic data from your Excel spreadsheets.
-
Create Data Visualizations in Cognos BI with Acumatica Data
Access Acumatica data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated DocuSign Data Replication to Teradata
Use CData Sync to Customize and automate DocuSign data replication to Teradata.
-
Query Cosmos DB Data as a SQL Server Database in Node.js
Execute SQL Server queries against Cosmos DB data from Node.js.
-
Connect to and Visualize Live ConvertAPI Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ConvertAPI data.
-
Getting Started with the CData Excel Add-In for PagerDuty
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PagerDuty.
-
How to Visualize ConvertAPI Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConvertAPI data in Python.
-
Access Live RSS Feeds in Excel 365 Online (Excel for the web)
Connect to RSS feeds from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Dashboards with Instagram Data in Dundas BI
Create dynamic dashboards and perform analytics based on Instagram data in Dundas BI.
-
Automated Continuous Azure Data Lake Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Azure SQL Database.
-
How to Easily Query SQL Analysis Services Data in OpenOffice Base
Connect to SQL Analysis Services data in OpenOffice Base using the CData ODBC Driver for SQL Analysis Services and generate reports with live data insights.
-
How to Connect to Live Bitbucket Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Bitbucket data for you.
-
Migrating data from PabblySubscriptions to Databricks using CData SSIS Components.
Easily push PabblySubscriptions data to Databricks using the CData SSIS Tasks for PabblySubscriptions and Databricks.
-
Migrating data from Beeminder to Google BigQuery using CData SSIS Components.
Easily push Beeminder data to Google BigQuery using the CData SSIS Tasks for Beeminder and Google BigQuery.
-
How to load Raisers Edge NXT data into Elasticsearch via Logstash
Introducing a simple method to load Raisers Edge NXT data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Establish a Live Connection with Omnisend Data using Tableau Bridge
The CData ODBC Driver for Omnisend enables you to integrate live Omnisend data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create SSAS Tabular Models from Procore Data
How to build a SQL Server Analysis Service Tabular Model from Procore data using CData drivers.
-
Connect to Shortcut Data in Ruby
Connect to Shortcut data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build a PostgreSQL Interface for Jodoo Data using the CData JDBC Driver
Use the Remoting features of the Jodoo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Bannerbear Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Bannerbear data from your Excel spreadsheets.
-
Create a Data Access Object for Salesforce CRM Analytics Data using JDBI
A brief overview of creating a SQL Object API for Salesforce CRM Analytics data in JDBI.
-
Use Biml to Build SSIS Tasks to Replicate LaunchDarkly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LaunchDarkly data to SQL Server.
-
Visualize Live Sybase IQ Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sybase IQ data.
-
Analyze ADP Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ADP data and visualize live ADP data in Infragistics Reveal.
-
Bidirectional Access to Stripe Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Stripe data in Filemaker Pro for Mac or Windows.
-
Integrate with ADP Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ADP data in SnapLogic.
-
How to Visualize Elasticsearch Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Elasticsearch data in Python.
-
Connect Demio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Demio data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Link Pipeliner CRM with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pipeliner CRM data in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for ZohoExpense in MicroStrategy Desktop
Connect to ZohoExpense data in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoExpense.
-
Bind Live SAP Hybris C4C Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Hybris C4C data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Zoho Inventory Data in ACL Analytics
Connect to Zoho Inventory data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho Inventory data.
-
Access Live ClickUp Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ClickUp data from your Excel spreadsheets.
-
Connect to Rebilly Data in Ruby
Connect to Rebilly data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Freshteam Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Freshteam data and visualize Freshteam data in SAP Analytics Cloud.
-
Build Dashboards with SAP HANA XS Advanced Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP HANA XS Advanced data in Dundas BI.
-
Replicate Basecamp Data to Multiple Databases via the CData Sync CLI
Replicate Basecamp data to disparate databases with a single configuration.
-
Automate BigQuery Data Replication to SAP HANA
Use CData Sync to customize and automate BigQuery data replication to SAP HANA.
-
Use the CData Software ODBC Driver for Avalara AvaTax in MicroStrategy Desktop
Connect to Avalara AvaTax data in MicroStrategy Desktop using the CData Software ODBC Driver for Avalara AvaTax.
-
Use the CData ODBC Driver for Bitbucket from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bitbucket to connect to Bitbucket data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bitbucket data in Excel.
-
How to Build an ETL App for Oracle HCM Cloud Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle HCM Cloud data in Python with petl.
-
Create Reports from Microsoft Entra ID Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Entra ID data and create custom reports in Looker Studio.
-
Create Informatica Mappings From/To an ODBC Data Source for Cosmos DB
Create an ODBC connection to Cosmos DB in Informatica and browse and transfer Cosmos DB data.
-
Create Power BI Reports on Real-Time ZohoExpense Data
Use the CData ODBC Driver for ZohoExpense to visualize ZohoExpense data in Power BI Desktop.
-
Visualize Live Pipedrive Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Pipedrive data into custom reports in Power BI.
-
How to import ShipStation Data into Apache Solr
Use the CData Software JDBC Driver for ShipStation in Data Import Handler and create an automated import of ShipStation data to Apache Solr Enterprise Search platform.
-
Automated Continuous SpaceX Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SpaceX replication to Google BigQuery.
-
Publish Dotmailer-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dotmailer data.
-
Automated Continuous Keap Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Keap replication to Google Cloud SQL.
-
Configure the CData JDBC Driver for Kintone in a Connection Pool in Tomcat
Connect to Kintone data from a connection pool in Tomcat.
-
Create Sage 200 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sage 200 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Dashboards with Parquet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Parquet data in Dundas BI.
-
Integrating OpenCode with GraphQL 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.
-
Integrate Dify with Live Attio Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Attio data.
-
Connect to Telegram Data in NetBeans
Connect to Telegram data in NetBeans with the data source configuration wizard.
-
Building Dynamic Web Pages with Google Search Results Using AngularJS
Create single-page applications with live connectivity to Google Search using the CData API Server.
-
Visualize Basecamp Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Basecamp data into TIBCO Spotfire.
-
Access Live Klipfolio Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Klipfolio data from your Excel spreadsheets.
-
Create Reports with Teamwork Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teamwork data.
-
Connect to Azure Synapse Data in RapidMiner
Integrate Azure Synapse data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Visualizations of SAP SuccessFactors LMS Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP SuccessFactors LMS data in Birst.
-
How to Access Twilio Data Using Entity Framework
This article shows how to access Twilio data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Consume Avalara AvaTax OData Feeds in PowerBuilder
This article demonstrates how to consume Avalara AvaTax data as OData feeds from PowerBuilder using the API Server.
-
Build Dashboards with Missive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Missive data in Dundas BI.
-
Import SAP Ariba Procurement Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Ariba Procurement Data and provide access to live SAP Ariba Procurement data for custom reports in the Power BI Service.
-
How to create Visio diagrams from QuickBooks Online Data
Automatically update QuickBooks Online data with the changes you make to Visio master shapes.
-
Integrating Claude Code CLI with Apollo 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 Teradata Replication to MySQL
Use CData Sync for automated, continuous, customizable Teradata replication to MySQL.
-
Access Live Azure Analysis Services Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Analysis Services data into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Analysis Services data in the Graph Builder and Query Builder.
-
Parallel Reporting in OBIEE with the Parallel JDBC Driver
Deploy the Parallel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Facebook Data as a SQL Server Database in Node.js
Execute SQL Server queries against Facebook data from Node.js.
-
Build an OLAP Cube in SSAS from CSV Data
Establish a connection to CSV data data from SQL Server Analysis Services, and use the CSV Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Office 365 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Office 365 and the SQL Gateway to access Office 365 data from Google Apps Script.
-
Build SendPulse-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SendPulse data without replication.
-
DataBind Controls to Paylocity Data in Delphi
DataBind to Paylocity data in Delphi with standard data access components and controls.
-
Building Dynamic Web Pages with Kafka Data Using AngularJS
Create single-page applications with live connectivity to Kafka using the CData API Server.
-
Integrating Claude Code with Campaigner Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Campaigner data within assisted coding and automated development workflows.
-
Replicate SAP Ariba Source Data to Multiple Databases via the CData Sync CLI
Replicate SAP Ariba Source data to disparate databases with a single configuration.
-
How to Access Live Unbounce Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Unbounce enables you to integrate Unbounce data into workflows built using Microsoft Power Automate Desktop.
-
Publish Crystal Reports on HBase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HBase data.