CData Software - Knowledge Base
Recent Articles
-
Automate Eventbrite Data Replication to SAP HANA
Use CData Sync to customize and automate Eventbrite data 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 data 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 data from within the chat interface.
-
Connect to Printify Data in JRuby
Create a simple JRuby app with access to live Printify data.
-
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 data 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 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 data into a Java-based ORM framework, Hibernate.
-
Stream NASA Data into Apache Kafka Topics
Access and stream NASA data 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 data.
-
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 data within automated workflows.
-
Connect to Front Data from a Connection Pool in JBoss
Integrate Front data into Java servlets: Use the Management Console in JBoss to install the Front JDBC Driver.
-
Use Grok to Talk to Your SparkPost 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 SparkPost data for you.
-
Query, Visualize, and Share live Avalara AvaTax Data in Redash
Use CData Connect AI to connect to live Avalara AvaTax data in Redash for querying, visualizing, and sharing.
-
Access Sendwithus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sendwithus data from HeidiSQL.
-
Explore Geographical Relationships in Cohere Data with Power Map
Create data visualizations with Cohere data in Power Map.
-
Import and Visualize Avro Data in Power View
Create data visualizations based on Avro data in Excel.
-
Build Apps with Live DB2 Data Using the Low-Code Development Platform of Mendix
Connect DB2 data 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 data 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 results 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.
-
Integrating Claude Code with Klipfolio Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Klipfolio data within assisted coding and automated development workflows.
-
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 data from within the chat interface.
-
Integrate HubDB Data in the Pentaho Report Designer
Publish reports based on HubDB data in the Pentaho BI tool.
-
Connect to Klipfolio Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Klipfolio data from Filemaker Pro on Mac.
-
Connect to Dropbox Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Dropbox data 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 data 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 data 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 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 Google Translate data 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.
-
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 Phoenix data without any replication or custom integration required.
-
Working with Avaza Data in LINQPad
Execute LINQ queries to Avaza data in LINQPad.
-
Connect to CampaignMonitor Data in DBeaver
Use the CData ODBC Driver to connect to CampaignMonitor data 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 data 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 results.
-
Configure the CData JDBC Driver for Stack Exchange in a Connection Pool in Tomcat
Connect to Stack Exchange data from a connection pool in Tomcat.
-
Integrate ShipEngine Data in the Pentaho Report Designer
Publish reports based on ShipEngine data 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 data 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 data and execute queries in PowerBuilder.
-
Integrating Kiro 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 data to disparate databases with a single configuration.
-
Import and Visualize Onfleet Data in Power View
Create data visualizations based on Onfleet data 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 data 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 data 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.
-
Design BIRT Reports on Cvent Data
Provide current Cvent data to your embedded analytics.
-
Automated Continuous ServiceNow Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ServiceNow replication to delimited files (CSV/TSV).
-
Connect to Presto Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Presto data in the Denodo Virtual DataPort Administrator.
-
Process & Analyze Foursquare Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Foursquare Data.
-
Connect to OpenWeatherMap Data in Jaspersoft Studio
Execute SQL to remote OpenWeatherMap data in Jaspersoft Studio.
-
How to Use a Microsoft Access Database to Update Shopify Data in Real Time
Update Shopify data by creating a linked table in Microsoft Access with the CData Shopify ODBC Driver.
-
Visualize GitHub Data in TIBCO Spotfire through ADO.NET
Integrate GitHub data into dashboards in TIBCO Spotfire.
-
How to Connect Flowise AI Agents to Live SageHR 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 SageHR data without replication.
-
Use JayDeBeApi to access Everhour Data in Python
Use standard Python scripting and the development environment of your choice to access live Everhour data.
-
Connecting GenSpark with Basecamp Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Basecamp data without any replication or custom integration required.
-
Analyze Yelp Data in Cognos Analytics
Use CData Connect AI to connect to Yelp Data from Cognos Analytics and analyze live Yelp data.
-
Integrate OpenCode with Live Impala Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Impala data from within your AI coding agent.
-
Connect to ZohoInvoice Data in CloverDX (formerly CloverETL)
Transfer ZohoInvoice data using the visual workflow in the CloverDX data integration tool.
-
How to load Shopify data into Elasticsearch via Logstash
Introducing a simple method to load Shopify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure DevOps
Create Azure DevOps data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to AdRoll Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to AdRoll and work with AdRoll data in your FileMaker applications.
-
Connect to Hugging Face Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Hugging Face data in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData JDBC Driver for LDAP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LDAP.
-
Connect to Oracle Financials Cloud Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Financials Cloud and the Script function in FileMaker Pro to connect to Oracle Financials Cloud and work with Oracle Financials Cloud data in your FileMaker application.
-
Integrate Cursor with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MYOB AccountRight data from within the editor.
-
Consume SAP BusinessObjects BI OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP BusinessObjects BI feeds that reflect any changes in SAP Lumira.
-
A PostgreSQL Interface for Aircall Data using the CData ODBC Driver
Use the SQL Gateway and Aircall ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Impala in MicroStrategy
Connect to Impala data in MicroStrategy Developer using the CData Software JDBC Driver for Impala.
-
Integrating Boomi Agentstudio with Oracle Eloqua Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle Eloqua data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Greenhouse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Greenhouse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Greenhouse data.
-
Use the CData ODBC Driver for Google Contacts in Microsoft Power Query
You can use the CData Google Contacts ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Contacts data into Microsoft Power Query.
-
How to Connect DBeaver to TigerGraph via a JDBC Driver
Manage TigerGraph data with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for Outreach.io in MicroStrategy Web
Connect to Outreach.io data in MicroStrategy Web using the CData Software ODBC Driver for Outreach.io.
-
How to integrate Metabase with SAP SuccessFactors LMS Data
Use CData Connect AI to connect to live SAP SuccessFactors LMS data and create an interactive dashboard in Metabase from SAP SuccessFactors LMS data.
-
Quick Setup Guide for CData HubSpot Drivers
Easy guide for using CData HubSpot Drivers and Connectors for the first time.
-
Visualize Stripe Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Stripe data into TIBCO Spotfire.
-
Connect to Postmark from Asprova with CData Software ODBC Driver for Postmark
This article shows how to connect faster to Postmark data from Asprova.
-
Automated Continuous Zendesk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zendesk replication to AlloyDB.
-
How to Create Power BI Visual Reports with Real-Time ZohoPeople Data
Use CData Power BI Connectors to visualize ZohoPeople data in Power BI.
-
Getting Started with the CData Power BI Connector for Intercom
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Live DocuSign Data in Power Automate Desktop via ODBC
The CData ODBC Driver for DocuSign enables you to integrate DocuSign data into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Google Campaign Manager 360 Data in Delphi
DataBind to Google Campaign Manager 360 data in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Pinterest in Microsoft Power Query
You can use the CData Pinterest ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pinterest data into Microsoft Power Query.
-
How to Build an ETL App for Confluence Data in Python with CData
Create ETL applications and real-time data pipelines for Confluence data in Python with petl.
-
Integrate Acumatica Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Acumatica data and integrate live Acumatica data into your Power Automate tasks.
-
Design BIRT Reports on SAS xpt Data
Provide current SAS xpt data to your embedded analytics.
-
Design BIRT Reports on Zoho Projects Data
Provide current Zoho Projects data to your embedded analytics.