CData Software - Knowledge Base
Recent Articles
-
Access Printful Data from MySQL in Amazon QuickSight
Connect to Printful and build visualizations of Printful data using a MySQL Connection in Amazon QuickSight.
-
Connect to Gumroad Data in DBeaver
Use the CData ODBC Driver to connect to Gumroad data in DBeaver.
-
Prepare, Blend, and Analyze IBM Informix Data in Alteryx Designer (ODBC)
Build workflows to access live IBM Informix data for self-service data analytics.
-
Connect to Miro Data in HULFT Integrate
Connect to Miro as a JDBC data source in HULFT Integrate
-
Provide OData Services of Facebook Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Facebook Ads data by developing a WCF Service Application.
-
Getting Started with the CData Excel Add-In for Apollo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Apollo.
-
Integrating Boomi Agentstudio with Splunk Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Splunk data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Model, Search, and Visualize Live Facebook Data in ThoughtSpot
Use CData Connect AI to connect to live Facebook data for modeling, searching, and visualizing.
-
Automate Azure DevOps Data Replication to Azure Synapse
Use CData Sync to customize and automate Azure DevOps data replication to Azure Synapse.
-
Connect Twitter Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Twitter Ads with IBM WebSphere for seamless data integration and connectivity.
-
Validate Lakebase Data with QuerySurge
Access and validate Lakebase data in QuerySurge using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for SingleStore on an SSRS Report Server
Connect to SingleStore 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.
-
Integrate Open WebUI with Live AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live AfterShip data from within the chat interface.
-
Getting Started with the CData ODBC Driver for Egnyte
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Egnyte.
-
Integrate Theia IDE with Live CSV 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 CSV data from within the development environment.
-
Visualize Amazon Athena Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon Athena data.
-
Create Epicor Kinetic-Connected Applications in Appsmith
Connect to Epicor Kinetic Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Epicor Kinetic data.
-
Feed XML Data into FineReport
How to set XML data as a JDBC data source in FineReport.
-
Replicate Onfleet Data to Multiple Databases
Replicate Onfleet data to disparate databases with a point-and-click configuration.
-
Automated Continuous SingleStore Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SingleStore replication to IBM DB2.
-
Connect to Adobe Commerce Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Adobe Commerce data in Airbyte.
-
Analyze Facebook Data in Cognos Analytics
Use CData Connect AI to connect to Facebook Data from Cognos Analytics and analyze live Facebook data.
-
How to use SQLAlchemy ORM to access Paddle Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Paddle data.
-
Build Apollo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apollo data and build web apps with connectivity to live Apollo data.
-
A PostgreSQL Interface for Square Data (MySQL Remoting via JDBC)
Use the Remoting features of the Square JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Teradata with Apache Airflow
Access and process Teradata data in Apache Airflow using the CData JDBC Driver.
-
Automate Landbot Data Replication to Azure Synapse
Use CData Sync to customize and automate Landbot data replication to Azure Synapse.
-
Getting Started with the CData JDBC Driver for OneNote
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for OneNote.
-
Automated Continuous Quickbase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Quickbase replication to Apache Kafka.
-
Migrating data from Hubstaff to Databricks using CData SSIS Components.
Easily push Hubstaff data to Databricks using the CData SSIS Tasks for Hubstaff and Databricks.
-
Use Biml to Build SSIS Tasks to Replicate WooCommerce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate WooCommerce data to SQL Server.
-
Model, Search, and Visualize Live SAP ByDesign Data in ThoughtSpot
Use CData Connect AI to connect to live SAP ByDesign data for modeling, searching, and visualizing.
-
How to connect PolyBase to AfterShip
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live AfterShip data.
-
How to Work with IBM Cloud Object Storage Data in AWS Glue Jobs Using JDBC
Connect to IBM Cloud Object Storage from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Trigger Salesforce CRM Analytics IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesforce CRM Analytics with standard wizards in Logic Apps.
-
Connect Browserless Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Browserless data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Using Your Own Sender ID and Password with the Sage Intacct API
How to configure your own Web Services Sender ID and Password for use with the Sage Intacct API in CData products.
-
Query SuiteCRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SuiteCRM entities in PHP by modeling them as objects.
-
Access SAP Business One Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Business One data from HeidiSQL.
-
Visualize ZohoInvoice Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoInvoice data.
-
Connect to Excel in SpagoBI
Create reports featuring live Excel data in SpagoBI Studio. Host Excel reports on SpagoBI Server.
-
Create SSAS Tabular Models from Sugar CRM Data
How to build a SQL Server Analysis Service Tabular Model from Sugar CRM data using CData drivers.
-
Analyze Figshare Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Figshare data and visualize Figshare data in SAP Analytics Cloud.
-
How to Visualize SAP Concur Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Concur data in Python.
-
Establish a Live Connection with FHIR Data using Tableau Bridge
The CData ODBC Driver for FHIR enables you to integrate live FHIR data into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Avalara AvaTax Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Avalara AvaTax with the DevExpress Windows Forms and Web controls to provide Avalara AvaTax data to a chart.
-
Integrating LangGraph with Slack Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Slack data within automated workflows.
-
Work with Cosmos DB Data in FoxPro
Load Cosmos DB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Add Nethunt Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Nethunt with the Informatica Enterprise Data Catalog to classify and organize data.
-
Working with xBase Data in LINQPad
Execute LINQ queries to xBase data in LINQPad.
-
Explore Geographical Relationships in Printify Data with Power Map
Create data visualizations with Printify data in Power Map.
-
Connect to Supabase in SpagoBI
Create reports featuring live Supabase data in SpagoBI Studio. Host Supabase reports on SpagoBI Server.
-
Connect to Nuclia Data from a Connection Pool in Jetty
The Nuclia JDBC Driver supports connection pooling: This article shows how to connect faster to Nuclia data from Web apps in Jetty.
-
Integrate Cursor with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Paylocity data from within the editor.
-
Connect to Real-Time BigCommerce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for BigCommerce and Dataflow to import and use BigCommerce data in Power Apps.
-
Connect to Live WordPress Data in PostGresSQL Interface through CData Connect AI
Create a live connection to WordPress in CData Connect AI and connect to your WordPress data from PostgreSQL.
-
Access Workable 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 Workable data.
-
Migrating data from Webflow to Databricks using CData SSIS Components.
Easily push Webflow data to Databricks using the CData SSIS Tasks for Webflow and Databricks.
-
How to Connect to Live Wave Financial 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 Wave Financial data for you.
-
Use Microsoft Copilot Studio to talk to your FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your FHIR data for you.
-
Automated Continuous SAP ByDesign Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to SQL Server.
-
Deploy the ADO.NET Provider for Clari on an SSRS Report Server
Connect to Clari 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.
-
How to Connect to Live Oracle Eloqua 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 Oracle Eloqua data through natural language.
-
Automated Cloudant Data Replication to Teradata
Use CData Sync to Customize and automate Cloudant data replication to Teradata.
-
Build Automated Workflows with Live Klaviyo Data in Workato
Use CData Connect AI to connect to live Klaviyo data and build automated workflows in Workato.
-
Create SSAS Tabular Models from Instagram Data
How to build a SQL Server Analysis Service Tabular Model from Instagram data using CData drivers.
-
How to Connect to Live Salesloft 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 Salesloft data through natural language.
-
Use JayDeBeApi to access FreeAgent Data in Python
Use standard Python scripting and the development environment of your choice to access live FreeAgent data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HBase
Provide connectivity to HBase data through an SAP BusinessObjects universe.
-
Create Data Visualizations in Cognos BI with Zoho Projects Data
Access Zoho Projects data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live Supabase 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 Supabase data for you.
-
Integrating Claude Code CLI with EnterpriseDB 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 Email Data in C++Builder
DataBind to Email data in C++Builder with standard components and controls.
-
How to connect to Humanity Data from IntelliJ
Integrate connectivity to Humanity data with wizards in IntelliJ.
-
Automated Continuous Google Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to MySQL.
-
DataBind Controls to Act CRM Data in C++Builder
DataBind to Act CRM data in C++Builder with standard components and controls.
-
Use Grok to Talk to Your QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your QuickBooks Time data for you.
-
Integrating Antigravity CLI with OneNote data via CData CLI
Connect OneNote data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use ChatGPT to Talk to Your CockroachDB 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 CockroachDB data for you.
-
Consume Jira OData Feeds in PowerBuilder
This article demonstrates how to consume Jira data as OData feeds from PowerBuilder using the API Server.
-
Vault CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Vault CRM facts in real time.
-
Connect to Oracle Eloqua Data in HULFT Integrate
Connect to Oracle Eloqua as a JDBC data source in HULFT Integrate
-
Connect to Gong Data in ACL Analytics
Connect to Gong data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Gong data.
-
Use Microsoft Copilot Studio to talk to your Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Sybase IQ data for you.
-
How to integrate Tickspot with Apache Airflow
Access and process Tickspot data in Apache Airflow using the CData JDBC Driver.
-
Integrating Odoo Data in Talend Cloud Data Management Platform
Connect Odoo Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Odoo.
-
Connect to Real-Time Google Campaign Manager 360 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Campaign Manager 360 and Dataflow to import and use Google Campaign Manager 360 data in Power Apps.
-
Write a Simple Go Application to work with Demio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Demio data.
-
Use ChatGPT to Talk to Your Box 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 Box data for you.
-
Create LinkedIn Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LinkedIn Ads data access from reports, embedded analytics, and more.
-
Getting Started with the CData Python Connector for Intercom
Learn to install and license the CData Python Connector and configure a connection to live Intercom data.
-
Connect Google Analytics to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Analytics data using the CData Python MCP Server.
-
Use CData Connect AI to Access xBase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live xBase data in the Power Pivot business intelligence tool.
-
How to create SFTP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SFTP data in MySQL .
-
Create SSAS Tabular Models from Access Data
How to build a SQL Server Analysis Service Tabular Model from Access data using CData drivers.
-
Build Dashboards with Autopilot Data in DBxtra
Create dynamic dashboards and perform analytics based on Autopilot data in DBxtra.
-
Integrate Cursor with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Calendar data from within the editor.
-
Connect to AgileCRM Data in Jaspersoft Studio
Execute SQL to remote AgileCRM data in Jaspersoft Studio.
-
Use Biml to Build SSIS Tasks to Replicate MailChimp Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MailChimp data to SQL Server.
-
Access Live Intercom Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Intercom data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.