CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Jira Assets in MicroStrategy Web
Connect to Jira Assets in MicroStrategy Web using the CData Software ODBC Driver for Jira Assets.
-
Use Azure AI Foundry to Talk to Your Act-On 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 Act-On for you.
-
How to connect PolyBase to Presto
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Presto.
-
Integrating Codex CLI with PagerDuty 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 Vercel
Create an ODBC connection to Vercel in Informatica and browse and transfer Vercel.
-
Connect to FHIR Data in Aqua Data Studio
Access FHIR from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Query ServiceDesk Plus Data in MySQL Workbench
Execute MySQL queries against live ServiceDesk Plus from MySQL Workbench.
-
Build a Singer.io Tap for Quickbase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Quickbase data using
-
How to connect SharePoint with Microsoft Dataverse Data through external lists
Provide Microsoft Dataverse (CDS) to SharePoint users as an external list.
-
How to Build an ETL App for Ontraport Data in Python with CData
Create ETL applications and real-time data pipelines for Ontraport in Python with petl.
-
Viewing Pipedrive Data in RAD Studio Data Explorer
How to view Pipedrive in RAD Studio Data Explorer using the CData ODBC Driver for Pipedrive.
-
Integrate with ZeroBounce Data in JReport Designer
Create charts and reports based on ZeroBounce in JReport Designer.
-
Build an OLAP Cube in SSAS from Sage Intacct Data
Establish a connection to Sage Intacct data from SQL Server Analysis Services, and use the Sage Intacct Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live ADP Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live ADP through MCP integration.
-
Integrating Codex CLI with Accelo 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 Aircall Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Aircall as an External Source in Dremio.
-
Automated Continuous ChargeOver Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ChargeOver replication to Amazon S3.
-
Automate Sage Cloud Accounting Data Replication to Couchbase
Use CData Sync to Customize and automate Sage Business Cloud Accounting replication to Couchbase.
-
Connect to Splunk Data from a Connection Pool in JBoss
Integrate Splunk into Java servlets: Use the Management Console in JBoss to install the Splunk JDBC Driver.
-
Query Tally Data in DataGrip
Create a Data Source for Tally in DataGrip and use SQL to query live Tally ERP.
-
Extend Google Sheets with Redis Data
Make calls to Redis from Google Apps Script via the API Server.
-
Operational Reporting on Zuora Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zuora.
-
Connect to Anaplan Data in Ruby
Connect to Anaplan in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query BigQuery Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google BigQuery and perform CRUD operations on BigQuery from Node.js.
-
Back Up Unbounce to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Unbounce data.
-
Access HBase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache HBase from your Oracle system.
-
Rapidly Develop Microsoft Teams-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 Microsoft Teams.
-
Add Avalara AvaTax Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Avalara AvaTax with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData ODBC Driver for SendGrid
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SendGrid.
-
Visualize Hubstaff Data in Tableau
The CData ODBC driver for Hubstaff enables you integrate Hubstaff into Tableau dashboards.
-
Connect to Close Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Close using standard SQL.
-
Use the CData Software JDBC Driver for DB2 in MicroStrategy Desktop
Connect to IBM DB2 in MicroStrategy Desktop using the CData Software JDBC Driver for DB2.
-
Build Dashboards with ZohoMarketingHub Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZohoMarketingHub in Dundas BI.
-
Publish Couchbase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Couchbase.
-
Build Zoho Projects Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Projects and build visualizations in Tableau.
-
Use JayDeBeApi to access ZeroBounce Data in Python
Use standard Python scripting and the development environment of your choice to access live ZeroBounce.
-
Configure the CData JDBC Driver for Google Cloud Storage in a Connection Pool in Tomcat
Connect to Google Cloud Storage from a connection pool in Tomcat.
-
How to Build an ETL App for BigQuery Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google BigQuery in Python with petl and the CData Connect AI Python SDK.
-
Configure the CData JDBC Driver for Omnisend in a Connection Pool in Tomcat
Connect to Omnisend from a connection pool in Tomcat.
-
Build a Singer.io Tap for Raisers Edge NXT With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Raisers Edge NXT data using
-
Connect to MailerSend from a Connection Pool in WebLogic
Use the CData JDBC Driver for MailerSend to connect to MailerSend from Web applications running on WebLogic.
-
Use Biml to Build SSIS Tasks to Replicate Datadog Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Datadog to SQL Server.
-
How to import MailerSend Data into Apache Solr
Use the CData Software JDBC Driver for MailerSend in Data Import Handler and create an automated import of MailerSend to Apache Solr Enterprise Search platform.
-
Connect CampaignMonitor to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CampaignMonitor using the CData Python MCP Server.
-
Integrate with CSV Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CSV/TSV Files to a JSON file on disk.
-
Use JayDeBeApi to access VWO Data in Python
Use standard Python scripting and the development environment of your choice to access live VWO.
-
Build Automated Workflows with Live Facebook Ads Data in Workato
Use CData Connect AI to connect to live Facebook Ads and build automated workflows in Workato.
-
A PostgreSQL Interface for MessageBird Data using the CData ODBC Driver
Use the SQL Gateway and MessageBird ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create a Data Access Object for Snowflake Data using JDBI
A brief overview of creating a SQL Object API for Snowflake in JDBI.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads for you.
-
Design BIRT Reports on Sentry Data
Provide current Sentry to your embedded analytics.
-
Connect to Dynamics 365 Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Dynamics 365 from HeidiSQL.
-
Write a Simple Go Application to work with PingOne Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PingOne.
-
Use Manus AI to Talk to Your Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Gong.
-
How to Seamlessly Import PayPal Data into IBM SPSS Modeler
Integrate PayPal data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Clockify
Provide connectivity to Clockify through an SAP BusinessObjects universe.
-
Enable the Google Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Analytics.
-
Stream Authorize.Net Data into Apache Kafka Topics
Access and stream Authorize.Net in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SFTP
Provide connectivity to SFTP through an SAP BusinessObjects universe.
-
How to connect to Workable Data with Squirrel SQL client
Connect to Workable and execute queries in the Squirrel SQL Client.
-
Excel Spreadsheet Automation on PabblySubscriptions Data with the QUERY Formula
Pull data from PabblySubscriptions, automate spreadsheets, and more with the QUERY formula.
-
Import Real-Time SAP ByDesign Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Business ByDesign in ColdFusion.
-
Use Agno to Talk to Your Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zoom for you.
-
Access Live Apollo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apollo into the statistical analysis tools available in SAS JMP. This article shows how to use Apollo in the Graph Builder and Query Builder.
-
Automated Continuous HDFS Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HDFS replication to IBM DB2.
-
ETL Parallel in Oracle Data Integrator
This article shows how to transfer Parallel into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData ADO.NET Provider for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP SuccessFactors LMS.
-
Build Freshdesk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Freshdesk.
-
Using the CData Software ODBC Driver for Avro in PyCharm
Connect to Avro as an ODBC data source in PyCharm using the CData Software ODBC Driver for Avro.
-
Integrate Webflow Data in Pentaho Data Integration
Build ETL pipelines based on Webflow in the Pentaho Data Integration tool.
-
Integrate JDBC-ODBC Bridge Data in the Pentaho Report Designer
Publish reports based on JDBC-ODBC Bridge in the Pentaho BI tool.
-
Create FTP-Connected Nintex Workflows
Use CData Connect AI to connect to FTP Data from Nintex Workflow Cloud and build custom workflows using live FTP Servers.
-
Use the CData Software ODBC Driver for BigQuery in MicroStrategy Web
Connect to Google BigQuery in MicroStrategy Web using the CData Software ODBC Driver for BigQuery.
-
Replicate Google Search Results to Multiple Databases via the CData Sync CLI
Replicate Google Search to disparate databases with a single configuration.
-
Connect to Google Spanner Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Spanner in the Denodo Virtual DataPort Administrator.
-
Connecting Mastra with BambooHR Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time BambooHR, no replication required.
-
Analyze Power BI XMLA Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Power BI XMLA and visualize live Power BI XMLA in Infragistics Reveal.
-
Getting Started with the CData ADO.NET Provider for Confluence
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Confluence.
-
Replicate Multiple ActiveCampaign Accounts
Replicate multiple ActiveCampaign accounts to one or many databases.
-
How to Create Power BI Visual Reports with Real-Time ShipStation Data
Use CData Power BI Connectors to visualize ShipStation in Power BI.
-
Enable the Chargebee JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Chargebee.
-
Explore Geographical Relationships in Omnisend Data with Power Map
Create data visualizations with Omnisend in Power Map.
-
A PostgreSQL Interface for Mouseflow Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mouseflow JDBC Driver to create a PostgreSQL entry-point for data access.
-
Deploy the ADO.NET Provider for AlloyDB on an SSRS Report Server
Connect to Google AlloyDB from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating SAP Netweaver Gateway Data in Talend Cloud Data Management Platform
Connect SAP Netweaver Gateway Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Netweaver Gateway.
-
Integrating Codex CLI with Instagram 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.
-
Integrating LangGraph with Microsoft Teams Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Teams within automated workflows.
-
Connect to Google Sheets Data in CloverDX (formerly CloverETL)
Transfer Google Sheets using the visual workflow in the CloverDX data integration tool.
-
Query Pinecone Data in ColdFusion
Write standard ColdFusion data access code to connect to Pinecone.
-
Access Drip Data from MySQL in PHP
Connect to Drip through the standard MySQL libraries in PHP.
-
How to Connect Flowise AI Agents to Live OData Services via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live OData without replication.
-
Write a Simple Go Application to work with Asana Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Asana.
-
Integrating Outlook Data in Talend Cloud Data Management Platform
Connect Outlook Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData ODBC Driver for Azure Table in Microsoft Power Query
You can use the CData Azure Table ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Table Storage into Microsoft Power Query.
-
Replicate SAP ByDesign Data to Multiple Databases
Replicate SAP Business ByDesign to disparate databases with a point-and-click configuration.
-
How to publish and share Google Calendar Data dashboards with Tableau Server
The CData ODBC driver for Google Calendar enables you integrate Google Calendar into Tableau dashboards.
-
Access OneNote Data from MySQL in PHP
Connect to OneNote through the standard MySQL libraries in PHP.
-
Visualize Unbounce Data in TIBCO Spotfire through ADO.NET
Integrate Unbounce into dashboards in TIBCO Spotfire.
-
Connect to Cloudflare Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Cloudflare in the Denodo Virtual DataPort Administrator.
-
Access Helpscout Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Helpscout from HeidiSQL.