CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData JDBC Driver for Box
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Box.
-
Automated Continuous Google Contacts Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Contacts replication to delimited files (CSV/TSV).
-
Analyze Live HubDB Data in SAS Viya
Use CData Connect AI to connect to HubDB data from SAS Viya and deploy self-service analytics using live HubDB data.
-
Build Semantic Layer Views for Printify Data in APOS Live Data Gateway
Use the CData Connector for Printify in APOS Live Data Gateway to build Semantic Layer Views for Printify data.
-
AfterShip Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on AfterShip facts in real time.
-
Enable the Qualaroo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Qualaroo data.
-
Integrating Cursor with Optimizely 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.
-
Process & Analyze Impala Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Impala Data.
-
Getting Started with the CData Tableau Connector for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Creator.
-
Integrating LangChain with MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MailerLite data within automated workflows.
-
How to integrate Metabase with Omnisend Data
Use CData Connect AI to connect to live Omnisend data and create an interactive dashboard in Metabase from Omnisend data.
-
Connect to SAP Netweaver Gateway Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Netweaver Gateway as an External Source in Dremio.
-
Automated Continuous ZeroBounce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZeroBounce replication to PostgreSQL.
-
Connect to Real-Time AdRoll Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use AdRoll data in Power Apps.
-
Build an OLAP Cube in SSAS from SageHR Data
Establish a connection to SageHR data data from SQL Server Analysis Services, and use the SageHR Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Business Warehouse
Provide connectivity to SAP Business Warehouse data through an SAP BusinessObjects universe.
-
Automated Continuous Sugar CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sugar CRM replication to SingleStore.
-
Use Biml to Build SSIS Tasks to Replicate Strava Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Strava data to SQL Server.
-
Create Reports from Oracle Eloqua Data in Looker Studio
Use CData Connect AI to gain access to live Oracle Eloqua data and create custom reports in Looker Studio.
-
Configure the CData JDBC Driver for Close in a Connection Pool in Tomcat
Connect to Close data from a connection pool in Tomcat.
-
Analyze Office 365 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Office 365 from Power Pivot. You will use the Table Import Wizard to load Office 365 data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live SAP Ariba Procurement Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAP Ariba Procurement data for you.
-
Query Live Neo4J 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 Neo4J data through a conversational interface.
-
Connect to ActiveCampaign Data from AWS Glue
Use CData Connect AI to gain access to live ActiveCampaign data from your AWS Glue jobs.
-
Use ChatGPT to Talk to Your Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft OneDrive data for you.
-
Build an OLAP Cube in SSAS from ShipEngine Data
Establish a connection to ShipEngine data data from SQL Server Analysis Services, and use the ShipEngine Data Provider to build OLAP cubes for use in analytics and reporting.
-
Write a Simple Go Application to work with Cloudant Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cloudant data.
-
Integrate Live Microsoft Entra ID Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Microsoft Entra ID data from within the IDE.
-
Automated Continuous Pushbullet Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pushbullet replication to Apache Kafka.
-
Connect to Mailgun Data in CloverDX (formerly CloverETL)
Transfer Mailgun data using the visual workflow in the CloverDX data integration tool.
-
Visualize SpaceX 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 SpaceX data into TIBCO Spotfire.
-
Visualize Live SAP Fieldglass Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Fieldglass data into custom reports in Power BI.
-
Work with Live Typeform Data in Power Query
Use CData Connect AI to connect to Typeform data and work with live Typeform data in Microsoft Power Query.
-
Query ZohoExpense Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoExpense data.
-
Build SingleStore-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SingleStore data and build SingleStore-connected web apps with Axios.
-
Integrating LlamaIndex with Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Table data in real time.
-
Connect Microsoft Entra ID Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Entra ID data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect and Query Live SurveyMonkey Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SurveyMonkey data into Databricks and enable direct, live querying and analysis without replication.
-
Connect Amazon S3 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amazon S3 data using the CData Python MCP Server.
-
Use the CData Software JDBC Driver for MariaDB in MicroStrategy Desktop
Connect to MariaDB data in MicroStrategy Desktop using the CData Software JDBC Driver for MariaDB.
-
Automate SAP Ariba Procurement Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Ariba Procurement data replication to SAP HANA.
-
Analyze YouTube Analytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of YouTube Analytics data and visualize YouTube Analytics data in SAP Analytics Cloud.
-
Build Outreach.io-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Outreach.io data.
-
Connect to Keap Data from PowerBuilder via ADO.NET
This article demonstrates how to access Keap data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Replicate Multiple Stripe Accounts
Replicate multiple Stripe accounts to one or many databases.
-
Automate OData Services Replication to Azure Data Lake
Use CData Sync to customize and automate OData services replication to Azure Data Lake.
-
Easily Integrate MYOB AccountRight Data in Lazarus Pascal IDE
Learn how to easily integrate live MYOB AccountRight data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Omnisend Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Omnisend replication to Google Cloud SQL.
-
Migrating data from SAP Ariba Procurement to Databricks using CData SSIS Components.
Easily push SAP Ariba Procurement data to Databricks using the CData SSIS Tasks for SAP Ariba Procurement and Databricks.
-
ETL Paymo in Oracle Data Integrator
This article shows how to transfer Paymo data into a data warehouse using Oracle Data Integrator.
-
Connect to Procore Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Procore and work with Procore data in your FileMaker application.
-
Access MongoDB Data from MySQL in Amazon QuickSight
Connect to MongoDB and build visualizations of MongoDB data using a MySQL Connection in Amazon QuickSight.
-
Use Grok to Talk to Your Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Microsoft Entra ID data for you.
-
Use the CData Software JDBC Driver for Klaviyo in MicroStrategy Web
Connect to Klaviyo data in MicroStrategy Web using the CData Software JDBC Driver for Klaviyo.
-
Use the CData ODBC Driver for Tanda in Microsoft Power Query
You can use the CData Tanda ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Tanda data into Microsoft Power Query.
-
Connect and Visualize Live Salesforce Data 360 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce Data 360 data into the Databricks platform and create visualization dashboards with real-time Salesforce Data 360 data.
-
Automated Continuous Phoenix Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Phoenix replication to Amazon Redshift.
-
Integrating ConvertKit Data in Talend Cloud Data Management Platform
Connect ConvertKit Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live SparkPost Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SparkPost data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Instantly Data in Jaspersoft Studio
Execute SQL to remote Instantly data in Jaspersoft Studio.
-
Design BIRT Reports on Printful Data
Provide current Printful data to your embedded analytics.
-
Access Live Dynamics 365 Data in AWS Lambda
Connect to live Dynamics 365 data in AWS Lambda using the CData JDBC Driver.
-
Build AI/ML Models with Live Aha! Data using Dataiku
Connect Aha! Data with Dataiku using the CData API Driver for JDBC.
-
Build Dashboards with YouTube Analytics Data in Dundas BI
Create dynamic dashboards and perform analytics based on YouTube Analytics data in Dundas BI.
-
Connect to Redis Data in NetBeans
Connect to Redis data in NetBeans with the data source configuration wizard.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy Desktop
Connect to Everhour data in MicroStrategy Desktop using the CData Software JDBC Driver for Everhour.
-
Analyze RabbitMQ Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze RabbitMQ data in Microsoft R Open.
-
Connect to Live ConstantContact Data in MicroStrategy through CData Connect AI
Create a live connection to ConstantContact Data in CData Connect AI and connect to your ConstantContact data from MicroStrategy.
-
Use the CData SSIS Components to Insert New or Update Existing Jira Assets Records from SQL Server
Easily push SQL Server data to Jira Assets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Jira Assets or update existing records with data from a SQL Server database.
-
Connect to Microsoft Dataverse Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Dataverse data in Airbyte.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP HANA XS Advanced
Provide connectivity to SAP HANA XS Advanced data through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for Deel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Deel.
-
Rapidly Develop Oracle-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Oracle.
-
Use Databricks Agent Bricks to Talk to Your Typeform Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Typeform data for you.
-
Connect to Instantly Data from a Connection Pool in Jetty
The Instantly JDBC Driver supports connection pooling: This article shows how to connect faster to Instantly data from Web apps in Jetty.
-
Integrate Cursor with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft OneDrive data from within the editor.
-
Create Data Visualizations Based On Facebook Data in Mode
Use CData Connect AI to connect to Facebook Data from Mode and build visualizations using live Facebook data.
-
Build MVC Applications with Connectivity to SAP HANA Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP HANA from an ASP.NET MVC application.
-
Load Cloudant Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Cloudant data to a database.
-
How to connect SharePoint with IBM Cloud Object Storage Data through external lists
Provide IBM Cloud Object Storage data to SharePoint users as an external list.
-
Getting Started with the CData Python Connector for Impala
Learn to install and license the CData Python Connector and configure a connection to live Impala data.
-
Integrating Cursor with OpenWeatherMap 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 a Singer.io Tap for Tickspot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Tickspot data using the CData Python Connector.
-
Design BIRT Reports on Webflow Data
Provide current Webflow data to your embedded analytics.
-
Getting Started with the CData Tableau Connector for LinkedIn
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for LinkedIn.
-
Connect to Twitter Ads Data in Aqua Data Studio
Access Twitter Ads data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Stripe Data Using Azure Data Factory
Use CData Connect AI to connect to Stripe Data from Azure Data Factory and import live Stripe data.
-
Query Bright Data Data in DataGrip
Create a Data Source for Bright Data in DataGrip and use SQL to query live Bright Data data.
-
Use Grok to Talk to Your Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Dynamics CRM data for you.
-
LINQ to Outlook Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Outlook Data Provider.
-
Visualize Parallel Data in Tableau
The CData ODBC driver for Parallel enables you integrate Parallel data into Tableau dashboards.
-
Automated Continuous Power BI XMLA Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to IBM DB2.
-
Publish Reports with Monday.com Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Monday.com data.
-
Working with AfterShip Data in LINQPad
Execute LINQ queries to AfterShip data in LINQPad.
-
Access Live Highrise Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Highrise data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import and Visualize ZohoMarketingHub Data in Power View
Create data visualizations based on ZohoMarketingHub data in Excel.
-
Automated Continuous Tickspot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Tickspot replication to Apache Cassandra.
-
Analyze Oracle Eloqua Reporting Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Eloqua Reporting data with the CData JDBC Driver for Oracle Eloqua Reporting.
-
Work with Shippo Data in FoxPro
Load Shippo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connecting Pipedream with Cloudflare Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Cloudflare data in real time.