CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze Excel Data in Alteryx Designer (ODBC)
Build workflows to access live Excel data for self-service data analytics.
-
Automated Continuous Clari Replication to MySQL
Use CData Sync for automated, continuous, customizable Clari replication to MySQL.
-
Use Databricks Agent Bricks to Talk to Your SAP BusinessObjects BI Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP BusinessObjects BI data for you.
-
Analyze API Data in Cognos Analytics
Use CData Connect AI to connect to API Data from Cognos Analytics and analyze live API data.
-
Integrating Claude Code CLI with SpaceX 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.
-
Use CData Connect AI to Access SQL Server Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SQL Server data in the Power Pivot business intelligence tool.
-
Viewing Trello Data in RAD Studio Data Explorer
How to view Trello data in RAD Studio Data Explorer using the CData ODBC Driver for Trello.
-
How to Connect to Live Google Calendar 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 Google Calendar data for you.
-
Use Dash to Build Web Apps on Discord Data via CData Connect AI
Build interactive Dash web apps on live Discord data using pandas and the CData Connect AI Python SDK.
-
Getting Started with the CData JDBC Driver for SendGrid
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SendGrid.
-
Use the CData ODBC Driver for Greenhouse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Greenhouse to connect to Greenhouse data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Greenhouse data in Excel.
-
Integrating GitHub Copilot 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.
-
Getting Started with the CData Tableau Connector for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Excel Online Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Excel Online data.
-
Connecting Pipedream with OData Services 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 OData data in real time.
-
Connecting Mastra with Google Cloud Storage 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 Google Cloud Storage data, no replication required.
-
Build AI/ML Models with Live BenchmarkEmail Data using Dataiku
Connect BenchmarkEmail Data with Dataiku using the CData API Driver for JDBC.
-
Stream Excel Data into Apache Kafka Topics
Access and stream Excel data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Microsoft Teams Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SingleStore.
-
Visualize MailChimp Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailChimp data.
-
Access Live BenchmarkEmail Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BenchmarkEmail data from your Excel spreadsheets.
-
Connect to ZendeskSell Data in RazorSQL
Connect to ZendeskSell from wizards and query ZendeskSell data from the GUI in the RazorSQL database management tool.
-
Build Semantic Layer Views for Procore Data in APOS Live Data Gateway
Use the CData Connector for Procore in APOS Live Data Gateway to build Semantic Layer Views for Procore data.
-
Integrating OpenCode with SAP Business Warehouse 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.
-
Automated Continuous Tanda Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Tanda replication to Apache Cassandra.
-
Getting Started with the CData Python Connector for JobNimbus
Learn to install and license the CData Python Connector and configure a connection to live JobNimbus data.
-
Working with Pinecone Data in LINQPad
Execute LINQ queries to Pinecone data in LINQPad.
-
Migrating data from Shippo to Snowflake using CData SSIS Components.
Easily push Shippo data to Snowflake using the CData SSIS Tasks for Shippo and Snowflake.
-
Automated Continuous DocuSign Replication to Amazon S3
Use CData Sync for automated, continuous, customizable DocuSign replication to Amazon S3.
-
Integrate REST Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live REST data from Informatica Cloud.
-
How to update MailChimp from Excel
This article explains how to transfer data from Excel to MailChimp using the Excel Add-In for MailChimp.
-
Visualize Live Highrise Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Highrise data.
-
Analyze AlloyDB Data in Cognos Analytics
Use CData Connect AI to connect to AlloyDB Data from Cognos Analytics and analyze live AlloyDB data.
-
Analyze Klaviyo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Klaviyo data and visualize Klaviyo data in SAP Analytics Cloud.
-
Build an OLAP Cube in SSAS from Printful Data
Establish a connection to Printful data data from SQL Server Analysis Services, and use the Printful Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Discord Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Discord replication to PostgreSQL.
-
Build AI/ML Models with Live Sage Intacct Data using Dataiku
Connect Sage Intacct Data with Dataiku using the CData JDBC Driver for Sage Intacct.
-
Visualize Vault CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Vault CRM data.
-
DataBind Charts to Foursquare Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Foursquare 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.
-
Build Cassandra Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Cassandra data and build visualizations in Tableau Cloud.
-
Use Manus AI to Talk to Your Tavily 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 Tavily data.
-
Use the CData Software ODBC Driver for SAP Hybris C4C in MicroStrategy Desktop
Connect to SAP Hybris C4C data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Hybris C4C.
-
Build Facebook-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Facebook data.
-
Query Nuclia Data as a MySQL Database in Node.js
Execute MySQL queries against Nuclia data from Node.js.
-
Connect to Exact Online Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Exact Online data using standard SQL.
-
Connect to LinkedIn Ads Data in HULFT Integrate
Connect to LinkedIn Ads as a JDBC data source in HULFT Integrate
-
Build Voice Agents in ElevenLabs with access to Live Procore Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Procore data.
-
Replicate Microsoft OneLake Data in Heroku for Use in Salesforce Connect
Replicate Microsoft OneLake data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Load Hubstaff Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Hubstaff data to a database.
-
Create Dynamic Excel Online Grids Using the Infragistics XamDataGrid
Learn how you can connect Excel Online to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Amazon DynamoDB Data in Alteryx Designer (Connect AI)
Build workflows to access live Amazon DynamoDB data for self-service data analytics.
-
Getting Started with the CData Connect AI Python SDK for Sage Cloud Accounting
Install the CData Connect AI Python SDK to read and write live Sage Cloud Accounting data with standard DB-API 2.0 Python code.
-
Connect to SAP Business Warehouse Data in Aqua Data Studio
Access SAP Business Warehouse data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
A PostgreSQL Interface for Cloudant Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cloudant JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Charts with LightSpeedRetail Data in Clear Analytics
Create dynamic charts and perform analytics based on LightSpeedRetail data in Clear Analytics.
-
Work with Onfleet Data in FoxPro
Load Onfleet data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Mailgun Data with Squirrel SQL client
Connect to Mailgun data and execute queries in the Squirrel SQL Client.
-
Connect to Freshdesk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Freshdesk data in Airbyte.
-
Viewing SAP Netweaver Gateway Data in RAD Studio Data Explorer
How to view SAP Netweaver Gateway data in RAD Studio Data Explorer using the CData ODBC Driver for SAP Netweaver Gateway.
-
How to Connect DBeaver to Tavily via a JDBC Driver
Manage Tavily data with visual tools in DBeaver like the query browser.
-
Build Visualizations of ZohoMarketingHub Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoMarketingHub data in Birst.
-
Automate YouTube Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access YouTube Analytics data from PowerShell? This article demonstrates how to utilize the YouTube Analytics Cmdlets for tasks like connecting to YouTube Analytics data, automating operations, downloading data, and more.
-
Connect to Perplexity Data in HULFT Integrate
Connect to Perplexity as a JDBC data source in HULFT Integrate
-
Analyze Clio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Clio from Power Pivot. You will use the Table Import Wizard to load Clio data. You can visually build the import query or use any SQL supported by the driver.
-
Query Google Campaign Manager 360 Data as a MySQL Database in Node.js
Execute MySQL queries against Google Campaign Manager 360 data from Node.js.
-
How to Connect the Power BI Service to Clockify: Complete Guide
Connect to the CData Software Power BI Connector for Clockify from PowerBI.com to provide real-time Clockify data across the organization.
-
Analyze Live Tavily Data in SAS Viya
Use CData Connect AI to connect to Tavily data from SAS Viya and deploy self-service analytics using live Tavily data.
-
Create Google Contacts-Connected Applications in Appsmith
Connect to Google Contacts Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Contacts data.
-
Connect to Quickbase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Quickbase and the SQL Gateway to access Quickbase data from Google Apps Script.
-
Integrate Cursor with Live Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sage 300 data from within the editor.
-
Connect Reply.io to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Reply.io with IBM WebSphere for seamless data integration and connectivity.
-
How to Query Jira Data in MySQL Workbench
Execute MySQL queries against live Jira data from MySQL Workbench.
-
Link Bugsnag with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bugsnag data in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData JDBC Driver for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage Cloud Accounting.
-
Visualize Vimeo Data in TIBCO Spotfire through ADO.NET
Integrate Vimeo data into dashboards in TIBCO Spotfire.
-
Connect to ZohoExpense in SpagoBI
Create reports featuring live ZohoExpense data in SpagoBI Studio. Host ZohoExpense reports on SpagoBI Server.
-
Analyze WordPress Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of WordPress data and visualize live WordPress data in Infragistics Reveal.
-
Create Confluence-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Confluence Data from OutSystems and build custom enterprise apps using live Confluence data.
-
How to integrate Amplitude with Apache Airflow
Access and process Amplitude data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Coda Replication to SingleStore
Use CData Sync for automated, continuous, customizable Coda replication to SingleStore.
-
How to create an RPA flow for Shopify Data in UiPath Studio
Use the Shopify ODBC Driver to create workflows that access real-time Shopify data without any coding.
-
Connect to Salesforce CRM Analytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce CRM Analytics Data and connect to Salesforce CRM Analytics data in Akorbi Digital RunMyProcess.
-
Integrate Pipeliner CRM Data in the Pentaho Report Designer
Publish reports based on Pipeliner CRM data in the Pentaho BI tool.
-
DataBind Charts to VWO Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to VWO 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.
-
ETL Sugar CRM in Oracle Data Integrator
This article shows how to transfer Sugar CRM data into a data warehouse using Oracle Data Integrator.
-
Integrate with Pinterest Data in JReport Designer
Create charts and reports based on Pinterest data in JReport Designer.
-
Getting Started with the CData ADO.NET Provider for Missive
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous xBase Replication to SQLite
Use CData Sync for automated, continuous, customizable xBase replication to SQLite.
-
Integrate OpenCode with Live GraphQL Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live GraphQL data from within your AI coding agent.
-
Automated Continuous Teradata Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Teradata replication to Amazon Redshift.
-
How to Connect the Power BI Service to Dynamics CRM: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics CRM from PowerBI.com to provide real-time Dynamics CRM data across the organization.
-
Enable the ShipEngine JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ShipEngine data.
-
How to create an RPA flow for GraphQL Data in UiPath Studio
Use the GraphQL ODBC Driver to create workflows that access real-time GraphQL data without any coding.
-
Codat Reporting in OBIEE with the Codat JDBC Driver
Deploy the Codat JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Snapchat Ads Data Replication to Azure Synapse
Use CData Sync to customize and automate Snapchat Ads data replication to Azure Synapse.
-
Automate Azure Data Lake Storage Data Replication to SAP HANA
Use CData Sync to customize and automate Azure Data Lake Storage data replication to SAP HANA.
-
Process & Analyze Float Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Float Data.
-
How to Connect to Live HCL Domino Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your HCL Domino data for you.
-
Access Live QuickBooks Data in AWS Lambda (with IntelliJ IDEA)
Connect to live QuickBooks data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Trigger Active Directory IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Active Directory with standard wizards in Logic Apps.