CData Software - Knowledge Base
Recent Articles
-
Automated Continuous AgileCRM Replication to Oracle
Use CData Sync for automated, continuous, customizable AgileCRM replication to Oracle.
-
Automated Continuous MarkLogic Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MarkLogic replication to Apache Kafka.
-
Integrate with ServiceDesk Plus Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ServiceDesk Plus data in SnapLogic.
-
Use the CData ODBC Driver for Adobe Commerce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Adobe Commerce to connect to Adobe Commerce data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Commerce data in Excel.
-
DataBind Controls to Epicor Kinetic Data in Delphi
DataBind to Epicor Kinetic data in Delphi with standard data access components and controls.
-
How to Connect to Live BigQuery Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live BigQuery data securely in real time.
-
Connect to Short.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Short.io and the SQL Gateway to access Short.io data from Google Apps Script.
-
Use the CData Software ODBC Driver for Cvent in SAS for Real-Time Reporting and Analytics
Connect to real-time Cvent data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cvent.
-
Create TaxJar-Connected Nintex Workflows
Use CData Connect AI to connect to TaxJar Data from Nintex Workflow Cloud and build custom workflows using live TaxJar data.
-
Visualize Live Oracle Sales Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Sales data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from PostgreSQL Data
Establish a connection to PostgreSQL data data from SQL Server Analysis Services, and use the PostgreSQL Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Typeform Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Typeform data.
-
Integrate with live Kafka Data in Jitterbit
Use CData Connect AI to connect to and integrate live Kafka data in Jitterbit.
-
Getting Started with the CData Python Connector for Perigon
Learn to install and license the CData Python Connector and configure a connection to live Perigon data.
-
How to connect to Grafana Data in DBVisualizer
Integrate Grafana data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to work with Active Directory Data in Apache Spark using SQL
Access and process Active Directory Data in Apache Spark using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Dotmailer Data
Use CData Power BI Connectors to visualize Dotmailer data in Power BI.
-
Build Agents in Relevance AI with Access to Live Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Exa data within intelligent agent workflows.
-
Build SparkPost-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 SparkPost data without replication.
-
Automated Continuous IBM Cloud Object Storage Replication to Amazon S3
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Amazon S3.
-
Integrating Google Analytics Data in Talend Cloud Data Management Platform
Connect Google Analytics Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Analytics.
-
Use the CData Software JDBC Driver for ShipStation in MicroStrategy Web
Connect to ShipStation data in MicroStrategy Web using the CData Software JDBC Driver for ShipStation.
-
Access Live SurveyMonkey Data in Excel 365 Online (Excel for the web)
Connect to SurveyMonkey data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Eventbrite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Eventbrite data. Leverage the pyodbc module for ODBC in Python.
-
Integrating Cursor with Google Contacts 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.
-
Integrating Boomi Agentstudio with FHIR Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to FHIR data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Shippo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Shippo data. Leverage the pyodbc module for ODBC in Python.
-
DataBind Controls to MailerSend Data in Delphi
DataBind to MailerSend data in Delphi with standard data access components and controls.
-
Access xBase Data from MySQL in PHP
Connect to xBase through the standard MySQL libraries in PHP.
-
How to connect PolyBase to Email
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Email data.
-
Create Data Visualizations in Cognos BI with Wrike Data
Access Wrike data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connecting Mastra with Certinia Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Certinia data, no replication required.
-
Connect and Query Live ZohoSubscriptions Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ZohoSubscriptions data into Databricks and enable direct, live querying and analysis without replication.
-
Create Informatica Mappings From/To an ODBC Data Source for Suadeo
Create an ODBC connection to Suadeo in Informatica and browse and transfer Suadeo data.
-
Use Dash to Build Web Apps on ServiceNow Data via CData Connect AI
Build interactive Dash web apps on live ServiceNow data using pandas and the CData Connect AI Python SDK.
-
Query Live Sybase 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 Sybase data through a conversational interface.
-
Integrating Flowlu Data in Talend Cloud Data Management Platform
Connect Flowlu Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Clockify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Clockify data from HeidiSQL.
-
View Reports on Real-Time Teradata Data in Power BI Report Server
Use the CData ODBC Driver for Teradata to visualize Teradata data in Power BI Desktop and then publish them to Power BI Report Server.
-
Process & Analyze Excel Online Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Excel Online Data.
-
Build Voice Agents in ElevenLabs with access to Live AlloyDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live AlloyDB data.
-
Build ZohoMarketingHub Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ZohoMarketingHub data and build visualizations in Tableau.
-
Analyze Live Twitter Ads Data in SAS Viya
Use CData Connect AI to connect to Twitter Ads data from SAS Viya and deploy self-service analytics using live Twitter Ads data.
-
Create ADP-Connected Dashboards in Grafana
Connect to ADP Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ADP data.
-
Create a Data Access Object for Airtable Data using JDBI
A brief overview of creating a SQL Object API for Airtable data in JDBI.
-
Integrating LangChain with SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SurveyMonkey data within automated workflows.
-
Build a Singer.io Tap for Cloudflare With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cloudflare data using the CData Python Connector.
-
Access Live JSON Services in AWS Lambda (with IntelliJ IDEA)
Connect to live JSON services in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Data in MicroStrategy Using the CData ODBC Driver for Dynamics CRM
In this article we show the use of CData ODBC Drivers with the MicroStrategy BI platform.
-
Automated Continuous Blackbaud FE NXT Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to IBM DB2.
-
Import and Visualize Keap Data in Power View
Create data visualizations based on Keap data in Excel.
-
Build Pipelines with Live Dynamics 365 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 from Google Cloud Data Fusion, enabling the integration of live Dynamics 365 data into the building and management of effective data pipelines.
-
Connect to Raisers Edge NXT Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Raisers Edge NXT data.
-
Automate Mailgun Data Replication to Couchbase
Use CData Sync to Customize and automate Mailgun data replication to Couchbase.
-
Access Live MarkLogic Data in AWS Lambda
Connect to live MarkLogic data in AWS Lambda using the CData JDBC Driver.
-
Replicate Multiple MarkLogic Accounts via the CData Sync CLI
Replicate multiple MarkLogic accounts to one or many databases.
-
How to Query Live Autopilot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Autopilot data data in natural language using Python.
-
Build a Simple VCL Application for Dynamics 365 Data
How to build a simple VCL Application to view Dynamics 365 data in RAD Studio using the CData ODBC Driver for Dynamics 365.
-
How to Build an ETL App for Harvest Data in Python with CData
Create ETL applications and real-time data pipelines for Harvest data in Python with petl.
-
Automated Continuous Certinia Replication to MySQL
Use CData Sync for automated, continuous, customizable Certinia replication to MySQL.
-
Using the CData Software ODBC Driver for QuickBooks in PyCharm
Connect to QuickBooks as an ODBC data source in PyCharm using the CData Software ODBC Driver for QuickBooks.
-
Build Semantic Layer Views for ZohoExpense Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ZohoExpense data.
-
Enable the Spark JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Spark data.
-
Search External FHIR Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of FHIR data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create FHIR Data objects that you can access from apps and the dashboard.
-
Integrate Trae with Live LinkedIn Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live LinkedIn Ads data from within the AI-powered IDE.
-
How to create Guru federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Guru data in MySQL .
-
Integrating GitHub Copilot with iContact 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.
-
Replicate Multiple Zoho Creator Accounts via the CData Sync CLI
Replicate multiple Zoho Creator accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for HelloSign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HelloSign.
-
Use the CData ODBC Driver for Codat from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Codat to connect to Codat data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Codat data in Excel.
-
Connect to CapsuleCRM Data in Jaspersoft Studio
Execute SQL to remote CapsuleCRM data in Jaspersoft Studio.
-
How to Access Live SAP Ariba Procurement Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Ariba Procurement enables you to integrate SAP Ariba Procurement data into workflows built using Microsoft Power Automate Desktop.
-
Build an MVC Application with Connectivity to QuickBooks
CData ADO.NET Providers can be used from many tools and IDEs. In this article we show how to connect to QuickBooks from an MVC project using the CData ADO.NET Provider for QuickBooks. Although this article uses the QuickBooks Data Provider, the same process can be used with any of the CData ADO.NET Providers.
-
Replicate IBM Cloud Object Storage Data in Heroku for Use in Salesforce Connect
Replicate IBM Cloud Object Storage data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating PDFMonkey Data in Talend Cloud Data Management Platform
Connect PDFMonkey Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous MailChimp Replication to SQL Server
Use CData Sync for automated, continuous, customizable MailChimp replication to SQL Server.
-
Visualize Reckon Data in TIBCO Spotfire through ADO.NET
Integrate Reckon data into dashboards in TIBCO Spotfire.
-
Creating MariaDB-Connected Applications in Unqork
You can use CData Connect AI to feed MariaDB data to Unqork and build custom business apps.
-
Connect to Short.io Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Short.io data in the Denodo Virtual DataPort Administrator.
-
Integrate Live Facebook Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Facebook data and integrate live Facebook data into apps built in Microsoft Power Apps.
-
Create SAP Concur-Connected Applications in Appsmith
Connect to SAP Concur Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Concur data.
-
Create Apps from Notion Data in Qlik Sense Cloud
Use CData Connect AI to connect to Notion Data and build apps from live Notion data in Qlik Sense Cloud.
-
Create ZohoDesk Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoDesk from PowerBI.com to create Power BI Dataflows with real-time data.
-
Link Rootly with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Rootly data in Filemaker Pro for Mac or Windows.
-
A PostgreSQL Interface for Lakebase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Lakebase JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with ADP Data in Apache Spark using SQL
Access and process ADP Data in Apache Spark using the CData Software JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Acumatica Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Acumatica data for you.
-
Visualize SAP Business Warehouse Data in Tableau
The CData ODBC driver for SAP Business Warehouse enables you integrate SAP Business Warehouse data into Tableau dashboards.
-
Connect to Monday.com Data from HeidiSQL
Use CData Connect AI to connect to and query live Monday.com data from HeidiSQL.
-
Build LinkedIn-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 LinkedIn data without replication.
-
Connect to SingleStore Data in DBeaver
Use the CData ODBC Driver to connect to SingleStore data in DBeaver.
-
Automated Continuous Access Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Access replication to Apache Cassandra.
-
Access Live Amazon DynamoDB Data in TIBCO Data Virtualization
Use the Amazon DynamoDB Tibco DV Adapter to create a Amazon DynamoDB data data source in TIBCO Data Virtualization Studio and gain access to live Amazon DynamoDB data from your TDV Server.
-
Integrating LlamaIndex with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Certinia data in real time.
-
Replicate Multiple Browserless Accounts
Replicate multiple Browserless accounts to one or many databases.
-
How to Easily Query Oracle SCM Data in OpenOffice Base
Connect to Oracle SCM data in OpenOffice Base using the CData ODBC Driver for Oracle SCM and generate reports with live data insights.
-
Automated Continuous Perigon Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Perigon replication to Amazon Redshift.
-
Stream Presto Data into Apache Kafka Topics
Access and stream Presto data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Scrapfly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Scrapfly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Scrapfly data.
-
Visualize Live Microsoft Entra ID Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Entra ID data into custom reports in Power BI.