CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Excel Add-In for Twilio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Twilio.
-
How to publish and share PabblySubscriptions Data dashboards with Tableau Server
The CData ODBC driver for PabblySubscriptions enables you integrate PabblySubscriptions into Tableau dashboards.
-
Use Microsoft Copilot Studio to talk to your Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Trello for you.
-
Explore Geographical Relationships in CampaignMonitor Data with Power Map
Create data visualizations with CampaignMonitor in Power Map.
-
Integrating Cursor CLI with Qualaroo 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 LlamaIndex with SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Business One in real time.
-
Connect to SAS xpt Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAS xpt Data and connect to SAS XPORT in Akorbi Digital RunMyProcess.
-
Access SAS xpt Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAS XPORT from your Oracle system.
-
Migrating data from Google Cloud Storage to Databricks using CData SSIS Components.
Easily push Google Cloud Storage to Databricks using the CData SSIS Tasks for Google Cloud Storage and Databricks.
-
Migrating data from Google Analytics to Google BigQuery using CData SSIS Components.
Easily push Google Analytics to Google BigQuery using the CData SSIS Tasks for Google Analytics and Google BigQuery.
-
Connect to Twilio in SpagoBI
Create reports featuring live Twilio in SpagoBI Studio. Host Twilio reports on SpagoBI Server.
-
Connecting Pipedream with Couchbase 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 Couchbase data in real time.
-
How to Import Data from Amazon Marketplace into Google Sheets
Import Amazon Marketplace into a Google spreadsheet that is automatically refreshed.
-
Create Dynamic Reply.io Grids Using the Infragistics XamDataGrid
Learn how you can connect Reply.io to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Epicor Kinetic in SpagoBI
Create reports featuring live Epicor Kinetic in SpagoBI Studio. Host Epicor Kinetic reports on SpagoBI Server.
-
Create Testmonitor Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Testmonitor from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Dataiku with Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Ads.
-
Visualize Live Instagram Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Instagram into custom reports in Power BI.
-
Create Data Visualizations Based On SurveyMonkey Data in Mode
Use CData Connect AI to connect to SurveyMonkey Data from Mode and build visualizations using live
-
Enable the Reckon Accounts Hosted JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Reckon Accounts Hosted.
-
Use JayDeBeApi to access Google Tasks Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Tasks.
-
Bidirectional Access to Wave Financial Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Wave Financial in Filemaker Pro for Mac or Windows.
-
ETL EnterpriseDB in Oracle Data Integrator
This article shows how to transfer EnterpriseDB into a data warehouse using Oracle Data Integrator.
-
Create Datasets from Jira Assets in Domo Workbench and Build Visualizations of Jira Assets Data in Domo
Use the CData Software ODBC Driver for Jira Assets to create datasets from Jira Assets in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Google Campaign Manager 360 Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Campaign Manager 360 from HeidiSQL.
-
Use the CData Software ODBC Driver for Productboard in MicroStrategy Desktop
Connect to Productboard in MicroStrategy Desktop using the CData Software ODBC Driver for Productboard.
-
How to Build an ETL App for Printful Data in Python with CData
Create ETL applications and real-time data pipelines for Printful in Python with petl.
-
Access Certinia Data from MySQL in PHP
Connect to Certinia through the standard MySQL libraries in PHP.
-
Prepare, Blend, and Analyze HubSpot Data in Alteryx Designer (Connect AI)
Build workflows to access live HubSpot for self-service data analytics.
-
How to Work with Oracle Financials Cloud Data in AWS Glue Jobs Using JDBC
Connect to Oracle Financials Cloud from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate iContact Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live iContact from Informatica Cloud.
-
Automated Continuous ZohoMarketingHub Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Snowflake.
-
How to connect to Microsoft Exchange Data with Squirrel SQL client
Connect to Microsoft Exchange and execute queries in the Squirrel SQL Client.
-
Build AI/ML Models with Live MailChimp Data using Dataiku
Connect MailChimp Data with Dataiku using the CData JDBC Driver for MailChimp.
-
Use the CData Software ODBC Driver for Chargebee in SAS for Real-Time Reporting and Analytics
Connect to real-time Chargebee in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Chargebee.
-
Connecting Mastra with Oracle HCM Cloud 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 Oracle HCM Cloud, no replication required.
-
Create Dynamic Missive Grids Using the Infragistics XamDataGrid
Learn how you can connect Missive to Infragistics XamDataGrid to build dynamic grids.
-
Use ChatGPT to Talk to Your Sybase IQ 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 Sybase IQ for you.
-
Query Dynamics NAV Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dynamics NAV entities in PHP by modeling them as objects.
-
How to Query Pinterest Data in MySQL Workbench
Execute MySQL queries against live Pinterest from MySQL Workbench.
-
Integrate Real-Time Access to Basecamp in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Basecamp in real time.
-
Connect to Salesforce Data 360 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce Data 360 and the SQL Gateway to access Salesforce Data 360 from Google Apps Script.
-
How to Build an ETL App for Spark Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Spark SQL in Python with petl.
-
Prepare, Blend, and Analyze Twitter Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Twitter Ads for self-service data analytics.
-
Integrate Live Cvent Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Connect Jira Assets Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Jira Assets data in real time using natural language.
-
How to Access Live Trello Data in Visual Studio Code via Cline
Run CData MCP Server for Trello on Windows Subsytem for Linux (WSL) and connect to live Trello from the Cline extension in Visual Studio Code.
-
Replicate Float Data in Heroku for Use in Salesforce Connect
Replicate Float to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Live Perigon Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Perigon using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Deploy the ADO.NET Provider for Sendwithus on an SSRS Report Server
Connect to Sendwithus from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Consume Twitter Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Twitter Ads as OData feeds from PowerBuilder using the API Server.
-
How to use SQLAlchemy ORM to access ClickUp Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ClickUp.
-
Automate Kafka Data Replication to Couchbase
Use CData Sync to Customize and automate Apache Kafka replication to Couchbase.
-
Work with Microsoft Planner Data in FoxPro
Load Microsoft Planner into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Stack Exchange-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Stack Exchange and build web apps with connectivity to live Stack Exchange.
-
Create Azure Data Catalog Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure Data Catalog from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Charts to Pipeliner CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Pipeliner CRM 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.
-
How to import Planio Data into Apache Solr
Use the CData Software JDBC Driver for Planio in Data Import Handler and create an automated import of Planio to Apache Solr Enterprise Search platform.
-
Create Dynamic OneNote Grids Using the Infragistics XamDataGrid
Learn how you can connect OneNote to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to Printful Data with Squirrel SQL client
Connect to Printful and execute queries in the Squirrel SQL Client.
-
Visualize Live Pinecone Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pinecone using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Apify Data using the CData ODBC Driver
Use the SQL Gateway and Apify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Codat Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Codat. Leverage the native support for ODBC in PHP.
-
Create Highrise-Connected Business Apps in AppSheet
Connect to Highrise Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Highrise CRM.
-
Build Semantic Layer Views for ConstantContact Data in APOS Live Data Gateway
Use the CData Connector for ConstantContact in APOS Live Data Gateway to build Semantic Layer Views for ConstantContact.
-
Work with SurveyMonkey Data in FoxPro
Load SurveyMonkey into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Pinterest Data in Ruby
Connect to Pinterest in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Building Dynamic Web Pages with Amazon DynamoDB Data Using AngularJS
Create single-page applications with live connectivity to Amazon DynamoDB using the CData API Server.
-
Automated Continuous JotForm Replication to SQL Server
Use CData Sync for automated, continuous, customizable JotForm replication to SQL Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Redis using the Model Context Protocol.
-
Access Live Mocean Data in Coginiti Pro
Connect to and query live Mocean from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect DBeaver to Foursquare via a JDBC Driver
Manage Foursquare with visual tools in DBeaver like the query browser.
-
DataBind LinkedIn Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for LinkedIn Ads with the DevExpress Windows Forms and Web controls to provide LinkedIn Ads to a chart.
-
Integrate Cline with Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sugar CRM from within your IDE.
-
Import and Visualize LaunchDarkly Data in Power View
Create data visualizations based on LaunchDarkly in Excel.
-
Automated Continuous IBM Cloud Object Storage Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to OneLake in Microsoft Fabric.
-
Connect to ServiceNow Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ServiceNow Data and connect to ServiceNow in Akorbi Digital RunMyProcess.
-
Connect to Deel Data from PowerBuilder via JDBC
This article demonstrates how to access Deel from PowerBuilder using the Deel JDBC Driver.
-
Query Vault CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Veeva Vault & Vault CRM from Node.js.
-
Query Testmonitor Data in ColdFusion
Write standard ColdFusion data access code to connect to Testmonitor.
-
Create Azure DevOps-Connected Applications in Appsmith
Connect to Azure DevOps Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure DevOps.
-
Automated Continuous Hubstaff Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Hubstaff replication to Amazon S3.
-
Connect to Phoenix Data from HeidiSQL
Use CData Connect AI to connect to and query live Apache Phoenix from HeidiSQL.
-
Connect to Google Ad Manager Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Ad Manager.
-
Build Dynamics 365-Connected Apps in Choreo
Use CData Connect AI to connect to Dynamics 365 Data from Choreo and build custom apps using live Microsoft Dynamics 365.
-
Use Biml to Build SSIS Tasks to Replicate Certinia Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Certinia to SQL Server.
-
Bidirectional Access to Dynamics NAV Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics NAV in Filemaker Pro for Mac or Windows.
-
Build a Singer.io Tap for Workable With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Workable data using
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce for you.
-
How to Connect to Live Salesforce Pardot Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Salesforce Pardot through natural language.
-
Access Live Salesforce Data in Coginiti Pro
Connect to and query live Salesforce & Force.com from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Live Jira Assets Data in MicroStrategy through CData Connect AI
Create a live connection to Jira Assets Data in CData Connect AI and connect to your Jira Assets from MicroStrategy.
-
Rapidly Develop SAP Ariba Source-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 SAP Ariba Source.
-
Natively Connect to Shopify Data in PHP
The CData ODBC driver for Shopify enables you to create PHP applications with connectivity to Shopify. Leverage the native support for ODBC in PHP.
-
Automated Continuous Bannerbear Replication to SingleStore
Use CData Sync for automated, continuous, customizable Bannerbear replication to SingleStore.
-
Analyze Microsoft Planner Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Planner and visualize live Microsoft Planner in Infragistics Reveal.
-
Connect to Amazon DynamoDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Amazon DynamoDB using standard SQL.
-
Automated Continuous Zoho Books Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho Books replication to SQL Server.
-
Integrating Dataiku with Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Exchange.
-
Access Live ZarMoney Data in AWS Lambda
Connect to live ZarMoney in AWS Lambda using the CData JDBC Driver.