CData Software - Knowledge Base
Recent Articles
-
How to connect to Google Cloud Storage Data in DBVisualizer
Integrate Google Cloud Storage data with visual data analysis tools and data connection wizards in DBVisualizer
-
Prepare, Blend, and Analyze Mode Data in Alteryx Designer (Connect AI)
Build workflows to access live Mode data for self-service data analytics.
-
Integrating GitHub Copilot with Google Forms 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 Voice Agents in ElevenLabs with access to Live Google Search Results
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Search results.
-
Configure the CData JDBC Driver for QuickBooks Time in a Connection Pool in Tomcat
Connect to QuickBooks Time data from a connection pool in Tomcat.
-
Integrate with Eventbrite Data in JReport Designer
Create charts and reports based on Eventbrite data in JReport Designer.
-
How to connect to Salesforce Pardot Data from IntelliJ
Integrate connectivity to Salesforce Pardot data with wizards in IntelliJ.
-
Visualize Apollo Data in TIBCO Spotfire through ADO.NET
Integrate Apollo data into dashboards in TIBCO Spotfire.
-
Use Biml to Build SSIS Tasks to Replicate Oracle SCM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle SCM data to SQL Server.
-
Use the CData Software JDBC Driver for PabblySubscriptions in MicroStrategy
Connect to PabblySubscriptions data in MicroStrategy Developer using the CData Software JDBC Driver for PabblySubscriptions.
-
Create a Data Access Object for Google Tasks Data using JDBI
A brief overview of creating a SQL Object API for Google Tasks data in JDBI.
-
Integrate Live MariaDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MariaDB data to Blue Prism using the CData ODBC Driver for MariaDB to create automated workflows for repetitive business tasks.
-
Connecting Pipedream with PayPal 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 PayPal data in real time.
-
Getting Started with the CData ADO.NET Provider for Workable
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Google's Antigravity Agent with Live Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Paymo data using the Model Context Protocol.
-
Replicate ZeroBounce Data to Multiple Databases via the CData Sync CLI
Replicate ZeroBounce data to disparate databases with a single configuration.
-
Visualize Live Exa Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Exa data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Python Connector for Facebook Ads
Learn to install and license the CData Python Connector and configure a connection to live Facebook Ads data.
-
How to Work with Strava Data in ETL Validator JDBC
Connect to Strava from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Bannerbear Data in Aqua Data Studio
Access Bannerbear 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 Twilio
Provide connectivity to Twilio data through an SAP BusinessObjects universe.
-
Integrate Open WebUI with Live Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Mailjet data from within the chat interface.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Monday.com
Provide connectivity to Monday.com data through an SAP BusinessObjects universe.
-
Integrating SAS xpt Data in Talend Cloud Data Management Platform
Connect SAS xpt Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAS xpt.
-
Rapidly Develop HCL Domino-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 HCL Domino.
-
How to Connect to Greenhouse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Greenhouse data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Facebook Ads Data in Pentaho Data Integration
Build ETL pipelines based on Facebook Ads data in the Pentaho Data Integration tool.
-
Connect to Klaviyo Data from HeidiSQL
Use CData Connect AI to connect to and query live Klaviyo data from HeidiSQL.
-
Integrating Cursor with Salesforce CRM Analytics 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 Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Smartsheet data within intelligent agent workflows.
-
Build Charts with Epicor Kinetic Data in Clear Analytics
Create dynamic charts and perform analytics based on Epicor Kinetic data in Clear Analytics.
-
Connect to Dynamics 365 Business Central Data in DBeaver
Use the CData ODBC Driver to connect to Dynamics 365 Business Central data in DBeaver.
-
Load Todoist Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Todoist data to a database.
-
Build Dashboards with Shippo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Shippo data in Dundas BI.
-
Connect to Aweber Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Aweber Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Extract, Transform, and Load Rootly Data in Informatica PowerCenter
Create a simple Workflow for Rootly data in Informatica PowerCenter.
-
Integrate Devin with Live Google Drive Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Google Drive data.
-
Manage AfterShip Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for AfterShip.
-
Consume Dynamics CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dynamics CRM feeds that reflect any changes in SAP Lumira.
-
Integrating LangGraph with Aweber Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Aweber data within automated workflows.
-
How to connect to Smartsheet Data in DBVisualizer
Integrate Smartsheet data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Kintone-Connected Apps in Choreo
Use CData Connect AI to connect to Kintone Data from Choreo and build custom apps using live Kintone data.
-
Connect to Guru Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Guru Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connecting Agentforce with Campaigner Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Campaigner data for you.
-
Automated Continuous Postmark Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Postmark replication to IBM DB2.
-
Integrate with xBase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live xBase data in SnapLogic.
-
Build MVC Applications with Connectivity to Tavily Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Tavily from an ASP.NET MVC application.
-
How to connect to Zoho Books Data in DBVisualizer
Integrate Zoho Books data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate CapsuleCRM Data into Power Automate Desktop using CData Connect
CData Connect for CapsuleCRM Data enables you to integrate CapsuleCRM data into workflows built using Microsoft Power Automate Desktop.
-
How to Access Azure Analysis Services Data Using Entity Framework
This article shows how to access Azure Analysis Services data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Informatica Mappings From/To an ODBC Data Source for Postmark
Create an ODBC connection to Postmark in Informatica and browse and transfer Postmark data.
-
Access Tally Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Tally data from your Oracle system.
-
Integrating OpenCode with Microsoft Entra ID 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.
-
How to connect and process Simplesat data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Simplesat data.
-
Connect to and Query Microsoft Dataverse Data in QlikView over ODBC
Create data visualizations with Microsoft Dataverse data in QlikView.
-
Visualize Teamgate Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Teamgate data into TIBCO Spotfire.
-
Connect to PDFMonkey Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for PDFMonkey to connect to PDFMonkey data and execute queries in PowerBuilder.
-
Connecting Agentforce with Greenplum Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Greenplum data for you.
-
Use the CData ODBC Driver for IBM Cloud Object Storage in Microsoft Power Query
You can use the CData IBM Cloud Object Storage ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM Cloud Object Storage data into Microsoft Power Query.
-
Migrating data from FormSite to Databricks using CData SSIS Components.
Easily push FormSite data to Databricks using the CData SSIS Tasks for FormSite and Databricks.
-
Automated Continuous Freshteam Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Freshteam replication to AlloyDB.
-
Connect to JobNimbus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to JobNimbus and work with JobNimbus data in your FileMaker applications.
-
Build a PostgreSQL Interface for OpenWeatherMap Data using the CData JDBC Driver
Use the Remoting features of the OpenWeatherMap JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for SAP Netweaver Gateway in MicroStrategy Desktop
Connect to SAP Netweaver Gateway data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Netweaver Gateway.
-
Working with OpenWeatherMap Data in LINQPad
Execute LINQ queries to OpenWeatherMap data in LINQPad.
-
Query Vault CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Vault CRM data.
-
Using the CData Software ODBC Driver for Redis in PyCharm
Connect to Redis as an ODBC data source in PyCharm using the CData Software ODBC Driver for Redis.
-
Analyze Box Data in Cognos Analytics
Use CData Connect AI to connect to Box Data from Cognos Analytics and analyze live Box data.
-
ETL ChargeOver in Oracle Data Integrator
This article shows how to transfer ChargeOver data into a data warehouse using Oracle Data Integrator.
-
Visualize Live Cloudant Data in the Power BI Service
Use CData Connect AI to connect to live Cloudant data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with QuickBooks Data in JReport Designer
Create charts and reports based on QuickBooks data in JReport Designer.
-
How to Easily Query Webex Data in OpenOffice Base
Connect to Webex data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect to Azure DevOps Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Azure DevOps data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Freshservice Data in ACL Analytics
Connect to Freshservice data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Freshservice data.
-
How to connect PolyBase to Paymo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Paymo data.
-
Integrate with live Airtable Data in Jitterbit
Use CData Connect AI to connect to and integrate live Airtable data in Jitterbit.
-
Automated Continuous EmailOctopus Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Google BigQuery.
-
How to connect to Zendesk Data from IntelliJ
Integrate connectivity to Zendesk data with wizards in IntelliJ.
-
Import Real-Time GitHub Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use GitHub data in ColdFusion.
-
Connect to Amazon Athena 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 Amazon Athena data.
-
How to Access ZohoDesk Data Using Entity Framework
This article shows how to access ZohoDesk data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Billsby Data in Ruby
Connect to Billsby data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData ODBC Driver for Cassandra in Microsoft Power Query
You can use the CData Cassandra ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Cassandra data into Microsoft Power Query.
-
Viewing Supabase Data in RAD Studio Data Explorer
How to view Supabase data in RAD Studio Data Explorer using the CData ODBC Driver for Supabase.
-
Power AI Workflows with SQL Server 2025 And CData Sync
Learn how SQL Server 2025’s new AI features such as native vector support transform AI workflows. Then, how to use CData Sync alongside SQl Server 2025 to load enterprise data, build embeddings, and power semantic search and RAG pipelines fast.
-
Integrate Exact Online Data into Power Automate Desktop using CData Connect
CData Connect for Exact Online Data enables you to integrate Exact Online data into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Monday.com to Snowflake using CData SSIS Components.
Easily push Monday.com data to Snowflake using the CData SSIS Tasks for Monday.com and Snowflake.
-
Use Dash to Build to Web Apps on ConstantContact Data
Create Python applications that use pandas and Dash to build ConstantContact-connected web apps.
-
How to connect to Tickspot Data from Spring Boot
Connect to Tickspot in a Spring Boot Application using the CData API Driver for JDBC
-
Migrating data from SAP Business One to Google BigQuery using CData SSIS Components.
Easily push SAP Business One data to Google BigQuery using the CData SSIS Tasks for SAP Business One and Google BigQuery.
-
How to integrate Parquet with Apache Airflow
Access and process Parquet data in Apache Airflow using the CData JDBC Driver.
-
Connect to Printify Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Printify to connect to Printify data and execute queries in PowerBuilder.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Close
Provide connectivity to Close data through an SAP BusinessObjects universe.
-
Build Automated Workflows with Live Salesloft Data in Workato
Use CData Connect AI to connect to live Salesloft data and build automated workflows in Workato.
-
Integrating Claude Code CLI with Workable 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.
-
How to update Quickbase from Excel
This article explains how to transfer data from Excel to Quickbase using the Excel Add-In for Quickbase.
-
Connect to Zoho Books from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Books data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
A PostgreSQL Interface for DocuSign Data (MySQL Remoting via JDBC)
Use the Remoting features of the DocuSign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Agentforce with Vault CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Vault CRM data for you.
-
Connect to Gmail Data from HeidiSQL
Use CData Connect AI to connect to and query live Gmail data from HeidiSQL.