CData Software - Knowledge Base
Recent Articles
-
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.
-
Enable the Hugging Face JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hugging Face.
-
Query Aweber Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Aweber entities in PHP by modeling them as objects.
-
Import Real-Time JotForm Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use JotForm in ColdFusion.
-
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.
-
Use the CData ODBC Driver for Apify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Apify to connect to Apify from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apify in Excel.
-
Automated Continuous Paylocity Replication to Vertica
Use CData Sync for automated, continuous, customizable Paylocity replication to Vertica.
-
Build CircleCI-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live CircleCI Data in Cursor to assist with building CircleCI-powered applications.
-
Access xBase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live xBase from HeidiSQL.
-
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.
-
How to import SQL Server Data into Apache Solr
Use the CData Software JDBC Driver for SQL Server in Data Import Handler and create an automated import of Microsoft SQL Server to Apache Solr Enterprise Search platform.
-
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.
-
Integrating Boomi Agentstudio with Active Directory Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Active Directory, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Seamlessly Import Paymo Data into IBM SPSS Modeler
Integrate Paymo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for Invoiced in SAS for Real-Time Reporting and Analytics
Connect to real-time Invoiced in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Invoiced.
-
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.
-
How to connect to Cloudant Data from IntelliJ
Integrate connectivity to IBM Cloudant with wizards in IntelliJ.
-
How to connect to Invoiced Data from Spring Boot
Connect to Invoiced in a Spring Boot Application using the CData API Driver for JDBC
-
Use Biml to Build SSIS Tasks to Replicate IBM Cloud Object Storage Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM Cloud Object Storage to SQL Server.
-
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 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.
-
Getting Started with the CData ODBC Driver for Sybase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sybase.
-
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.
-
How to Query Live SFTP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SFTP data in natural language using Python.
-
Build AI/ML Models with Live SAP HANA Data using Dataiku
Connect SAP HANA Data with Dataiku using the CData JDBC Driver for SAP HANA.
-
Connecting Moonlit Workflow with Freshservice 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 Freshservice in real time.
-
Connect to CSV Data in CloverDX (formerly CloverETL)
Transfer CSV/TSV Files using the visual workflow in the CloverDX data integration tool.
-
Connect to Pinecone Data in CloverDX (formerly CloverETL)
Transfer Pinecone 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.
-
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.
-
Connect to LeadDesk Data in NetBeans
Connect to LeadDesk in NetBeans with the data source configuration wizard.
-
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.
-
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.
-
Access SendInBlue Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SendInBlue from your Oracle system.
-
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.
-
Automated Continuous ShipStation Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ShipStation replication to Apache Cassandra.
-
Building Dynamic Web Pages with Eventbrite Data Using AngularJS
Create single-page applications with live connectivity to Eventbrite using the CData API Server.
-
Build FreshBooks-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live FreshBooks Data in Claude Code to assist with building FreshBooks-powered applications.
-
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.
-
Use the CData API Server to Access Retently Data in Microsoft PowerPivot
Use the CData API Server to connect to live Retently in the Power Pivot business intelligence tool.
-
Automated Continuous Slack Replication to SQL Server
Use CData Sync for automated, continuous, customizable Slack replication to SQL Server.
-
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.
-
Build Google Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Analytics and build Google Analytics-connected web apps with Axios.
-
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.
-
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.
-
Natively Connect to Factorial Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Factorial. Leverage the native support for ODBC in PHP.
-
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.
-
Access Live Microsoft Dataverse Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Dataverse (CDS) from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
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.
-
Connect to Retently Data in RazorSQL
Connect to Retently from wizards and query Retently from the GUI in the RazorSQL database management tool.
-
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.
-
Establish a Live Connection with Procore Data using Tableau Bridge
The CData ODBC Driver for Procore enables you to integrate live Procore into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Presto Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Presto and the SQL Gateway to access Presto from Google Apps Script.
-
Automated Quaderno Data Replication to Teradata
Use CData Sync to Customize and automate Quaderno replication to Teradata.
-
Build Visualizations of Superchat Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Superchat in Birst.
-
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.
-
How to connect PolyBase to Harvest
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Harvest.
-
Import and Visualize Amplitude Data in Power View
Create data visualizations based on Amplitude in Excel.
-
How to Connect DBeaver to Strava via a JDBC Driver
Manage Strava with visual tools in DBeaver like the query browser.
-
Add Google Drive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Drive with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize VWO Data in Sisense
Create an ElastiCube in Sisense app with access to VWO.
-
Connect to and Visualize Live SharePoint Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft SharePoint.
-
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.
-
Connect to ZohoMarketingHub Data in CloverDX (formerly CloverETL)
Transfer ZohoMarketingHub using the visual workflow in the CloverDX data integration tool.
-
Import Strava Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Strava. In this article, you will use the OData format to import Strava into Microsoft Power Query.
-
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.
-
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.
-
Connect to QuickBooks Online 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 QuickBooks Online.
-
Access Live SAP ByDesign Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Business ByDesign from your Excel spreadsheets.
-
Integrate with live Salesforce Pardot Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce Pardot in Jitterbit.
-
Connecting Moonlit Workflow with Azure Analysis Services 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 Azure Analysis Services in real time.
-
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.
-
View Reports on Real-Time Wrike Data in Power BI Report Server
Use the CData ODBC Driver for Wrike to visualize Wrike in Power BI Desktop and then publish them to Power BI Report Server.
-
Process & Analyze Excel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Excel Data.
-
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.
-
Query Live Shopify Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Shopify directly from the development environment.
-
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.
-
Visualize Live Adobe Target Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Target using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live eBay Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to eBay from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live eBay.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Klaviyo
Provide connectivity to Klaviyo through an SAP BusinessObjects universe.
-
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.
-
Deploy the ADO.NET Provider for OData on an SSRS Report Server
Connect to OData 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.
-
Use the CData ODBC Driver for GitHub from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for GitHub to connect to GitHub from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring GitHub in Excel.
-
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.
-
Connecting Agentforce with BigCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your BigCommerce for you.
-
Analyze DB2 Data in Looker
Use CData Connect AI to connect to DB2 Data from Looker and build custom apps using live IBM DB2.
-
Build OData-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live OData and build OData-connected web apps with Axios.
-
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.