CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live ShipStation 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 ShipStation data for you.
-
Integrate Devin with Live Act CRM 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 Act CRM data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Avalara AvaTax
Provide connectivity to Avalara AvaTax data through an SAP BusinessObjects universe.
-
Build PostgreSQL-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live PostgreSQL data and build PostgreSQL-connected web apps with Axios.
-
Connect to Dropbox Data in Google Apps Script via Connect AI
Use CData Connect AI to access Dropbox data in Google Apps Script.
-
Publish Crystal Reports on Couchbase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Couchbase data.
-
Build AI/ML Models with Live Excel Online Data using Dataiku
Connect Excel Online Data with Dataiku using the CData JDBC Driver for Excel Online.
-
Build Optimizely-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Optimizely data.
-
Paymo Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Paymo data through CData Connect AI using different applications and tools.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing data through natural language.
-
Automated Continuous Microsoft Dataverse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to delimited files (CSV/TSV).
-
How to load Datadog data into Elasticsearch via Logstash
Introducing a simple method to load Datadog data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query FreshBooks Data through ODBC in Node.js
Use node-odbc to execute SQL queries against FreshBooks data from Node.js.
-
How to Connect to Reckon Accounts Hosted Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reckon Accounts Hosted data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous QuickBooks Time Replication to Amazon S3
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Amazon S3.
-
How to Visualize Humanity Data in Python with pandas
Use pandas and other modules to analyze and visualize live Humanity data in Python.
-
Integrating Antigravity CLI with HBase data via CData CLI
Connect HBase data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software JDBC Driver for Elasticsearch in MicroStrategy Web
Connect to Elasticsearch data in MicroStrategy Web using the CData Software JDBC Driver for Elasticsearch.
-
Build HubDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for HubDB Data and create custom apps in Mendix.
-
Integrate Vault CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Vault CRM data and integrate live Vault CRM data into your Power Automate tasks.
-
Use JayDeBeApi to access Basecamp Data in Python
Use standard Python scripting and the development environment of your choice to access live Basecamp data.
-
Automated Continuous Notion Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Notion replication to Amazon Redshift.
-
Moving Data from Billsby to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Billsby data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect DBeaver to CampaignMonitor via a JDBC Driver
Manage CampaignMonitor data with visual tools in DBeaver like the query browser.
-
Build MVC Applications with Connectivity to Ontraport Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Ontraport from an ASP.NET MVC application.
-
Use JayDeBeApi to access ServiceDesk Plus Data in Python
Use standard Python scripting and the development environment of your choice to access live ServiceDesk Plus data.
-
Access Live Hive 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 Hive data through MCP integration.
-
Create a Data Access Object for LightSpeedRetail Data using JDBI
A brief overview of creating a SQL Object API for LightSpeedRetail data in JDBI.
-
Getting Started with the CData Tableau Connector for Factorial
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Aha! Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Aha! replication to Apache Kafka.
-
How to Connect to Printful Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Printful data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Real-Time Timely Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Timely data in Power Apps.
-
Replicate Mode Data to Multiple Databases
Replicate Mode data to disparate databases with a point-and-click configuration.
-
DataBind Controls to Webex Data in C++Builder
DataBind to Webex data in C++Builder with standard components and controls.
-
Create Reports from Amazon S3 Data in Looker Studio
Use CData Connect AI to gain access to live Amazon S3 data and create custom reports in Looker Studio.
-
Create Google Spanner Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Spanner data access from reports, embedded analytics, and more.
-
Integrate HubSpot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HubSpot with External Services.
-
Connect to Epicor Kinetic Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Epicor Kinetic Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Getting Started with the CData JDBC Driver for Sendwithus
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sendwithus.
-
Build Charts with SpaceX Data in Clear Analytics
Create dynamic charts and perform analytics based on SpaceX data in Clear Analytics.
-
Access ZohoSubscriptions Data from MySQL in PHP
Connect to ZohoSubscriptions through the standard MySQL libraries in PHP.
-
Automate Discourse Data Replication to SAP HANA
Use CData Sync to customize and automate Discourse data replication to SAP HANA.
-
Build Apps with Live JobNimbus Data Using the Low-Code Development Platform of Mendix
Connect JobNimbus data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous AlloyDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable AlloyDB replication to Amazon Redshift.
-
Feed Kafka Data into FineReport
How to set Kafka data as a JDBC data source in FineReport.
-
How to create Visio diagrams from Kintone Data
Automatically update Kintone data with the changes you make to Visio master shapes.
-
How to create Redis federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Redis data in MySQL .
-
Access Live Snapchat Ads Data in Excel 365 Online (Excel for the web)
Connect to Snapchat Ads data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Google Directory Reporting in OBIEE with the Google Directory JDBC Driver
Deploy the Google Directory JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Toggl Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Toggl replication to Apache Cassandra.
-
Use JayDeBeApi to access Perplexity Data in Python
Use standard Python scripting and the development environment of your choice to access live Perplexity data.
-
Connect CouchDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CouchDB data using the CData Python MCP Server.
-
Access Live Tavily 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 Tavily data through MCP integration.
-
Import and Visualize ElevenLabs Data in Power View
Create data visualizations based on ElevenLabs data in Excel.
-
Viewing Oracle Financials Cloud Data in RAD Studio Data Explorer
How to view Oracle Financials Cloud data in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Financials Cloud.
-
How to Work with Nuclia Data in AWS Glue Jobs Using JDBC
Connect to Nuclia from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Real-Time Access to Salesforce Marketing in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Marketing data in real time.
-
Automated Continuous SAP Hybris C4C Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to MySQL.
-
DataBind Controls to Snowflake Data in C++Builder
DataBind to Snowflake data in C++Builder with standard components and controls.
-
Replicate Multiple Cvent Accounts
Replicate multiple Cvent accounts to one or many databases.
-
Replicate Spark Data from PowerShell
Write a quick PowerShell script to query Spark data. Use connectivity to the live data to replicate Spark data to SQL Server.
-
DataBind Controls to Wave Financial Data in C++Builder
DataBind to Wave Financial data in C++Builder with standard components and controls.
-
How to Access Live Grafana Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Grafana enables you to integrate Grafana data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Theia IDE with Live SAP Ariba Procurement 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 SAP Ariba Procurement data from within the development environment.
-
Query Confluence Data as a SQL Server Database in Node.js
Execute SQL Server queries against Confluence data from Node.js.
-
Create Amazon S3-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon S3 Data from OutSystems and build custom enterprise apps using live Amazon S3 data.
-
Visualize HBase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to HBase data.
-
Object-Relational Mapping (ORM) with ChartMogul 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 ChartMogul data into a Java-based ORM framework, Hibernate.
-
Create Reports with Smartsheet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Smartsheet data.
-
Import Real-Time Zoho Creator Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Creator data in ColdFusion.
-
A PostgreSQL Interface for Google Cloud Storage Data using the CData ODBC Driver
Use the SQL Gateway and Google Cloud Storage ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Phoenix Data in C++Builder
DataBind to Phoenix data in C++Builder with standard components and controls.
-
Visualize IBM Informix Data in TIBCO Spotfire through OData
Integrate IBM Informix data into dashboards in TIBCO Spotfire.
-
Integrating Gumloop with SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SQL Server data within automated workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for SAS Data Sets
Create SAS Data Sets data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for LDAP in MicroStrategy
Connect to LDAP objects in MicroStrategy Developer using the CData Software ODBC Driver for LDAP.
-
Build Automated Workflows with Live ZohoMarketingHub Data in Workato
Use CData Connect AI to connect to live ZohoMarketingHub data and build automated workflows in Workato.
-
Integrate OpenCode with Live MYOB AccountRight Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live MYOB AccountRight data from within your AI coding agent.
-
Comprehensive Workday Connectivity through Workday WQL and Reports-as-a-Service
Walk through CData’s comprehensive workday connectivity and learn to configure your Workday instance to provide access to Workday Reports-as-a-Service.
-
Connect to Microsoft Entra ID 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 Microsoft Entra ID data.
-
DataBind Dropbox Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Dropbox with the DevExpress Windows Forms and Web controls to provide Dropbox data to a chart.
-
Import PingOne Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to PingOne Data and provide access to live PingOne data for custom reports in the Power BI Service.
-
Visualize Azure Analysis Services Data in Tableau
The CData ODBC driver for Azure Analysis Services enables you integrate Azure Analysis Services data into Tableau dashboards.
-
Connect to Toggl Data in Jaspersoft Studio
Execute SQL to remote Toggl data in Jaspersoft Studio.
-
Access Live Sage 200 Data in Excel 365 Online (Excel for the web)
Connect to Sage 200 data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automate Impala Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Impala data from PowerShell? This article demonstrates how to utilize the Impala Cmdlets for tasks like connecting to Impala data, automating operations, downloading data, and more.
-
Replicate Multiple Egnyte Accounts
Replicate multiple Egnyte accounts to one or many databases.
-
Integrating Cursor with SAP Ariba Source 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.
-
DataBind Controls to Rebilly Data in C++Builder
DataBind to Rebilly data in C++Builder with standard components and controls.
-
Access Snowflake Data from MySQL in Amazon QuickSight
Connect to Snowflake and build visualizations of Snowflake data using a MySQL Connection in Amazon QuickSight.
-
DataBind Controls to Phoenix Data in Delphi
DataBind to Phoenix data in Delphi with standard data access components and controls.
-
Design BIRT Reports on Onfleet Data
Provide current Onfleet data to your embedded analytics.
-
Query ConvertAPI Data in DataGrip
Create a Data Source for ConvertAPI in DataGrip and use SQL to query live ConvertAPI data.
-
Use CData Connect AI to Access Twitter Ads Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Twitter Ads data in the Power Pivot business intelligence tool.
-
Use Agno to Talk to Your Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zendesk data for you.
-
Replicate Mailjet Data in Heroku for Use in Salesforce Connect
Replicate Mailjet data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use ChatGPT to Talk to Your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MailChimp data for you.
-
Access Live Beeminder Data in Coginiti Pro
Connect to and query live Beeminder data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Controls to MYOB AccountRight Data in Delphi
DataBind to MYOB AccountRight data in Delphi with standard data access components and controls.
-
Connect to Snapchat Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live Snapchat Ads data from Crystal Reports.