CData Software - Knowledge Base
Recent Articles
-
Connect to Salesforce Data from a Connection Pool in JBoss
Integrate Salesforce & Force.com into Java servlets: Use the Management Console in JBoss to install the Salesforce JDBC Driver.
-
Connect and Visualize Live Amazon DynamoDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon DynamoDB into the Databricks platform and create visualization dashboards with real-time Amazon DynamoDB.
-
How to connect to LaunchDarkly Data from Spring Boot
Connect to LaunchDarkly in a Spring Boot Application using the CData API Driver for JDBC
-
Creating MarkLogic-Connected Applications in Unqork
You can use CData Connect AI to feed MarkLogic to Unqork and build custom business apps.
-
How to connect PolyBase to Zuora
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zuora.
-
Access iContact Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live iContact from HeidiSQL.
-
Use Microsoft Copilot Studio to talk to your Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Excel Online for you.
-
Visualize Cohere 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 Cohere into TIBCO Spotfire.
-
Analyze Adobe Analytics Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Adobe Analytics in Microsoft R Open.
-
Rapidly Develop Webex-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 Webex.
-
Query Guru Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Guru from Node.js.
-
Automated Continuous Amplitude Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Amplitude replication to PostgreSQL.
-
Connecting Pipedream with NetSuite 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 NetSuite data in real time.
-
How to create Visio diagrams from FTP Data
Automatically update FTP Servers with the changes you make to Visio master shapes.
-
Build a PostgreSQL Interface for Mistral AI Data using the CData JDBC Driver
Use the Remoting features of the Mistral AI JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query QuickBooks Time Data in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks Time.
-
Create SSAS Tabular Models from Outreach.io Data
How to build a SQL Server Analysis Service Tabular Model from Outreach.io using CData drivers.
-
Migrating data from Neo4J to Snowflake using CData SSIS Components.
Easily push Neo4J to Snowflake using the CData SSIS Tasks for Neo4J and Snowflake.
-
Publish Reports with Printful Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Printful.
-
How to load HBase data into Elasticsearch via Logstash
Introducing a simple method to load HBase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Query Zoom Data in MySQL Workbench
Execute MySQL queries against live Zoom from MySQL Workbench.
-
Integrating GitHub Copilot CLI with Zendesk 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 Sentry Data in HULFT Integrate
Connect to Sentry as a JDBC data source in HULFT Integrate
-
Automate Elorus Data Replication to SAP HANA
Use CData Sync to customize and automate Elorus replication to SAP HANA.
-
Connect MySQL to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MySQL using the CData Python MCP Server.
-
Visualize Paddle 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 Paddle into TIBCO Spotfire.
-
Automated Continuous SendInBlue Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SendInBlue replication to AlloyDB.
-
Automated Continuous Google Forms Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Forms replication to delimited files (CSV/TSV).
-
Integrate Pushbullet Data in the Pentaho Report Designer
Publish reports based on Pushbullet in the Pentaho BI tool.
-
Integrating OpenCode Terminal with ZohoSubscriptions 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.
-
Analyze SAP Netweaver Gateway Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Netweaver Gateway and visualize live SAP Netweaver Gateway in Infragistics Reveal.
-
Integrating Claude Code with Microsoft Teams Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Teams within assisted coding and automated development workflows.
-
How to Build an ETL App for Bannerbear Data in Python with CData
Create ETL applications and real-time data pipelines for Bannerbear in Python with petl.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce for you.
-
Visualize Live Microsoft Teams Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Teams.
-
Connect to Printful Data in DBArtisan
Use wizards in DBArtisan to configure Printful as a data source.
-
Publish Reckon Accounts Hosted-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Reckon Accounts Hosted.
-
Automated Continuous LaunchDarkly Replication to Databricks
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Databricks.
-
Build eBay-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for eBay to explore live eBay Data in Cursor to assist with building eBay-powered applications.
-
Design BIRT Reports on Freshdesk Data
Provide current Freshdesk to your embedded analytics.
-
Design BIRT Reports on SAP Business Warehouse Data
Provide current SAP Business Warehouse to your embedded analytics.
-
Build Bullhorn CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Bullhorn CRM and build visualizations in Tableau Cloud.
-
Connect to Deel 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 Deel and work with Deel in your FileMaker application.
-
Connect to Zoho CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho CRM as an External Source in Dremio.
-
Getting Started with the CData Python Connector for Gong
Learn to install and license the CData Python Connector
-
Back Up PingOne to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for PingOne. In this article, we will employ an SSIS workflow to populate a database with PingOne data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Phoenix
Provide connectivity to Apache Phoenix through an SAP BusinessObjects universe.
-
Build Dashboards with Google Drive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Drive in Dundas BI.
-
How to Query LaunchDarkly Data in MySQL Workbench
Execute MySQL queries against live LaunchDarkly from MySQL Workbench.
-
Add ClickUp Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ClickUp with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Greenhouse
Provide connectivity to Greenhouse through an SAP BusinessObjects universe.
-
Access Sage 200 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sage 200 from HeidiSQL.
-
Validate Amazon S3 Data with QuerySurge
Access and validate Amazon S3 in QuerySurge using the CData JDBC Driver.
-
Integrating Boomi Agentstudio with Dynamics CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Dynamics CRM, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Avro from Asprova with CData Software ODBC Driver for Avro
This article shows how to connect faster to Avro data from Asprova.
-
Connect to PivotalTracker Data from a Connection Pool in JBoss
Integrate PivotalTracker into Java servlets: Use the Management Console in JBoss to install the PivotalTracker JDBC Driver.
-
Query FTP Data through ODBC in Node.js
Use node-odbc to execute SQL queries against FTP Servers from Node.js.
-
Automated Continuous iContact Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable iContact replication to Amazon Redshift.
-
Operational Reporting on SingleStore Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SingleStore.
-
Connect to CockroachDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with CockroachDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to update Microsoft Ads from Excel
This article explains how to transfer data from Excel to Microsoft Ads using the Excel Add-In for Microsoft Ads.
-
Analyze VWO Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for VWO from Power Pivot. You will use the Table Import Wizard to load VWO. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Charts to Paymo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Paymo 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.
-
Automated Continuous Sage Intacct Replication to Vertica
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Vertica.
-
Connect to Flowlu Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Flowlu in the Denodo Virtual DataPort Administrator.
-
How to Query Tanda Data in MySQL Workbench
Execute MySQL queries against live Tanda from MySQL Workbench.
-
Integrate Theia IDE with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build a Simple VCL Application for Placid Data
How to build a simple VCL Application to view Placid in RAD Studio using the CData ODBC Driver for Placid.
-
Build Zendesk-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zendesk to explore live Zendesk Data in GitHub Copilot to assist with building Zendesk-powered applications.
-
Visualize Live Confluence Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Atlassian Confluence into custom reports in Power BI.
-
Create a Data Access Object for Oracle Financials Cloud Data using JDBI
A brief overview of creating a SQL Object API for Oracle Financials Cloud in JDBI.
-
Build Dashboards with xBase Data in DBxtra
Create dynamic dashboards and perform analytics based on xBase in DBxtra.
-
Automated Continuous LeadDesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LeadDesk replication to OneLake in Microsoft Fabric.
-
Use the CData ODBC Driver for Webflow in Microsoft Power Query
You can use the CData Webflow ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Webflow into Microsoft Power Query.
-
Visualize Live Azure DevOps Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure DevOps.
-
Automated Continuous Bullhorn CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to SQLite.
-
Create Power BI Reports on Real-Time Square Data
Use the CData ODBC Driver for Square to visualize Square in Power BI Desktop.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Tickspot
Provide connectivity to Tickspot through an SAP BusinessObjects universe.
-
How to Create Power BI Visual Reports with Real-Time Bugsnag Data
Use CData Power BI Connectors to visualize Bugsnag in Power BI.
-
How to Create Power BI Visual Reports with Real-Time OData Services
Use CData Power BI Connectors to visualize OData in Power BI.
-
Integrate with Twitter Ads Data in JReport Designer
Create charts and reports based on Twitter Ads in JReport Designer.
-
Connect to MySQL Data from Crystal Reports
Use CData Connect AI to connect to and report on live MySQL from Crystal Reports.
-
Build Semantic Layer Views for Perplexity Data in APOS Live Data Gateway
Use the CData Connector for Perplexity in APOS Live Data Gateway to build Semantic Layer Views for Perplexity.
-
View Reports on Real-Time Elorus Data in Power BI Report Server
Use the CData ODBC Driver for Elorus to visualize Elorus in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect and process IBM DB2 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live IBM DB2.
-
Migrating data from Chargebee to Snowflake using CData SSIS Components.
Easily push Chargebee to Snowflake using the CData SSIS Tasks for Chargebee and Snowflake.
-
Import Real-Time IBM Informix Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use IBM Informix in ColdFusion.
-
How to Query Live TaxJar Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live TaxJar data in natural language using Python.
-
Building Dynamic Web Pages with Google Directory Data Using AngularJS
Create single-page applications with live connectivity to Google Directory using the CData API Server.
-
Use the CData Software JDBC Driver for Google Tasks in MicroStrategy Desktop
Connect to Google Tasks in MicroStrategy Desktop using the CData Software JDBC Driver for Google Tasks.
-
Integrate Cursor with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Box from within the editor.
-
Connect Gmail to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Gmail using the CData Python MCP Server.
-
Connect to Cosmos DB from Asprova with CData Software ODBC Driver for Cosmos DB
This article shows how to connect faster to Cosmos DB data from Asprova.
-
Access CouchDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache CouchDB from your Oracle system.
-
Build Dashboards with Jira Assets Data in Dundas BI
Create dynamic dashboards and perform analytics based on Jira Assets in Dundas BI.
-
Excel Spreadsheet Automation on Vercel Data with the QUERY Formula
Pull data from Vercel, automate spreadsheets, and more with the QUERY formula.
-
Connect to FormSite Data in CloverDX (formerly CloverETL)
Transfer FormSite using the visual workflow in the CloverDX data integration tool.
-
Integrate HBase Data in Pentaho Data Integration
Build ETL pipelines based on Apache HBase in the Pentaho Data Integration tool.
-
Query, Visualize, and Share live Oracle Eloqua Data in Redash
Use CData Connect AI to connect to live Oracle Eloqua in Redash for querying, visualizing, and sharing.
-
Connect to and Query Reckon Accounts Hosted Data in QlikView over ODBC
Create data visualizations with Reckon Accounts Hosted in QlikView.