CData Software - Knowledge Base
Recent Articles
-
How to Connect Flowise AI Agents to Live Google Campaign Manager 360 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 Google Campaign Manager 360 data without replication.
-
Load CampaignMonitor Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CampaignMonitor data to a database.
-
Analyze Box Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Box data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Model Vault CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Vault CRM, enabling the direct import of real-time Vault CRM data.
-
Consume Smartsheet OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Smartsheet feeds that reflect any changes in SAP Lumira.
-
Moving Data from Deel to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Deel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Moving Data from ADP to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ADP data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Visualizations of Google Spanner Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Spanner data in Birst.
-
Connect to Adobe Target Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Target data in the Denodo Virtual DataPort Administrator.
-
Replicate Eventbrite Data to Multiple Databases
Replicate Eventbrite data to disparate databases with a point-and-click configuration.
-
Access REST Data from MySQL in PHP
Connect to REST through the standard MySQL libraries in PHP.
-
Create a Data Access Object for Certinia Data using JDBI
A brief overview of creating a SQL Object API for Certinia data in JDBI.
-
Back Up Kintone data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Kintone. In this article, we will employ an SSIS workflow to populate a database with Kintone data data.
-
Connect to Blackbaud FE NXT Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Blackbaud FE NXT Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating LlamaIndex with Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Synapse data in real time.
-
Automate RabbitMQ Data Replication to SAP HANA
Use CData Sync to customize and automate RabbitMQ data replication to SAP HANA.
-
Use JayDeBeApi to access Beeminder Data in Python
Use standard Python scripting and the development environment of your choice to access live Beeminder data.
-
Build a Simple VCL Application for Salesforce Pardot Data
How to build a simple VCL Application to view Salesforce Pardot data in RAD Studio using the CData ODBC Driver for Salesforce Pardot.
-
Integrating Cursor with PostgreSQL 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.
-
How to connect PolyBase to Coda
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Coda data.
-
Connecting GenSpark with Confluence Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Confluence data without any replication or custom integration required.
-
Integrating Claude Code CLI with Exact Online 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.
-
View Reports on Real-Time Paylocity Data in Power BI Report Server
Use the CData ODBC Driver for Paylocity to visualize Paylocity data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Shortcut-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Shortcut Data and create custom apps in Mendix.
-
Create Datasets from Autopilot in Domo Workbench and Build Visualizations of Autopilot Data in Domo
Use the CData Software ODBC Driver for Autopilot to create datasets from Autopilot data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Kintone Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Kintone data from your Google Sheets.
-
Access Live BigCommerce Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BigCommerce data from your Excel spreadsheets.
-
Connect to Jira Data from a Connection Pool in JBoss
Integrate Jira data into Java servlets: Use the Management Console in JBoss to install the Jira JDBC Driver.
-
Create Front Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Front data access from reports, embedded analytics, and more.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MessageBird
Provide connectivity to MessageBird data through an SAP BusinessObjects universe.
-
Integrating GitHub Copilot with Clio 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.
-
Connect to Jira Assets Data from a Connection Pool in JBoss
Integrate Jira Assets data into Java servlets: Use the Management Console in JBoss to install the Jira Assets JDBC Driver.
-
Connect Campaigner Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Campaigner data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Model Act CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Act CRM, enabling the direct import of real-time Act CRM data.
-
Connect to Sage 200 Data from a Connection Pool in Jetty
The Sage 200 JDBC Driver supports connection pooling: This article shows how to connect faster to Sage 200 data from Web apps in Jetty.
-
A PostgreSQL Interface for AfterShip Data (MySQL Remoting via JDBC)
Use the Remoting features of the AfterShip JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Todoist Data in PHP
The CData ODBC driver for Todoist enables you to create PHP applications with connectivity to Todoist data. Leverage the native support for ODBC in PHP.
-
Bridge CircleCI Connectivity with Apache NiFi
Access and process CircleCI data in Apache NiFi using the CData JDBC Driver.
-
Integrating LangChain with BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on BambooHR data within automated workflows.
-
Replicate ZohoExpense Data in Heroku for Use in Salesforce Connect
Replicate ZohoExpense data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Azure Data Catalog Data in Heroku for Use in Salesforce Connect
Replicate Azure Data Catalog data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Viewing Flowlu Data in RAD Studio Data Explorer
How to view Flowlu data in RAD Studio Data Explorer using the CData ODBC Driver for Flowlu.
-
Connect to Recurly Data from PowerBuilder via JDBC
This article demonstrates how to access Recurly data from PowerBuilder using the Recurly JDBC Driver.
-
How to create an RPA flow for Act CRM Data in UiPath Studio
Use the Act CRM ODBC Driver to create workflows that access real-time Act CRM data without any coding.
-
Connect QuickBooks Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your QuickBooks data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Codex with Procore 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.
-
Connect to ShipStation Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ShipStation data.
-
Connecting Moonlit Workflow with HBase 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 HBase data in real time.
-
Create Apps from ZohoExpense Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoExpense Data and build apps from live ZohoExpense data in Qlik Sense Cloud.
-
Access Live Postmark Data in Coginiti Pro
Connect to and query live Postmark data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to Adobe Analytics Data in DBVisualizer
Integrate Adobe Analytics data with visual data analysis tools and data connection wizards in DBVisualizer
-
Migrating data from Cloudant to Snowflake using CData SSIS Components.
Easily push Cloudant data to Snowflake using the CData SSIS Tasks for Cloudant and Snowflake.
-
Model, Search, and Visualize Live Vertica Data in ThoughtSpot
Use CData Connect AI to connect to live Vertica data for modeling, searching, and visualizing.
-
Easily Integrate Snowflake Data in Lazarus Pascal IDE
Learn how to easily integrate live Snowflake data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Acumatica-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Acumatica data and build web apps with connectivity to live Acumatica data.
-
Visualize Live Oracle Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle data into custom reports in Power BI.
-
How to Work with Parquet Data in ETL Validator JDBC
Connect to Parquet from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Zuora Data in TIBCO Spotfire through ADO.NET
Integrate Zuora data into dashboards in TIBCO Spotfire.
-
DataBind Charts to Exact Online Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Exact Online data 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.
-
Bind Live Oracle Eloqua Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Eloqua data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Grafana in SpagoBI
Create reports featuring live Grafana data in SpagoBI Studio. Host Grafana reports on SpagoBI Server.
-
Visualize Salesforce Marketing 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 Salesforce Marketing data into TIBCO Spotfire.
-
Import Real-Time Trello Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Trello data in ColdFusion.
-
Use Azure AI Foundry to Talk to Your Confluence 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 Confluence data for you.
-
Build MVC Applications with Connectivity to Drip Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Drip from an ASP.NET MVC application.
-
Connect to SQL Analysis Services Data in Ruby
Connect to SQL Analysis Services data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Redshift 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 Redshift data for you.
-
A PostgreSQL Interface for Dynamics 365 Data using the CData ODBC Driver
Use the SQL Gateway and Dynamics 365 ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for MailerLite Data in Python with CData Connect AI
Extract and transform live MailerLite data in Python with petl and the CData Connect AI Python SDK.
-
Connect to SAP HANA XS Advanced Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP HANA XS Advanced Data and connect to SAP HANA XS Advanced data in Akorbi Digital RunMyProcess.
-
Getting Started with the CData ADO.NET Provider for Cohere
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect to Live SuiteCRM 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 SuiteCRM data through natural language.
-
Replicate Data from Multiple Files in an Amazon S3 Bucket Using CData Sync
Use CData Sync to replicate multiple files from an Amazon S3 bucket to a data warehouse
-
Analyze Reckon Accounts Hosted Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Reckon Accounts Hosted from Power Pivot. You will use the Table Import Wizard to load Reckon Accounts Hosted data. You can visually build the import query or use any SQL supported by the driver.
-
Create ServiceDesk Plus-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ServiceDesk Plus Data from OutSystems and build custom enterprise apps using live ServiceDesk Plus data.
-
Natively Connect to Bright Data Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bright Data data. Leverage the native support for ODBC in PHP.
-
Import Real-Time Raisers Edge NXT Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Raisers Edge NXT data in ColdFusion.
-
Access Live HubDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate HubDB data into the statistical analysis tools available in SAS JMP. This article shows how to use HubDB data in the Graph Builder and Query Builder.
-
Deploy the ADO.NET Provider for SparkPost on an SSRS Report Server
Connect to SparkPost 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 Tanda Data in NetBeans
Connect to Tanda data in NetBeans with the data source configuration wizard.
-
Integrate Google Contacts Data in the Pentaho Report Designer
Publish reports based on Google Contacts data in the Pentaho BI tool.
-
Automated Continuous SAP BusinessObjects BI Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to SQL Server.
-
Design BIRT Reports on Helpscout Data
Provide current Helpscout data to your embedded analytics.
-
Analyze Mailgun Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Mailgun data and visualize Mailgun data in SAP Analytics Cloud.
-
Migrating data from Azure DevOps to Google BigQuery using CData SSIS Components.
Easily push Azure DevOps data to Google BigQuery using the CData SSIS Tasks for Azure DevOps and Google BigQuery.
-
Visualize Live Dotmailer Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Dotmailer data.
-
Visualize Samanage Data in Sisense
Create an ElastiCube in Sisense app with access to Samanage data.
-
Automated Continuous Google Cloud Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to MongoDB.
-
Integrate Email Data in Pentaho Data Integration
Build ETL pipelines based on Email data in the Pentaho Data Integration tool.
-
Create SSAS Tabular Models from Clari Data
How to build a SQL Server Analysis Service Tabular Model from Clari data using CData drivers.
-
Integrate Jumpseller with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jumpseller with External Services.
-
Use the CData Software JDBC Driver for Mouseflow in MicroStrategy
Connect to Mouseflow data in MicroStrategy Developer using the CData Software JDBC Driver for Mouseflow.
-
Build Charts with Xero Data in Clear Analytics
Create dynamic charts and perform analytics based on Xero data in Clear Analytics.
-
Connect to Gumroad Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Gumroad as an External Source in Dremio.
-
Connect to Spark Data in JRuby
Create a simple JRuby app with access to live Spark data.
-
Automated Continuous Salesforce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesforce replication to delimited files (CSV/TSV).
-
Connect to MailerLite Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MailerLite Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Optimizely Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Optimizely data.
-
Connect to Workday Data in Ruby
Connect to Workday data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Google's Antigravity Agent with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SurveyMonkey data using the Model Context Protocol.