CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Toggl Data in Delphi
DataBind to Toggl in Delphi with standard data access components and controls.
-
Object-Relational Mapping (ORM) with QuickBooks Online 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 QuickBooks Online into a Java-based ORM framework, Hibernate.
-
Connect to Gong Data in HULFT Integrate
Connect to Gong as a JDBC data source in HULFT Integrate
-
Operational Reporting on CockroachDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CockroachDB.
-
How to Connect to & Open Bullhorn CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Bullhorn CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Real-Time Aha! Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Aha! in Power Apps.
-
Automated Continuous DB2 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable DB2 replication to Azure SQL Database.
-
How to Build an ETL App for Okta Data in Python with CData
Create ETL applications and real-time data pipelines for Okta in Python with petl.
-
Integrating OpenCode Terminal with Tanda 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.
-
How to Build an ETL App for Phoenix Data in Python with CData Connect AI
Build ETL pipelines that read and write live Apache Phoenix in Python with petl and the CData Connect AI Python SDK.
-
How to connect and process Customer.io from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Customer.io.
-
Connect to CircleCI Data in Jaspersoft Studio
Execute SQL to remote CircleCI in Jaspersoft Studio.
-
Natively Connect to Cohere Data in PHP
The CData ODBC driver for Cohere enables you to create PHP applications with connectivity to Cohere. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for Azure Table
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Table.
-
Edit and Search MySQL External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of MySQL to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create MySQL objects that you can access from apps and the dashboard.
-
A PostgreSQL Interface for ChartMogul Data using the CData ODBC Driver
Use the SQL Gateway and ChartMogul ODBC Driver to create a PostgreSQL entry-point for data access.
-
Process & Analyze Google Translate Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Translate Data.
-
How to create ConvertAPI federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ConvertAPI in MySQL .
-
Enable the Brex JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Brex.
-
Getting Started with the CData Power BI Connector for ChartMogul
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData SSIS Components for MailerSend
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailerSend.
-
Visualize Live iContact Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live iContact using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access BambooHR Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BambooHR from HeidiSQL.
-
Visualize Apify Data in TIBCO Spotfire through ADO.NET
Integrate Apify into dashboards in TIBCO Spotfire.
-
How to Connect to Live Raisers Edge NXT Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Raisers Edge NXT for you.
-
Stream Instantly Data into Apache Kafka Topics
Access and stream Instantly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Build an ETL App for GraphQL Data in Python with CData Connect AI
Build ETL pipelines that read and write live GraphQL in Python with petl and the CData Connect AI Python SDK.
-
Integrating Cursor CLI with Opsgenie 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.
-
Import and Visualize Auth0 Data in Power View
Create data visualizations based on Auth0 in Excel.
-
Automated FreeAgent Data Replication to Teradata
Use CData Sync to Customize and automate FreeAgent replication to Teradata.
-
Automated Continuous Workday Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Workday replication to IBM DB2.
-
SAP SuccessFactors Reporting in OBIEE with the SAP SuccessFactors JDBC Driver
Deploy the SAP SuccessFactors JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Pipeliner CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Pipeliner CRM and work with Pipeliner CRM in your FileMaker application.
-
Bridge CSV Connectivity with Apache NiFi
Access and process CSV/TSV Files in Apache NiFi using the CData JDBC Driver.
-
How to Query Deel Data in MySQL Workbench
Execute MySQL queries against live Deel from MySQL Workbench.
-
How to Connect to Live EnterpriseDB 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 EnterpriseDB for you.
-
Use Azure AI Foundry to Talk to Your SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SendGrid for you.
-
Visualize Live CouchDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache CouchDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Egnyte Data in DataGrip
Create a Data Source for Egnyte in DataGrip and use SQL to query live Egnyte.
-
Using CData JDBC Drivers from NetBeans
CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to develop with CData JDBC Drivers using the NetBeans Java IDE.
-
Build Pipelines with Live Freshdesk Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Freshdesk from Google Cloud Data Fusion, enabling the integration of live Freshdesk into the building and management of effective data pipelines.
-
Operational Reporting on SAP ByDesign Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business ByDesign.
-
Publish Gong-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Gong.
-
Connect to LionDesk Data in HULFT Integrate
Connect to LionDesk as a JDBC data source in HULFT Integrate
-
Connect to Google Analytics Data in Jaspersoft Studio
Execute SQL to remote Google Analytics in Jaspersoft Studio.
-
How to Connect Amazon Athena 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 Amazon Athena data in real time using natural language.
-
Connecting Pipedream with GraphQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on GraphQL data in real time.
-
How to connect Amazon QuickSight to SAS xpt Data
Create a connection to SAS XPORT in CData Connect AI and insert SAS XPORT into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect PolyBase to Dynamics CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dynamics CRM.
-
Build AI/ML Models with Live Rebilly Data using Dataiku
Connect Rebilly Data with Dataiku using the CData API Driver for JDBC.
-
How to Seamlessly Import Bullhorn CRM Data into IBM SPSS Modeler
Integrate Bullhorn CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Easily Integrate BenchmarkEmail Data in Lazarus Pascal IDE
Learn how to easily integrate live BenchmarkEmail in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Extend Google Sheets with Google Drive Data
Make calls to Google Drive from Google Apps Script via the API Server.
-
DataBind Controls to Scrapfly Data in Delphi
DataBind to Scrapfly in Delphi with standard data access components and controls.
-
Access Live Epicor Kinetic Data in TIBCO Data Virtualization
Use the Epicor Kinetic Tibco DV Adapter to create a Epicor Kinetic data source in TIBCO Data Virtualization Studio and gain access to live Epicor Kinetic from your TDV Server.
-
Visualize Live MySQL Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MySQL.
-
Getting Started with the CData JDBC Driver for Confluence
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Confluence.
-
Integrate Timely Data in Pentaho Data Integration
Build ETL pipelines based on Timely in the Pentaho Data Integration tool.
-
Bridge ZohoMarketingHub Connectivity with Apache NiFi
Access and process ZohoMarketingHub in Apache NiFi using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for SpaceX on an SSRS Report Server
Connect to SpaceX 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.
-
Build a PostgreSQL Interface for Typeform Data using the CData JDBC Driver
Use the Remoting features of the Typeform JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP HANA XS Advanced Data in HULFT Integrate
Connect to SAP HANA XS Advanced as a JDBC data source in HULFT Integrate
-
How to Connect to Live Cloudant 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 IBM Cloudant for you.
-
Access Live Sage Cloud Accounting Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sage Cloud Accounting data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Live Freshservice Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Freshservice and integrate live Freshservice into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for Samanage in MicroStrategy Web
Connect to Samanage in MicroStrategy Web using the CData Software JDBC Driver for Samanage.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in MicroStrategy
Connect to Salesforce Data 360 in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce Data 360.
-
Build a Simple VCL Application for GitHub Data
How to build a simple VCL Application to view GitHub in RAD Studio using the CData ODBC Driver for GitHub.
-
Query PingOne Data as a MySQL Database in Node.js
Execute MySQL queries against PingOne from Node.js.
-
Back Up CircleCI 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 CircleCI data.
-
How to connect to LinkedIn Ads Data with Squirrel SQL client
Connect to LinkedIn Ads and execute queries in the Squirrel SQL Client.
-
Use the CData ODBC Driver for SharePoint from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SharePoint to connect to Microsoft SharePoint from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft SharePoint in Excel.
-
Replicate Multiple Autopilot Accounts via the CData Sync CLI
Replicate multiple Autopilot accounts to one or many databases.
-
How to Access Live Slack Data in Visual Studio Code via Cline
Run CData MCP Server for Slack on Windows Subsytem for Linux (WSL) and connect to live Slack from the Cline extension in Visual Studio Code.
-
Choosing the Best Method to Connect Intercom to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Intercom from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Biml to Build SSIS Tasks to Replicate Avalara AvaTax Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Avalara AvaTax to SQL Server.
-
How to work with Onfleet Data in Apache Spark using SQL
Access and process Onfleet Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live Anaplan Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Anaplan using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Cohere Data in RazorSQL
Connect to Cohere from wizards and query Cohere from the GUI in the RazorSQL database management tool.
-
Automated Continuous Microsoft Entra ID Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to IBM DB2.
-
Build Raisers Edge NXT-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Raisers Edge NXT to explore live Raisers Edge NXT Data in Claude Code to assist with building Raisers Edge NXT-powered applications.
-
Connect to DB2 in SpagoBI
Create reports featuring live IBM DB2 in SpagoBI Studio. Host DB2 reports on SpagoBI Server.
-
Create Data Visualizations Based On Redis Data in Mode
Use CData Connect AI to connect to Redis Data from Mode and build visualizations using live
-
Use JayDeBeApi to access PhantomBuster Data in Python
Use standard Python scripting and the development environment of your choice to access live PhantomBuster.
-
Connect to MailerSend Data in HULFT Integrate
Connect to MailerSend as a JDBC data source in HULFT Integrate
-
Automated Continuous EnterpriseDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Azure SQL Database.
-
A PostgreSQL Interface for MongoDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the MongoDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Dynamics 365 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics 365.
-
Visualize Live SAP Ariba Source Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Ariba Source into custom reports in Power BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for YouTube Analytics
Provide connectivity to YouTube Analytics through an SAP BusinessObjects universe.
-
Access MariaDB 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 MariaDB.
-
Add CampaignMonitor Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CampaignMonitor with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to ClickUp from a Connection Pool in WebLogic
Use the CData JDBC Driver for ClickUp to connect to ClickUp from Web applications running on WebLogic.
-
Access Live SAP Hybris C4C Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Hybris C4C into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Hybris C4C in the Graph Builder and Query Builder.
-
Natively Connect to Square Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Square. Leverage the native support for ODBC in PHP.
-
Integrate Theia IDE with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Exa Replication to Oracle
Use CData Sync for automated, continuous, customizable Exa replication to Oracle.
-
Design BIRT Reports on Slack Data
Provide current Slack to your embedded analytics.
-
Publish Crystal Reports on Hacker News Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Hacker News.
-
Automated Continuous Samanage Replication to MySQL
Use CData Sync for automated, continuous, customizable Samanage replication to MySQL.