CData Software - Knowledge Base
Recent Articles
-
Integrate with Sage 300 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sage 300 data to a JSON file on disk.
-
Connect to HubDB Data in Ruby
Connect to HubDB data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for VWO in MicroStrategy Desktop
Connect to VWO data in MicroStrategy Desktop using the CData Software ODBC Driver for VWO.
-
How to Create Power BI Visual Reports with Real-Time Datadog Data
Use CData Power BI Connectors to visualize Datadog data in Power BI.
-
Connect to Microsoft Exchange Data in Aqua Data Studio
Access Microsoft Exchange data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Power BI Connector for Apollo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Guru Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Guru data in the Denodo Virtual DataPort Administrator.
-
Using the CData Software ODBC Driver for JSON in PyCharm
Connect to JSON as an ODBC data source in PyCharm using the CData Software ODBC Driver for JSON.
-
Getting Started with the CData Connect AI Python SDK for NetSuite
Install the CData Connect AI Python SDK to read and write live NetSuite data with standard DB-API 2.0 Python code.
-
Validate Adobe Experience Manager Data with QuerySurge
Access and validate Adobe Experience Manager data in QuerySurge using the CData JDBC Driver.
-
Access Live Google Search Results in AWS Lambda
Connect to live Google Search results in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData SSIS Components for Outlook
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Outlook.
-
Query Live Xero Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Xero data through a conversational interface.
-
Build Apps with Live Dynamics 365 Data Using the Low-Code Development Platform of Mendix
Connect Dynamics 365 data with Mendix to build apps using the CData JDBC Driver for Dynamics 365.
-
Stream Dynamics 365 Data into Apache Kafka Topics
Access and stream Dynamics 365 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Data Flows from SQL Server to LDAP through SSIS
Easily push SQL Server data to LDAP using the CData SSIS Tasks for LDAP.
-
Use Dash to Build to Web Apps on Calendly Data
Create Python applications that use pandas and Dash to build Calendly-connected web apps.
-
Connect to Snowflake Data from HeidiSQL
Use CData Connect AI to connect to and query live Snowflake data from HeidiSQL.
-
Connect to Monday.com Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Monday.com data in Airbyte.
-
Getting Started with the CData SSIS Components for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ActiveCampaign.
-
How to Connect to Live Act-On 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 Act-On data for you.
-
Work with Dotmailer Data in FoxPro
Load Dotmailer data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import Power BI XMLA Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Power BI XMLA Data and provide access to live Power BI XMLA data for custom reports in the Power BI Service.
-
Connect to Power BI XMLA from Asprova with CData Software ODBC Driver for Power BI XMLA
This article shows how to connect faster to Power BI XMLA data from Asprova.
-
Integrate OpenCode with Live Mailgun Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Mailgun data from within your AI coding agent.
-
Build Dashboards with Eventbrite Data in Dundas BI
Create dynamic dashboards and perform analytics based on Eventbrite data in Dundas BI.
-
Connect to MessageBird Data in Jaspersoft Studio
Execute SQL to remote MessageBird data in Jaspersoft Studio.
-
Connect to LDAP Objects from a Connection Pool in JBoss
Integrate LDAP objects into Java servlets: Use the Management Console in JBoss to install the LDAP JDBC Driver.
-
Build ZohoMarketingHub-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 ZohoMarketingHub data without replication.
-
How to connect SharePoint with Microsoft Exchange Data through external lists
Provide Microsoft Exchange data to SharePoint users as an external list.
-
Automated Continuous Acumatica Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Acumatica replication to delimited files (CSV/TSV).
-
Build a PostgreSQL Interface for ZohoExpense Data using the CData JDBC Driver
Use the Remoting features of the ZohoExpense JDBC Driver to create a PostgreSQL entry-point for data access.
-
Back Up xBase data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for xBase. In this article, we will employ an SSIS workflow to populate a database with xBase data data.
-
How to Connect Flowise AI Agents to Live FreshBooks Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live FreshBooks data without replication.
-
How to Access Live Wave Financial Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Wave Financial enables you to integrate Wave Financial data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous ZohoDesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoDesk data replication to OneLake in Microsoft Fabric.
-
Create a Data Access Object for Copper Data using JDBI
A brief overview of creating a SQL Object API for Copper data in JDBI.
-
Connect to Dynamics CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Dynamics CRM data.
-
Use the CData Software ODBC Driver for Certinia in MicroStrategy Web
Connect to Certinia data in MicroStrategy Web using the CData Software ODBC Driver for Certinia.
-
Integrate Trae with Live ZohoMarketingHub Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ZohoMarketingHub data from within the AI-powered IDE.
-
Create Smartsheet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Smartsheet data access from reports, embedded analytics, and more.
-
How to connect PolyBase to PostgreSQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PostgreSQL data.
-
Feed ActiveCampaign Data into FineReport
How to set ActiveCampaign data as a JDBC data source in FineReport.
-
How to connect PolyBase to Square
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Square data.
-
Integrate Demio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Demio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Demio data.
-
Integrate Dify with Live Avro 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 Avro data.
-
Build Visualizations of Tavily Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Tavily data in Birst.
-
Automated Continuous ShipStation Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ShipStation replication to Amazon Redshift.
-
Integrate with Supabase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Supabase data in SnapLogic.
-
Query Float Data as a MySQL Database in Node.js
Execute MySQL queries against Float data from Node.js.
-
Easily Integrate Supabase Data in Lazarus Pascal IDE
Learn how to easily integrate live Supabase data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData JDBC Driver for Twilio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Twilio.
-
A PostgreSQL Interface for Gorgias Data using the CData ODBC Driver
Use the SQL Gateway and Gorgias ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Azure Synapse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Synapse with IBM WebSphere for seamless data integration and connectivity.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP BusinessObjects BI
Provide connectivity to SAP BusinessObjects BI data through an SAP BusinessObjects universe.
-
Connect to Teamgate Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Teamgate data.
-
Create Rebilly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Rebilly data access from reports, embedded analytics, and more.
-
Integrating OpenCode with Google Translate 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.
-
Visualize Live Shopify Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Shopify data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Paddle to Databricks using CData SSIS Components.
Easily push Paddle data to Databricks using the CData SSIS Tasks for Paddle and Databricks.
-
Integrate Cline with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sage 200 data from within your IDE.
-
Automated Continuous Dynamics NAV Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to AlloyDB.
-
Write a Simple Go Application to work with Float Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Float data.
-
Consume Teradata OData Feeds in PowerBuilder
This article demonstrates how to consume Teradata data as OData feeds from PowerBuilder using the API Server.
-
Connect to SendGrid Data in RapidMiner
Integrate SendGrid data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Freshdesk Data from Spring Boot
Connect to Freshdesk in a Spring Boot Application using the CData JDBC Driver for Freshdesk
-
Getting Started with the CData Excel Add-In for Redshift
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Redshift.
-
Using the CData Software ODBC Driver for Wave Financial in PyCharm
Connect to Wave Financial as an ODBC data source in PyCharm using the CData Software ODBC Driver for Wave Financial.
-
Build Moosend-Connected Apps in Choreo
Use CData Connect AI to connect to Moosend Data from Choreo and build custom apps using live Moosend data.
-
Migrating data from Microsoft Dataverse to Databricks using CData SSIS Components.
Easily push Microsoft Dataverse data to Databricks using the CData SSIS Tasks for Microsoft Dataverse and Databricks.
-
Connect to Twilio Data in RapidMiner
Integrate Twilio data with standard components and data source configuration wizards in RapidMiner Studio.
-
Edit and Search External Smartsheet Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Smartsheet data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Smartsheet Data objects that you can access from apps and the dashboard.
-
Integrating Claude Code CLI with Reply.io 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 Semantic Layer Views for YouTube Analytics Data in APOS Live Data Gateway
Use the CData Connector for YouTube Analytics in APOS Live Data Gateway to build Semantic Layer Views for YouTube Analytics data.
-
Build Data Flows from Tavily to SQL Server using SSIS
Easily back up Tavily data to SQL Server using the SSIS components for Tavily.
-
Visualize Epicor Kinetic Data in Sisense
Create an ElastiCube in Sisense app with access to Epicor Kinetic data.
-
DataBind Controls to Oracle Data in Delphi
DataBind to Oracle data in Delphi with standard data access components and controls.
-
Integrate Live ScrapingBee Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ScrapingBee data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Google Spanner Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Spanner data from HeidiSQL.
-
Query Xero Data as a MySQL Database in Node.js
Execute MySQL queries against Xero data from Node.js.
-
Automated Continuous Outlook Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Outlook replication to Apache Cassandra.
-
Automated Continuous Hacker News Replication to Oracle
Use CData Sync for automated, continuous, customizable Hacker News replication to Oracle.
-
Stream Redshift Data into Apache Kafka Topics
Access and stream Redshift data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize MarkLogic Data in TIBCO Spotfire through OData
Integrate MarkLogic data into dashboards in TIBCO Spotfire.
-
Replicate SAP Ariba Source Data in Heroku for Use in Salesforce Connect
Replicate SAP Ariba Source data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Yelp Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Yelp data from your Excel spreadsheets.
-
Use the CData ODBC Driver for Presto from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Presto to connect to Presto data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Presto data in Excel.
-
Migrating data from Helpscout to Snowflake using CData SSIS Components.
Easily push Helpscout data to Snowflake using the CData SSIS Tasks for Helpscout and Snowflake.
-
Connect to Moosend Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Moosend data from Filemaker Pro on Mac.
-
Analyze RSS Feeds in Cognos Analytics
Use CData Connect AI to connect to RSS Feeds from Cognos Analytics and analyze live RSS feeds.
-
Publish Mixpanel-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Mixpanel data.
-
Publish Crystal Reports on ShipStation Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipStation data.
-
Connect to Live LinkedIn Ads Data in MicroStrategy through CData Connect AI
Create a live connection to LinkedIn Ads Data in CData Connect AI and connect to your LinkedIn Ads data from MicroStrategy.
-
Design BIRT Reports on Simplesat Data
Provide current Simplesat data to your embedded analytics.
-
Build Visualizations of QuickBooks Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of QuickBooks data in Birst.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Ariba Source
Provide connectivity to SAP Ariba Source data through an SAP BusinessObjects universe.
-
Getting Started with the CData Tableau Connector for OData
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for OData.
-
Visualize Blackbaud FE NXT Data in TIBCO Spotfire through OData
Integrate Blackbaud FE NXT data into dashboards in TIBCO Spotfire.
-
Explore Geographical Relationships in Oracle Service Cloud Data with Power Map
Create data visualizations with Oracle Service Cloud data in Power Map.
-
Perform Batch Operations with Dynamics NAV Data in Apache NiFi
Connect to Dynamics NAV data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.