CData Software - Knowledge Base
Recent Articles
-
Work with Pipeliner CRM Data in FoxPro
Load Pipeliner CRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Google Drive Data from PowerBuilder via JDBC
This article demonstrates how to access Google Drive from PowerBuilder using the Google Drive JDBC Driver.
-
How to load Planio data into Elasticsearch via Logstash
Introducing a simple method to load Planio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Bridge Zoho Books Connectivity with Apache NiFi
Access and process Zoho Books in Apache NiFi using the CData JDBC Driver.
-
Connect to Azure Data Lake Storage from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Data Lake Storage to connect to Azure Data Lake Storage from Web applications running on WebLogic.
-
Visualize Google Tasks 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 Google Tasks into TIBCO Spotfire.
-
Build AI/ML Models with Live Oracle Sales Data using Dataiku
Connect Oracle Sales Data with Dataiku using the CData JDBC Driver for Oracle Sales.
-
Viewing PingOne Data in RAD Studio Data Explorer
How to view PingOne in RAD Studio Data Explorer using the CData ODBC Driver for PingOne.
-
PabblySubscriptions Reporting in OBIEE with the PabblySubscriptions JDBC Driver
Deploy the PabblySubscriptions JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate JotForm Data in the Pentaho Report Designer
Publish reports based on JotForm in the Pentaho BI tool.
-
Viewing Mailgun Data in RAD Studio Data Explorer
How to view Mailgun in RAD Studio Data Explorer using the CData ODBC Driver for Mailgun.
-
Connect to MariaDB Data in CloverDX (formerly CloverETL)
Transfer MariaDB using the visual workflow in the CloverDX data integration tool.
-
ETL SparkPost in Oracle Data Integrator
This article shows how to transfer SparkPost into a data warehouse using Oracle Data Integrator.
-
Prepare, Blend, and Analyze Pipedrive Data in Alteryx Designer (Connect AI)
Build workflows to access live Pipedrive for self-service data analytics.
-
Use Azure AI Foundry to Talk to Your PayPal 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 PayPal for you.
-
Create SSAS Tabular Models from CSV Data
How to build a SQL Server Analysis Service Tabular Model from CSV/TSV Files using CData drivers.
-
Use Azure AI Foundry to Talk to Your CouchDB 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 Apache CouchDB for you.
-
Automate LightSpeedRetail Data Replication to Couchbase
Use CData Sync to Customize and automate LightSpeedRetail replication to Couchbase.
-
Getting Started with the CData JDBC Driver for Power BI XMLA
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Power BI XMLA.
-
Publish Smartsheet-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Smartsheet.
-
Connect and Visualize Live API Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live API into the Databricks platform and create visualization dashboards with real-time API.
-
Build Voice Agents in ElevenLabs with access to Live SharePoint Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft SharePoint.
-
Analyze Power BI XMLA Data in Looker
Use CData Connect AI to connect to Power BI XMLA Data from Looker and build custom apps using live Power BI XMLA.
-
Publish Oracle HCM Cloud-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle HCM Cloud.
-
Explore Geographical Relationships in Float Data with Power Map
Create data visualizations with Float in Power Map.
-
Automated Continuous Testmonitor Replication to Databricks
Use CData Sync for automated, continuous, customizable Testmonitor replication to Databricks.
-
Connect to MariaDB Data in HULFT Integrate
Connect to MariaDB as a JDBC data source in HULFT Integrate
-
How to connect PolyBase to Google Drive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Drive.
-
How to Connect to Live Azure Synapse 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 Azure Synapse for you.
-
Establish a Live Connection with SQL Analysis Services Data using Tableau Bridge
The CData ODBC Driver for SQL Analysis Services enables you to integrate live SQL Analysis Services into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Easily Query Sage 200 Data in OpenOffice Base
Connect to Sage 200 data in OpenOffice Base using the CData ODBC Driver for Sage 200 and generate reports with live data insights.
-
How to Connect to Live Zoho Creator 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 Zoho Creator for you.
-
How to Visualize HubSpot Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live HubSpot in Python.
-
Access Live ServiceNow Data in Excel 365 Online (Excel for the web)
Connect to ServiceNow from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Discord-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Discord.
-
Build Apps with Live Google Ad Manager in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Ad Manager into the Adalo platform and build custom mobile and web applications with real-time Google Ad Manager.
-
Use Dash to Build to Web Apps on Customer.io Data
Create Python applications that use pandas and Dash to build Customer.io-connected web apps.
-
Connect to Oracle Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle as an External Source in Dremio.
-
Connect to Blackbaud FE NXT Data from Crystal Reports
Use CData Connect AI to connect to and report on live Blackbaud FE NXT from Crystal Reports.
-
Automated Continuous Sage 200 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage 200 replication to Amazon Redshift.
-
Feed Sentry Data into FineReport
How to set Sentry as a JDBC data source in FineReport.
-
Getting Started with the CData ODBC Driver for Sage 200
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sage 200.
-
Integrate Cline with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SurveyMonkey from within your IDE.
-
Natively Connect to SQL Server Data in PHP
The CData ODBC driver for SQL Server enables you to create PHP applications with connectivity to Microsoft SQL Server. Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce Data 360
Create an ODBC connection to Salesforce Data 360 in Informatica and browse and transfer Salesforce Data 360.
-
Use the CData Software JDBC Driver for Zoho Recruit in MicroStrategy Web
Connect to Zoho Recruit in MicroStrategy Web using the CData Software JDBC Driver for Zoho Recruit.
-
DataBind Controls to CockroachDB Data in C++Builder
DataBind to CockroachDB in C++Builder with standard components and controls.
-
How to Access Live Xero Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Xero enables you to integrate Xero Accounting into workflows built using Microsoft Power Automate Desktop.
-
Connect to CockroachDB Data from a Connection Pool in JBoss
Integrate CockroachDB into Java servlets: Use the Management Console in JBoss to install the CockroachDB JDBC Driver.
-
Query Yelp Data as a MySQL Database in Node.js
Execute MySQL queries against Yelp from Node.js.
-
Connect to Live Authorize.Net Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Authorize.Net in CData Connect AI and connect to your Authorize.Net from PostgreSQL.
-
Work with Redshift Data in FoxPro
Load Amazon Redshift into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for DocuSign in MicroStrategy Web
Connect to DocuSign in MicroStrategy Web using the CData Software ODBC Driver for DocuSign.
-
Connect to AgileCRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access AgileCRM from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Dashboards with Brex Data in Dundas BI
Create dynamic dashboards and perform analytics based on Brex in Dundas BI.
-
DataBind Charts to HDFS Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache HDFS 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.
-
Connect to SAP ByDesign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Business ByDesign in the Denodo Virtual DataPort Administrator.
-
Use Biml to Build SSIS Tasks to Replicate FTP Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate FTP Servers to SQL Server.
-
Use the CData SSIS Components to Insert New or Update Existing Oracle Records from SQL Server
Easily push SQL Server data to Oracle using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Oracle or update existing records with data from a SQL Server database.
-
How to Access ConvertKit Data Using Entity Framework
This article shows how to access ConvertKit using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Azure AI Foundry to Talk to Your ServiceNow 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 ServiceNow for you.
-
Create Reports from YouTube Analytics Data in Looker Studio
Use CData Connect AI to gain access to live YouTube Analytics and create custom reports in Looker Studio.
-
Integrating GitHub Copilot CLI with Discourse 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 Hacker News Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Hacker News using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Avalara AvaTax 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 Avalara AvaTax for you.
-
How to Connect to Live Outreach.io Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Outreach.io through natural language.
-
Integrate LeadDesk Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LeadDesk from Informatica Cloud.
-
How to Seamlessly Import Oracle Eloqua Data into IBM SPSS Modeler
Integrate Oracle Eloqua data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to PDFMonkey Data in CloverDX (formerly CloverETL)
Transfer PDFMonkey using the visual workflow in the CloverDX data integration tool.
-
Use Biml to Build SSIS Tasks to Replicate Paymo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Paymo to SQL Server.
-
Access Live Auth0 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Auth0 into the statistical analysis tools available in SAS JMP. This article shows how to use Auth0 in the Graph Builder and Query Builder.
-
Consume Cosmos DB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Cosmos DB feeds that reflect any changes in SAP Lumira.
-
Import Real-Time Pinterest Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pinterest in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for Unbounce
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Rapidly Develop ZeroBounce-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by ZeroBounce.
-
Connect to Kintone in SpagoBI
Create reports featuring live Kintone in SpagoBI Studio. Host Kintone reports on SpagoBI Server.
-
How to Build an ETL App for SAP SuccessFactors Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP SuccessFactors in Python with petl and the CData Connect AI Python SDK.
-
Use the CData ODBC Driver for Nuclia in Microsoft Power Query
You can use the CData Nuclia ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Nuclia into Microsoft Power Query.
-
Use Claude to Talk to Your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Zoho CRM for you.
-
Integrate Cursor with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Power BI XMLA from within the editor.
-
Operational Reporting on Raisers Edge NXT Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Raisers Edge NXT.
-
Import and Visualize Copper Data in Power View
Create data visualizations based on Copper in Excel.
-
How to connect to Klipfolio Data with Squirrel SQL client
Connect to Klipfolio and execute queries in the Squirrel SQL Client.
-
Visualize Live Zoho Projects Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoho Projects into custom reports in Power BI.
-
Query Accelo Data in DataGrip
Create a Data Source for Accelo in DataGrip and use SQL to query live Accelo.
-
How to Access Live Salesforce CRM Analytics Data in Visual Studio Code via Cline
Run CData MCP Server for Salesforce CRM Analytics on Windows Subsytem for Linux (WSL) and connect to live Salesforce CRM Analytics from the Cline extension in Visual Studio Code.
-
Rapidly Develop Salesforce CRM Analytics-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Salesforce CRM Analytics.
-
Explore Geographical Relationships in ShipStation Data with Power Map
Create data visualizations with ShipStation in Power Map.
-
Create Apps from Dropbox Data in Qlik Sense Cloud
Use CData Connect AI to connect to Dropbox Data and build apps from live Dropbox in Qlik Sense Cloud.
-
Replicate JSON Services from PowerShell
Write a quick PowerShell script to query JSON. Use connectivity to the live data to replicate JSON to SQL Server.
-
Load Clockify Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Clockify to a database.
-
Build Automated BambooHR-Connected Workflows in Zapier
Use CData Connect AI to connect to live BambooHR and build automated workflows in Zapier.
-
Create Redis-Connected Nintex Workflows
Use CData Connect AI to connect to Redis Data from Nintex Workflow Cloud and build custom workflows using live Redis.
-
Build AI/ML Models with Live Float Data using Dataiku
Connect Float Data with Dataiku using the CData API Driver for JDBC.
-
Connect to OData Services from a Connection Pool in JBoss
Integrate OData into Java servlets: Use the Management Console in JBoss to install the OData JDBC Driver.
-
How to create an RPA flow for Sage Cloud Accounting Data in UiPath Studio
Use the Sage Cloud Accounting ODBC Driver to create workflows that access real-time Sage Business Cloud Accounting without any coding.
-
Automated Continuous Google Calendar Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Calendar replication to OneLake in Microsoft Fabric.
-
Establish a Live Connection with Keap Data using Tableau Bridge
The CData ODBC Driver for Keap enables you to integrate live Keap into Tableau Cloud dashboards using the Tableau Bridge.
-
Create PolarTeamPro Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PolarTeamPro data access from reports, embedded analytics, and more.
-
How to Connect to Live MariaDB Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your MariaDB for you.