CData Software - Knowledge Base
Recent Articles
-
Connect to Cloudant Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Cloudant data.
-
Automated Continuous Apollo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Apollo replication to PostgreSQL.
-
Query, Visualize, and Share live Tally Data in Redash
Use CData Connect AI to connect to live Tally data in Redash for querying, visualizing, and sharing.
-
Build a PostgreSQL Interface for SAP Concur Data using the CData JDBC Driver
Use the Remoting features of the SAP Concur JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import QuickBooks Time Data into Apache Solr
Use the CData Software JDBC Driver for QuickBooks Time in Data Import Handler and create an automated import of QuickBooks Time data to Apache Solr Enterprise Search platform.
-
Integrating OpenCode with Quaderno 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.
-
Automate Google Campaign Manager 360 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Campaign Manager 360 data replication to Azure Data Lake.
-
How to connect PolyBase to LDAP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LDAP objects.
-
Query Azure Analysis Services Data as a MySQL Database in Node.js
Execute MySQL queries against Azure Analysis Services data from Node.js.
-
Import Azure Data Catalog Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure Data Catalog Data and provide access to live Azure Data Catalog data for custom reports in the Power BI Service.
-
A PostgreSQL Interface for Sage Cloud Accounting Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sage Cloud Accounting JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Onfleet Data from MySQL in Amazon QuickSight
Connect to Onfleet and build visualizations of Onfleet data using a MySQL Connection in Amazon QuickSight.
-
Work with ZohoMarketingHub Data in FoxPro
Load ZohoMarketingHub data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Building Dynamic Web Pages with SAS Data Sets Data Using AngularJS
Create single-page applications with live connectivity to SAS Data Sets using the CData API Server.
-
Import Real-Time ChartMogul Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ChartMogul data in ColdFusion.
-
Integrate Open WebUI with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Authorize.Net data from within the chat interface.
-
How to Connect Flowise AI Agents to Live Wistia Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Wistia data without replication.
-
Connect to Email Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Email data using standard SQL.
-
Automated Continuous Instagram Replication to SQLite
Use CData Sync for automated, continuous, customizable Instagram replication to SQLite.
-
Connect to Shortcut Data in CloverDX (formerly CloverETL)
Transfer Shortcut data using the visual workflow in the CloverDX data integration tool.
-
ETL Google Ad Manager in Oracle Data Integrator
This article shows how to transfer Google Ad Manager data into a data warehouse using Oracle Data Integrator.
-
Build Google Directory-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Directory data.
-
Create Datasets from Aweber in Domo Workbench and Build Visualizations of Aweber Data in Domo
Use the CData Software ODBC Driver for Aweber to create datasets from Aweber data in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Live ClickUp Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your ClickUp data for you.
-
Integrating GitHub Copilot with Omnisend 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.
-
Query, Visualize, and Share live Gong Data in Redash
Use CData Connect AI to connect to live Gong data in Redash for querying, visualizing, and sharing.
-
Access Live CloudConvert Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CloudConvert data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Tableau Connector for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SharePoint Excel Services.
-
Integrating Vercel Data in Talend Cloud Data Management Platform
Connect Vercel Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live Cosmos DB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Cosmos DB data.
-
How to create WooCommerce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for WooCommerce data in MySQL .
-
Connect to Real-Time Tanda Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Tanda data in Power Apps.
-
Process & Analyze Paylocity Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Paylocity Data.
-
Create Facebook-Connected Applications in Appsmith
Connect to Facebook Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Facebook data.
-
Access Live Microsoft Entra ID Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Entra ID data into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Entra ID data in the Graph Builder and Query Builder.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Reply.io
Provide connectivity to Reply.io data through an SAP BusinessObjects universe.
-
Using the CData Software ODBC Driver for Trello in PyCharm
Connect to Trello as an ODBC data source in PyCharm using the CData Software ODBC Driver for Trello.
-
Access Live Missive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Missive data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Manus AI to Talk to Your LinkedIn 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 LinkedIn data.
-
How to connect PolyBase to Elasticsearch
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Elasticsearch data.
-
ETL IBM Informix in Oracle Data Integrator
This article shows how to transfer IBM Informix data into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for HubSpot in MicroStrategy Web
Connect to HubSpot data in MicroStrategy Web using the CData Software JDBC Driver for HubSpot.
-
Build Dashboards with Smartsheet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Smartsheet data in Dundas BI.
-
Load Zoho Inventory Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Inventory data to a database.
-
Create Informatica Mappings From/To a JDBC Data Source for Adobe Commerce
Create Adobe Commerce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Apps with Live SparkPost Data Using the Low-Code Development Platform of Mendix
Connect SparkPost data with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live DB2 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live DB2 data from your Excel spreadsheets.
-
Integrate Live SendPulse Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SendPulse data from within the IDE.
-
DataBind Zoho Recruit Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Zoho Recruit data to a chart.
-
Query Live Kintone Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Kintone data directly from the development environment.
-
Use the CData Software ODBC Driver for Google Contacts in MicroStrategy
Connect to Google Contacts data in MicroStrategy Developer using the CData Software ODBC Driver for Google Contacts.
-
Connect to Square Data in CloverDX (formerly CloverETL)
Transfer Square data using the visual workflow in the CloverDX data integration tool.
-
Visualize ConvertAPI Data in Tableau
The CData ODBC driver for ConvertAPI enables you integrate ConvertAPI data into Tableau dashboards.
-
Query Onfleet Data in DataGrip
Create a Data Source for Onfleet in DataGrip and use SQL to query live Onfleet data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Drive
Provide connectivity to Google Drive data through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy
Connect to Microsoft Teams data in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Teams.
-
Natively Connect to Exact Online Data in PHP
The CData ODBC driver for Exact Online enables you to create PHP applications with connectivity to Exact Online data. Leverage the native support for ODBC in PHP.
-
Connect to Missive Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Missive.
-
Query Webex Data as a MySQL Database in Node.js
Execute MySQL queries against Webex data from Node.js.
-
Import Real-Time Oracle HCM Cloud Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle HCM Cloud data in ColdFusion.
-
How to Connect DBeaver to Zoho Books via a JDBC Driver
Manage Zoho Books data with visual tools in DBeaver like the query browser.
-
Automated Continuous AlloyDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable AlloyDB data replication to OneLake in Microsoft Fabric.
-
Connect to Pipedrive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pipedrive and the SQL Gateway to access Pipedrive data from Google Apps Script.
-
How to work with EnterpriseDB Data in Apache Spark using SQL
Access and process EnterpriseDB Data in Apache Spark using the CData Software JDBC Driver.
-
DataBind Chargebee Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Chargebee data to a chart.
-
Automated Continuous Aha! Replication to Vertica
Use CData Sync for automated, continuous, customizable Aha! replication to Vertica.
-
Create Monday.com-Connected Nintex Workflows
Use CData Connect AI to connect to Monday.com Data from Nintex Workflow Cloud and build custom workflows using live Monday.com data.
-
Publish SAP Business One-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Business One data.
-
Deploy the ADO.NET Provider for Greenhouse on an SSRS Report Server
Connect to Greenhouse data 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.
-
Integrate Azure DevOps Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure DevOps data from Informatica Cloud.
-
Twilio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Twilio facts in real time.
-
Integrating RabbitMQ Data in Talend Cloud Data Management Platform
Connect RabbitMQ Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query Salesforce Marketing Data as a SQL Server Database in Node.js
Execute SQL Server queries against Salesforce Marketing data from Node.js.
-
Build Dashboards with Lakebase Data in DBxtra
Create dynamic dashboards and perform analytics based on Lakebase data in DBxtra.
-
Query CampaignMonitor Data in ColdFusion
Write standard ColdFusion data access code to connect to CampaignMonitor data.
-
Build Pipelines with Live ConstantContact Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ConstantContact from Google Cloud Data Fusion, enabling the integration of live ConstantContact data into the building and management of effective data pipelines.
-
How to connect to PDFMonkey Data in DBVisualizer
Integrate PDFMonkey data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to import Calendly Data into Apache Solr
Use the CData Software JDBC Driver for Calendly in Data Import Handler and create an automated import of Calendly data to Apache Solr Enterprise Search platform.
-
Automated Brex Data Replication to Teradata
Use CData Sync to Customize and automate Brex data replication to Teradata.
-
Use the CData Software JDBC Driver for Cvent in MicroStrategy Web
Connect to Cvent data in MicroStrategy Web using the CData Software JDBC Driver for Cvent.
-
Build a Dynamic React App with Live Data Using CData API Server
Learn how to build a dynamic React app powered by live data using CData API Server’s REST and OData endpoints.
-
DataBind HubSpot Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HubSpot with the DevExpress Windows Forms and Web controls to provide HubSpot data to a chart.
-
Automated Continuous SAP Netweaver Gateway Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to MySQL.
-
DataBind Controls to ShipEngine Data in C++Builder
DataBind to ShipEngine data in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for CapsuleCRM in MicroStrategy
Connect to CapsuleCRM data in MicroStrategy Developer using the CData Software ODBC Driver for CapsuleCRM.
-
Connect to SAS Data Sets Data from a Connection Pool in JBoss
Integrate SAS Data Sets data into Java servlets: Use the Management Console in JBoss to install the SAS Data Sets JDBC Driver.
-
Visualize Datadog Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Datadog data.
-
Analyze Billsby Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Billsby data in Microsoft R Open.
-
Automated Continuous ZohoDesk Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Apache Cassandra.
-
Build Google Cloud Storage Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Cloud Storage data and build visualizations in Tableau Cloud.
-
Replicate Avaza Data from PowerShell
Write a quick PowerShell script to query Avaza data. Use connectivity to the live data to replicate Avaza data to SQL Server.
-
Connecting Pipedream with Office 365 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 Office 365 data in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for Elorus
Create Elorus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate with Avalara AvaTax Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Avalara AvaTax data in SnapLogic.
-
Create a Data Access Object for Pipeliner CRM Data using JDBI
A brief overview of creating a SQL Object API for Pipeliner CRM data in JDBI.
-
Automated Continuous SAP Ariba Source Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Google Cloud SQL.
-
Build Automated Workflows with Live AfterShip Data in Workato
Use CData Connect AI to connect to live AfterShip data and build automated workflows in Workato.
-
Add Microsoft Planner Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Planner with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData ODBC Driver for FreeAgent in Microsoft Power Query
You can use the CData FreeAgent ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FreeAgent data into Microsoft Power Query.
-
Getting Started with the CData SSIS Components for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Adobe Analytics.