CData Software - Knowledge Base
Recent Articles
-
Create Dynamic ZohoSubscriptions Grids Using the Infragistics XamDataGrid
Learn how you can connect ZohoSubscriptions to Infragistics XamDataGrid to build dynamic grids.
-
How to Access Live VWO Data in Power Automate Desktop via ODBC
The CData ODBC Driver for VWO enables you to integrate VWO into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous BambooHR Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable BambooHR replication to delimited files (CSV/TSV).
-
Integrate with Live Snowflake Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Snowflake from the MuleSoft Anypoint Platform to integrate live Snowflake into custom reports and dashboards.
-
Integrate with Live GraphQL Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to GraphQL from the MuleSoft Anypoint Platform to integrate live GraphQL into custom reports and dashboards.
-
Integrate with live QuickBooks Time Data in Jitterbit
Use CData Connect AI to connect to and integrate live QuickBooks Time in Jitterbit.
-
Import Real-Time Autopilot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Autopilot in ColdFusion.
-
Connect to Greenplum Data in RazorSQL
Connect to Greenplum from wizards and query Pivotal GreenPlum from the GUI in the RazorSQL database management tool.
-
Integrate Phoenix Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apache Phoenix and integrate live Apache Phoenix into your Power Automate tasks.
-
Integrate Cursor with Live WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live WooCommerce from within the editor.
-
Zoho Creator Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho Creator facts in real time.
-
How to Visualize Slack Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Slack in Python.
-
Create Google Analytics-Connected Applications in Appsmith
Connect to Google Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Analytics.
-
Build Zoho Inventory-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho Inventory Data and create custom apps in Mendix.
-
Automated Continuous Drip Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Drip replication to Azure SQL Database.
-
Automate ZohoDesk Data Replication to Couchbase
Use CData Sync to Customize and automate ZohoDesk replication to Couchbase.
-
Stream WordPress Data into Apache Kafka Topics
Access and stream WordPress in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to SAS xpt Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAS XPORT from Crystal Reports.
-
Feed Couchbase Data into FineReport
How to set Couchbase as a JDBC data source in FineReport.
-
Automated Continuous Elasticsearch Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Elasticsearch replication to AlloyDB.
-
Use Azure AI Foundry to Talk to Your MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your MarkLogic for you.
-
Build a Simple VCL Application for Adobe Experience Manager Data
How to build a simple VCL Application to view Adobe Experience Manager in RAD Studio using the CData ODBC Driver for Adobe Experience Manager.
-
How to Work with Reckon Accounts Hosted Data in ETL Validator JDBC
Connect to Reckon Accounts Hosted from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Wave Financial Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Wave Financial to SQL Server.
-
How to create MarkLogic federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MarkLogic in MySQL .
-
Integrate YouTube Analytics Data in Pentaho Data Integration
Build ETL pipelines based on YouTube Analytics in the Pentaho Data Integration tool.
-
How to integrate Metabase with Trello Data
Use CData Connect AI to connect to live Trello and create an interactive dashboard in Metabase from Trello.
-
Integrating GitHub Copilot CLI with Salesforce Pardot 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.
-
Deploy the ADO.NET Provider for xBase on an SSRS Report Server
Connect to xBase 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.
-
Connect to Tickspot Data in DBArtisan
Use wizards in DBArtisan to configure Tickspot as a data source.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Concur within intelligent workflows.
-
Moving Data from Foursquare to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Foursquare data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Work with Box Data in AWS Glue Jobs Using JDBC
Connect to Box from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Manus AI to Talk to Your WooCommerce 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 WooCommerce.
-
Query Outlook Data as a MySQL Database in Node.js
Execute MySQL queries against Outlook from Node.js.
-
Bidirectional Access to Vimeo Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Vimeo in Filemaker Pro for Mac or Windows.
-
Use the CData ODBC Driver for BigQuery from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for BigQuery to connect to Google BigQuery from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google BigQuery in Excel.
-
Connect to Billsby Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Billsby and work with Billsby in your FileMaker applications.
-
How to Query REST Data in MySQL Workbench
Execute MySQL queries against live REST from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho Books
Provide connectivity to Zoho Books through an SAP BusinessObjects universe.
-
Back Up ZohoPeople to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoPeople data.
-
Build MVC Applications with Connectivity to Copper Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Copper from an ASP.NET MVC application.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics NAV
Provide connectivity to Microsoft Dynamics NAV through an SAP BusinessObjects universe.
-
Integrate Cline with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live IBM Cloud Object Storage from within your IDE.
-
Use Azure AI Foundry to Talk to Your Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Sheets for you.
-
Use Agno to Talk to Your FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your FreshBooks for you.
-
Connect to Salesloft Data in CloverDX (formerly CloverETL)
Transfer Salesloft using the visual workflow in the CloverDX data integration tool.
-
Create Microsoft Teams Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Teams from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData ODBC Driver for Kintone
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Kintone.
-
Natively Connect to Dropbox Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dropbox. Leverage the native support for ODBC in PHP.
-
Connect to Mistral AI Data in JRuby
Create a simple JRuby app with access to live Mistral AI.
-
How to Connect DBeaver to Planio via a JDBC Driver
Manage Planio with visual tools in DBeaver like the query browser.
-
Automated Continuous Microsoft Teams Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to PostgreSQL.
-
Connect to LeadDesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LeadDesk and the SQL Gateway to access LeadDesk from Google Apps Script.
-
Automated Continuous ADP Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ADP replication to AlloyDB.
-
Publish WooCommerce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live WooCommerce.
-
Integrate Goose with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure DevOps from within the local AI agent.
-
Integrate Pushbullet Data in Pentaho Data Integration
Build ETL pipelines based on Pushbullet in the Pentaho Data Integration tool.
-
Integrating LangGraph with Epicor Kinetic Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Epicor Kinetic within automated workflows.
-
Getting Started with the CData JDBC Driver for Exa
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Exa.
-
Deploying CData Sync in a Kubernetes Environment
Deploy CData Sync in a Containerized Kubernetes Environment.
-
LINQ to HubSpot 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 HubSpot Data Provider.
-
How to create SAP Ariba Source federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Ariba Source in MySQL .
-
Connect to RSS from a Connection Pool in WebLogic
Use the CData JDBC Driver for RSS to connect to RSS Feeds from Web applications running on WebLogic.
-
Integrate LibreChat with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Search from within the chat interface.
-
Use Claude to Talk to Your Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Jira Assets for you.
-
How to Easily Query SendGrid Data in OpenOffice Base
Connect to SendGrid data in OpenOffice Base using the CData ODBC Driver for SendGrid and generate reports with live data insights.
-
How to Build an ETL App for Microsoft Dataverse Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Dataverse (CDS) in Python with petl and the CData Connect AI Python SDK.
-
How to Work with Paddle Data in AWS Glue Jobs Using JDBC
Connect to Paddle from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Harvest Data from a Connection Pool in JBoss
Integrate Harvest into Java servlets: Use the Management Console in JBoss to install the Harvest JDBC Driver.
-
Connect Mailjet Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mailjet using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Google Drive from Asprova with CData Software ODBC Driver for Google Drive
This article shows how to connect faster to Google Drive data from Asprova.
-
Migrating data from MariaDB to Google BigQuery using CData SSIS Components.
Easily push MariaDB to Google BigQuery using the CData SSIS Tasks for MariaDB and Google BigQuery.
-
Use JayDeBeApi to access Slack Data in Python
Use standard Python scripting and the development environment of your choice to access live Slack.
-
Query SAP Business One Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Business One entities in PHP by modeling them as objects.
-
Manage Microsoft OneDrive Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft OneDrive.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Teams Data
Use CData Power BI Connectors to visualize Microsoft Teams in Power BI.
-
Natively Connect to Salesforce Pardot Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Pardot. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Databricks Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Databricks securely in real time.
-
How to create Couchbase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Couchbase in MySQL .
-
Connect to SendInBlue from Asprova with CData Software ODBC Driver for SendInBlue
This article shows how to connect faster to SendInBlue data from Asprova.
-
Design BIRT Reports on Salesforce Data 360 Data
Provide current Salesforce Data 360 to your embedded analytics.
-
Create Informatica Mappings From/To an ODBC Data Source for Perplexity
Create an ODBC connection to Perplexity in Informatica and browse and transfer Perplexity.
-
Analyze Microsoft Entra ID Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Entra ID and visualize live Microsoft Entra ID in Infragistics Reveal.
-
Integrate Live Auth0 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Auth0 to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Natively Connect to Keap Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Keap. Leverage the native support for ODBC in PHP.
-
Viewing Optimizely Data in RAD Studio Data Explorer
How to view Optimizely in RAD Studio Data Explorer using the CData ODBC Driver for Optimizely.
-
Getting Started with the CData ODBC Driver for JotForm
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for JotForm.
-
Integrate Live Google Drive Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Drive and integrate live Google Drive into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for Procore in MicroStrategy Web
Connect to Procore in MicroStrategy Web using the CData Software JDBC Driver for Procore.
-
How to use SQLAlchemy ORM to access Mouseflow Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mouseflow.
-
Query SAS xpt Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAS xpt entities in PHP by modeling them as objects.
-
Excel Spreadsheet Automation on Slack Data with the QUERY Formula
Pull data from Slack, automate spreadsheets, and more with the QUERY formula.
-
Easily Integrate Vercel Data in Lazarus Pascal IDE
Learn how to easily integrate live Vercel in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData ODBC Driver for Bitbucket in Microsoft Power Query
You can use the CData Bitbucket ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bitbucket into Microsoft Power Query.
-
Migrating data from Cvent to Snowflake using CData SSIS Components.
Easily push Cvent to Snowflake using the CData SSIS Tasks for Cvent and Snowflake.
-
Integrate Pipeliner CRM Data in Pentaho Data Integration
Build ETL pipelines based on Pipeliner CRM in the Pentaho Data Integration tool.
-
Connect to Invoiced Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Invoiced and work with Invoiced in your FileMaker applications.
-
Build Agents in Relevance AI with Access to Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Eloqua within intelligent agent workflows.
-
Integrating Cursor CLI with ZohoSubscriptions 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.