CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to Dynamics NAV: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics NAV from PowerBI.com to provide real-time Microsoft Dynamics NAV across the organization.
-
Build Greenplum-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Greenplum to explore live Greenplum Data in Cursor to assist with building Greenplum-powered applications.
-
Bridge Float Connectivity with Apache NiFi
Access and process Float in Apache NiFi using the CData JDBC Driver.
-
Connect to SAP Data in Ruby
Connect to SAP ERP/NetWeaver in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Stripe-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Stripe and build web apps with connectivity to live Stripe.
-
DataBind Controls to Avalara AvaTax Data in C++Builder
DataBind to Avalara AvaTax in C++Builder with standard components and controls.
-
Build SAP SuccessFactors LMS-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP SuccessFactors LMS to explore live SAP SuccessFactors LMS Data in GitHub Copilot to assist with building SAP SuccessFactors LMS-powered applications.
-
Connect to Bitly Data in CloverDX (formerly CloverETL)
Transfer Bitly using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Impala Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Impala replication to delimited files (CSV/TSV).
-
Build Charts with PDFMonkey Data in Clear Analytics
Create dynamic charts and perform analytics based on PDFMonkey in Clear Analytics.
-
Connect to and Query Deel Data in QlikView over ODBC
Create data visualizations with Deel in QlikView.
-
Bridge SAP HANA XS Advanced Connectivity with Apache NiFi
Access and process SAP HANA XS Advanced in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Databricks in a Connection Pool in Tomcat
Connect to Databricks from a connection pool in Tomcat.
-
Automate Google Search Results Replication to Azure Synapse
Use CData Sync to customize and automate Google Search replication to Azure Synapse.
-
Integrate Live GitLab Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live GitLab to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Seamlessly Bring SingleStore Data into Retool Using CData Connect AI
Integrate SingleStore data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Microsoft Planner Data in TIBCO Spotfire through OData
Integrate Microsoft Planner into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Moosend
Create an ODBC connection to Moosend in Informatica and browse and transfer Moosend.
-
Automated Continuous RSS Replication to MongoDB
Use CData Sync for automated, continuous, customizable RSS replication to MongoDB.
-
Integrating Cursor CLI with Outreach.io 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.
-
Create Dynamic Oracle SCM Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle SCM to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Perigon Data in DBeaver
Use the CData ODBC Driver to connect to Perigon in DBeaver.
-
SAP Netweaver Gateway Reporting in OBIEE with the SAP Netweaver Gateway JDBC Driver
Deploy the SAP Netweaver Gateway JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Extend Google Sheets with Raisers Edge NXT Data
Make calls to Raisers Edge NXT from Google Apps Script via the API Server.
-
Create a Data Access Object for Mailgun Data using JDBI
A brief overview of creating a SQL Object API for Mailgun in JDBI.
-
Integrating Cursor CLI with Parallel 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 HBase Data in HULFT Integrate
Connect to HBase as a JDBC data source in HULFT Integrate
-
Build Dashboards with Amplitude Data in DBxtra
Create dynamic dashboards and perform analytics based on Amplitude in DBxtra.
-
Integrating Sage Cloud Accounting Data in Talend Cloud Data Management Platform
Connect Sage Cloud Accounting Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage Cloud Accounting.
-
Access Live SharePoint Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft SharePoint from your Excel spreadsheets.
-
How to Work with AdRoll Data in AWS Glue Jobs Using JDBC
Connect to AdRoll from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous ZohoSubscriptions Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Azure SQL Database.
-
Query Google Calendar Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Calendar from Node.js.
-
How to Design Active Directory Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Active Directory from mobile and tablet Power Apps.
-
Replicate Multiple LeadDesk Accounts via the CData Sync CLI
Replicate multiple LeadDesk accounts to one or many databases.
-
How to Connect DBeaver to JDBC-ODBC Bridge via a JDBC Driver
Manage JDBC-ODBC Bridge with visual tools in DBeaver like the query browser.
-
Connect to Facebook Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Facebook Ads as an External Source in Dremio.
-
Import Real-Time Microsoft Dataverse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Dataverse (CDS) in ColdFusion.
-
Work with Live LinkedIn Data in Power Query
Use CData Connect AI to connect to LinkedIn and work with live LinkedIn in Microsoft Power Query.
-
Use the CData Software ODBC Driver for ChartMogul in MicroStrategy Desktop
Connect to ChartMogul in MicroStrategy Desktop using the CData Software ODBC Driver for ChartMogul.
-
Build JSON-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for JSON Services and create custom apps in Mendix.
-
Automate Cassandra Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache Cassandra replication to Azure Data Lake.
-
DataBind Controls to QuickBooks Online Data in Delphi
DataBind to QuickBooks Online in Delphi with standard data access components and controls.
-
Migrating data from ZohoPeople to Databricks using CData SSIS Components.
Easily push ZohoPeople to Databricks using the CData SSIS Tasks for ZohoPeople and Databricks.
-
Access Live Microsoft Teams Data in AWS Lambda
Connect to live Microsoft Teams in AWS Lambda using the CData JDBC Driver.
-
Migrating data from Azure DevOps to Databricks using CData SSIS Components.
Easily push Azure DevOps to Databricks using the CData SSIS Tasks for Azure DevOps and Databricks.
-
Use Biml to Build SSIS Tasks to Replicate MySQL Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MySQL to SQL Server.
-
Create Reports from FTP Data in Looker Studio
Use CData Connect AI to gain access to live FTP Servers and create custom reports in Looker Studio.
-
Moving Data from ZohoExpense to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoExpense data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Reports with ClickTime Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ClickTime.
-
Use the CData ODBC Driver for Demio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Demio to connect to Demio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Demio in Excel.
-
Getting Started with the CData SSIS Components for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Stack Exchange.
-
Automated Continuous Google Contacts Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Contacts replication to Databricks.
-
Integrate Salesforce CRM Analytics Data in Pentaho Data Integration
Build ETL pipelines based on Salesforce CRM Analytics in the Pentaho Data Integration tool.
-
Integrate Open WebUI with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP SuccessFactors LMS from within the chat interface.
-
Connect to Microsoft Planner Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Planner in the Denodo Virtual DataPort Administrator.
-
Integrating Typeform Data in Talend Cloud Data Management Platform
Connect Typeform Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Live Presto Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Presto from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Presto.
-
Natively Connect to Short.io Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Short.io. Leverage the native support for ODBC in PHP.
-
Connect to Adobe Analytics Data in HULFT Integrate
Connect to Adobe Analytics as a JDBC data source in HULFT Integrate
-
Automate SageHR Data Replication to Azure Synapse
Use CData Sync to customize and automate SageHR replication to Azure Synapse.
-
Connect to JSON Services from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for JSON to connect to JSON and execute queries in PowerBuilder.
-
Getting Started with the CData Excel Add-In for Acumatica
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Acumatica.
-
Connect to Oracle Service Cloud Data from a Connection Pool in JBoss
Integrate Oracle Service Cloud into Java servlets: Use the Management Console in JBoss to install the Oracle Service Cloud JDBC Driver.
-
How to create an RPA flow for BenchmarkEmail Data in UiPath Studio
Use the BenchmarkEmail ODBC Driver to create workflows that access real-time BenchmarkEmail without any coding.
-
Publish AfterShip-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live AfterShip.
-
Bridge CampaignMonitor Connectivity with Apache NiFi
Access and process CampaignMonitor in Apache NiFi using the CData JDBC Driver.
-
Connect to Billsby Data in CloverDX (formerly CloverETL)
Transfer Billsby using the visual workflow in the CloverDX data integration tool.
-
How to Query Samanage Data in MySQL Workbench
Execute MySQL queries against live Samanage from MySQL Workbench.
-
Automate FormSite Data Replication to Azure Data Lake
Use CData Sync to customize and automate FormSite replication to Azure Data Lake.
-
Integrating Claude Code CLI with MariaDB 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.
-
Establish a Live Connection with VWO Data using Tableau Bridge
The CData ODBC Driver for VWO enables you to integrate live VWO into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Dropbox Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Dropbox.
-
Connect to Microsoft Planner Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Planner from Filemaker Pro on Mac.
-
Explore Geographical Relationships in Reply.io Data with Power Map
Create data visualizations with Reply.io in Power Map.
-
DataBind Controls to AgileCRM Data in Delphi
DataBind to AgileCRM in Delphi with standard data access components and controls.
-
DataBind Controls to Telegram Data in Delphi
DataBind to Telegram in Delphi with standard data access components and controls.
-
Establish a Live Connection with Dotmailer Data using Tableau Bridge
The CData ODBC Driver for Dotmailer enables you to integrate live Dotmailer into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect DB2 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live IBM DB2 using the CData Python MCP Server.
-
Build Semantic Layer Views for JSON Services in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for JSON.
-
Use Biml to Build SSIS Tasks to Replicate Azure Table Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Table Storage to SQL Server.
-
Connect to CockroachDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CockroachDB to connect to CockroachDB and execute queries in PowerBuilder.
-
Connect to Landbot Data from PowerBuilder via ADO.NET
This article demonstrates how to access Landbot from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build a Simple VCL Application for Coda Data
How to build a simple VCL Application to view Coda in RAD Studio using the CData ODBC Driver for Coda.
-
Build Voice Agents in ElevenLabs with access to Live Zoho Projects Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zoho Projects.
-
Access Live Monday.com Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Monday.com data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Replicate Retently Data to Multiple Databases via the CData Sync CLI
Replicate Retently to disparate databases with a single configuration.
-
Connect and Visualize Live Freshdesk Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Freshdesk into the Databricks platform and create visualization dashboards with real-time Freshdesk.
-
Visualize Live GraphQL Data in the Power BI Service
Use CData Connect AI to connect to live GraphQL and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Helpscout Data in Tableau
The CData ODBC driver for Helpscout enables you integrate Helpscout into Tableau dashboards.
-
Use the CData ODBC Driver for Recurly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Recurly to connect to Recurly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Recurly in Excel.
-
How to use SQLAlchemy ORM to access Mailgun Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mailgun.
-
Import and Visualize Samanage Data in Power View
Create data visualizations based on Samanage in Excel.
-
Use the CData ODBC Driver for Pingdom in Microsoft Power Query
You can use the CData Pingdom ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pingdom into Microsoft Power Query.
-
Build Oracle Sales Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Sales and build visualizations in Tableau.
-
Access Live Oracle Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Database into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Database in the Graph Builder and Query Builder.
-
Create Dashboards and Visualize Live SingleStore Data in Geckoboard
Use CData Connect AI to connect to live SingleStore and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Landbot Data from MySQL in Amazon QuickSight
Connect to Landbot and build visualizations of Landbot using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous GetResponse Replication to SQLite
Use CData Sync for automated, continuous, customizable GetResponse replication to SQLite.
-
Connect Telegram Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Telegram using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.