CData Software - Knowledge Base
Recent Articles
-
Access Live ClickTime Data in AWS Lambda
Connect to live ClickTime in AWS Lambda using the CData JDBC Driver.
-
Create Reports with Klipfolio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Klipfolio.
-
Connect to JSON Services in Aqua Data Studio
Access JSON from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to work with REST Data in Apache Spark using SQL
Access and process REST Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live Sybase IQ 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 Sybase IQ for you.
-
Connecting Pipedream with Airtable 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 Airtable data in real time.
-
Connect to Smartsheet Data from Crystal Reports
Use CData Connect AI to connect to and report on live Smartsheet from Crystal Reports.
-
LINQ to Greenplum Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Greenplum Data Provider.
-
Build Visualizations of Grafana Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Grafana in Birst.
-
Connect Spotify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Spotify using the CData Python MCP Server.
-
Build a Simple VCL Application for Elasticsearch Data
How to build a simple VCL Application to view Elasticsearch in RAD Studio using the CData ODBC Driver for Elasticsearch.
-
Connect to Reply.io Data from a Connection Pool in Jetty
The Reply.io JDBC Driver supports connection pooling: This article shows how to connect faster to Reply.io from Web apps in Jetty.
-
Build Charts with FreeAgent Data in Clear Analytics
Create dynamic charts and perform analytics based on FreeAgent in Clear Analytics.
-
Build AI/ML Models with Live NetSuite Data using Dataiku
Connect NetSuite Data with Dataiku using the CData JDBC Driver for NetSuite.
-
How to Build an ETL App for CockroachDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live CockroachDB in Python with petl and the CData Connect AI Python SDK.
-
Connect Kafka to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Kafka with IBM WebSphere for seamless data integration and connectivity.
-
How to Work with MailerSend Data in AWS Glue Jobs Using JDBC
Connect to MailerSend from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Missive Data in Sisense
Create an ElastiCube in Sisense app with access to Missive.
-
Excel Spreadsheet Automation on Landbot Data with the QUERY Formula
Pull data from Landbot, automate spreadsheets, and more with the QUERY formula.
-
Access Live Confluence Data in AWS Lambda
Connect to live Atlassian Confluence in AWS Lambda using the CData JDBC Driver.
-
Connect to Scrapfly Data in CloverDX (formerly CloverETL)
Transfer Scrapfly using the visual workflow in the CloverDX data integration tool.
-
Integrating OpenCode Terminal with ZendeskSell 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.
-
Integrate with Bullhorn CRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Bullhorn CRM in SnapLogic.
-
Work with Copper Data in FoxPro
Load Copper into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to & Open Hugging Face Data in Microsoft Excel
This article uses the CData ODBC driver for Hugging Face to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live Reckon Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Reckon.
-
Getting Started with the CData Python Connector for LDAP
Learn to install and license the CData Python Connector
-
How to Connect to Live Vault CRM 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 Veeva Vault & Vault CRM without replication.
-
How to Seamlessly Import Tanda Data into IBM SPSS Modeler
Integrate Tanda data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create LaunchDarkly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LaunchDarkly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Voice Agents in ElevenLabs with access to Live SAP Netweaver Gateway Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Netweaver Gateway.
-
Create Box-Connected Applications in Appsmith
Connect to Box Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Box.
-
Bridge Eventbrite Connectivity with Apache NiFi
Access and process Eventbrite in Apache NiFi using the CData JDBC Driver.
-
How to Query Live Wave Financial Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Wave Financial data in natural language using Python.
-
Integrate with Google Sheets Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Sheets in SnapLogic.
-
Automated Continuous Campaigner Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Campaigner replication to OneLake in Microsoft Fabric.
-
Connect to Contentful Data from a Connection Pool in Jetty
The Contentful JDBC Driver supports connection pooling: This article shows how to connect faster to Contentful from Web apps in Jetty.
-
Validate Procore Data with QuerySurge
Access and validate Procore in QuerySurge using the CData JDBC Driver.
-
Build Agents in Relevance AI with Access to Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Redis within intelligent agent workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mode
Provide connectivity to Mode through an SAP BusinessObjects universe.
-
Integrate with LaunchDarkly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LaunchDarkly to a JSON file on disk.
-
Replicate Intercom Data to Multiple Databases
Replicate Intercom to disparate databases with a point-and-click configuration.
-
Connect to YouTube Analytics Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for YouTube Analytics in the Denodo Virtual DataPort Administrator.
-
Query Odoo Data as a MySQL Database in Node.js
Execute MySQL queries against Odoo ERP from Node.js.
-
How to Easily Query Perigon Data in OpenOffice Base
Connect to Perigon data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect to Bright Data Data with Squirrel SQL client
Connect to Bright Data and execute queries in the Squirrel SQL Client.
-
Build AI/ML Models with Live Ontraport Data using Dataiku
Connect Ontraport Data with Dataiku using the CData API Driver for JDBC.
-
Integrate with Live QuickBooks Online Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to QuickBooks Online from the MuleSoft Anypoint Platform to integrate live QuickBooks Online into custom reports and dashboards.
-
Analyze Oracle Sales Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle Sales and visualize Oracle Sales in SAP Analytics Cloud.
-
Bridge Greenplum Connectivity with Apache NiFi
Access and process Pivotal GreenPlum in Apache NiFi using the CData JDBC Driver.
-
Bind Live Suadeo Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Suadeo data
-
Build Semantic Layer Views for Helpscout Data in APOS Live Data Gateway
Use the CData Connector for Helpscout in APOS Live Data Gateway to build Semantic Layer Views for Helpscout.
-
Write a Simple Go Application to work with Instantly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Instantly.
-
Replicate Bullhorn CRM Data in Heroku for Use in Salesforce Connect
Replicate Bullhorn CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Mailgun Data as a MySQL Database in Node.js
Execute MySQL queries against Mailgun from Node.js.
-
Integrating GitHub Copilot CLI with Yelp 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.
-
DataBind Tavily Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Tavily to a chart.
-
Integrating Zuora Data in Talend Cloud Data Management Platform
Connect Zuora Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zuora.
-
Integrating Claude Code with Zoho Books Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zoho Books within assisted coding and automated development workflows.
-
Connect to Real-Time Cassandra Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Cassandra and Dataflow to import and use Apache Cassandra in Power Apps.
-
Connect to Placid from Asprova with CData Software ODBC Driver for Placid
This article shows how to connect faster to Placid data from Asprova.
-
Manage Onfleet Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Onfleet.
-
Import Real-Time Dynamics 365 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Dynamics 365 in ColdFusion.
-
Configure the CData JDBC Driver for Azure Data Lake Storage in a Connection Pool in Tomcat
Connect to Azure Data Lake Storage from a connection pool in Tomcat.
-
Connect to Salesforce Pardot Data from a Connection Pool in JBoss
Integrate Salesforce Pardot into Java servlets: Use the Management Console in JBoss to install the Salesforce Pardot JDBC Driver.
-
How to load Gorgias data into Elasticsearch via Logstash
Introducing a simple method to load Gorgias data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Operational Reporting on Oracle HCM Cloud Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle HCM Cloud.
-
Create Reports from MarkLogic Data in Looker Studio
Use CData Connect AI to gain access to live MarkLogic and create custom reports in Looker Studio.
-
Getting Started with the CData JDBC Driver for Optimizely
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Optimizely.
-
Visualize LionDesk Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to LionDesk.
-
Visualize Live Notion Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Notion.
-
Publish ZohoDesk-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoDesk.
-
Configure the CData JDBC Driver for Intercom in a Connection Pool in Tomcat
Connect to Intercom from a connection pool in Tomcat.
-
Build Dashboards with Campaigner Data in Dundas BI
Create dynamic dashboards and perform analytics based on Campaigner in Dundas BI.
-
Connect RabbitMQ Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your RabbitMQ using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze Procore Data in Cognos Analytics
Use CData Connect AI to connect to Procore Data from Cognos Analytics and analyze live Procore.
-
Automated Continuous CampaignMonitor Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Google Cloud SQL.
-
Query Zoom Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoom from Node.js.
-
Create a Data Access Object for Confluence Data using JDBI
A brief overview of creating a SQL Object API for Atlassian Confluence in JDBI.
-
Build Semantic Layer Views for Google Translate Data in APOS Live Data Gateway
Use the CData Connector for Google Translate in APOS Live Data Gateway to build Semantic Layer Views for Google Translate.
-
Working with Rootly Data in LINQPad
Execute LINQ queries to Rootly in LINQPad.
-
How to Work with Pipedrive Data in AWS Glue Jobs Using JDBC
Connect to Pipedrive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect Testmonitor to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Testmonitor with IBM WebSphere for seamless data integration and connectivity.
-
Add Aweber Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Aweber with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Claude Code CLI with Confluence 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.
-
Getting Started with the CData Python Connector for HubSpot
Learn to install and license the CData Python Connector
-
Replicate Auth0 Data from PowerShell
Write a quick PowerShell script to query Auth0. Use connectivity to the live data to replicate Auth0 to SQL Server.
-
Oracle Financials Cloud Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Financials Cloud through CData Connect AI using different applications and tools.
-
Use Databricks Agent Bricks to Talk to Your Impala Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Apache Impala for you.
-
Import and Visualize Google Calendar Data in Power View
Create data visualizations based on Google Calendar in Excel.
-
Build Data Flows from Reply.io to SQL Server using SSIS
Easily back up Reply.io to SQL Server using the SSIS components for Reply.io.
-
Integrating Claude Code CLI with Microsoft Entra ID 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.
-
Automated Continuous Perplexity Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Perplexity replication to Google Cloud SQL.
-
Query SAP SuccessFactors LMS Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP SuccessFactors LMS from Node.js.
-
Build Dashboards with EmailOctopus Data in DBxtra
Create dynamic dashboards and perform analytics based on EmailOctopus in DBxtra.
-
Automated Continuous PabblySubscriptions Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Amazon Redshift.
-
Create Reports from Dynamics CRM Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Dynamics CRM and create custom reports in Looker Studio.
-
Use the CData SSIS Components to Insert New or Update Existing Twilio Records from SQL Server
Easily push SQL Server data to Twilio using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Twilio or update existing records with data from a SQL Server database.
-
Automated Continuous Greenplum Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Greenplum replication to delimited files (CSV/TSV).
-
Access Live Greenplum Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Greenplum data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.