CData Software - Knowledge Base
Recent Articles
-
Analyze PayPal Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PayPal from Power Pivot. You will use the Table Import Wizard to load PayPal data. You can visually build the import query or use any SQL supported by the driver.
-
Connect and Query Live Facebook Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Facebook Ads data into Databricks and enable direct, live querying and analysis without replication.
-
DataBind Controls to Pushbullet Data in C++Builder
DataBind to Pushbullet data in C++Builder with standard components and controls.
-
Establish a Live Connection with MailChimp Data using Tableau Bridge
The CData ODBC Driver for MailChimp enables you to integrate live MailChimp data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Build an ETL App for PingOne Data in Python with CData
Create ETL applications and real-time data pipelines for PingOne data in Python with petl.
-
How to Connect to Live Perplexity 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 Perplexity data for you.
-
Automated Continuous CouchDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CouchDB replication to Amazon S3.
-
Import ClickUp Data Using Azure Data Factory
Use CData Connect AI to connect to ClickUp Data from Azure Data Factory and import live ClickUp data.
-
How to work with Monday.com Data in Apache Spark using SQL
Access and process Monday.com Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Google Ads Data in RapidMiner
Integrate Google Ads data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to integrate Impala with Apache Airflow
Access and process Impala data in Apache Airflow using the CData JDBC Driver.
-
Publish Crystal Reports on Ontraport Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Ontraport data.
-
Automate Campaigner Data Replication to Couchbase
Use CData Sync to Customize and automate Campaigner data replication to Couchbase.
-
Connect to Helpscout Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Helpscout as an External Source in Dremio.
-
Build Oracle Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle data and build visualizations in Tableau Cloud.
-
How to integrate Metabase with Google Ads Data
Use CData Connect AI to connect to live Google Ads data and create an interactive dashboard in Metabase from Google Ads data.
-
Using the CData Software ODBC Driver for Cosmos DB in PyCharm
Connect to Cosmos DB as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cosmos DB.
-
Analyze Jira Assets Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Jira Assets from Power Pivot. You will use the Table Import Wizard to load Jira Assets data. You can visually build the import query or use any SQL supported by the driver.
-
Query Active Directory Data in ColdFusion
Write standard ColdFusion data access code to connect to Active Directory data.
-
Connect to ActiveCampaign Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ActiveCampaign data.
-
Integrate LibreChat with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Slack data from within the chat interface.
-
LINQ to Microsoft Teams 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 Microsoft Teams Data Provider.
-
Connect to Accelo Data from a Connection Pool in JBoss
Integrate Accelo data into Java servlets: Use the Management Console in JBoss to install the Accelo JDBC Driver.
-
Query Oracle Service Cloud Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Service Cloud data from Node.js.
-
Build a PostgreSQL Interface for Miro Data using the CData JDBC Driver
Use the Remoting features of the Miro JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Mailjet Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Mailjet data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData SSIS Components for Jira Assets
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jira Assets.
-
Use Databricks Agent Bricks to Talk to Your ZohoExpense Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ZohoExpense data for you.
-
Use the CData Software JDBC Driver for Templated in MicroStrategy
Connect to Templated data in MicroStrategy Developer using the CData Software JDBC Driver for Templated.
-
Connect to Live Figshare Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Figshare in CData Connect AI and connect to your Figshare data from PostgreSQL.
-
Build Apps with Live ZohoPeople Data Using the Low-Code Development Platform of Mendix
Connect ZohoPeople data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Build an ETL App for ZohoSubscriptions Data in Python with CData Connect AI
Extract and transform live ZohoSubscriptions data in Python with petl and the CData Connect AI Python SDK.
-
Analyze Authorize.Net Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Authorize.Net data in Microsoft R Open.
-
Access SAP HANA Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP HANA data from HeidiSQL.
-
Rapidly Develop SAP BusinessObjects BI-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 SAP BusinessObjects BI.
-
How to Create Power BI Visual Reports with Real-Time GraphQL Data
Use CData Power BI Connectors to visualize GraphQL data in Power BI.
-
Excel Spreadsheet Automation on ChartMogul Data with the QUERY Formula
Pull data from ChartMogul, automate spreadsheets, and more with the QUERY formula.
-
Create Datasets from Pipeline CRM in Domo Workbench and Build Visualizations of Pipeline CRM Data in Domo
Use the CData Software ODBC Driver for Pipeline CRM to create datasets from Pipeline CRM data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live TigerGraph Data in AWS Lambda
Connect to live TigerGraph data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Spark Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Spark data without replication.
-
Manage CircleCI Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CircleCI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LightSpeedRetail
Provide connectivity to LightSpeedRetail data through an SAP BusinessObjects universe.
-
Connect to MessageBird Data in JRuby
Create a simple JRuby app with access to live MessageBird data.
-
Use Agno to Talk to Your Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Cloud Storage data for you.
-
Connect to Float Data in DBArtisan
Use wizards in DBArtisan to configure Float data as a data source.
-
How to Access Live Parallel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Parallel enables you to integrate Parallel data into workflows built using Microsoft Power Automate Desktop.
-
Automate Autopilot Data Replication to SAP HANA
Use CData Sync to customize and automate Autopilot data replication to SAP HANA.
-
Write a Simple Go Application to work with SAP Ariba Source Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Ariba Source data.
-
Integrating Kiro with Kintone 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.
-
Publish Presto-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Presto data.
-
Use the CData SSIS Components to Insert New or Update Existing SAP Hybris C4C Records from SQL Server
Easily push SQL Server data to SAP Hybris C4C using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP Hybris C4C or update existing records with data from a SQL Server database.
-
Analyze Email Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Email data in Microsoft R Open.
-
Automated Marketo Data Replication to Teradata
Use CData Sync to Customize and automate Marketo data replication to Teradata.
-
Build Sybase IQ-Connected Apps in Choreo
Use CData Connect AI to connect to Sybase IQ Data from Choreo and build custom apps using live Sybase IQ data.
-
Connect to Figshare Data in RapidMiner
Integrate Figshare data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Jumpseller Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Jumpseller data from HeidiSQL.
-
Visualize Live Neo4J Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Neo4J data into custom reports in Power BI.
-
Access Live Google Spanner Data in Excel 365 Online (Excel for the web)
Connect to Google Spanner data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Chargebee Replication to SingleStore
Use CData Sync for automated, continuous, customizable Chargebee replication to SingleStore.
-
How to Connect to Live Email Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Email data without replication.
-
Use the CData Software JDBC Driver for Azure Data Lake Storage in MicroStrategy Web
Connect to Azure Data Lake Storage data in MicroStrategy Web using the CData Software JDBC Driver for Azure Data Lake Storage.
-
Work with Reckon Data in FoxPro
Load Reckon data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Visualizations of SpaceX Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SpaceX data in Birst.
-
Integrate Dify with Live Instagram Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Instagram data.
-
Connecting Moonlit Workflow with OneNote Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your OneNote data in real time.
-
Establish a Live Connection with Tally Data using Tableau Bridge
The CData ODBC Driver for Tally enables you to integrate live Tally data into Tableau Cloud dashboards using the Tableau Bridge.
-
Import Real-Time SAP Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP data in ColdFusion.
-
Use the CData Software ODBC Driver for Freshservice in SAS for Real-Time Reporting and Analytics
Connect to real-time Freshservice data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Freshservice.
-
Analyze PostgreSQL Data in Looker
Use CData Connect AI to connect to PostgreSQL Data from Looker and build custom apps using live PostgreSQL data.
-
Deploy the ADO.NET Provider for SAS xpt on an SSRS Report Server
Connect to SAS xpt 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Mixpanel
Create Mixpanel data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to & Open Avalara AvaTax Data in Microsoft Excel
This article uses the CData ODBC driver for Avalara AvaTax to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Consume Facebook Ads OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Facebook Ads feeds that reflect any changes in SAP Lumira.
-
Connect to FreshBooks Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for FreshBooks Data and connect to FreshBooks data in Akorbi Digital RunMyProcess.
-
Connect to ClickUp Data from PowerBuilder via ADO.NET
This article demonstrates how to access ClickUp data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Live Google Search Results from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Search results for you.
-
Integrate Google's Antigravity Agent with Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sage Cloud Accounting data using the Model Context Protocol.
-
Analyze Guru Data in Looker
Use CData Connect AI to connect to Guru Data from Looker and build custom apps using live Guru data.
-
Getting Started with the CData ADO.NET Provider for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Salesforce Marketing.
-
Build a PostgreSQL Interface for Aha! Data using the CData JDBC Driver
Use the Remoting features of the Aha! JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Workflows with Live ActiveCampaign Data in Workato
Use CData Connect AI to connect to live ActiveCampaign data and build automated workflows in Workato.
-
Access Live Email Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Email data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Sentry Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Sentry and work with Sentry data in your FileMaker applications.
-
Connect to Mouseflow Data in Ruby
Connect to Mouseflow data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Moving Data from EmailOctopus to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live EmailOctopus data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData ADO.NET Provider for Perplexity
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connecting Agentforce with NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data for you.
-
How to Use a Microsoft Access Database to Update Microsoft Planner Data in Real Time
Update Microsoft Planner data by creating a linked table in Microsoft Access with the CData Microsoft Planner ODBC Driver.
-
Work with Facebook Ads Data in FoxPro
Load Facebook Ads data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Apps with Live BenchmarkEmail Data Using the Low-Code Development Platform of Mendix
Connect BenchmarkEmail data with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Oracle HCM Cloud Data in TIBCO Spotfire through OData
Integrate Oracle HCM Cloud data into dashboards in TIBCO Spotfire.
-
Create Redis-Connected Dashboards in Grafana
Connect to Redis Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Redis data.
-
Connect to Parallel Data in Aqua Data Studio
Access Parallel data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish CircleCI-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CircleCI data.
-
Connect Hugging Face to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Hugging Face data using the CData Python MCP Server.
-
Connect to Sendwithus Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sendwithus and the SQL Gateway to access Sendwithus data from Google Apps Script.
-
Bridge Jumpseller Connectivity with Apache NiFi
Access and process Jumpseller data in Apache NiFi using the CData JDBC Driver.
-
Replicate Google Tasks Data in Heroku for Use in Salesforce Connect
Replicate Google Tasks data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build SAP SuccessFactors-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP SuccessFactors data.
-
Create Informatica Mappings From/To an ODBC Data Source for FormSite
Create an ODBC connection to FormSite in Informatica and browse and transfer FormSite data.