CData Software - Knowledge Base
Recent Articles
-
How to connect to Browserless Data in DBVisualizer
Integrate Browserless data with visual data analysis tools and data connection wizards in DBVisualizer
-
Query BigQuery Data in DataGrip
Create a Data Source for BigQuery in DataGrip and use SQL to query live BigQuery data.
-
How to Use a Microsoft Access Database to Update Impala Data in Real Time
Update Impala data by creating a linked table in Microsoft Access with the CData Impala ODBC Driver.
-
Connect to QuickBooks Online Data in NetBeans
Connect to QuickBooks Online data in NetBeans with the data source configuration wizard.
-
Build a Singer.io Tap for Google Directory With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Directory data using the CData Python Connector.
-
Connect to Aircall Data in CloverDX (formerly CloverETL)
Transfer Aircall data using the visual workflow in the CloverDX data integration tool.
-
How to Query Live Google Sheets Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Sheets data data in natural language using Python.
-
Query Dynamics 365 Data as a MySQL Database in Node.js
Execute MySQL queries against Dynamics 365 data from Node.js.
-
Visualize Live ShipStation Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ShipStation data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Claude Code CLI with ConstantContact 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.
-
Deploy the ADO.NET Provider for Microsoft Exchange on an SSRS Report Server
Connect to Microsoft Exchange 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.
-
Connect to Mixpanel Data from PowerBuilder via JDBC
This article demonstrates how to access Mixpanel data from PowerBuilder using the Mixpanel JDBC Driver.
-
View Reports on Real-Time MessageBird Data in Power BI Report Server
Use the CData ODBC Driver for MessageBird to visualize MessageBird data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Vertica Data Replication to Azure Data Lake
Use CData Sync to customize and automate Vertica data replication to Azure Data Lake.
-
Seamlessly Bring Twilio Data into Retool Using CData Connect AI
Integrate Twilio data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Live Azure Data Lake Storage Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Azure Data Lake Storage data for you.
-
Connecting Mastra with Oracle Eloqua 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 Oracle Eloqua data, no replication required.
-
How to create an RPA flow for Square Data in UiPath Studio
Use the Square ODBC Driver to create workflows that access real-time Square data without any coding.
-
Connect to DocuSign Data from HeidiSQL
Use CData Connect AI to connect to and query live DocuSign data from HeidiSQL.
-
Integrating LangChain with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Facebook Ads data within automated workflows.
-
Load CircleCI Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CircleCI data to a database.
-
How to Visualize HubDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live HubDB data in Python.
-
Connect to FreshBooks Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to FreshBooks and work with FreshBooks data in your FileMaker applications.
-
Connect to Superchat Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Superchat.
-
Visualize Oracle Financials Cloud Data in TIBCO Spotfire through OData
Integrate Oracle Financials Cloud data into dashboards in TIBCO Spotfire.
-
Connect to Calendly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Calendly and work with Calendly data in your FileMaker applications.
-
Prepare, Blend, and Analyze Azure Table Data in Alteryx Designer (Connect AI)
Build workflows to access live Azure Table data for self-service data analytics.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Apache Kafka.
-
A Comparison of Drivers for Amazon DynamoDB
An article comparing the read performance, client-side resource usage, and read capacity consumption of different JDBC drivers for Amazon DynamoDB.
-
How to Connect to Live Oracle HCM Cloud 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 Oracle HCM Cloud data for you.
-
Create Datasets from Oracle Eloqua Reporting in Domo Workbench and Build Visualizations of Oracle Eloqua Reporting Data in Domo
Use the CData Software ODBC Driver for Oracle Eloqua Reporting to create datasets from Oracle Eloqua Reporting data in Domo Workbench and then build visualizations in the Domo service.
-
How to Visualize Templated Data in Python with pandas
Use pandas and other modules to analyze and visualize live Templated data in Python.
-
Automated Continuous Tavily Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tavily data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Excel Replication to Oracle
Use CData Sync for automated, continuous, customizable Excel replication to Oracle.
-
Integrate with Live Campaigner Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Campaigner from the MuleSoft Anypoint Platform to integrate live Campaigner data into custom reports and dashboards.
-
Connect SFTP Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SFTP data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Mode Replication to SQLite
Use CData Sync for automated, continuous, customizable Mode replication to SQLite.
-
Integrate Outlook with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Outlook with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Outlook data.
-
Natively Connect to Reply.io Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Reply.io data. Leverage the native support for ODBC in PHP.
-
Integrate Beeminder with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Beeminder with External Services.
-
A PostgreSQL Interface for HDFS Data (MySQL Remoting via JDBC)
Use the Remoting features of the HDFS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Oracle Data in PHP
The CData ODBC driver for Oracle enables you to create PHP applications with connectivity to Oracle data. Leverage the native support for ODBC in PHP.
-
Integrate Goose with Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sugar CRM data from within the local AI agent.
-
Integrating Claude Code with LDAP Objects via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on LDAP objects within assisted coding and automated development workflows.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy Desktop
Connect to JDBC-ODBC Bridge data in MicroStrategy Desktop using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Access Live Superchat Data in AWS Lambda
Connect to live Superchat data in AWS Lambda using the CData JDBC Driver.
-
Connect to Beeminder Data in RapidMiner
Integrate Beeminder data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect and Visualize Live OData Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live OData services into the Databricks platform and create visualization dashboards with real-time OData services.
-
Create SSAS Tabular Models from MariaDB Data
How to build a SQL Server Analysis Service Tabular Model from MariaDB data using CData drivers.
-
Build Data Flows from Trello to SQL Server using SSIS
Easily back up Trello data to SQL Server using the SSIS components for Trello.
-
Design BIRT Reports on AfterShip Data
Provide current AfterShip data to your embedded analytics.
-
Connect to JotForm Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for JotForm data.
-
Integrating Kiro with Suadeo 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 Pipeliner CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to IBM DB2.
-
Automated Continuous Gong Replication to SingleStore
Use CData Sync for automated, continuous, customizable Gong replication to SingleStore.
-
Natively Connect to Pushbullet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pushbullet data. Leverage the native support for ODBC in PHP.
-
Integrate eBay with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate eBay with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to eBay data.
-
Model Wave Financial Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Wave Financial, enabling the direct import of real-time Wave Financial data.
-
Migrating data from Salesforce CRM Analytics to Databricks using CData SSIS Components.
Easily push Salesforce CRM Analytics data to Databricks using the CData SSIS Tasks for Salesforce CRM Analytics and Databricks.
-
Integrating Dataiku with Notion Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Notion data.
-
Connect OData to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect OData with IBM WebSphere for seamless data integration and connectivity.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HubDB
Provide connectivity to HubDB data through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for TaxJar in Microsoft Power Query
You can use the CData TaxJar ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import TaxJar data into Microsoft Power Query.
-
Build AI Agents with GitHub Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live GitHub data through CData Connect AI.
-
Use the CData Software JDBC Driver for RabbitMQ in MicroStrategy Desktop
Connect to RabbitMQ data in MicroStrategy Desktop using the CData Software JDBC Driver for RabbitMQ.
-
Analyze SAP Ariba Procurement Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Ariba Procurement data in Microsoft R Open.
-
Bidirectional Access to Box Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Box data in Filemaker Pro for Mac or Windows.
-
Configure the CData JDBC Driver for Oracle SCM in a Connection Pool in Tomcat
Connect to Oracle SCM data from a connection pool in Tomcat.
-
A PostgreSQL Interface for Oracle HCM Cloud Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle HCM Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Jira Assets Data in Python with CData Connect AI
Build ETL pipelines that read and write live Jira Assets data in Python with petl and the CData Connect AI Python SDK.
-
How to Create Derived Views, Saved Queries, and Custom Reports in CData Connect AI
Explore the Derived Views, Saved Queries, and Custom Reports features in CDataConnect AI
-
Build AI/ML Models with Live Redis Data using Dataiku
Connect Redis Data with Dataiku using the CData JDBC Driver for Redis.
-
Integrate Apollo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apollo data from Informatica Cloud.
-
Natively Connect to Brex Data in PHP
The CData ODBC driver for Brex enables you to create PHP applications with connectivity to Brex data. Leverage the native support for ODBC in PHP.
-
Publish Reports with Couchbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Couchbase data.
-
Connect to Supabase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Supabase.
-
Add Reckon Accounts Hosted Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Reckon Accounts Hosted with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Missive Data in RapidMiner
Integrate Missive data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SendInBlue from a Connection Pool in WebLogic
Use the CData JDBC Driver for SendInBlue to connect to SendInBlue data from Web applications running on WebLogic.
-
Build a Simple VCL Application for Klipfolio Data
How to build a simple VCL Application to view Klipfolio data in RAD Studio using the CData ODBC Driver for Klipfolio.
-
Connect to Sentry Data in RapidMiner
Integrate Sentry data with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Bannerbear Data to Multiple Databases
Replicate Bannerbear data to disparate databases with a point-and-click configuration.
-
Automate Paylocity Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Paylocity data from PowerShell? This article demonstrates how to utilize the Paylocity Cmdlets for tasks like connecting to Paylocity data, automating operations, downloading data, and more.
-
How to publish and share Amazon Marketplace Data dashboards with Tableau Server
The CData ODBC driver for Amazon Marketplace enables you integrate Amazon Marketplace data into Tableau dashboards.
-
How to Visualize Coda Data in Python with pandas
Use pandas and other modules to analyze and visualize live Coda data in Python.
-
How to connect PolyBase to Excel
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Excel data.
-
Connect to Yelp Data in Jaspersoft Studio
Execute SQL to remote Yelp data in Jaspersoft Studio.
-
Access Outreach.io Data from MySQL in Amazon QuickSight
Connect to Outreach.io and build visualizations of Outreach.io data using a MySQL Connection in Amazon QuickSight.
-
Connecting Pipedream with Adobe Analytics 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 Adobe Analytics data in real time.
-
A PostgreSQL Interface for FormSite Data (MySQL Remoting via JDBC)
Use the Remoting features of the FormSite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Configure the CData JDBC Driver for Elorus in a Connection Pool in Tomcat
Connect to Elorus data from a connection pool in Tomcat.
-
Query Clockify Data in DataGrip
Create a Data Source for Clockify in DataGrip and use SQL to query live Clockify data.
-
Link Autopilot with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Autopilot data in Filemaker Pro for Mac or Windows.
-
How to Visualize Square Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Square data in Python.
-
Connect to Apify from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apify data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
BigCommerce Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to BigCommerce data through CData Connect AI using different applications and tools.
-
Create Email Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Email from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Wave Financial Data in MySQL Workbench
Execute MySQL queries against live Wave Financial data from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Timely
Provide connectivity to Timely data through an SAP BusinessObjects universe.
-
Connect to Google Directory Data in RapidMiner
Integrate Google Directory data with standard components and data source configuration wizards in RapidMiner Studio.