CData Software - Knowledge Base
Recent Articles
-
Connect to Landbot Data in Ruby
Connect to Landbot data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to and Visualize Live Invoiced Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Invoiced data.
-
Prepare, Blend, and Analyze SAP BusinessObjects BI Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP BusinessObjects BI data for self-service data analytics.
-
Integrate Live Avro 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 Avro data from within the IDE.
-
Work with Basecamp Data in FoxPro
Load Basecamp data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating LangGraph with SAP Netweaver Gateway Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Netweaver Gateway data within automated workflows.
-
Use the CData Software JDBC Driver for PingOne in MicroStrategy Web
Connect to PingOne data in MicroStrategy Web using the CData Software JDBC Driver for PingOne.
-
Connect and Visualize Live IBM Cloud Object Storage Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live IBM Cloud Object Storage data into the Databricks platform and create visualization dashboards with real-time IBM Cloud Object Storage data.
-
Build Pipelines with Live Act CRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Act CRM from Google Cloud Data Fusion, enabling the integration of live Act CRM data into the building and management of effective data pipelines.
-
How to Access Live SAP Hybris C4C Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Hybris C4C enables you to integrate SAP Hybris C4C data into workflows built using Microsoft Power Automate Desktop.
-
Analyze HubDB Data in Cognos Analytics
Use CData Connect AI to connect to HubDB Data from Cognos Analytics and analyze live HubDB data.
-
Automated Continuous SharePoint Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SharePoint replication to Apache Cassandra.
-
Connect and Visualize Live SAP ByDesign Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP ByDesign data into the Databricks platform and create visualization dashboards with real-time SAP ByDesign data.
-
Automated Continuous HelloSign Replication to SQLite
Use CData Sync for automated, continuous, customizable HelloSign replication to SQLite.
-
Analyze Tanda Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Tanda data with the CData JDBC Driver for Tanda.
-
Integrating Claude Code CLI with Google Calendar 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Contentful
Provide connectivity to Contentful data through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze NASA Data in Alteryx Designer (ODBC)
Build workflows to access live NASA data for self-service data analytics.
-
Integrate LibreChat with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Amazon Athena data from within the chat interface.
-
A PostgreSQL Interface for Elasticsearch Data (MySQL Remoting via JDBC)
Use the Remoting features of the Elasticsearch JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Drive Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Drive data.
-
Manage Outlook Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Outlook.
-
How to connect to Ontraport Data with Squirrel SQL client
Connect to Ontraport data and execute queries in the Squirrel SQL Client.
-
Build Automated Freshservice-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshservice data and build automated workflows in Zapier.
-
Integrating LangGraph with AfterShip Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on AfterShip data within automated workflows.
-
Connect to HelloSign Data in JRuby
Create a simple JRuby app with access to live HelloSign data.
-
Automated Continuous Freshteam Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Freshteam replication to IBM DB2.
-
Integrating LangGraph with SAP Hybris C4C Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Hybris C4C data within automated workflows.
-
Access Toggl Data from MySQL in PHP
Connect to Toggl through the standard MySQL libraries in PHP.
-
Connect to Amazon DynamoDB Data in Ruby
Connect to Amazon DynamoDB data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Oracle SCM Data from IntelliJ
Integrate connectivity to Oracle SCM data with wizards in IntelliJ.
-
Interact with Live SAP HANA Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP HANA data.
-
Getting Started with the CData SSIS Components for Mixpanel
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mixpanel.
-
Connect to Exa 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 Exa and work with Exa data in your FileMaker application.
-
Automated Continuous Copper Replication to SingleStore
Use CData Sync for automated, continuous, customizable Copper replication to SingleStore.
-
Automated Continuous Excel Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Excel replication to PostgreSQL.
-
Access Live PDFMonkey Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PDFMonkey data into the statistical analysis tools available in SAS JMP. This article shows how to use PDFMonkey data in the Graph Builder and Query Builder.
-
Connect to Avaza Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Avaza data using standard SQL.
-
Use Claude to Talk to Your MailChimp 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 MailChimp data for you.
-
Connect to Everhour Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Everhour data in the Denodo Virtual DataPort Administrator.
-
Connect to Spark Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Spark data in Airbyte.
-
Integrate with Cosmos DB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Cosmos DB data in SnapLogic.
-
Build Samanage-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Samanage Data and create custom apps in Mendix.
-
Build Dashboards with Pipeline CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Pipeline CRM data in DBxtra.
-
Connecting GenSpark with Sage Intacct Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sage Intacct data without any replication or custom integration required.
-
Integrate Live Stripe Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Stripe data and integrate live Stripe data into apps built in Microsoft Power Apps.
-
How to Connect to Live SAS xpt 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 SAS xpt data through natural language.
-
Create Azure Data Catalog-Connected Nintex Workflows
Use CData Connect AI to connect to Azure Data Catalog Data from Nintex Workflow Cloud and build custom workflows using live Azure Data Catalog data.
-
Manage Excel Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Excel.
-
Access Live Amazon Marketplace Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Amazon Marketplace data through MCP integration.
-
Integrate Trae with Live HCL Domino Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live HCL Domino data from within the AI-powered IDE.
-
Create a Data Access Object for ScrapingBee Data using JDBI
A brief overview of creating a SQL Object API for ScrapingBee data in JDBI.
-
Connect to Salesforce Pardot Data in Aqua Data Studio
Access Salesforce Pardot data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to and Visualize Live Authorize.Net Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Authorize.Net data.
-
Import and Visualize Bannerbear Data in Power View
Create data visualizations based on Bannerbear data in Excel.
-
Connect to DocuSign Data in DBArtisan
Use wizards in DBArtisan to configure DocuSign data as a data source.
-
How to update Dynamics CRM from Excel
This article explains how to transfer data from Excel to Dynamics CRM using the Excel Add-In for Dynamics CRM.
-
How to connect and process ZarMoney data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZarMoney data.
-
A PostgreSQL Interface for Splunk Data (MySQL Remoting via JDBC)
Use the Remoting features of the Splunk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HCL Domino
Provide connectivity to HCL Domino data through an SAP BusinessObjects universe.
-
Connect Pipeline CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Pipeline CRM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Typeform Data in Excel 365 Online (Excel for the web)
Connect to Typeform data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Procore Data from a Connection Pool in Jetty
The Procore JDBC Driver supports connection pooling: This article shows how to connect faster to Procore data from Web apps in Jetty.
-
Connect to Epicor Kinetic Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Epicor Kinetic.
-
Analyze Live QuickBooks Online Data in SAS Viya
Use CData Connect AI to connect to QuickBooks Online data from SAS Viya and deploy self-service analytics using live QuickBooks Online data.
-
Load Workable Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Workable data to a database.
-
Create FreshBooks-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to FreshBooks Data from OutSystems and build custom enterprise apps using live FreshBooks data.
-
Connecting Moonlit Workflow with Kintone Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Kintone data in real time.
-
Access Live Google Sheets Data in AWS Lambda
Connect to live Google Sheets data in AWS Lambda using the CData JDBC Driver.
-
A PostgreSQL Interface for Exact Online Data using the CData ODBC Driver
Use the SQL Gateway and Exact Online ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with Office 365 Data in ETL Validator JDBC
Connect to Office 365 from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live Perplexity Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Perplexity data.
-
Use Azure AI Foundry to Talk to Your JSON Services 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 JSON services for you.
-
Interact with Live Teradata Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Teradata data.
-
Object-Relational Mapping (ORM) with IBM Informix Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to IBM Informix data into a Java-based ORM framework, Hibernate.
-
Using the CData Software ODBC Driver for BenchmarkEmail in PyCharm
Connect to BenchmarkEmail as an ODBC data source in PyCharm using the CData Software ODBC Driver for BenchmarkEmail.
-
Publish Crystal Reports on Moosend Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Moosend data.
-
Automated Continuous Zoho Creator Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Apache Cassandra.
-
Analyze Dynamics NAV Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Dynamics NAV data and visualize Dynamics NAV data in SAP Analytics Cloud.
-
Integrate with Hive Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Hive data to a JSON file on disk.
-
Visualize QuickBooks Online 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 QuickBooks Online data into TIBCO Spotfire.
-
Integrate Cursor with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live LinkedIn data from within the editor.
-
Establish a Live Connection with Authorize.Net Data using Tableau Bridge
The CData ODBC Driver for Authorize.Net enables you to integrate live Authorize.Net data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create eBay-Connected Nintex Workflows
Use CData Connect AI to connect to eBay Data from Nintex Workflow Cloud and build custom workflows using live eBay data.
-
Access Live Optimizely Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Optimizely data into the statistical analysis tools available in SAS JMP. This article shows how to use Optimizely data in the Graph Builder and Query Builder.
-
Build Pipelines with Live Adobe Experience Manager Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Adobe Experience Manager from Google Cloud Data Fusion, enabling the integration of live Adobe Experience Manager data into the building and management of effective data pipelines.
-
Extract, Transform, and Load CloudConvert Data in Informatica PowerCenter
Create a simple Workflow for CloudConvert data in Informatica PowerCenter.
-
Access Live Bright Data Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bright Data data into the statistical analysis tools available in SAS JMP. This article shows how to use Bright Data data in the Graph Builder and Query Builder.
-
How to Connect to & Open Bannerbear Data in Microsoft Excel
This article uses the CData ODBC driver for Bannerbear to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to create ChartMogul federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ChartMogul data in MySQL .
-
Create Twitter Ads-Connected Dashboards in Grafana
Connect to Twitter Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Twitter Ads data.
-
Connect Teamwork Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Teamwork data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to Discord Data from IntelliJ
Integrate connectivity to Discord data with wizards in IntelliJ.
-
Getting Started with the CData Tableau Connector for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automate Hive Data Replication to SAP HANA
Use CData Sync to customize and automate Hive data replication to SAP HANA.
-
Connect to Zoho Recruit Data in CloverDX (formerly CloverETL)
Transfer Zoho Recruit data using the visual workflow in the CloverDX data integration tool.
-
Integrate Goose with Live Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Samanage data from within the local AI agent.
-
Model, Search, and Visualize Live Sendwithus Data in ThoughtSpot
Use CData Connect AI to connect to live Sendwithus data for modeling, searching, and visualizing.
-
Integrate Apollo Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apollo data and integrate live Apollo data into your Power Automate tasks.
-
Connect to Quickbase Data in Jaspersoft Studio
Execute SQL to remote Quickbase data in Jaspersoft Studio.