CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Klaviyo Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Klaviyo data for you.
-
Connect to Mailgun Data in Ruby
Connect to Mailgun data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Superchat Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Superchat data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access MariaDB Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for MariaDB data.
-
Connect to Dotmailer Data from a Connection Pool in Jetty
The Dotmailer JDBC Driver supports connection pooling: This article shows how to connect faster to Dotmailer data from Web apps in Jetty.
-
Connect to Perplexity Data in DBArtisan
Use wizards in DBArtisan to configure Perplexity data as a data source.
-
Getting Started with the CData Excel Add-In for ADP
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ADP.
-
Access Live Salesloft Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Salesloft data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
ETL Samanage in Oracle Data Integrator
This article shows how to transfer Samanage data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Pipedrive Replication to MySQL
Use CData Sync for automated, continuous, customizable Pipedrive replication to MySQL.
-
Connect to Microsoft Exchange Data in ACL Analytics
Connect to Microsoft Exchange data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Exchange data.
-
Build YouTube Analytics-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live YouTube Analytics data without replication.
-
Excel Spreadsheet Automation on Azure Data Catalog Data with the QUERY Formula
Pull data from Azure Data Catalog, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Azure Data Catalog in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Data Catalog data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Data Catalog.
-
Connect to Mailjet Data from a Connection Pool in Jetty
The Mailjet JDBC Driver supports connection pooling: This article shows how to connect faster to Mailjet data from Web apps in Jetty.
-
Import Phoenix Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Phoenix Data and provide access to live Phoenix data for custom reports in the Power BI Service.
-
Getting Started with the CData JDBC Driver for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Analysis Services.
-
How to Query Mode Data in MySQL Workbench
Execute MySQL queries against live Mode data from MySQL Workbench.
-
Use JayDeBeApi to access Mixpanel Data in Python
Use standard Python scripting and the development environment of your choice to access live Mixpanel data.
-
Create Dynamic Greenhouse Grids Using the Infragistics XamDataGrid
Learn how you can connect Greenhouse to Infragistics XamDataGrid to build dynamic grids.
-
Build Dashboards with Oracle Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle data in DBxtra.
-
Migrating data from Figshare to Google BigQuery using CData SSIS Components.
Easily push Figshare data to Google BigQuery using the CData SSIS Tasks for Figshare and Google BigQuery.
-
Use the CData Software ODBC Driver for Microsoft Dataverse in MicroStrategy Desktop
Connect to Microsoft Dataverse data in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Dataverse.
-
How to Query FreshBooks Data in MySQL Workbench
Execute MySQL queries against live FreshBooks data from MySQL Workbench.
-
Use the CData Software JDBC Driver for Sendwithus in MicroStrategy
Connect to Sendwithus data in MicroStrategy Developer using the CData Software JDBC Driver for Sendwithus.
-
Connect to Perplexity Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Perplexity data using standard SQL.
-
Query, Visualize, and Share live SageHR Data in Redash
Use CData Connect AI to connect to live SageHR data in Redash for querying, visualizing, and sharing.
-
Automated Continuous Telegram Replication to SQL Server
Use CData Sync for automated, continuous, customizable Telegram replication to SQL Server.
-
Integrating Kiro with Codat 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.
-
Consume Snowflake OData Feeds in PowerBuilder
This article demonstrates how to consume Snowflake data as OData feeds from PowerBuilder using the API Server.
-
Choosing the Best Method to Connect Auth0 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Auth0 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate eBay Analytics Data in the Pentaho Report Designer
Publish reports based on eBay Analytics data in the Pentaho BI tool.
-
Connect to Excel Online Data in Aqua Data Studio
Access Excel Online data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Spark Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Spark replication to Apache Cassandra.
-
Integrating OpenCode with QuickBooks 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 to Tally Data from IntelliJ
Integrate connectivity to Tally data with wizards in IntelliJ.
-
Natively Connect to CircleCI Data in PHP
The CData ODBC driver for CircleCI enables you to create PHP applications with connectivity to CircleCI data. Leverage the native support for ODBC in PHP.
-
DataBind Charts to Amazon Athena Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon Athena 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.
-
Create Apps from Jira Data in Qlik Sense Cloud
Use CData Connect AI to connect to Jira Data and build apps from live Jira data in Qlik Sense Cloud.
-
How to Query Epicor Kinetic Data in MySQL Workbench
Execute MySQL queries against live Epicor Kinetic data from MySQL Workbench.
-
Automated Continuous CampaignMonitor Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to IBM DB2.
-
Build SharePoint Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SharePoint data and build visualizations in Tableau Cloud.
-
Connect to SharePoint Excel Services from a Connection Pool in WebLogic
Use the CData JDBC Driver for SharePoint Excel Services to connect to SharePoint Excel Services data from Web applications running on WebLogic.
-
Connect to OneNote Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live OneNote data from Filemaker Pro on Mac.
-
Connect to eBay Analytics Data from HeidiSQL
Use CData Connect AI to connect to and query live eBay Analytics data from HeidiSQL.
-
Use the CData Software JDBC Driver for Trello in MicroStrategy
Connect to Trello data in MicroStrategy Developer using the CData Software JDBC Driver for Trello.
-
Analyze ConstantContact Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ConstantContact data and visualize ConstantContact data in SAP Analytics Cloud.
-
How to Connect to Live TaxJar 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 TaxJar data through natural language.
-
How to Query Excel Data in MySQL Workbench
Execute MySQL queries against live Excel data from MySQL Workbench.
-
Integrate Exa Data in Pentaho Data Integration
Build ETL pipelines based on Exa data in the Pentaho Data Integration tool.
-
Visualize Live Quickbase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Quickbase data into custom reports in Power BI.
-
Use CData Connect AI to Access Sage Cloud Accounting Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage Cloud Accounting data in the Power Pivot business intelligence tool.
-
Access Live SAP BusinessObjects BI Data in Excel 365 Online (Excel for the web)
Connect to SAP BusinessObjects BI data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Operational Reporting on SendInBlue Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SendInBlue data.
-
Seamlessly Bring Salesforce Pardot Data into Retool Using CData Connect AI
Integrate Salesforce Pardot data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Dynamic Pinecone Grids Using the Infragistics XamDataGrid
Learn how you can connect Pinecone to Infragistics XamDataGrid to build dynamic grids.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Moosend
Provide connectivity to Moosend data through an SAP BusinessObjects universe.
-
Interact with Live Kafka Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Kafka data.
-
How to Build an ETL App for Adobe Commerce Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Commerce data in Python with petl.
-
Integrating Gumloop with MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MailChimp data within automated workflows.
-
Automated Continuous AfterShip Replication to Oracle
Use CData Sync for automated, continuous, customizable AfterShip replication to Oracle.
-
How to Connect DBeaver to Sage 200 via a JDBC Driver
Manage Sage 200 data with visual tools in DBeaver like the query browser.
-
Integrate Cursor with Live Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Perplexity data from within the editor.
-
How to create Strava federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Strava data in MySQL .
-
Integrate Cursor with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Dynamics 365 Business Central data from within the editor.
-
Search External HDFS Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of HDFS data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create HDFS Data objects that you can access from apps and the dashboard.
-
Automated Continuous Exact Online Replication to Snowflake
Use CData Sync for automated, continuous, customizable Exact Online replication to Snowflake.
-
How to Work with Bannerbear Data in AWS Glue Jobs Using JDBC
Connect to Bannerbear from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Reports with Aweber Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aweber data.
-
How to Connect to Live Blackbaud FE NXT Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Blackbaud FE NXT data for you.
-
Configure the CData JDBC Driver for Paddle in a Connection Pool in Tomcat
Connect to Paddle data from a connection pool in Tomcat.
-
How to create Visio diagrams from Square Data
Automatically update Square data with the changes you make to Visio master shapes.
-
Use Biml to Build SSIS Tasks to Replicate Lakebase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Lakebase data to SQL Server.
-
Migrating data from Jira Assets to Google BigQuery using CData SSIS Components.
Easily push Jira Assets data to Google BigQuery using the CData SSIS Tasks for Jira Assets and Google BigQuery.
-
Use the CData Software JDBC Driver for Power BI XMLA in MicroStrategy Web
Connect to Power BI XMLA data in MicroStrategy Web using the CData Software JDBC Driver for Power BI XMLA.
-
Connect to Retently Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Retently data.
-
DataBind Controls to FreshBooks Data in Delphi
DataBind to FreshBooks data in Delphi with standard data access components and controls.
-
Use CData Connect AI to Access Google Ad Manager Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Ad Manager data in the Power Pivot business intelligence tool.
-
How to connect and process Instantly data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Instantly data.
-
How to connect and process Pipeline CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pipeline CRM data.
-
Link SAP SuccessFactors LMS with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP SuccessFactors LMS data in Filemaker Pro for Mac or Windows.
-
How to Connect Flowise AI Agents to Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data without replication.
-
Automated Continuous HubDB Replication to SQLite
Use CData Sync for automated, continuous, customizable HubDB replication to SQLite.
-
Connect to SageHR Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SageHR data.
-
Rapidly Develop Sage 300-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Sage 300.
-
Automated Continuous Cassandra Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Cassandra replication to delimited files (CSV/TSV).
-
Automate ScrapingBee Data Replication to SAP HANA
Use CData Sync to customize and automate ScrapingBee data replication to SAP HANA.
-
Publish Paylocity-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Paylocity data.
-
How to Connect to Live AgileCRM Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your AgileCRM data for you.
-
Automated Continuous Recurly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Recurly replication to SingleStore.
-
Create Stripe-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Stripe Data from OutSystems and build custom enterprise apps using live Stripe data.
-
Automate ConvertAPI Data Replication to Couchbase
Use CData Sync to Customize and automate ConvertAPI data replication to Couchbase.
-
Getting Started with the CData Excel Add-In for Notion
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Notion.
-
Access Live Oracle Eloqua Reporting Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Eloqua Reporting data into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Eloqua Reporting data in the Graph Builder and Query Builder.
-
Build Semantic Layer Views for SendGrid Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SendGrid data.
-
Analyze Grafana Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Grafana data in Microsoft R Open.
-
Integrate Act CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Act CRM with External Services.
-
Import Real-Time Workday Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Workday data in ColdFusion.
-
Integrating Gumloop with Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Excel Online data within automated workflows.
-
Integrating LlamaIndex with AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on AfterShip data in real time.