CData Software - Knowledge Base
Recent Articles
-
How to connect to Beeminder Data from IntelliJ
Integrate connectivity to Beeminder with wizards in IntelliJ.
-
Connect to LinkedIn Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for LinkedIn Ads in Airbyte.
-
Connecting Mastra with Google Contacts 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 Google Contacts, no replication required.
-
Use Claude to Talk to Your MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your MySQL for you.
-
Import and Visualize PhantomBuster Data in Power View
Create data visualizations based on PhantomBuster in Excel.
-
How to connect and process Parallel from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Parallel.
-
Visualize Google Campaign Manager 360 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Campaign Manager 360.
-
How to publish and share Zendesk Data dashboards with Tableau Server
The CData ODBC driver for Zendesk enables you integrate Zendesk into Tableau dashboards.
-
How to connect and process Teradata from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teradata.
-
Integrating Antigravity CLI with ElevenLabs via CData CLI
Connect ElevenLabs to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous MariaDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MariaDB replication to Azure SQL Database.
-
How to Work with ActiveCampaign Data in ETL Validator JDBC
Connect to ActiveCampaign from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Pipeline CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to IBM DB2.
-
Edit and Search External Google Sheets Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Sheets to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Sheets Data objects that you can access from apps and the dashboard.
-
Use the CData ODBC Driver for SAP Business One in Microsoft Power Query
You can use the CData SAP Business One ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Business One into Microsoft Power Query.
-
How to Connect to YouTube Analytics Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to YouTube Analytics. Leverage the pyodbc module for ODBC in Python.
-
Build PDFMonkey-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PDFMonkey and build web apps with connectivity to live PDFMonkey.
-
Getting Started with the CData SSIS Components for Quaderno
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Quaderno.
-
A PostgreSQL Interface for Dropbox Data using the CData ODBC Driver
Use the SQL Gateway and Dropbox ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from Oracle Service Cloud Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle Service Cloud Data and build apps from live Oracle Service Cloud in Qlik Sense Cloud.
-
Replicate Confluence Data in Heroku for Use in Salesforce Connect
Replicate Atlassian Confluence to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to TigerGraph Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for TigerGraph and the Script function in FileMaker Pro to connect to TigerGraph and work with TigerGraph in your FileMaker application.
-
Consume Microsoft Entra ID OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Entra ID feeds that reflect any changes in SAP Lumira.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Adobe Analytics to Power BI dashboards. Simply drag and drop Adobe Analytics into data visuals on the Power BI canvas.
-
Visualize Grafana Data in Sisense
Create an ElastiCube in Sisense app with access to Grafana.
-
Replicate Multiple Avro Accounts
Replicate multiple Avro accounts to one or many databases.
-
Publish Oracle-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Database.
-
Create SAS xpt-Connected Applications in Appsmith
Connect to SAS xpt Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAS XPORT.
-
Enable the Oracle Eloqua Reporting JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Eloqua Reporting.
-
Visualize Couchbase Data in TIBCO Spotfire through OData
Integrate Couchbase into dashboards in TIBCO Spotfire.
-
Integrate MongoDB Data in Pentaho Data Integration
Build ETL pipelines based on MongoDB 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 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 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 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 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 from within the local AI agent.
-
Access Live PostgreSQL Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to PostgreSQL from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Antigravity CLI with QuickBooks Time via CData CLI
Connect QuickBooks Time 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 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. Leverage the native support for ODBC in PHP.
-
Integrate Active Directory Data in the Pentaho Report Designer
Publish reports based on Active Directory 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring EmailOctopus in Excel.
-
Connect to Delighted Data in DBArtisan
Use wizards in DBArtisan to configure Delighted as a data source.
-
Integrating GitHub Copilot CLI with Apache Cassandra 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 using standard SQL.
-
Migrating data from Pushbullet to Google BigQuery using CData SSIS Components.
Easily push Pushbullet 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 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 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.
-
Connect to Copper in SpagoBI
Create reports featuring live Copper in SpagoBI Studio. Host Copper reports on SpagoBI Server.
-
Viewing LightSpeedRetail Data in RAD Studio Data Explorer
How to view LightSpeedRetail 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 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 Accounting 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 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 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 within intelligent agent workflows.
-
DataBind Controls to Brex Data in C++Builder
DataBind to Brex 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 using the visual workflow in the CloverDX data integration tool.
-
How to Import Data from Xero into Google Sheets
Import Xero Accounting into a Google spreadsheet that is automatically refreshed.
-
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.
-
Create Data Visualizations in Cognos BI with SAP HANA Data
Access SAP HANA 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 in Power Apps.
-
Migrating data from Oracle Service Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle Service Cloud to Google BigQuery using the CData SSIS Tasks for Oracle Service Cloud and Google BigQuery.
-
How to publish and share Testmonitor Data dashboards with Tableau Server
The CData ODBC driver for Testmonitor enables you integrate Testmonitor into Tableau dashboards.
-
Integrating GitHub Copilot CLI with SAP Hybris C4C 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.
-
Stream Microsoft Dataverse Data into Apache Kafka Topics
Access and stream Microsoft Dataverse (CDS) 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.
-
Getting Started with the CData Connect AI Python SDK for Airtable
Install the CData Connect AI Python SDK to read and write live Airtable with standard DB-API 2.0 Python code.
-
Replicate Tanda Data to Multiple Databases
Replicate Tanda to disparate databases with a point-and-click configuration.
-
Connect to Teamwork Data in Ruby
Connect to Teamwork 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 in ColdFusion.
-
Build GitLab-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to GitLab and build web apps with connectivity to live GitLab.
-
Connect to Google Campaign Manager 360 Data from a Connection Pool in JBoss
Integrate Google Campaign Manager 360 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 into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Campaigner Data in ColdFusion
Write standard ColdFusion data access code to connect to Campaigner.
-
How to connect to MarkLogic Data with Squirrel SQL client
Connect to MarkLogic and execute queries in the Squirrel SQL Client.
-
How to Access Dynamics CRM Data Using Entity Framework
This article shows how to access Microsoft Dynamics CRM 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 Apache Avro in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Avro into the Adalo platform and build custom mobile and web applications with real-time Apache Avro.
-
Enable the Avalara AvaTax JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Avalara AvaTax.
-
Query Retently Data in ColdFusion
Write standard ColdFusion data access code to connect to Retently.
-
Connect to Facebook Data from a Connection Pool in JBoss
Integrate Facebook 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 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.
-
Connect FreeAgent to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FreeAgent using the CData Python MCP Server.
-
ETL Rootly in Oracle Data Integrator
This article shows how to transfer Rootly 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.
-
Access Live Instagram Data in Excel 365 Online (Excel for the web)
Connect to Instagram from Excel 365 Online (Excel for the web) with CData Connect AI.
-
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 from PowerBuilder using the Vimeo JDBC Driver.
-
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.