CData Software - Knowledge Base
Recent Articles
-
Integrate MongoDB Data in Pentaho Data Integration
Build ETL pipelines based on MongoDB data in the Pentaho Data Integration tool.
-
Automated Continuous HubDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HubDB replication to PostgreSQL.
-
Explore Geographical Relationships in Exa Data with Power Map
Create data visualizations with Exa data in Power Map.
-
How to Access Live Cloudflare Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cloudflare enables you to integrate Cloudflare data into workflows built using Microsoft Power Automate Desktop.
-
Access Outlook Data from MySQL in PHP
Connect to Outlook through the standard MySQL libraries in PHP.
-
Easily Integrate Pipeline CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Pipeline CRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Dashboards with Zoho Inventory Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Inventory data in Dundas BI.
-
Integrate Goose with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle HCM Cloud data from within the local AI agent.
-
Automate Webex Data Replication to Azure Data Lake
Use CData Sync to customize and automate Webex data replication to Azure Data Lake.
-
Analyze Kafka Data in Looker
Use CData Connect AI to connect to Kafka Data from Looker and build custom apps using live Kafka data.
-
Access Live PostgreSQL Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to PostgreSQL data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Antigravity CLI with QuickBooks Time data via CData CLI
Connect QuickBooks Time data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Migrating data from MongoDB to Google BigQuery using CData SSIS Components.
Easily push MongoDB data to Google BigQuery using the CData SSIS Tasks for MongoDB and Google BigQuery.
-
Natively Connect to Discord Data in PHP
The CData ODBC driver for Discord enables you to create PHP applications with connectivity to Discord data. Leverage the native support for ODBC in PHP.
-
Integrate Active Directory Data in the Pentaho Report Designer
Publish reports based on Active Directory data in the Pentaho BI tool.
-
Use the CData ODBC Driver for EmailOctopus from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for EmailOctopus to connect to EmailOctopus data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring EmailOctopus data in Excel.
-
Integrating GitHub Copilot with Cassandra 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 Microsoft Teams Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Teams data using standard SQL.
-
Migrating data from Pushbullet to Google BigQuery using CData SSIS Components.
Easily push Pushbullet data to Google BigQuery using the CData SSIS Tasks for Pushbullet and Google BigQuery.
-
Connect to Oracle Service Cloud Data in Aqua Data Studio
Access Oracle Service Cloud data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Analytics
Provide connectivity to Google Analytics data through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for Oracle Eloqua Reporting Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Eloqua Reporting ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous CouchDB Replication to Vertica
Use CData Sync for automated, continuous, customizable CouchDB replication to Vertica.
-
Build BenchmarkEmail-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live BenchmarkEmail data.
-
Connect to Copper in SpagoBI
Create reports featuring live Copper data in SpagoBI Studio. Host Copper reports on SpagoBI Server.
-
Viewing LightSpeedRetail Data in RAD Studio Data Explorer
How to view LightSpeedRetail data in RAD Studio Data Explorer using the CData ODBC Driver for LightSpeedRetail.
-
How to create SurveyMonkey federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SurveyMonkey data in MySQL .
-
Excel Spreadsheet Automation on SAP ByDesign Data with the QUERY Formula
Pull data from SAP ByDesign, automate spreadsheets, and more with the QUERY formula.
-
Access Xero Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Xero data from your Oracle system.
-
Connect Nuclia to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Nuclia with IBM WebSphere for seamless data integration and connectivity.
-
Connect to iContact Data in DBArtisan
Use wizards in DBArtisan to configure iContact data as a data source.
-
Use the CData ODBC Driver for Google Search in Microsoft Power Query
You can use the CData Google Search ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Search results into Microsoft Power Query.
-
Build Agents in Relevance AI with Access to Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Quickbase data within intelligent agent workflows.
-
DataBind Controls to Brex Data in C++Builder
DataBind to Brex data in C++Builder with standard components and controls.
-
Building Dynamic Web Pages with LDAP Objects Using AngularJS
Create single-page applications with live connectivity to LDAP using the CData API Server.
-
Automated Continuous Dynamics CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Google Cloud SQL.
-
Connect to LinkedIn Data in CloverDX (formerly CloverETL)
Transfer LinkedIn data using the visual workflow in the CloverDX data integration tool.
-
Build Freshteam-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Freshteam data and build Freshteam-connected web apps with Axios.
-
Build Okta-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Okta data.
-
Create Data Visualizations in Cognos BI with SAP HANA Data
Access SAP HANA data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Real-Time Chargebee Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Chargebee data in Power Apps.
-
Migrating data from Oracle Service Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle Service Cloud data to Google BigQuery using the CData SSIS Tasks for Oracle Service Cloud and Google BigQuery.
-
Build Pipelines with Live TaxJar Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to TaxJar from Google Cloud Data Fusion, enabling the integration of live TaxJar data into the building and management of effective data pipelines.
-
How to publish and share Testmonitor Data dashboards with Tableau Server
The CData ODBC driver for Testmonitor enables you integrate Testmonitor data into Tableau dashboards.
-
Integrating GitHub Copilot with SAP Hybris C4C 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.
-
Build Agents in Relevance AI with Access to Live ZohoSubscriptions Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ZohoSubscriptions data within intelligent agent workflows.
-
Stream Microsoft Dataverse Data into Apache Kafka Topics
Access and stream Microsoft Dataverse data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build AI/ML Models with Live Impala Data using Dataiku
Connect Impala Data with Dataiku using the CData JDBC Driver for Impala.
-
Integrate Adobe Experience Manager Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Adobe Experience Manager data and integrate live Adobe Experience Manager data into your Power Automate tasks.
-
Getting Started with the CData Connect AI Python SDK for Airtable
Install the CData Connect AI Python SDK to read and write live Airtable data with standard DB-API 2.0 Python code.
-
Replicate Tanda Data to Multiple Databases
Replicate Tanda data to disparate databases with a point-and-click configuration.
-
Connect to Teamwork Data in Ruby
Connect to Teamwork data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Import Real-Time Avaza Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Avaza data in ColdFusion.
-
Build GitLab-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to GitLab data and build web apps with connectivity to live GitLab data.
-
Connect to Google Campaign Manager 360 Data from a Connection Pool in JBoss
Integrate Google Campaign Manager 360 data into Java servlets: Use the Management Console in JBoss to install the Google Campaign Manager 360 JDBC Driver.
-
Establish a Live Connection with Adobe Target Data using Tableau Bridge
The CData ODBC Driver for Adobe Target enables you to integrate live Adobe Target data into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Campaigner Data in ColdFusion
Write standard ColdFusion data access code to connect to Campaigner data.
-
How to connect to MarkLogic Data with Squirrel SQL client
Connect to MarkLogic data and execute queries in the Squirrel SQL Client.
-
How to Access Dynamics CRM Data Using Entity Framework
This article shows how to access Dynamics CRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Work with Planio Data in ETL Validator JDBC
Connect to Planio from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Apps with Live Avro data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Avro data into the Adalo platform and build custom mobile and web applications with real-time Avro data.
-
Enable the Avalara AvaTax JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Avalara AvaTax data.
-
Query Retently Data in ColdFusion
Write standard ColdFusion data access code to connect to Retently data.
-
Connecting GenSpark with Coda Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Coda data without any replication or custom integration required.
-
Connect to Facebook Data from a Connection Pool in JBoss
Integrate Facebook data into Java servlets: Use the Management Console in JBoss to install the Facebook JDBC Driver.
-
Connect to Rootly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Rootly and work with Rootly data in your FileMaker applications.
-
Connect to and Visualize Live Demio Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Demio data.
-
Connect FreeAgent to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FreeAgent data using the CData Python MCP Server.
-
ETL Rootly in Oracle Data Integrator
This article shows how to transfer Rootly data into a data warehouse using Oracle Data Integrator.
-
Integrate Keap with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Keap with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Keap data.
-
Access Live Instagram Data in Excel 365 Online (Excel for the web)
Connect to Instagram data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Jumpseller Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Jumpseller Data and connect to Jumpseller data in Akorbi Digital RunMyProcess.
-
Getting Started with the CData Power BI Connector for Snowflake
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Snowflake.
-
Connect to Vimeo Data from PowerBuilder via JDBC
This article demonstrates how to access Vimeo data from PowerBuilder using the Vimeo JDBC Driver.
-
Connect to Egnyte Data from HeidiSQL
Use CData Connect AI to connect to and query live Egnyte data from HeidiSQL.
-
Excel Spreadsheet Automation on Exa Data with the QUERY Formula
Pull data from Exa, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Helpscout Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Helpscout replication to Azure SQL Database.
-
Import FHIR Data Using Azure Data Factory
Use CData Connect AI to connect to FHIR Data from Azure Data Factory and import live FHIR data.
-
Integrate Trae with Live Suadeo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Suadeo data from within the AI-powered IDE.
-
Integrating Antigravity CLI with Cassandra data via CData CLI
Connect Cassandra data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with live DocuSign Data in Jitterbit
Use CData Connect AI to connect to and integrate live DocuSign data in Jitterbit.
-
Visualize Pinterest Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pinterest data.
-
Connect to Oracle SCM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle SCM in FileMaker Pro to connect to Oracle SCM and work with Oracle SCM data in your FileMaker applications.
-
Automated Bitbucket Data Replication to Teradata
Use CData Sync to Customize and automate Bitbucket data replication to Teradata.
-
How to Query Salesforce Pardot Data in MySQL Workbench
Execute MySQL queries against live Salesforce Pardot data from MySQL Workbench.
-
Connect to Deel Data in CloverDX (formerly CloverETL)
Transfer Deel data using the visual workflow in the CloverDX data integration tool.
-
Connect to and Visualize Live Zuora Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zuora data.
-
Visualize Salesloft Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesloft data.
-
Access Live Greenhouse Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Greenhouse data from your Excel spreadsheets.
-
DataBind Charts to ConstantContact Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ConstantContact data 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.
-
Create Apps from Reckon Accounts Hosted Data in Qlik Sense Cloud
Use CData Connect AI to connect to Reckon Accounts Hosted Data and build apps from live Reckon Accounts Hosted data in Qlik Sense Cloud.
-
How to import Everhour Data into Apache Solr
Use the CData Software JDBC Driver for Everhour in Data Import Handler and create an automated import of Everhour data to Apache Solr Enterprise Search platform.
-
Access Mouseflow Data from MySQL in PHP
Connect to Mouseflow through the standard MySQL libraries in PHP.
-
Query Tavily Data as a SQL Server Database in Node.js
Execute SQL Server queries against Tavily data from Node.js.
-
Visualize Live SparkPost Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SparkPost data.
-
Connect to LinkedIn Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with LinkedIn Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to create Sendwithus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sendwithus data in MySQL .
-
Establish a Live Connection with Google Analytics Data using Tableau Bridge
The CData ODBC Driver for Google Analytics enables you to integrate live Google Analytics data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Goose with Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live LinkedIn Ads data from within the local AI agent.
-
Connect to Copper from Asprova with CData Software ODBC Driver for Copper
This article shows how to connect faster to Copper data from Asprova.