CData Software - Knowledge Base
Recent Articles
-
Analyze Databricks Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Databricks with the CData JDBC Driver for Databricks.
-
Connect to DB2 Data in HULFT Integrate
Connect to DB2 as a JDBC data source in HULFT Integrate
-
Create Dynamic Confluence Grids Using the Infragistics XamDataGrid
Learn how you can connect Confluence to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Gumloop with Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Quickbase within automated workflows.
-
Query ActiveCampaign Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ActiveCampaign from Node.js.
-
Migrating data from ElevenLabs to Snowflake using CData SSIS Components.
Easily push ElevenLabs to Snowflake using the CData SSIS Tasks for ElevenLabs and Snowflake.
-
Use Biml to Build SSIS Tasks to Replicate Keap Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Keap to SQL Server.
-
Moving Data from NASA to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live NASA data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build MVC Applications with Connectivity to Google Drive Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Drive from an ASP.NET MVC application.
-
Use the CData ODBC Driver for Google Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Ads to connect to Google Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Ads in Excel.
-
DataBind Nethunt Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Nethunt to a chart.
-
Access Live Chargebee Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Chargebee data source in TIBCO Data Virtualization Studio and gain access to live Chargebee from your TDV Server.
-
Build Stripe Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Stripe and build visualizations in Tableau.
-
Visualize Live API Data in the Power BI Service
Use CData Connect AI to connect to live API and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Reply.io Data as a MySQL Database in Node.js
Execute MySQL queries against Reply.io from Node.js.
-
Build AdRoll-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live AdRoll Data in Claude Code to assist with building AdRoll-powered applications.
-
Creating ServiceNow-Connected Applications in Unqork
You can use CData Connect AI to feed ServiceNow to Unqork and build custom business apps.
-
Build Automated GitHub-Connected Workflows in Zapier
Use CData Connect AI to connect to live GitHub and build automated workflows in Zapier.
-
Access Live ElevenLabs Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ElevenLabs in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Open WebUI with Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ShipStation from within the chat interface.
-
Building Dynamic Web Pages with BenchmarkEmail Data Using AngularJS
Create single-page applications with live connectivity to BenchmarkEmail using the CData API Server.
-
Connect to Google Ad Manager Data in Jaspersoft Studio
Execute SQL to remote Google Ad Manager in Jaspersoft Studio.
-
Automate Attio Data Replication to Azure Synapse
Use CData Sync to customize and automate Attio replication to Azure Synapse.
-
Stream Tanda Data into Apache Kafka Topics
Access and stream Tanda in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with ChargeOver Data in ETL Validator JDBC
Connect to ChargeOver from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous WordPress Replication to MongoDB
Use CData Sync for automated, continuous, customizable WordPress replication to MongoDB.
-
Establish a Live Connection with Egnyte Data using Tableau Bridge
The CData ODBC Driver for Egnyte enables you to integrate live Egnyte into Tableau Cloud dashboards using the Tableau Bridge.
-
Consume QuickBooks Online OData Feeds in PowerBuilder
This article demonstrates how to consume QuickBooks Online as OData feeds from PowerBuilder using the API Server.
-
Connecting GenSpark with Oracle Eloqua Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle Eloqua without any replication or custom integration required.
-
Build a Jira + Salesforce Unified Customer View with Cursor CLI and the CData CLI
Learn how to build a Java app that unifies Jira and Salesforce data into a single customer view using Cursor CLI and the CData CLI.
-
Load GitLab Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load GitLab to a database.
-
Work with Oracle HCM Cloud Data in FoxPro
Load Oracle HCM Cloud into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to SingleStore in SpagoBI
Create reports featuring live SingleStore in SpagoBI Studio. Host SingleStore reports on SpagoBI Server.
-
Integrate TigerGraph with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate TigerGraph with External Services.
-
Use the CData Software ODBC Driver for Amazon S3 in MicroStrategy Web
Connect to Amazon S3 in MicroStrategy Web using the CData Software ODBC Driver for Amazon S3.
-
Build Amazon S3 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Amazon S3 and build visualizations in Tableau Cloud.
-
How to Easily Query Workable Data in OpenOffice Base
Connect to Workable data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Import Data from Browserless into Google Sheets
Import Browserless into a Google spreadsheet that is automatically refreshed.
-
ETL Shopify in Oracle Data Integrator
This article shows how to transfer Shopify into a data warehouse using Oracle Data Integrator.
-
How to connect to ZohoSubscriptions Data from Spring Boot
Connect to ZohoSubscriptions in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live Salesforce Data in Excel 365 Online (Excel for the web)
Connect to Salesforce & Force.com from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Dynamics CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Vertica.
-
DataBind Controls to Google Sheets Data in C++Builder
DataBind to Google Sheets in C++Builder with standard components and controls.
-
Automate JSON Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live JSON and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Beeminder Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate with live NetSuite Data in Jitterbit
Use CData Connect AI to connect to and integrate live NetSuite CRM & ERP in Jitterbit.
-
Access Live Freshservice Data in Coginiti Pro
Connect to and query live Freshservice from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Greenhouse Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Greenhouse with the DevExpress Windows Forms and Web controls to provide Greenhouse to a chart.
-
Automated Continuous Coinbase Replication to MongoDB
Use CData Sync for automated, continuous, customizable Coinbase replication to MongoDB.
-
Access Live Sybase Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sybase from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Stripe Data in Excel 365 Online (Excel for the web)
Connect to Stripe from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to load MailerLite data into Elasticsearch via Logstash
Introducing a simple method to load MailerLite data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Xero Data in Talend Cloud Data Management Platform
Connect Xero Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Xero.
-
Create Data Visualizations Based On IBM Informix Data in Mode
Use CData Connect AI to connect to IBM Informix Data from Mode and build visualizations using live
-
Build HBase-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for HBase to explore live HBase Data in Claude Code to assist with building HBase-powered applications.
-
Build Dashboards with Mode Data in DBxtra
Create dynamic dashboards and perform analytics based on Mode in DBxtra.
-
Create SSAS Tabular Models from Azure Table Data
How to build a SQL Server Analysis Service Tabular Model from Azure Table Storage using CData drivers.
-
How to connect to Reply.io Data from Spring Boot
Connect to Reply.io in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating Antigravity CLI with Jodoo via CData CLI
Connect Jodoo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Claude Code CLI with Freshservice 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 LinkedIn Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to LinkedIn Ads as an External Source in Dremio.
-
Getting Started with the CData Power BI Connector for Jumpseller
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize Live Short.io Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Short.io using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to Figshare
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Figshare.
-
Build AI/ML Models with Live MongoDB Data using Dataiku
Connect MongoDB Data with Dataiku using the CData JDBC Driver for MongoDB.
-
How to Access Live Factorial Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Factorial enables you to integrate Factorial into workflows built using Microsoft Power Automate Desktop.
-
Use the CData SSIS Components to Insert New or Update Existing SFTP Records from SQL Server
Easily push SQL Server data to SFTP using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SFTP or update existing records with data from a SQL Server database.
-
How to Build an ETL App for Dynamics CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Dynamics CRM in Python with petl.
-
Build Microsoft Entra ID-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Entra ID Data and create custom apps in Bubble.
-
How to Connect to Live FHIR 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 FHIR for you.
-
Moving Data from SAP Hybris C4C to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Hybris C4C data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to PayPal Data in Aqua Data Studio
Access PayPal from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Humanity Data in the Pentaho Report Designer
Publish reports based on Humanity in the Pentaho BI tool.
-
Connect to SurveyMonkey Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SurveyMonkey and the Script function in FileMaker Pro to connect to SurveyMonkey and work with SurveyMonkey in your FileMaker application.
-
Prepare, Blend, and Analyze Quickbase Data in Alteryx Designer (ODBC)
Build workflows to access live Quickbase for self-service data analytics.
-
Build AI/ML Models with Live FreeAgent Data using Dataiku
Connect FreeAgent Data with Dataiku using the CData API Driver for JDBC.
-
Connect to ZeroBounce from Asprova with CData Software ODBC Driver for ZeroBounce
This article shows how to connect faster to ZeroBounce data from Asprova.
-
Import Real-Time SuiteCRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SuiteCRM in ColdFusion.
-
Automated Continuous Instagram Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Instagram replication to IBM DB2.
-
Create Dynamic Adobe Target Grids Using the Infragistics XamDataGrid
Learn how you can connect Adobe Target to Infragistics XamDataGrid to build dynamic grids.
-
Operational Reporting on Twitter Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Twitter Ads.
-
How to Connect to & Open Microsoft Dataverse Data in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Dataverse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to xBase in SpagoBI
Create reports featuring live xBase in SpagoBI Studio. Host xBase reports on SpagoBI Server.
-
Integrating GitHub Copilot CLI with SFTP 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 Informatica Mappings From/To an ODBC Data Source for Access
Create an ODBC connection to Access in Informatica and browse and transfer Microsoft Access.
-
Automated Continuous Supabase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Supabase replication to OneLake in Microsoft Fabric.
-
Marketo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Marketo facts in real time.
-
Build Dashboards with RabbitMQ Data in Dundas BI
Create dynamic dashboards and perform analytics based on RabbitMQ in Dundas BI.
-
Connect to XML Data in DBArtisan
Use wizards in DBArtisan to configure XML Files as a data source.
-
Automated Continuous Salesforce CRM Analytics Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to SQL Server.
-
Automated Continuous Bugsnag Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bugsnag replication to OneLake in Microsoft Fabric.
-
How to Access Foursquare Data Using Entity Framework
This article shows how to access Foursquare using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Coda Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Coda in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Edit and Search External SQL Server Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft SQL Server to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SQL Server Data objects that you can access from apps and the dashboard.
-
Access Live Clio Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Clio data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Operational Reporting on Oracle Financials Cloud Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Financials Cloud.
-
Connect Coinbase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Coinbase with IBM WebSphere for seamless data integration and connectivity.
-
Access Zoho Recruit Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Recruit from HeidiSQL.
-
Query MySQL Data from Node.js
Use the OData endpoint of the CData API Server to connect to your MySQL and perform CRUD operations on MySQL from Node.js.
-
How to Connect to Live Marketo Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Marketo without replication.