CData Software - Knowledge Base
Recent Articles
-
Connect to SAS xpt Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAS xpt data from Crystal Reports.
-
Feed Couchbase Data into FineReport
How to set Couchbase data 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 data for you.
-
Build a Simple VCL Application for Adobe Experience Manager Data
How to build a simple VCL Application to view Adobe Experience Manager data 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 data 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 data in MySQL .
-
Integrate YouTube Analytics Data in Pentaho Data Integration
Build ETL pipelines based on YouTube Analytics data in the Pentaho Data Integration tool.
-
How to integrate Metabase with Trello Data
Use CData Connect AI to connect to live Trello data and create an interactive dashboard in Metabase from Trello data.
-
Integrating GitHub Copilot with Salesforce Pardot 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.
-
Deploy the ADO.NET Provider for xBase on an SSRS Report Server
Connect to xBase data 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 data as a data source.
-
Integrate Google's Vertex AI Agent with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Concur data 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 data.
-
Query Outlook Data as a MySQL Database in Node.js
Execute MySQL queries against Outlook data from Node.js.
-
Link Vimeo with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Vimeo data 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 BigQuery data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring BigQuery data 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 data in your FileMaker applications.
-
How to Query REST Data in MySQL Workbench
Execute MySQL queries against live REST data from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho Books
Provide connectivity to Zoho Books data through an SAP BusinessObjects universe.
-
Back Up ZohoPeople data 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 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 Dynamics NAV data 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 data 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 data 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 data for you.
-
Connect to Salesloft Data in CloverDX (formerly CloverETL)
Transfer Salesloft data 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 data. 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 data.
-
Visualize Live Wave Financial Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Wave Financial data into custom reports in Power BI.
-
How to Connect DBeaver to Planio via a JDBC Driver
Manage Planio data 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 data 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 data.
-
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 data from within the local AI agent.
-
Integrate Pushbullet Data in Pentaho Data Integration
Build ETL pipelines based on Pushbullet data 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 data 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 data 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 results 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 data 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 data 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 data 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 data 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 data 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 data.
-
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 data in Power BI.
-
Integrate Dify with Live Exact Online Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Exact Online data.
-
Natively Connect to Salesforce Pardot Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Pardot data. 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 data 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 data 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 data 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 data.
-
Integrate Live Auth0 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Auth0 data 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 data. Leverage the native support for ODBC in PHP.
-
Viewing Optimizely Data in RAD Studio Data Explorer
How to view Optimizely data 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 data and integrate live Google Drive data into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for Procore in MicroStrategy Web
Connect to Procore data 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 data.
-
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 data 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 data into Microsoft Power Query.
-
Migrating data from Cvent to Snowflake using CData SSIS Components.
Easily push Cvent data 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 data 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 data 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 data within intelligent agent workflows.
-
Integrating Cursor 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.
-
Interact with Live Sybase Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Sybase data.
-
Connect to Shopify Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Shopify Data and connect to Shopify data in Akorbi Digital RunMyProcess.
-
Integrate ZeroBounce Data in the Pentaho Report Designer
Publish reports based on ZeroBounce data in the Pentaho BI tool.
-
Link JobNimbus with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate JobNimbus data in Filemaker Pro for Mac or Windows.
-
Integrate Microsoft Dataverse Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Dataverse data and integrate live Microsoft Dataverse data into your Power Automate tasks.
-
Search External Timely Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Timely data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Timely Data objects that you can access from apps and the dashboard.
-
Analyze Humanity Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Humanity data with the CData JDBC Driver for Humanity.
-
Use Dash to Build Web Apps on Microsoft Dataverse Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Dataverse data using pandas and the CData Connect AI Python SDK.
-
Connect to Salesforce CRM Analytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce CRM Analytics data.
-
Use JayDeBeApi to access IBM Cloud Object Storage Data in Python
Use standard Python scripting and the development environment of your choice to access live IBM Cloud Object Storage data.
-
Create Informatica Mappings From/To a JDBC Data Source for Wrike
Create Wrike data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Process & Analyze Airtable Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Airtable Data.
-
Build Apps with Live Codat Data Using the Low-Code Development Platform of Mendix
Connect Codat data with Mendix to build apps using the CData API Driver for JDBC.
-
Publish Reports with WooCommerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date WooCommerce data.
-
Connect to MongoDB Data in CloverDX (formerly CloverETL)
Transfer MongoDB data using the visual workflow in the CloverDX data integration tool.
-
Connect to GitHub Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live GitHub data.