CData Software - Knowledge Base
Recent Articles
-
Use CData Connect AI to Access MariaDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MariaDB in the Power Pivot business intelligence tool.
-
Integrate Sentry Data in Pentaho Data Integration
Build ETL pipelines based on Sentry in the Pentaho Data Integration tool.
-
Connect Salesforce Pardot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Salesforce Pardot using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Work with Perigon Data in AWS Glue Jobs Using JDBC
Connect to Perigon from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Theia IDE with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Codex CLI with Onfleet 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.
-
Visualize Live Okta Data in the Power BI Service
Use CData Connect AI to connect to live Okta and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to Beeminder Data from Spring Boot
Connect to Beeminder in a Spring Boot Application using the CData API Driver for JDBC
-
Build AfterShip-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live AfterShip.
-
Create Jira-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Jira Data from OutSystems and build custom enterprise apps using live Atlassian Jira.
-
Build Avro-Connected Apps in Choreo
Use CData Connect AI to connect to Avro Data from Choreo and build custom apps using live Apache Avro.
-
Connecting Mastra with Stripe Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Stripe, no replication required.
-
Workable Reporting in OBIEE with the Workable JDBC Driver
Deploy the Workable JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Design BIRT Reports on Apify Data
Provide current Apify to your embedded analytics.
-
Use Databricks Agent Bricks to Talk to Your Avro Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Apache Avro for you.
-
Stream Clari Data into Apache Kafka Topics
Access and stream Clari in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to and Visualize Live AlloyDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google AlloyDB.
-
Import Real-Time Vercel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Vercel in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for NASA
Provide connectivity to NASA through an SAP BusinessObjects universe.
-
Validate SAP HANA XS Advanced Data with QuerySurge
Access and validate SAP HANA XS Advanced in QuerySurge using the CData JDBC Driver.
-
How to connect and process SAS Data Sets from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAS Data Sets.
-
Import Real-Time SAP Ariba Procurement Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Ariba Procurement in ColdFusion.
-
Use Manus AI to Talk to Your HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on HubSpot.
-
Use Agno to Talk to Your Greenhouse 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 Greenhouse for you.
-
Use the CData Software ODBC Driver for Square in MicroStrategy
Connect to Square in MicroStrategy Developer using the CData Software ODBC Driver for Square.
-
Integrating Gumloop with Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon Marketplace within automated workflows.
-
Connect to TaxJar Data in Claris FileMaker Pro
Use the CData ODBC Driver for TaxJar in FileMaker Pro to connect to TaxJar and work with TaxJar in your FileMaker applications.
-
Connecting Moonlit Workflow with Dynamics CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft Dynamics CRM in real time.
-
Build Agents in Relevance AI with Access to Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Tally ERP within intelligent agent workflows.
-
Use Dash to Build Web Apps on MongoDB Data via CData Connect AI
Build interactive Dash web apps on live MongoDB using pandas and the CData Connect AI Python SDK.
-
Build a PostgreSQL Interface for DB2 Data using the CData JDBC Driver
Use the Remoting features of the DB2 JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect Flowise AI Agents to Live Workday 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 Workday without replication.
-
Automated Continuous Unbounce Replication to SingleStore
Use CData Sync for automated, continuous, customizable Unbounce replication to SingleStore.
-
Access Deel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Deel from HeidiSQL.
-
Access CloudConvert Data from MySQL in Amazon QuickSight
Connect to CloudConvert and build visualizations of CloudConvert using a MySQL Connection in Amazon QuickSight.
-
Replicate xBase Data from PowerShell
Write a quick PowerShell script to query xBase. Use connectivity to the live data to replicate xBase to SQL Server.
-
Integrating Dataiku with Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apache Spark SQL.
-
Establish a Live Connection with Salesforce Data using Tableau Bridge
The CData ODBC Driver for Salesforce enables you to integrate live Salesforce & Force.com into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate LibreChat with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MailChimp from within the chat interface.
-
Integrating LangGraph with Sage Intacct Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Sage Intacct within automated workflows.
-
Analyze Vault CRM Data in Cognos Analytics
Use CData Connect AI to connect to Vault CRM Data from Cognos Analytics and analyze live Veeva Vault & Vault CRM.
-
Connect to Brex Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Brex as an External Source in Dremio.
-
Connect to Oracle Service Cloud Data in RazorSQL
Connect to Oracle Service Cloud from wizards and query Oracle Service Cloud from the GUI in the RazorSQL database management tool.
-
Connect to Dynamics 365 Business Central Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Dynamics 365 Business Central.
-
ETL Telegram in Oracle Data Integrator
This article shows how to transfer Telegram into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData JDBC Driver for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP ByDesign.
-
DataBind Pipedrive Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Pipedrive with the DevExpress Windows Forms and Web controls to provide Pipedrive to a chart.
-
Import Real-Time Testmonitor Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Testmonitor in ColdFusion.
-
Access Live Google Campaign Manager 360 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Campaign Manager 360 into the statistical analysis tools available in SAS JMP. This article shows how to use Google Campaign Manager 360 in the Graph Builder and Query Builder.
-
Connect to Zoho Books Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoho Books in Airbyte.
-
Build Semantic Layer Views for GetResponse Data in APOS Live Data Gateway
Use the CData Connector for GetResponse in APOS Live Data Gateway to build Semantic Layer Views for GetResponse.
-
Integrating Optimizely Data in Talend Cloud Data Management Platform
Connect Optimizely Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Object-Relational Mapping (ORM) with Helpscout 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 Helpscout into a Java-based ORM framework, Hibernate.
-
Visualize Float Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Float.
-
Use the CData API Server to Access HubDB Data in Microsoft PowerPivot
Use the CData API Server to connect to live HubDB in the Power Pivot business intelligence tool.
-
Use Dash to Build to Web Apps on SendGrid Data
Create Python applications that use pandas and Dash to build SendGrid-connected web apps.
-
Access Live HubDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live HubDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Dashboards with ClickUp Data in Dundas BI
Create dynamic dashboards and perform analytics based on ClickUp in Dundas BI.
-
Creating Slack-Connected Applications in Unqork
You can use CData Connect AI to feed Slack to Unqork and build custom business apps.
-
How to Query Jira Assets Data in MySQL Workbench
Execute MySQL queries against live Jira Assets from MySQL Workbench.
-
Connect to Access Data in RapidMiner
Integrate Microsoft Access with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to HelloSign Data in Ruby
Connect to HelloSign in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Reports with Browserless Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Browserless.
-
Build Dashboards with Power BI XMLA Data in Dundas BI
Create dynamic dashboards and perform analytics based on Power BI XMLA in Dundas BI.
-
Query GitHub Data as a MySQL Database in Node.js
Execute MySQL queries against GitHub from Node.js.
-
Build Data Flows from SQL Server to Databricks through SSIS
Easily push SQL Server data to Databricks using the CData SSIS Tasks for Databricks.
-
Add Strava Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Strava with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to use SQLAlchemy ORM to access Productboard Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Productboard.
-
Access Live SAS Data Sets Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAS Data Sets into the statistical analysis tools available in SAS JMP. This article shows how to use SAS Data Sets in the Graph Builder and Query Builder.
-
Using the CData Software ODBC Driver for SpaceX in PyCharm
Connect to SpaceX as an ODBC data source in PyCharm using the CData Software ODBC Driver for SpaceX.
-
Automated Continuous Delighted Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Delighted replication to delimited files (CSV/TSV).
-
Build Sage Intacct-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sage Intacct and build web apps with connectivity to live Sage Intacct.
-
Connect to Live Dynamics 365 Business Central Data in MicroStrategy through CData Connect AI
Create a live connection to Dynamics 365 Business Central Data in CData Connect AI and connect to your Dynamics 365 Business Central from MicroStrategy.
-
Build AI Agents with WooCommerce Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live WooCommerce through CData Connect AI.
-
Connect to Google Analytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Analytics in Google Apps Script.
-
Build AI/ML Models with Live Cloudant Data using Dataiku
Connect Cloudant Data with Dataiku using the CData JDBC Driver for Cloudant.
-
Replicate Quickbase Data to Multiple Databases
Replicate Quickbase to disparate databases with a point-and-click configuration.
-
Connect to Twilio Data in HULFT Integrate
Connect to Twilio as a JDBC data source in HULFT Integrate
-
Connect to Live Act CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Act CRM Data in CData Connect AI and connect to your Act CRM from MicroStrategy.
-
Connect to Azure Data Lake Storage Data in CloverDX (formerly CloverETL)
Transfer Azure Data Lake Storage using the visual workflow in the CloverDX data integration tool.
-
Connect to Box Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Box Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Placid Data in TIBCO Spotfire through ADO.NET
Integrate Placid into dashboards in TIBCO Spotfire.
-
Integrate Google Cloud Storage Data in the Pentaho Report Designer
Publish reports based on Google Cloud Storage in the Pentaho BI tool.
-
Add Qualaroo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Qualaroo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Easily Integrate Aha! Data in Lazarus Pascal IDE
Learn how to easily integrate live Aha! in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Highrise Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Highrise CRM from HeidiSQL.
-
Migrating data from Invoiced to Snowflake using CData SSIS Components.
Easily push Invoiced to Snowflake using the CData SSIS Tasks for Invoiced and Snowflake.
-
How to load VWO data into Elasticsearch via Logstash
Introducing a simple method to load VWO data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Visualize Reckon Accounts Hosted Data in Python with pandas
Use pandas and other modules to analyze and visualize live Reckon Accounts Hosted in Python.
-
Use the CData ODBC Driver for Facebook in Microsoft Power Query
You can use the CData Facebook ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Facebook into Microsoft Power Query.
-
Access Live Oracle Eloqua Reporting Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Eloqua Reporting data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Live Klipfolio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Klipfolio to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize Live Strava Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Strava.
-
Visualize Live Facebook Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Facebook.
-
Use Dash to Build to Web Apps on Mailgun Data
Create Python applications that use pandas and Dash to build Mailgun-connected web apps.
-
Automated Continuous Keap Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Keap replication to Google BigQuery.
-
Connect to Acumatica Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Acumatica ERP in Airbyte.
-
How to import Google Calendar Data into Apache Solr
Use the CData Software JDBC Driver for Google Calendar in Data Import Handler and create an automated import of Google Calendar to Apache Solr Enterprise Search platform.
-
Manage Google Analytics Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Analytics.
-
Create Reports with Outreach.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Outreach.io.