CData Software - Knowledge Base
Recent Articles
-
Integrate Live Sage 300 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sage 300 data to Blue Prism using the CData ODBC Driver for Sage 300 to create automated workflows for repetitive business tasks.
-
Build Automated Workflows with Live Basecamp Data in Workato
Use CData Connect AI to connect to live Basecamp data and build automated workflows in Workato.
-
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.
-
Automated Continuous Eventbrite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Eventbrite replication to Azure SQL Database.
-
Automated Continuous Procore Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Procore replication to delimited files (CSV/TSV).
-
Import Real-Time DB2 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use DB2 data in ColdFusion.
-
How to integrate Amplitude with Apache Airflow
Access and process Amplitude data in Apache Airflow using the CData JDBC Driver.
-
How to work with Dotmailer Data in Apache Spark using SQL
Access and process Dotmailer Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Reckon Accounts Hosted.
-
Automated Continuous Coda Replication to SingleStore
Use CData Sync for automated, continuous, customizable Coda replication to SingleStore.
-
Build SurveyMonkey-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SurveyMonkey Data and create custom apps in Bubble.
-
Connect to Grafana Data in Google Apps Script via Connect AI
Use CData Connect AI to access Grafana data in Google Apps Script.
-
Integrate Pipeliner CRM Data in the Pentaho Report Designer
Publish reports based on Pipeliner CRM data in the Pentaho BI tool.
-
Create PhantomBuster Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PhantomBuster data access from reports, embedded analytics, and more.
-
Integrating Cursor with Sage 200 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.
-
Build an OLAP Cube in SSAS from Zoho Inventory Data
Establish a connection to Zoho Inventory data data from SQL Server Analysis Services, and use the Zoho Inventory Data Provider to build OLAP cubes for use in analytics and reporting.
-
Natively Connect to ZeroBounce Data in PHP
The CData ODBC driver for ZeroBounce enables you to create PHP applications with connectivity to ZeroBounce data. Leverage the native support for ODBC in PHP.
-
Visualize SAP 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 SAP data into TIBCO Spotfire.
-
Process & Analyze Gong Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Gong Data.
-
Use the CData SSIS Components to Insert New or Update Existing Sybase IQ Records from SQL Server
Easily push SQL Server data to Sybase IQ using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sybase IQ or update existing records with data from a SQL Server database.
-
Create Data Visualizations in Cognos BI with Google Search Results
Access Google Search results as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Multiple Azure DevOps Accounts
Replicate multiple Azure DevOps accounts to one or many databases.
-
Connect Mailjet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mailjet with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Controls to Qualaroo Data in Delphi
DataBind to Qualaroo data in Delphi with standard data access components and controls.
-
Build Automated SAP Fieldglass-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Fieldglass data and build automated workflows in Zapier.
-
Query MailChimp Data as a SQL Server Database in Node.js
Execute SQL Server queries against MailChimp data from Node.js.
-
Connect to SAP ByDesign Data from PowerBuilder via JDBC
This article demonstrates how to access SAP ByDesign data from PowerBuilder using the SAP ByDesign JDBC Driver.
-
How to work with Sage 300 Data in Apache Spark using SQL
Access and process Sage 300 Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Gumloop with Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Tavily data within automated workflows.
-
Getting Started with the CData Tableau Connector for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Zoho CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho CRM facts in real time.
-
Build Agents in Relevance AI with Access to Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAS xpt data within intelligent agent workflows.
-
Automated Continuous FreshBooks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable FreshBooks replication to Amazon Redshift.
-
Connect to SAP HANA XS Advanced Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP HANA XS Advanced data in Airbyte.
-
Analyze SAP Netweaver Gateway Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Netweaver Gateway from Power Pivot. You will use the Table Import Wizard to load SAP Netweaver Gateway data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Float from Asprova with CData Software ODBC Driver for Float
This article shows how to connect faster to Float data from Asprova.
-
Use the CData Software JDBC Driver for Moosend in MicroStrategy
Connect to Moosend data in MicroStrategy Developer using the CData Software JDBC Driver for Moosend.
-
Build Dashboards with Landbot Data in DBxtra
Create dynamic dashboards and perform analytics based on Landbot data in DBxtra.
-
How to Connect Flowise AI Agents to Live ZohoSubscriptions Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live ZohoSubscriptions data without replication.
-
Integrate with Printful Data in JReport Designer
Create charts and reports based on Printful data in JReport Designer.
-
Connecting Mastra with Microsoft Exchange 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 Microsoft Exchange data, no replication required.
-
Build AI/ML Models with Live Placid Data using Dataiku
Connect Placid Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect to Live PayPal Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your PayPal data for you.
-
How to connect to Asana Data from Spring Boot
Connect to Asana in a Spring Boot Application using the CData JDBC Driver for Asana
-
Connect to Zoho Creator Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Creator and the Script function in FileMaker Pro to connect to Zoho Creator and work with Zoho Creator data in your FileMaker application.
-
Connect and Query Live Smartsheet Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Smartsheet data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate with live SAP SuccessFactors Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP SuccessFactors data in Jitterbit.
-
Create PayPal Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PayPal data access from reports, embedded analytics, and more.
-
How to Build an ETL App for Odoo Data in Python with CData
Create ETL applications and real-time data pipelines for Odoo data in Python with petl.
-
Integrate Theia IDE with Live Apify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Apify data from within the development environment.
-
Integrate Google's Antigravity Agent with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MailChimp data using the Model Context Protocol.
-
Visualize Recurly Data in TIBCO Spotfire through ADO.NET
Integrate Recurly data into dashboards in TIBCO Spotfire.
-
Use the CData SSIS Components to Insert New or Update Existing Spark Records from SQL Server
Easily push SQL Server data to Spark using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Spark or update existing records with data from a SQL Server database.
-
Build Dashboards with Freshdesk Data in DBxtra
Create dynamic dashboards and perform analytics based on Freshdesk data in DBxtra.
-
Analyze Azure Data Catalog Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure Data Catalog data and visualize Azure Data Catalog data in SAP Analytics Cloud.
-
Manage Greenhouse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Greenhouse.
-
Connect to Live Reckon Data in MicroStrategy through CData Connect AI
Create a live connection to Reckon Data in CData Connect AI and connect to your Reckon data from MicroStrategy.
-
Integrate Theia IDE with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Shopify data from within the development environment.
-
Natively Connect to SendGrid Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SendGrid data. Leverage the native support for ODBC in PHP.
-
Query, Visualize, and Share live SharePoint Data in Redash
Use CData Connect AI to connect to live SharePoint data in Redash for querying, visualizing, and sharing.
-
Extract, Transform, and Load GetResponse Data in Informatica PowerCenter
Create a simple Workflow for GetResponse data in Informatica PowerCenter.
-
Connecting Moonlit Workflow with Figshare 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 Figshare data in real time.
-
Connecting GenSpark with LinkedIn Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to LinkedIn Ads data without any replication or custom integration required.
-
How to connect and process Jodoo data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Jodoo data.
-
How to Connect to SuiteCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SuiteCRM data. Leverage the pyodbc module for ODBC in Python.
-
A PostgreSQL Interface for Copper Data (MySQL Remoting via JDBC)
Use the Remoting features of the Copper JDBC Driver to create a PostgreSQL entry-point for data access.
-
A Performance Comparison of Drivers for MongoDB
An article comparing the read performance of CData Software Drivers for MongoDB.
-
Query Live Databricks Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Databricks data through a conversational interface.
-
Creating Twilio-Connected Applications in Unqork
You can use CData Connect AI to feed Twilio data to Unqork and build custom business apps.
-
Integrate Teamwork Data in the Pentaho Report Designer
Publish reports based on Teamwork data in the Pentaho BI tool.
-
Integrating Claude Code CLI with EmailOctopus 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.
-
Visualize Live Slack Data in the Power BI Service
Use CData Connect AI to connect to live Slack data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Airtable to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Airtable with IBM WebSphere for seamless data integration and connectivity.
-
Import Real-Time Google Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Ads data in ColdFusion.
-
Build a Simple VCL Application for QuickBooks Data
How to build a simple VCL Application to view QuickBooks data in RAD Studio using the CData ODBC Driver for QuickBooks.
-
ETL Timely in Oracle Data Integrator
This article shows how to transfer Timely data into a data warehouse using Oracle Data Integrator.
-
Connect to Procore Data from a Connection Pool in JBoss
Integrate Procore data into Java servlets: Use the Management Console in JBoss to install the Procore JDBC Driver.
-
Connect to PostgreSQL Data in JRuby
Create a simple JRuby app with access to live PostgreSQL data.
-
Query Aweber Data as a MySQL Database in Node.js
Execute MySQL queries against Aweber data from Node.js.
-
Connect to Moosend Data in Jaspersoft Studio
Execute SQL to remote Moosend data in Jaspersoft Studio.
-
How to integrate Metabase with SAS Data Sets Data
Use CData Connect AI to connect to live SAS Data Sets data and create an interactive dashboard in Metabase from SAS Data Sets data.
-
Write a Simple Go Application to work with Avro Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Avro data.
-
Access Live Act CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Act CRM data from your Excel spreadsheets.
-
How to Work with Phoenix Data in AWS Glue Jobs Using JDBC
Connect to Phoenix from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect Figshare 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 Figshare data in real time using natural language.
-
Connect Snapchat Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Snapchat Ads with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for GitHub in MicroStrategy
Connect to GitHub data in MicroStrategy Developer using the CData Software JDBC Driver for GitHub.
-
Use the CData Software ODBC Driver for Basecamp in MicroStrategy
Connect to Basecamp data in MicroStrategy Developer using the CData Software ODBC Driver for Basecamp.
-
How to Create Power BI Visual Reports with Real-Time Access Data
Use CData Power BI Connectors to visualize Access data in Power BI.
-
Create Anaplan-Connected Nintex Workflows
Use CData Connect AI to connect to Anaplan Data from Nintex Workflow Cloud and build custom workflows using live Anaplan data.
-
Visualize Email 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 Email data into TIBCO Spotfire.
-
Bridge Copper Connectivity with Apache NiFi
Access and process Copper data in Apache NiFi using the CData JDBC Driver.
-
Visualize Google Ad Manager 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 Google Ad Manager data into TIBCO Spotfire.
-
Connect to Greenhouse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Greenhouse to connect to Greenhouse data and execute queries in PowerBuilder.
-
Provide OData Services of ZohoExpense Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoExpense data by developing a WCF Service Application.
-
Working with Zoho CRM Data in LINQPad
Execute LINQ queries to Zoho CRM data in LINQPad.
-
Validate Rootly Data with QuerySurge
Access and validate Rootly data in QuerySurge using the CData JDBC Driver.
-
Build Charts with Couchbase Data in Clear Analytics
Create dynamic charts and perform analytics based on Couchbase data in Clear Analytics.
-
Enable the Quickbase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Quickbase data.
-
Create SSAS Tabular Models from Samanage Data
How to build a SQL Server Analysis Service Tabular Model from Samanage data using CData drivers.