CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Excel Add-In for Perigon
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Perigon.
-
Getting Started with the CData Power BI Connector for IBM Informix
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for IBM Informix.
-
Create Pipeliner CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pipeliner CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Shortcut Replication to Databricks
Use CData Sync for automated, continuous, customizable Shortcut replication to Databricks.
-
Build Semantic Layer Views for Salesforce Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Salesforce & Force.com.
-
Create Data Visualizations in Cognos BI with Brex Data
Access Brex as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Cosmos DB Data in RazorSQL
Connect to Cosmos DB from wizards and query Azure Cosmos DB from the GUI in the RazorSQL database management tool.
-
How to Connect to Live Office 365 Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft Office 365 for you.
-
Automated Avro Data Replication to Teradata
Use CData Sync to Customize and automate Apache Avro replication to Teradata.
-
How to Visualize SharePoint Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft SharePoint in Python.
-
Integrate Aweber Data in Pentaho Data Integration
Build ETL pipelines based on Aweber in the Pentaho Data Integration tool.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Act CRM actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Visualize AfterShip Data in Sisense
Create an ElastiCube in Sisense app with access to AfterShip.
-
Publish Flowlu-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Flowlu.
-
Configure the CData JDBC Driver for DB2 in a Connection Pool in Tomcat
Connect to IBM DB2 from a connection pool in Tomcat.
-
Access Live MailChimp Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live MailChimp data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Adobe Experience Manager-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Adobe Experience Manager to explore live Adobe Experience Manager Data in GitHub Copilot to assist with building Adobe Experience Manager-powered applications.
-
Using the CData Software ODBC Driver for Instagram in PyCharm
Connect to Instagram as an ODBC data source in PyCharm using the CData Software ODBC Driver for Instagram.
-
How to Build an ETL App for Google Translate Data in Python with CData
Create ETL applications and real-time data pipelines for Google Translate in Python with petl.
-
Build PostgreSQL Visualizations in Tableau Desktop
Use CData Connect AI to connect to live PostgreSQL and build visualizations in Tableau.
-
Operational Reporting on Planio Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Planio.
-
Deploy the ADO.NET Provider for Salesforce Data 360 on an SSRS Report Server
Connect to Salesforce Data 360 from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build BigCommerce Visualizations in Tableau Cloud
Use CData Connect AI to connect to live BigCommerce and build visualizations in Tableau Cloud.
-
Automated Continuous Insightly Replication to MySQL
Use CData Sync for automated, continuous, customizable Insightly replication to MySQL.
-
Integrate with Live ServiceNow Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ServiceNow from the MuleSoft Anypoint Platform to integrate live ServiceNow into custom reports and dashboards.
-
Build Dashboards with ADP Data in Dundas BI
Create dynamic dashboards and perform analytics based on ADP in Dundas BI.
-
Automated Continuous Todoist Replication to Snowflake
Use CData Sync for automated, continuous, customizable Todoist replication to Snowflake.
-
Automated Continuous Everhour Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Everhour replication to Apache Cassandra.
-
Analyze Tally Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Tally ERP in Microsoft R Open.
-
Access Onfleet Data from MySQL in PHP
Connect to Onfleet through the standard MySQL libraries in PHP.
-
Build Dashboards with Excel Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Excel in DBxtra.
-
Publish Teradata-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Teradata.
-
Migrating data from XML to Snowflake using CData SSIS Components.
Easily push XML Files to Snowflake using the CData SSIS Tasks for XML and Snowflake.
-
Create Power BI Reports on Real-Time Azure Data Catalog Data
Use the CData ODBC Driver for Azure Data Catalog to visualize Azure Data Catalog in Power BI Desktop.
-
Access Live Google Analytics Data in Excel 365 Online (Excel for the web)
Connect to Google Analytics from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to connect to Teradata Data from IntelliJ
Integrate connectivity to Teradata with wizards in IntelliJ.
-
Replicate Sage Intacct Data in Heroku for Use in Salesforce Connect
Replicate Sage Intacct to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Wave Financial Data in Talend Cloud Data Management Platform
Connect Wave Financial Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Wave Financial.
-
Publish Reports with Google Sheets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Sheets.
-
Automated Continuous Accelo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Accelo replication to Google Cloud SQL.
-
How to Build an ETL App for IBM Cloud Object Storage Data in Python with CData Connect AI
Build ETL pipelines that read and write live IBM Cloud Object Storage in Python with petl and the CData Connect AI Python SDK.
-
Connect to ShipStation Data in NetBeans
Connect to ShipStation in NetBeans with the data source configuration wizard.
-
Use Databricks Agent Bricks to Talk to Your Sage 200 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sage 200 for you.
-
Connect to IBM Cloud Object Storage Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live IBM Cloud Object Storage from Filemaker Pro on Mac.
-
How to Import Data from Google Cloud Storage into Google Sheets
Import Google Cloud Storage into a Google spreadsheet that is automatically refreshed.
-
Connect to Pingdom Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Pingdom and work with Pingdom in your FileMaker applications.
-
Load Reply.io Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Reply.io to a database.
-
How to Connect to Live Zuora Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zuora securely in real time.
-
Build Automated Sage Cloud Accounting-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sage Business Cloud Accounting and build automated workflows in Zapier.
-
Deploy the ADO.NET Provider for Freshsales on an SSRS Report Server
Connect to Freshsales from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to work with Egnyte Data in Apache Spark using SQL
Access and process Egnyte Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Greenplum with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Greenplum with External Services.
-
Use JayDeBeApi to access Datadog Data in Python
Use standard Python scripting and the development environment of your choice to access live Datadog.
-
Query Authorize.Net Data in ColdFusion
Write standard ColdFusion data access code to connect to Authorize.Net.
-
Object-Relational Mapping (ORM) with Drift Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Drift into a Java-based ORM framework, Hibernate.
-
Connect to RabbitMQ Data as an External Source in Dremio
Use the CData JDBC Driver to connect to RabbitMQ as an External Source in Dremio.
-
How to connect to Microsoft Planner Data from Spring Boot
Connect to Microsoft Planner in a Spring Boot Application using the CData JDBC Driver for Microsoft Planner
-
Use the CData ODBC Driver for CampaignMonitor from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CampaignMonitor to connect to CampaignMonitor from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CampaignMonitor in Excel.
-
Integrate Mixpanel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mixpanel with External Services.
-
Establish a Live Connection with Zendesk Data using Tableau Bridge
The CData ODBC Driver for Zendesk enables you to integrate live Zendesk into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Dashboards with Supabase Data in DBxtra
Create dynamic dashboards and perform analytics based on Supabase in DBxtra.
-
Access FreeAgent Data from MySQL in PHP
Connect to FreeAgent through the standard MySQL libraries in PHP.
-
Access Live Raisers Edge NXT Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Raisers Edge NXT into the statistical analysis tools available in SAS JMP. This article shows how to use Raisers Edge NXT in the Graph Builder and Query Builder.
-
Object-Relational Mapping (ORM) with Everhour Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Everhour into a Java-based ORM framework, Hibernate.
-
Create Dynamic Lakebase Grids Using the Infragistics XamDataGrid
Learn how you can connect Lakebase to Infragistics XamDataGrid to build dynamic grids.
-
Build a PostgreSQL Interface for Reckon Data using the CData JDBC Driver
Use the Remoting features of the Reckon JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Agentforce with Google Sheets 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 Google Sheets for you.
-
Connect to Phoenix Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Phoenix and the SQL Gateway to access Apache Phoenix from Google Apps Script.
-
Stream Cohere Data into Apache Kafka Topics
Access and stream Cohere in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create EnterpriseDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time EnterpriseDB data access from reports, embedded analytics, and more.
-
How to import SAP ByDesign Data into Apache Solr
Use the CData Software JDBC Driver for SAP ByDesign in Data Import Handler and create an automated import of SAP Business ByDesign to Apache Solr Enterprise Search platform.
-
Connect to and Query Amazon S3 Data in QlikView over ODBC
Create data visualizations with Amazon S3 in QlikView.
-
Build Visualizations of Zoho Inventory Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Inventory in Birst.
-
Work with Campaigner Data in FoxPro
Load Campaigner into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Zoom-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zoom Data from OutSystems and build custom enterprise apps using live Zoom.
-
Automated Continuous Mode Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mode replication to IBM DB2.
-
Automated Salesforce CRM Analytics Data Replication to Teradata
Use CData Sync to Customize and automate Salesforce CRM Analytics replication to Teradata.
-
Query Live Sage 200 Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Sage 200 directly from the development environment.
-
Build DB2-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for DB2 Data and create custom apps in Bubble.
-
Access Live Campaigner Data in Coginiti Pro
Connect to and query live Campaigner from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Facebook Ads.
-
Bridge Zoho Recruit Connectivity with Apache NiFi
Access and process Zoho Recruit in Apache NiFi using the CData JDBC Driver.
-
Connect to Odoo Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Odoo ERP from Filemaker Pro on Mac.
-
Access Live Clockify Data in AWS Lambda
Connect to live Clockify in AWS Lambda using the CData JDBC Driver.
-
Build Visualizations of Cloudant Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of IBM Cloudant in Birst.
-
Analyze SAP HANA XS Advanced Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP HANA XS Advanced from Power Pivot. You will use the Table Import Wizard to load SAP HANA XS Advanced. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Charts to NASA Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to NASA from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Contacts
Provide connectivity to Google Contacts through an SAP BusinessObjects universe.
-
Connect to GetResponse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for GetResponse.
-
Access Tavily Data from MySQL in Amazon QuickSight
Connect to Tavily and build visualizations of Tavily using a MySQL Connection in Amazon QuickSight.
-
How to Visualize Kintone Data in Python with pandas
Use pandas and other modules to analyze and visualize live Kintone in Python.
-
Build Charts with Todoist Data in Clear Analytics
Create dynamic charts and perform analytics based on Todoist in Clear Analytics.
-
How to connect Amazon QuickSight to SAP Fieldglass Data
Create a connection to SAP Fieldglass in CData Connect AI and insert SAP Fieldglass into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Adobe Commerce Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Commerce in the Pentaho Data Integration tool.
-
Easily Integrate Tanda Data in Lazarus Pascal IDE
Learn how to easily integrate live Tanda in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
A PostgreSQL Interface for Placid Data using the CData ODBC Driver
Use the SQL Gateway and Placid ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Datasets from Recurly in Domo Workbench and Build Visualizations of Recurly Data in Domo
Use the CData Software ODBC Driver for Recurly to create datasets from Recurly in Domo Workbench and then build visualizations in the Domo service.
-
Create Reports from BigQuery Data in Looker Studio
Use CData Connect AI to gain access to live Google BigQuery and create custom reports in Looker Studio.
-
Use Azure AI Foundry to Talk to Your Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Azure Table Storage for you.
-
Integrating Claude Code CLI with Tickspot 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.