CData Software - Knowledge Base
Recent Articles
-
Build Couchbase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Couchbase.
-
Automated Continuous Teamwork Replication to Oracle
Use CData Sync for automated, continuous, customizable Teamwork replication to Oracle.
-
DataBind Charts to Databricks Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Databricks from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Edit and Search External Power BI XMLA Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Power BI XMLA to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Power BI XMLA Data objects that you can access from apps and the dashboard.
-
Connect to Monday.com Data from a Connection Pool in JBoss
Integrate Monday.com into Java servlets: Use the Management Console in JBoss to install the Monday.com JDBC Driver.
-
Enable the Hugging Face JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hugging Face.
-
Integrating Antigravity CLI with Neo4J via CData CLI
Connect Neo4J to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind Controls to Missive Data in C++Builder
DataBind to Missive in C++Builder with standard components and controls.
-
Create Power BI Reports on Real-Time AgileCRM Data
Use the CData ODBC Driver for AgileCRM to visualize AgileCRM in Power BI Desktop.
-
Access ServiceDesk Plus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ServiceDesk Plus from HeidiSQL.
-
How to integrate Metabase with Pipedrive Data
Use CData Connect AI to connect to live Pipedrive and create an interactive dashboard in Metabase from Pipedrive.
-
Automated Continuous Paylocity Replication to Vertica
Use CData Sync for automated, continuous, customizable Paylocity replication to Vertica.
-
How to Build an ETL App for Google Analytics Data in Python with CData
Create ETL applications and real-time data pipelines for Google Analytics in Python with petl.
-
Visualize Optimizely 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 Optimizely into TIBCO Spotfire.
-
Stream Pushbullet Data into Apache Kafka Topics
Access and stream Pushbullet in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Prepare, Blend, and Analyze Google Calendar Data in Alteryx Designer (ODBC)
Build workflows to access live Google Calendar for self-service data analytics.
-
How to use SQLAlchemy ORM to access BigQuery Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google BigQuery.
-
Access Live Qualaroo Data in AWS Lambda
Connect to live Qualaroo in AWS Lambda using the CData JDBC Driver.
-
Access Live Trello Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Trello in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Claude Code CLI with Humanity 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.
-
Connect to IBM Informix Data from Crystal Reports
Use CData Connect AI to connect to and report on live IBM Informix from Crystal Reports.
-
Build Voice Agents in ElevenLabs with access to Live FHIR Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live FHIR.
-
Create NetSuite-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to NetSuite Data from OutSystems and build custom enterprise apps using live NetSuite CRM & ERP.
-
Connect to MYOB AccountRight Data in HULFT Integrate
Connect to MYOB AccountRight as a JDBC data source in HULFT Integrate
-
Analyze Microsoft Exchange Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Exchange and visualize Microsoft Exchange in SAP Analytics Cloud.
-
Create Dropbox-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dropbox Data from Klipfolio and build custom visualizations using live Dropbox.
-
Create SAS Data Sets-Connected Dashboards in Grafana
Connect to SAS Data Sets Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAS Data Sets.
-
Connect to Active Directory 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 Active Directory.
-
Import EnterpriseDB Data Using Azure Data Factory
Use CData Connect AI to connect to EnterpriseDB Data from Azure Data Factory and import live EnterpriseDB.
-
Connect to Elorus from Asprova with CData Software ODBC Driver for Elorus
This article shows how to connect faster to Elorus data from Asprova.
-
Access Live Deel Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Deel in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to CSV Data in CloverDX (formerly CloverETL)
Transfer CSV/TSV Files using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Jumpseller Replication to SingleStore
Use CData Sync for automated, continuous, customizable Jumpseller replication to SingleStore.
-
Integrating Codex CLI with Redis 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.
-
Connect CockroachDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CockroachDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create HBase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to HBase Data from OutSystems and build custom enterprise apps using live Apache HBase.
-
Design BIRT Reports on Email Data
Provide current Email to your embedded analytics.
-
Access Live Azure Data Lake Storage Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Data Lake Storage from your Excel spreadsheets.
-
Connect Elorus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Elorus using the CData Python MCP Server.
-
Use CData Connect AI to Access Azure DevOps Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Azure DevOps in the Power Pivot business intelligence tool.
-
Migrating data from Harvest to Databricks using CData SSIS Components.
Easily push Harvest to Databricks using the CData SSIS Tasks for Harvest and Databricks.
-
Integrate MailerSend with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MailerSend with External Services.
-
Visualize Strava Data in TIBCO Spotfire through ADO.NET
Integrate Strava into dashboards in TIBCO Spotfire.
-
How to connect Amazon QuickSight to Workday Data
Create a connection to Workday in CData Connect AI and insert Workday into Amazon QuickSight SPICE to build interactive dashboards.
-
DataBind Controls to Paymo Data in C++Builder
DataBind to Paymo in C++Builder with standard components and controls.
-
Access SendInBlue Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SendInBlue from your Oracle system.
-
How to Query MailerLite Data in MySQL Workbench
Execute MySQL queries against live MailerLite from MySQL Workbench.
-
Working with Oracle Eloqua Reporting Data in LINQPad
Execute LINQ queries to Oracle Eloqua Reporting in LINQPad.
-
Connect to Intercom Data in Jaspersoft Studio
Execute SQL to remote Intercom in Jaspersoft Studio.
-
Build Salesforce Pardot-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Salesforce Pardot Data from Zoho Analytics and import live Salesforce Pardot.
-
Visualize Live Salesforce Marketing Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce Marketing Cloud using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Highrise in SAS for Real-Time Reporting and Analytics
Connect to real-time Highrise CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Highrise.
-
Automated Continuous ShipStation Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ShipStation replication to Apache Cassandra.
-
Use Biml to Build SSIS Tasks to Replicate ClickTime Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ClickTime to SQL Server.
-
Integrate with Salesforce Pardot Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce Pardot in SnapLogic.
-
Import Real-Time Sendwithus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sendwithus in ColdFusion.
-
Visualize Vault CRM 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 Veeva Vault & Vault CRM into TIBCO Spotfire.
-
A PostgreSQL Interface for Short.io Data (MySQL Remoting via JDBC)
Use the Remoting features of the Short.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to Beeminder Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Beeminder from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to use SQLAlchemy ORM to access Spark Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Spark SQL.
-
How to Query Live Active Directory Data in Claude Desktop
Connect to and query live Active Directory Data in Claude Desktop using CData MCP Server.
-
Publish Active Directory-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Active Directory.
-
How to connect Amazon QuickSight to Microsoft OneDrive Data
Create a connection to Microsoft OneDrive in CData Connect AI and insert Microsoft OneDrive into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Agents in Relevance AI with Access to Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on NetSuite CRM & ERP within intelligent agent workflows.
-
A PostgreSQL Interface for Twitter Ads Data using the CData ODBC Driver
Use the SQL Gateway and Twitter Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Teamwork Data from a Connection Pool in Jetty
The Teamwork JDBC Driver supports connection pooling: This article shows how to connect faster to Teamwork from Web apps in Jetty.
-
Automated Certinia Data Replication to Teradata
Use CData Sync to Customize and automate Certinia replication to Teradata.
-
Replicate REST Data from PowerShell
Write a quick PowerShell script to query REST. Use connectivity to the live data to replicate REST to SQL Server.
-
Build SAS xpt Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAS XPORT and build visualizations in Tableau.
-
Consume SAP OData Feeds in PowerBuilder
This article demonstrates how to consume SAP ERP/NetWeaver as OData feeds from PowerBuilder using the API Server.
-
Changelog: Driver Update 2024.3
Review the driver-specific changes from the 2024.3 CData Driver release.
-
Analyze Google Search Results in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Search and visualize live Google Search in Infragistics Reveal.
-
Integrate Cline with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live OData from within your IDE.
-
Bidirectional Access to Google Directory Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Directory in Filemaker Pro for Mac or Windows.
-
Automated Continuous SAP Ariba Procurement Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Snowflake.
-
Automated Continuous GraphQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GraphQL replication to Google BigQuery.
-
Visualize VWO Data in Sisense
Create an ElastiCube in Sisense app with access to VWO.
-
Use the CData Software ODBC Driver for MessageBird in SAS for Real-Time Reporting and Analytics
Connect to real-time MessageBird in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MessageBird.
-
Integrate Open WebUI with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live OData from within the chat interface.
-
Connect to Adobe Experience Manager Data in Ruby
Connect to Adobe Experience Manager in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Live Zendesk Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zendesk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zendesk.
-
Access Bitbucket Data from MySQL in PHP
Connect to Bitbucket through the standard MySQL libraries in PHP.
-
Build a Simple VCL Application for MailerLite Data
How to build a simple VCL Application to view MailerLite in RAD Studio using the CData ODBC Driver for MailerLite.
-
Build a PostgreSQL Interface for Elorus Data using the CData JDBC Driver
Use the Remoting features of the Elorus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import SAP Hybris C4C Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Hybris C4C Data and provide access to live SAP Hybris C4C for custom reports in the Power BI Service.
-
Migrating data from SendGrid to Snowflake using CData SSIS Components.
Easily push SendGrid to Snowflake using the CData SSIS Tasks for SendGrid and Snowflake.
-
Connect Highrise to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Highrise with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Real-Time Access to Microsoft OneDrive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft OneDrive in real time.
-
Getting Started with the CData Power BI Connector for Outlook
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Redis Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Redis replication to PostgreSQL.
-
Getting Started with the CData Excel Add-In for Drift
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Drift.
-
Create DB2 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for DB2 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Oracle Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Oracle Database through MCP integration.
-
Automated Continuous eBay Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Vertica.
-
Integrate Live Okta Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Okta to Blue Prism using the CData ODBC Driver for Okta to create automated workflows for repetitive business tasks.
-
Integrate Microsoft Exchange with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Exchange with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Exchange.
-
Build MVC Applications with Connectivity to SAS xpt Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAS xpt from an ASP.NET MVC application.
-
Enable the HBase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache HBase.
-
Connecting Moonlit Workflow with Freshdesk 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 Freshdesk in real time.
-
Use the CData ODBC Driver for YouTube Analytics in Microsoft Power Query
You can use the CData YouTube Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import YouTube Analytics into Microsoft Power Query.