CData Software - Knowledge Base
Recent Articles
-
Back Up Outlook data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Outlook data data.
-
Automate Teamgate Data Replication to Azure Synapse
Use CData Sync to customize and automate Teamgate data replication to Azure Synapse.
-
How to Connect to Live Oracle 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 data for you.
-
Connect to Eventbrite Data from a Connection Pool in JBoss
Integrate Eventbrite data into Java servlets: Use the Management Console in JBoss to install the Eventbrite JDBC Driver.
-
Integrate Theia IDE with Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Discord data from within the development environment.
-
Automate Google Ad Manager Data Replication to Couchbase
Use CData Sync to Customize and automate Google Ad Manager data replication to Couchbase.
-
Access Live RSS Feeds in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to RSS feeds from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Apps with Live Vercel Data Using the Low-Code Development Platform of Mendix
Connect Vercel data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Microsoft Entra ID Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Entra ID to connect to Microsoft Entra ID data and execute queries in PowerBuilder.
-
Query Aweber Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Aweber data from Node.js.
-
Use the CData Software ODBC Driver for ConvertAPI in SAS for Real-Time Reporting and Analytics
Connect to real-time ConvertAPI data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ConvertAPI.
-
Design BIRT Reports on SingleStore Data
Provide current SingleStore data to your embedded analytics.
-
Use the CData Software ODBC Driver for PostgreSQL in SAS for Real-Time Reporting and Analytics
Connect to real-time PostgreSQL data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PostgreSQL.
-
Create a Data Access Object for Google Contacts Data using JDBI
A brief overview of creating a SQL Object API for Google Contacts data in JDBI.
-
DataBind Reckon Accounts Hosted Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Reckon Accounts Hosted with the DevExpress Windows Forms and Web controls to provide Reckon Accounts Hosted data to a chart.
-
Choosing the Best Method to Connect Salesforce Marketing to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce Marketing data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Visualize QuickBooks Online 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 QuickBooks Online data in Python.
-
Access Zoho Creator Data from MySQL in Amazon QuickSight
Connect to Zoho Creator and build visualizations of Zoho Creator data using a MySQL Connection in Amazon QuickSight.
-
How to Access Live ZohoMarketingHub Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZohoMarketingHub enables you to integrate ZohoMarketingHub data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Goose with Live ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ZohoInvoice data from within the local AI agent.
-
Create a Data Access Object for HubSpot Data using JDBI
A brief overview of creating a SQL Object API for HubSpot data in JDBI.
-
How to Work with Discord Data in ETL Validator JDBC
Connect to Discord from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Elasticsearch Data in Ruby
Connect to Elasticsearch data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Chargebee Data in JReport Designer
Create charts and reports based on Chargebee data in JReport Designer.
-
Using the CData Software ODBC Driver for Notion in PyCharm
Connect to Notion as an ODBC data source in PyCharm using the CData Software ODBC Driver for Notion.
-
Getting Started with the CData Excel Add-In for Superchat
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Superchat.
-
Getting Started with the CData Excel Add-In for ConvertKit
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ConvertKit.
-
Build Automated Azure DevOps-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure DevOps data and build automated workflows in Zapier.
-
Automated Continuous CockroachDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable CockroachDB replication to SQL Server.
-
How to Use a Microsoft Access Database to Update ActiveCampaign Data in Real Time
Update ActiveCampaign data by creating a linked table in Microsoft Access with the CData ActiveCampaign ODBC Driver.
-
Connect and Visualize Live ZohoPeople Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ZohoPeople data into the Databricks platform and create visualization dashboards with real-time ZohoPeople data.
-
Visualize Act CRM 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 Act CRM data into TIBCO Spotfire.
-
Automated Continuous SAP Ariba Procurement Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to IBM DB2.
-
Build Dashboards with SAP HANA Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP HANA data in DBxtra.
-
Visualize OpenWeatherMap Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to OpenWeatherMap data.
-
How to Connect to & Open ConstantContact Data in Microsoft Excel
This article uses the CData ODBC driver for ConstantContact to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect Amazon QuickSight to Shortcut Data
Create a connection to Shortcut data in CData Connect AI and insert Shortcut data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Impala Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Impala data. Leverage the pyodbc module for ODBC in Python.
-
Create Power BI Reports on Real-Time Wave Financial Data
Use the CData ODBC Driver for Wave Financial to visualize Wave Financial data in Power BI Desktop.
-
Connect to YouTube Analytics Data in ACL Analytics
Connect to YouTube Analytics data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to YouTube Analytics data.
-
Automated Continuous Oracle Service Cloud Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Amazon S3.
-
Use the CData Software JDBC Driver for Egnyte in MicroStrategy
Connect to Egnyte data in MicroStrategy Developer using the CData Software JDBC Driver for Egnyte.
-
Connecting Agentforce with ZohoExpense 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 ZohoExpense data for you.
-
How to connect and process JDBC-ODBC Bridge data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live JDBC-ODBC Bridge data.
-
Integrate Trae with Live Zoho Inventory Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Zoho Inventory data from within the AI-powered IDE.
-
How to work with Kafka Data in Apache Spark using SQL
Access and process Kafka Data in Apache Spark using the CData Software JDBC Driver.
-
Easily Integrate Dynamics 365 Data in Lazarus Pascal IDE
Learn how to easily integrate live Dynamics 365 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query Google Drive Data as a MySQL Database in Node.js
Execute MySQL queries against Google Drive data from Node.js.
-
Integrating LlamaIndex with Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Amazon Athena data in real time.
-
Create a Data Access Object for Presto Data using JDBI
A brief overview of creating a SQL Object API for Presto data in JDBI.
-
How to Easily Query Splunk Data in OpenOffice Base
Connect to Splunk data in OpenOffice Base using the CData ODBC Driver for Splunk and generate reports with live data insights.
-
Using the CData Software ODBC Driver for Spark in PyCharm
Connect to Spark as an ODBC data source in PyCharm using the CData Software ODBC Driver for Spark.
-
How to create an RPA flow for ActiveCampaign Data in UiPath Studio
Use the ActiveCampaign ODBC Driver to create workflows that access real-time ActiveCampaign data without any coding.
-
Automated Continuous Cvent Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cvent replication to Amazon S3.
-
Build Jira Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Jira data and build visualizations in Tableau.
-
Connect Attio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Attio data using the CData Python MCP Server.
-
Getting Started with the CData Tableau Connector for Intercom
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Seamlessly Bring QuickBooks Data into Retool Using CData Connect AI
Integrate QuickBooks data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Moving Data from Productboard to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Productboard data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Minimum Requirements for CData API Server
This page lists the minimum system requirements for using CData API Server.
-
Deploy the ADO.NET Provider for Hugging Face on an SSRS Report Server
Connect to Hugging Face 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 Sugar CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sugar CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Pipelines with Live YouTube Analytics Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to YouTube Analytics from Google Cloud Data Fusion, enabling the integration of live YouTube Analytics data into the building and management of effective data pipelines.
-
How to Connect to Live Highrise 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 Highrise data for you.
-
Build Apps with Live Wave Financial data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Wave Financial data into the Adalo platform and build custom mobile and web applications with real-time Wave Financial data.
-
Build Data Flows from Dynamics CRM to SQL Server using SSIS
Easily back up Dynamics CRM data to SQL Server using the SSIS components for Dynamics CRM.
-
Build AI/ML Models with Live Perigon Data using Dataiku
Connect Perigon Data with Dataiku using the CData API Driver for JDBC.
-
Query Live SAP HANA 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 SAP HANA data directly from the development environment.
-
Getting Started with the CData Power BI Connector for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure Synapse.
-
Build a Singer.io Tap for Toggl With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Toggl data using the CData Python Connector.
-
Build Data Flows from SQL Server to Redis through SSIS
Easily push SQL Server data to Redis using the CData SSIS Tasks for Redis.
-
Build Cloudant Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Cloudant data and build visualizations in Tableau Cloud.
-
How to create Visio diagrams from ADP Data
Automatically update ADP data with the changes you make to Visio master shapes.
-
Build a PostgreSQL Interface for Apollo Data using the CData JDBC Driver
Use the Remoting features of the Apollo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Pipelines with Live Snapchat Ads Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Snapchat Ads from Google Cloud Data Fusion, enabling the integration of live Snapchat Ads data into the building and management of effective data pipelines.
-
Replicate Multiple Snapchat Ads Accounts via the CData Sync CLI
Replicate multiple Snapchat Ads accounts to one or many databases.
-
Use the CData Software JDBC Driver for Gong in MicroStrategy
Connect to Gong data in MicroStrategy Developer using the CData Software JDBC Driver for Gong.
-
Deploy the ADO.NET Provider for Short.io on an SSRS Report Server
Connect to Short.io 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.
-
How to Connect to Live Microsoft Teams Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft Teams data through natural language.
-
Integrating OpenCode with Everhour 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.
-
LINQ to Guru Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Guru Data Provider.
-
Create Data Visualizations Based On Impala Data in Mode
Use CData Connect AI to connect to Impala Data from Mode and build visualizations using live Impala data.
-
Connect to and Visualize Live Reckon Accounts Hosted Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Reckon Accounts Hosted data.
-
How to Connect to CockroachDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CockroachDB data. Leverage the pyodbc module for ODBC in Python.
-
Integrating Antigravity CLI with Beeminder data via CData CLI
Connect Beeminder data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to use SQLAlchemy ORM to access Twitter Ads Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twitter Ads data.
-
How to Use a Microsoft Access Database to Update WordPress Data in Real Time
Update WordPress data by creating a linked table in Microsoft Access with the CData WordPress ODBC Driver.
-
Connect to Testmonitor Data in Jaspersoft Studio
Execute SQL to remote Testmonitor data in Jaspersoft Studio.
-
Integrate with SharePoint Excel Services Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SharePoint Excel Services data to a JSON file on disk.
-
Viewing Google Calendar Data in RAD Studio Data Explorer
How to view Google Calendar data in RAD Studio Data Explorer using the CData ODBC Driver for Google Calendar.
-
Connect to QuickBooks Online Data in DBArtisan
Use wizards in DBArtisan to configure QuickBooks Online data as a data source.
-
Create a Data Access Object for FreeAgent Data using JDBI
A brief overview of creating a SQL Object API for FreeAgent data in JDBI.
-
How to Build an ETL App for Cosmos DB Data in Python with CData Connect AI
Build ETL pipelines that read and write live Cosmos DB data in Python with petl and the CData Connect AI Python SDK.
-
Integrating Cursor with Stack Exchange 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 Pipelines with Live Guru Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Guru from Google Cloud Data Fusion, enabling the integration of live Guru data into the building and management of effective data pipelines.
-
Rapidly Develop HBase-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 HBase.
-
Replicate Google Sheets Data to Multiple Databases
Replicate Google Sheets data to disparate databases with a point-and-click configuration.
-
Build SharePoint-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SharePoint Data and create custom apps in Mendix.
-
Integrating LangGraph with HubDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on HubDB data within automated workflows.
-
Integrating Gumloop with OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on OneNote data within automated workflows.