CData Software - Knowledge Base
Recent Articles
-
Replicate Multiple Autopilot Accounts via the CData Sync CLI
Replicate multiple Autopilot accounts to one or many databases.
-
Choosing the Best Method to Connect Intercom to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Intercom data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Biml to Build SSIS Tasks to Replicate Avalara AvaTax Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Avalara AvaTax data to SQL Server.
-
How to work with Onfleet Data in Apache Spark using SQL
Access and process Onfleet Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live Anaplan Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Anaplan data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Cohere Data in RazorSQL
Connect to Cohere from wizards and query Cohere data from the GUI in the RazorSQL database management tool.
-
Build Automated Workflows with Live Figshare Data in Workato
Use CData Connect AI to connect to live Figshare data and build automated workflows in Workato.
-
Build Automated Workflows with Live Adobe Experience Manager Data in Workato
Use CData Connect AI to connect to live Adobe Experience Manager data and build automated workflows in Workato.
-
Automated Continuous Microsoft Entra ID Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to IBM DB2.
-
Connect to DB2 in SpagoBI
Create reports featuring live DB2 data in SpagoBI Studio. Host DB2 reports on SpagoBI Server.
-
Use Databricks Agent Bricks to Talk to Your Timely Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Timely data for you.
-
Create Data Visualizations Based On Redis Data in Mode
Use CData Connect AI to connect to Redis Data from Mode and build visualizations using live Redis data.
-
Use JayDeBeApi to access PhantomBuster Data in Python
Use standard Python scripting and the development environment of your choice to access live PhantomBuster data.
-
Connect to MailerSend Data in HULFT Integrate
Connect to MailerSend as a JDBC data source in HULFT Integrate
-
Automated Continuous EnterpriseDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Azure SQL Database.
-
A PostgreSQL Interface for MongoDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the MongoDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Dynamics 365 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Dynamics 365 data.
-
Visualize Live SAP Ariba Source Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Ariba Source data into custom reports in Power BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for YouTube Analytics
Provide connectivity to YouTube Analytics data through an SAP BusinessObjects universe.
-
Access MariaDB Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for MariaDB data.
-
Add CampaignMonitor Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CampaignMonitor with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to ClickUp from a Connection Pool in WebLogic
Use the CData JDBC Driver for ClickUp to connect to ClickUp data from Web applications running on WebLogic.
-
Access Live SAP Hybris C4C Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Hybris C4C data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Hybris C4C data in the Graph Builder and Query Builder.
-
Build Oracle Financials Cloud-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 Oracle Financials Cloud data without replication.
-
Connect to Mode from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Mode data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Natively Connect to Square Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Square data. Leverage the native support for ODBC in PHP.
-
Integrate Theia IDE with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Salesforce data from within the development environment.
-
Automated Continuous Exa Replication to Oracle
Use CData Sync for automated, continuous, customizable Exa replication to Oracle.
-
How to Connect to Live Pinterest 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 Pinterest data for you.
-
Design BIRT Reports on Slack Data
Provide current Slack data to your embedded analytics.
-
Integrate Trae with Live Instagram Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Instagram data from within the AI-powered IDE.
-
Publish Crystal Reports on Hacker News Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Hacker News data.
-
Automated Continuous Samanage Replication to MySQL
Use CData Sync for automated, continuous, customizable Samanage replication to MySQL.
-
Use JayDeBeApi to access Mixpanel Data in Python
Use standard Python scripting and the development environment of your choice to access live Mixpanel data.
-
Use the CData Software ODBC Driver for Instantly in SAS for Real-Time Reporting and Analytics
Connect to real-time Instantly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Instantly.
-
Use the CData Software ODBC Driver for Raisers Edge NXT in MicroStrategy Desktop
Connect to Raisers Edge NXT data in MicroStrategy Desktop using the CData Software ODBC Driver for Raisers Edge NXT.
-
Access Live Helpscout Data in Coginiti Pro
Connect to and query live Helpscout data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Cursor with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live QuickBooks Time data from within the editor.
-
Enable the SAP Ariba Source JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Ariba Source data.
-
Work with Mailjet Data in FoxPro
Load Mailjet data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Multiple Mode Accounts via the CData Sync CLI
Replicate multiple Mode accounts to one or many databases.
-
Import Real-Time LeadDesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LeadDesk data in ColdFusion.
-
Create Dynamic MailChimp Grids Using the Infragistics XamDataGrid
Learn how you can connect MailChimp to Infragistics XamDataGrid to build dynamic grids.
-
Write a Simple Go Application to work with Authorize.Net Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Authorize.Net data.
-
Configure the CData JDBC Driver for OneNote in a Connection Pool in Tomcat
Connect to OneNote data from a connection pool in Tomcat.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Jira Assets
Provide connectivity to Jira Assets data through an SAP BusinessObjects universe.
-
Integrating Boomi Agentstudio with ShipStation Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ShipStation data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Work with Wrike Data in ETL Validator JDBC
Connect to Wrike from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for Marketo
Install the CData Connect AI Python SDK to read and write live Marketo data with standard DB-API 2.0 Python code.
-
Automated Continuous Telegram Replication to SQL Server
Use CData Sync for automated, continuous, customizable Telegram replication to SQL Server.
-
Build Dashboards with Tavily Data in DBxtra
Create dynamic dashboards and perform analytics based on Tavily data in DBxtra.
-
Import Bitbucket Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Bitbucket Data and provide access to live Bitbucket data for custom reports in the Power BI Service.
-
Avro Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Avro data through CData Connect AI using different applications and tools.
-
Integrate Live MailerLite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MailerLite data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating OpenCode with Parquet 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.
-
Migrating data from Oracle Financials Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle Financials Cloud data to Google BigQuery using the CData SSIS Tasks for Oracle Financials Cloud and Google BigQuery.
-
Build Oracle Sales-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle Sales Data from Choreo and build custom apps using live Oracle Sales data.
-
Explore Geographical Relationships in CouchDB Data with Power Map
Create data visualizations with CouchDB data in Power Map.
-
How to connect Amazon QuickSight to Paymo Data
Create a connection to Paymo data in CData Connect AI and insert Paymo data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use Manus AI to Talk to Your Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Azure Analysis Services data.
-
Build Automated Workflows with Live Jira Assets Data in Workato
Use CData Connect AI to connect to live Jira Assets data and build automated workflows in Workato.
-
How to publish and share Pipeline CRM Data dashboards with Tableau Server
The CData ODBC driver for Pipeline CRM enables you integrate Pipeline CRM data into Tableau dashboards.
-
Automated Continuous Perigon Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Perigon replication to Amazon S3.
-
DataBind Charts to Dynamics 365 Business Central Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dynamics 365 Business Central data 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 Apps from Jira Data in Qlik Sense Cloud
Use CData Connect AI to connect to Jira Data and build apps from live Jira data in Qlik Sense Cloud.
-
Use the CData Software ODBC Driver for Spark in SAS for Real-Time Reporting and Analytics
Connect to real-time Spark data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Spark.
-
Excel Spreadsheet Automation on Instagram Data with the QUERY Formula
Pull data from Instagram, automate spreadsheets, and more with the QUERY formula.
-
Publish Crystal Reports on Demio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Demio data.
-
Integrate Cline with Live TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live TaxJar data from within your IDE.
-
Create Data Visualizations Based On ServiceNow Data in Mode
Use CData Connect AI to connect to ServiceNow Data from Mode and build visualizations using live ServiceNow data.
-
Connect to Azure Data Catalog Data from PowerBuilder via JDBC
This article demonstrates how to access Azure Data Catalog data from PowerBuilder using the Azure Data Catalog JDBC Driver.
-
Create Stack Exchange Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Stack Exchange from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Highrise Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Highrise replication to Google Cloud SQL.
-
How to Query Azure Data Catalog Data in MySQL Workbench
Execute MySQL queries against live Azure Data Catalog data from MySQL Workbench.
-
Connect to Azure Table Data in HULFT Integrate
Connect to Azure Table as a JDBC data source in HULFT Integrate
-
Connect to Paddle Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Paddle data using standard SQL.
-
Integrate Theia IDE with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live OData services from within the development environment.
-
Natively Connect to Placid Data in PHP
The CData ODBC driver for Placid enables you to create PHP applications with connectivity to Placid data. Leverage the native support for ODBC in PHP.
-
Build FreeAgent-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FreeAgent data.
-
Visualize Live Quickbase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Quickbase data into custom reports in Power BI.
-
Connect to Copper from a Connection Pool in WebLogic
Use the CData JDBC Driver for Copper to connect to Copper data from Web applications running on WebLogic.
-
Connect to Greenhouse Data from a Connection Pool in Jetty
The Greenhouse JDBC Driver supports connection pooling: This article shows how to connect faster to Greenhouse data from Web apps in Jetty.
-
Connect to Paymo Data in NetBeans
Connect to Paymo data in NetBeans with the data source configuration wizard.
-
How to Connect to Live ZohoInvoice Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ZohoInvoice data without replication.
-
Integrate Dify with Live SQL Analysis Services 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 SQL Analysis Services data.
-
How to Build an ETL App for Adobe Commerce Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Commerce data in Python with petl.
-
Query, Visualize, and Share live FHIR Data in Redash
Use CData Connect AI to connect to live FHIR data in Redash for querying, visualizing, and sharing.
-
How to Connect to & Open Parallel Data in Microsoft Excel
This article uses the CData ODBC driver for Parallel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
A PostgreSQL Interface for ElevenLabs Data using the CData ODBC Driver
Use the SQL Gateway and ElevenLabs ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Antigravity CLI with Redshift data via CData CLI
Connect Redshift data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Natively Connect to Salesforce Marketing Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Marketing data. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with AfterShip Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to AfterShip data.
-
Create Microsoft OneDrive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft OneDrive from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Smartsheet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Smartsheet data from HeidiSQL.
-
Stripe Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Stripe facts in real time.
-
Search External BenchmarkEmail Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of BenchmarkEmail data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create BenchmarkEmail Data objects that you can access from apps and the dashboard.
-
Import Real-Time SQL Analysis Services Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SQL Analysis Services data in ColdFusion.
-
How to connect and process Instantly data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Instantly data.
-
Analyze HCL Domino Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HCL Domino data in Microsoft R Open.
-
Getting Started with the CData ODBC Driver for Quaderno
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Quaderno.