CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Twilio in MicroStrategy
Connect to Twilio data in MicroStrategy Developer using the CData Software ODBC Driver for Twilio.
-
Integrating Codex with PagerDuty 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 SharePoint with Stripe Data through external lists
Provide Stripe data to SharePoint users as an external list.
-
Automated Continuous Rootly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Rootly replication to Apache Cassandra.
-
Integrate Beeminder with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Beeminder with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Beeminder data.
-
How to Query ServiceDesk Plus Data in MySQL Workbench
Execute MySQL queries against live ServiceDesk Plus data from MySQL Workbench.
-
Access Live Wave Financial Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Wave Financial data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Perplexity Data in RapidMiner
Integrate Perplexity data with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Simplesat Data as a MySQL Database in Node.js
Execute MySQL queries against Simplesat data from Node.js.
-
Query Databricks Data in DataGrip
Create a Data Source for Databricks in DataGrip and use SQL to query live Databricks data.
-
Build an OLAP Cube in SSAS from Sage Intacct Data
Establish a connection to Sage Intacct data data from SQL Server Analysis Services, and use the Sage Intacct Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create Box federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Box data in MySQL .
-
Back Up Mocean 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 Mocean data data.
-
Access Live SAP Ariba Source Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP Ariba Source data through MCP integration.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aha!
Provide connectivity to Aha! data through an SAP BusinessObjects universe.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Entra ID Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Entra ID data for you.
-
Connect to Customer.io Data in DBeaver
Use the CData ODBC Driver to connect to Customer.io data in DBeaver.
-
Automate Sage Cloud Accounting Data Replication to Couchbase
Use CData Sync to Customize and automate Sage Cloud Accounting data replication to Couchbase.
-
How to Work with JotForm Data in ETL Validator JDBC
Connect to JotForm from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Act CRM Data in Excel 365 Online (Excel for the web)
Connect to Act CRM data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Highrise Replication to SQL Server
Use CData Sync for automated, continuous, customizable Highrise replication to SQL Server.
-
Connect to Workable Data in HULFT Integrate
Connect to Workable as a JDBC data source in HULFT Integrate
-
Automated Continuous CSV Replication to SingleStore
Use CData Sync for automated, continuous, customizable CSV replication to SingleStore.
-
Consume Facebook Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Facebook Ads data as OData feeds from PowerBuilder using the API Server.
-
Import and Visualize Codat Data in Power View
Create data visualizations based on Codat data in Excel.
-
DataBind Charts to QuickBooks Time Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to QuickBooks Time 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.
-
How to Visualize ADP 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 ADP data in Python.
-
Connect to PDFMonkey Data in RapidMiner
Integrate PDFMonkey data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with live BigCommerce Data in Jitterbit
Use CData Connect AI to connect to and integrate live BigCommerce data in Jitterbit.
-
Integrate Devin with Live Wave Financial Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Wave Financial data.
-
Integrate with Live SuiteCRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SuiteCRM from the MuleSoft Anypoint Platform to integrate live SuiteCRM data into custom reports and dashboards.
-
Bridge GitLab Connectivity with Apache NiFi
Access and process GitLab data in Apache NiFi using the CData JDBC Driver.
-
DB2 Reporting in OBIEE with the DB2 JDBC Driver
Deploy the DB2 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create a Data Access Object for Cloudant Data using JDBI
A brief overview of creating a SQL Object API for Cloudant data in JDBI.
-
Build Zoho Projects Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Projects data and build visualizations in Tableau.
-
View Reports on Real-Time Sybase Data in Power BI Report Server
Use the CData ODBC Driver for Sybase to visualize Sybase data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Google's Vertex AI Agent with Live SingleStore 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 SingleStore data within intelligent workflows.
-
DataBind MySQL Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for MySQL with the DevExpress Windows Forms and Web controls to provide MySQL data to a chart.
-
Access Live Redis Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Redis data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Configure the CData JDBC Driver for Miro in a Connection Pool in Tomcat
Connect to Miro data from a connection pool in Tomcat.
-
Integrating OpenCode with Salesforce CRM Analytics 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 Build an ETL App for BigQuery Data in Python with CData Connect AI
Build ETL pipelines that read and write live BigQuery data in Python with petl and the CData Connect AI Python SDK.
-
Use the CData Software JDBC Driver for ActiveCampaign in MicroStrategy Web
Connect to ActiveCampaign data in MicroStrategy Web using the CData Software JDBC Driver for ActiveCampaign.
-
LINQ to Parallel 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 Parallel Data Provider.
-
Connect to ZohoSubscriptions Data from Crystal Reports
Use CData Connect AI to connect to and report on live ZohoSubscriptions data from Crystal Reports.
-
Automated Continuous Google Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Ads replication to Google BigQuery.
-
Connect to Google Ads Data in Ruby
Connect to Google Ads data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to ZohoInvoice Data in Jaspersoft Studio
Execute SQL to remote ZohoInvoice data in Jaspersoft Studio.
-
Connect to Dynamics 365 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Dynamics 365 Data and connect to Dynamics 365 data in Akorbi Digital RunMyProcess.
-
Connecting Agentforce with Cvent Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Cvent data for you.
-
Integrating Antigravity CLI with Impala data via CData CLI
Connect Impala data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Google Translate Reporting in OBIEE with the Google Translate JDBC Driver
Deploy the Google Translate JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Databricks Agent Bricks to Talk to Your Cloudflare Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Cloudflare data for you.
-
Automate Instagram Data Replication to Azure Data Lake
Use CData Sync to customize and automate Instagram data replication to Azure Data Lake.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Databricks
Provide connectivity to Databricks data through an SAP BusinessObjects universe.
-
HubDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HubDB facts in real time.
-
Access Live EnterpriseDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live EnterpriseDB data from your Google Sheets.
-
Validate ChartMogul Data with QuerySurge
Access and validate ChartMogul data in QuerySurge using the CData JDBC Driver.
-
A PostgreSQL Interface for Google Spanner Data using the CData ODBC Driver
Use the SQL Gateway and Google Spanner ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Workflows with Live Facebook Ads Data in Workato
Use CData Connect AI to connect to live Facebook Ads data and build automated workflows in Workato.
-
A PostgreSQL Interface for MessageBird Data using the CData ODBC Driver
Use the SQL Gateway and MessageBird ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Visualize Onfleet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Onfleet data in Python.
-
Creating Raisers Edge NXT-Connected Applications in Unqork
You can use CData Connect AI to feed Raisers Edge NXT data to Unqork and build custom business apps.
-
Create IBM Informix Dataflows on PowerBI.com
Connect to the CData Power BI Connector for IBM Informix from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze BigCommerce Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of BigCommerce data and visualize BigCommerce data in SAP Analytics Cloud.
-
Access Live Act-On Data in Excel 365 Online (Excel for the web)
Connect to Act-On data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Adobe Target Reporting in OBIEE with the Adobe Target JDBC Driver
Deploy the Adobe Target JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for Apify in MicroStrategy Web
Connect to Apify data in MicroStrategy Web using the CData Software ODBC Driver for Apify.
-
Create SAP Business One-Connected Dashboards in Grafana
Connect to SAP Business One Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Business One data.
-
Query Blackbaud FE NXT Data in DataGrip
Create a Data Source for Blackbaud FE NXT in DataGrip and use SQL to query live Blackbaud FE NXT data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Databricks
Provide connectivity to Databricks data through an SAP BusinessObjects universe.
-
How to connect to Workable Data with Squirrel SQL client
Connect to Workable data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Tableau Connector for Google Directory
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Directory.
-
Access Live Kafka 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 Kafka data through MCP integration.
-
Create Dynamic Eventbrite Grids Using the Infragistics XamDataGrid
Learn how you can connect Eventbrite to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Dify with Live Moosend 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 Moosend data.
-
Analyze EnterpriseDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze EnterpriseDB data in Microsoft R Open.
-
Automated Continuous SpaceX Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SpaceX replication to delimited files (CSV/TSV).
-
Integrate with GitLab Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy GitLab data to a JSON file on disk.
-
Integrate Google's Antigravity Agent with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live HCL Domino data using the Model Context Protocol.
-
Import MailerLite Data Using Azure Data Factory
Use CData Connect AI to connect to MailerLite Data from Azure Data Factory and import live MailerLite data.
-
Work with IBM Informix Data in FoxPro
Load IBM Informix data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Cursor with Webflow 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.
-
Connecting Mastra with BambooHR 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 BambooHR data, no replication required.
-
Replicate MYOB AccountRight Data from PowerShell
Write a quick PowerShell script to query MYOB AccountRight data. Use connectivity to the live data to replicate MYOB AccountRight data to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bitbucket
Provide connectivity to Bitbucket data through an SAP BusinessObjects universe.
-
Connect to Google Contacts Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Contacts data in Airbyte.
-
Connect Certinia Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Certinia data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to PostgreSQL from a Connection Pool in WebLogic
Use the CData JDBC Driver for PostgreSQL to connect to PostgreSQL data from Web applications running on WebLogic.
-
Replicate Multiple Hive Accounts
Replicate multiple Hive accounts to one or many databases.
-
Create Power BI Reports on Real-Time Vercel Data
Use the CData ODBC Driver for Vercel to visualize Vercel data in Power BI Desktop.
-
How to Create Power BI Visual Reports with Real-Time ShipStation Data
Use CData Power BI Connectors to visualize ShipStation data in Power BI.
-
Connect to Redis Data in RazorSQL
Connect to Redis from wizards and query Redis data from the GUI in the RazorSQL database management tool.
-
Build AI/ML Models with Live Gong Data using Dataiku
Connect Gong Data with Dataiku using the CData API Driver for JDBC.
-
How to Query Live Azure Table Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Table data data in natural language using Python.
-
Build Impala-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Impala data.
-
How to Access Live FreshBooks Data in Power Automate Desktop via ODBC
The CData ODBC Driver for FreshBooks enables you to integrate FreshBooks data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Attio Data in Heroku for Use in Salesforce Connect
Replicate Attio data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate OpenCode with Live CapsuleCRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live CapsuleCRM data from within your AI coding agent.
-
Connect to Azure Data Catalog Data in DBeaver
Use the CData ODBC Driver to connect to Azure Data Catalog data in DBeaver.