CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Sugar CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Amazon Redshift.
-
Publish Crystal Reports on Zoom Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoom.
-
Analyze DB2 Data in Looker
Use CData Connect AI to connect to DB2 Data from Looker and build custom apps using live IBM DB2.
-
Connect to Bugsnag Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bugsnag.
-
Integrating Claude Code CLI with MessageBird 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.
-
ETL Kafka in Oracle Data Integrator
This article shows how to transfer Apache Kafka into a data warehouse using Oracle Data Integrator.
-
Connect to Adobe Analytics Data in DBArtisan
Use wizards in DBArtisan to configure Adobe Analytics as a data source.
-
Integrating OpenCode Terminal with Customer.io 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.
-
Object-Relational Mapping (ORM) with Pushbullet 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 Pushbullet into a Java-based ORM framework, Hibernate.
-
How to connect to Workday Data with Squirrel SQL client
Connect to Workday and execute queries in the Squirrel SQL Client.
-
How to create an RPA flow for Oracle Financials Cloud Data in UiPath Studio
Use the Oracle Financials Cloud ODBC Driver to create workflows that access real-time Oracle Financials Cloud without any coding.
-
Connect to Real-Time Mocean Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mocean in Power Apps.
-
Access Live eBay Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live eBay data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Work with Live SAS Data Sets Data in Power Query
Use CData Connect AI to connect to SAS Data Sets and work with live SAS Data Sets in Microsoft Power Query.
-
Connect to Reckon Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon.
-
How to Visualize Procore Data in Python with pandas
Use pandas and other modules to analyze and visualize live Procore in Python.
-
Connect to Notion Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Notion to connect to Notion and execute queries in PowerBuilder.
-
How to Import Data from Zoho Inventory into Google Sheets
Import Zoho Inventory into a Google spreadsheet that is automatically refreshed.
-
Write a Simple Go Application to work with Google Tasks Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Tasks.
-
How to Visualize Azure DevOps Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure DevOps in Python.
-
Moving Data from SAP SuccessFactors LMS to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP SuccessFactors LMS data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate HDFS Data to Multiple Databases
Replicate Apache HDFS to disparate databases with a point-and-click configuration.
-
Use Dash to Build Web Apps on Azure Data Lake Storage Data via CData Connect AI
Build interactive Dash web apps on live Azure Data Lake Storage using pandas and the CData Connect AI Python SDK.
-
Connect to Aweber Data from PowerBuilder via JDBC
This article demonstrates how to access Aweber from PowerBuilder using the Aweber JDBC Driver.
-
Edit and Search External Authorize.Net Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Authorize.Net to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Authorize.Net Data objects that you can access from apps and the dashboard.
-
Use Dash to Build to Web Apps on Office 365 Data
Create Python applications that use pandas and Dash to build Office 365-connected web apps.
-
Establish a Live Connection with Billsby Data using Tableau Bridge
The CData ODBC Driver for Billsby enables you to integrate live Billsby into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Anaplan with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Anaplan with External Services.
-
How to Connect DBeaver to Missive via a JDBC Driver
Manage Missive with visual tools in DBeaver like the query browser.
-
Build MVC Applications with Connectivity to Freshteam Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Freshteam from an ASP.NET MVC application.
-
Visualize Live Mouseflow Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mouseflow.
-
Integrating OpenCode Terminal with Todoist 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 Postmark Data in Delphi
DataBind to Postmark in Delphi with standard data access components and controls.
-
Access Blackbaud FE NXT Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Blackbaud FE NXT from HeidiSQL.
-
How to Query Microsoft Exchange Data in MySQL Workbench
Execute MySQL queries against live Microsoft Exchange from MySQL Workbench.
-
Use the CData ODBC Driver for Microsoft Dataverse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Dataverse to connect to Microsoft Dataverse (CDS) from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Dataverse (CDS) in Excel.
-
Using the CData Software ODBC Driver for Teamwork in PyCharm
Connect to Teamwork as an ODBC data source in PyCharm using the CData Software ODBC Driver for Teamwork.
-
Connect to WooCommerce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to WooCommerce as an External Source in Dremio.
-
CapsuleCRM Reporting in OBIEE with the CapsuleCRM JDBC Driver
Deploy the CapsuleCRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Easily Integrate GraphQL Data in Lazarus Pascal IDE
Learn how to easily integrate live GraphQL in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create a Data Access Object for Zoho CRM Data using JDBI
A brief overview of creating a SQL Object API for Zoho CRM in JDBI.
-
Build Testmonitor-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Testmonitor.
-
Automate Eventbrite Data Replication to SAP HANA
Use CData Sync to customize and automate Eventbrite replication to SAP HANA.
-
Integrate with Workable Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Workable to a JSON file on disk.
-
Integrate LibreChat with Live Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Couchbase from within the chat interface.
-
Connect to Printify Data in JRuby
Create a simple JRuby app with access to live Printify.
-
Connect to Hugging Face Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Hugging Face to connect to Hugging Face and execute queries in PowerBuilder.
-
Automated Continuous Workday Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Workday replication to delimited files (CSV/TSV).
-
Integrating Cursor CLI with SFTP 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.
-
Object-Relational Mapping (ORM) with Simplesat 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 Simplesat into a Java-based ORM framework, Hibernate.
-
Stream NASA Data into Apache Kafka Topics
Access and stream NASA in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
A PostgreSQL Interface for Elasticsearch Data using the CData ODBC Driver
Use the SQL Gateway and Elasticsearch ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Onfleet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Onfleet.
-
Create SAP Business Warehouse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Business Warehouse from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating LangGraph with Google Campaign Manager 360 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Campaign Manager 360 within automated workflows.
-
Connect to Front Data from a Connection Pool in JBoss
Integrate Front into Java servlets: Use the Management Console in JBoss to install the Front JDBC Driver.
-
Query, Visualize, and Share live Avalara AvaTax Data in Redash
Use CData Connect AI to connect to live Avalara AvaTax in Redash for querying, visualizing, and sharing.
-
How to Access Live Microsoft Teams Data in Visual Studio Code via Cline
Run CData MCP Server for Microsoft Teams on Windows Subsytem for Linux (WSL) and connect to live Microsoft Teams from the Cline extension in Visual Studio Code.
-
Access Sendwithus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sendwithus from HeidiSQL.
-
Explore Geographical Relationships in Cohere Data with Power Map
Create data visualizations with Cohere in Power Map.
-
Import and Visualize Avro Data in Power View
Create data visualizations based on Apache Avro in Excel.
-
Build Apps with Live DB2 Data Using the Low-Code Development Platform of Mendix
Connect IBM DB2 with Mendix to build apps using the CData JDBC Driver for DB2.
-
Create SSAS Tabular Models from Elorus Data
How to build a SQL Server Analysis Service Tabular Model from Elorus using CData drivers.
-
Access Google Search Results as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Search from your Oracle system.
-
Connect LeadDesk to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect LeadDesk with IBM WebSphere for seamless data integration and connectivity.
-
Build a PostgreSQL Interface for Attio Data using the CData JDBC Driver
Use the Remoting features of the Attio JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect Twitter Ads Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Twitter Ads data in real time using natural language.
-
Integrate Open WebUI with Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Ariba Procurement from within the chat interface.
-
Integrate HubDB Data in the Pentaho Report Designer
Publish reports based on HubDB in the Pentaho BI tool.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Impala actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Dropbox Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Dropbox using standard SQL.
-
Connect to Google Cloud Storage Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Cloud Storage as an External Source in Dremio.
-
Getting Started with the CData JDBC Driver for Discord
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Discord.
-
Prepare, Blend, and Analyze Azure Synapse Data in Alteryx Designer (Connect AI)
Build workflows to access live Azure Synapse for self-service data analytics.
-
Use the CData SSIS Components to Insert New or Update Existing Salesforce Records from SQL Server
Easily push SQL Server data to Salesforce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce or update existing records with data from a SQL Server database.
-
Build a Simple VCL Application for ActiveCampaign Data
How to build a simple VCL Application to view ActiveCampaign in RAD Studio using the CData ODBC Driver for ActiveCampaign.
-
Build MVC Applications with Connectivity to Reply.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Reply.io from an ASP.NET MVC application.
-
Back Up Google Translate 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 Google Translate data.
-
Consume Splunk OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Splunk feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData JDBC Driver for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Elasticsearch.
-
Automate Tasks in Power Automate Using the CData API Server
Automate QuickBooks Online actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connecting GenSpark with Phoenix Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apache Phoenix without any replication or custom integration required.
-
Working with Avaza Data in LINQPad
Execute LINQ queries to Avaza in LINQPad.
-
Connect to CampaignMonitor Data in DBeaver
Use the CData ODBC Driver to connect to CampaignMonitor in DBeaver.
-
How to Connect to & Open OnePageCrm Data in Microsoft Excel
This article uses the CData ODBC driver for OnePageCrm to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Zoho CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho CRM to connect to Zoho CRM and execute queries in PowerBuilder.
-
Integrating Dataiku with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Search.
-
Configure the CData JDBC Driver for Stack Exchange in a Connection Pool in Tomcat
Connect to Stack Exchange from a connection pool in Tomcat.
-
Integrate ShipEngine Data in the Pentaho Report Designer
Publish reports based on ShipEngine in the Pentaho BI tool.
-
How to Access Live MariaDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MariaDB enables you to integrate MariaDB into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous CSV Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CSV replication to Amazon Redshift.
-
Use Dash to Build to Web Apps on Airtable Data
Create Python applications that use pandas and Dash to build Airtable-connected web apps.
-
Connect to Auth0 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Auth0 to connect to Auth0 and execute queries in PowerBuilder.
-
Integrating Kiro CLI with Tickspot 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.
-
Replicate AfterShip Data to Multiple Databases via the CData Sync CLI
Replicate AfterShip to disparate databases with a single configuration.
-
Import and Visualize Onfleet Data in Power View
Create data visualizations based on Onfleet in Excel.
-
Manage Tavily Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Tavily.
-
How to Connect to Live Elasticsearch 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 Elasticsearch for you.
-
Create Power BI Reports on Real-Time Reckon Accounts Hosted Data
Use the CData ODBC Driver for Reckon Accounts Hosted to visualize Reckon Accounts Hosted in Power BI Desktop.
-
Using the CData Software ODBC Driver for FTP in PyCharm
Connect to FTP as an ODBC data source in PyCharm using the CData Software ODBC Driver for FTP.