CData Software - Knowledge Base
Recent Articles
-
Operational Reporting on Acumatica Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Acumatica data.
-
Build Data Flows from Billsby to SQL Server using SSIS
Easily back up Billsby data to SQL Server using the SSIS components for Billsby.
-
Connect to Tanda Data from a Connection Pool in JBoss
Integrate Tanda data into Java servlets: Use the Management Console in JBoss to install the Tanda JDBC Driver.
-
Connect to Vertica Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Vertica data.
-
Integrate Cursor with Live GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live GetResponse data from within the editor.
-
Automated Continuous Oracle Eloqua Reporting Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to MySQL.
-
How to Query Live Harvest Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Harvest data data in natural language using Python.
-
Connect to ConvertKit Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ConvertKit data.
-
Integrating LangChain with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ServiceNow data within automated workflows.
-
How to Connect to Dynamics 365 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Dynamics 365 data. Leverage the pyodbc module for ODBC in Python.
-
Add SAP Ariba Source Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Ariba Source with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData JDBC Driver for FreshBooks
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FreshBooks.
-
Create Spotify Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Spotify from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Informatica Mappings From/To a JDBC Data Source for Presto
Create Presto data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connecting Agentforce with Salesforce Pardot 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 Salesforce Pardot data for you.
-
Create Data Visualizations Based On Reckon Accounts Hosted Data in Mode
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Mode and build visualizations using live Reckon Accounts Hosted data.
-
Automated Continuous Copper Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Copper replication to delimited files (CSV/TSV).
-
Build a Singer.io Tap for Harvest With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Harvest data using the CData Python Connector.
-
Use Agno to Talk to Your Wave Financial 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 Wave Financial data for you.
-
How to Connect to Freshdesk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Freshdesk data. Leverage the pyodbc module for ODBC in Python.
-
How to Create Power BI Visual Reports with Real-Time Salesforce Marketing Data
Use CData Power BI Connectors to visualize Salesforce Marketing data in Power BI.
-
Connect to MYOB AccountRight Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to MYOB AccountRight.
-
Access ConvertAPI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ConvertAPI data from HeidiSQL.
-
Visualize Live Excel Online Data in the Power BI Service
Use CData Connect AI to connect to live Excel Online data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Outreach.io Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Outreach.io data through CData Connect AI using different applications and tools.
-
How to connect to Copper Data in DBVisualizer
Integrate Copper data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Visualizations of Bitbucket Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bitbucket data in Birst.
-
Access Live Helpscout Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Helpscout data into the statistical analysis tools available in SAS JMP. This article shows how to use Helpscout data in the Graph Builder and Query Builder.
-
Integrate Live Azure Data Lake Storage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Data Lake Storage data to Blue Prism using the CData ODBC Driver for Azure Data Lake Storage to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Attio in SAS for Real-Time Reporting and Analytics
Connect to real-time Attio data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Attio.
-
Visualize Salesforce Data 360 Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce Data 360 data.
-
Import Dynamics CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Dynamics CRM Data and provide access to live Dynamics CRM data for custom reports in the Power BI Service.
-
DataBind Charts to Demio Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Demio data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build YouTube Analytics-Connected Apps in Choreo
Use CData Connect AI to connect to YouTube Analytics Data from Choreo and build custom apps using live YouTube Analytics data.
-
Build Apps with Live SingleStore data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SingleStore data into the Adalo platform and build custom mobile and web applications with real-time SingleStore data.
-
Connect to Google Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Ads data.
-
Automated Continuous Azure Synapse Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure Synapse replication to IBM DB2.
-
How to Connect to Live API 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 API data without replication.
-
Replicate Presto Data from PowerShell
Write a quick PowerShell script to query Presto data. Use connectivity to the live data to replicate Presto data to SQL Server.
-
Query Strava Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Strava data from Node.js.
-
Write a Simple Go Application to work with Google Sheets Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Sheets data.
-
Import Real-Time Cassandra Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Cassandra data in ColdFusion.
-
Connect Pipeliner CRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pipeliner CRM with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy Web
Connect to Sugar CRM data in MicroStrategy Web using the CData Software ODBC Driver for Sugar CRM.
-
Access Live Coda Data in AWS Lambda
Connect to live Coda data in AWS Lambda using the CData JDBC Driver.
-
Create FHIR-Connected Business Apps in AppSheet
Connect to FHIR Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to FHIR data.
-
How to load ZohoExpense data into Elasticsearch via Logstash
Introducing a simple method to load ZohoExpense data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Data Flows from GraphQL to SQL Server using SSIS
Easily back up GraphQL data to SQL Server using the SSIS components for GraphQL.
-
Getting Started with the CData ODBC Driver for Workable
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Workable.
-
Access Auth0 Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Auth0 data.
-
How to connect to Aircall Data in DBVisualizer
Integrate Aircall data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build HubDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HubDB data.
-
Natively Connect to Pipeliner CRM Data in PHP
The CData ODBC driver for Pipeliner CRM enables you to create PHP applications with connectivity to Pipeliner CRM data. Leverage the native support for ODBC in PHP.
-
Access Live Microsoft Ads Data in AWS Lambda
Connect to live Microsoft Ads data in AWS Lambda using the CData JDBC Driver.
-
How to Connect DBeaver to Helpscout via a JDBC Driver
Manage Helpscout data with visual tools in DBeaver like the query browser.
-
Integrating Gumloop with Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Pinterest data within automated workflows.
-
Excel Spreadsheet Automation on Campaigner Data with the QUERY Formula
Pull data from Campaigner, automate spreadsheets, and more with the QUERY formula.
-
Integrate with Microsoft Entra ID Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Entra ID data to a JSON file on disk.
-
Back Up Mailgun 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 Mailgun data data.
-
How to Access Live Salesforce CRM Analytics Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesforce CRM Analytics enables you to integrate Salesforce CRM Analytics data into workflows built using Microsoft Power Automate Desktop.
-
Use Grok to Talk to Your YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your YouTube Analytics data for you.
-
Create Office 365-Connected Nintex Workflows
Use CData Connect AI to connect to Office 365 Data from Nintex Workflow Cloud and build custom workflows using live Office 365 data.
-
Use Dash to Build Web Apps on Excel Online Data via CData Connect AI
Build interactive Dash web apps on live Excel Online data using pandas and the CData Connect AI Python SDK.
-
Create ADP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ADP data access from reports, embedded analytics, and more.
-
Use the CData ODBC Driver for CapsuleCRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CapsuleCRM to connect to CapsuleCRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CapsuleCRM data in Excel.
-
Build Charts with Clockify Data in Clear Analytics
Create dynamic charts and perform analytics based on Clockify data in Clear Analytics.
-
SAP Ariba Procurement Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Ariba Procurement facts in real time.
-
Use the CData Software ODBC Driver for Templated in SAS for Real-Time Reporting and Analytics
Connect to real-time Templated data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Templated.
-
Automated Continuous SAP SuccessFactors Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Google BigQuery.
-
Getting Started with the CData Python Connector for Timely
Learn to install and license the CData Python Connector and configure a connection to live Timely data.
-
How to Access Live Snapchat Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Snapchat Ads enables you to integrate Snapchat Ads data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Connect AI Python SDK for Act-On
Install the CData Connect AI Python SDK to read and write live Act-On data with standard DB-API 2.0 Python code.
-
Connect and Visualize Live ShipEngine Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ShipEngine data into the Databricks platform and create visualization dashboards with real-time ShipEngine data.
-
Deploy the ADO.NET Provider for Google Forms on an SSRS Report Server
Connect to Google Forms 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.
-
Use Claude to Talk to Your AlloyDB 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 AlloyDB data for you.
-
How to Visualize Zuora Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zuora data in Python.
-
Getting Started with the CData ODBC Driver for WordPress
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for WordPress.
-
Build Coda-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Coda Data from Zoho Analytics and import live Coda data.
-
How to connect PolyBase to Cloudflare
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Cloudflare data.
-
How to import Short.io Data into Apache Solr
Use the CData Software JDBC Driver for Short.io in Data Import Handler and create an automated import of Short.io data to Apache Solr Enterprise Search platform.
-
Connect to Google Campaign Manager 360 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Campaign Manager 360 and the Script function in FileMaker Pro to connect to Google Campaign Manager 360 and work with Google Campaign Manager 360 data in your FileMaker application.
-
Build Google Calendar Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Calendar data and build visualizations in Tableau.
-
Connect to PDFMonkey Data from PowerBuilder via ADO.NET
This article demonstrates how to access PDFMonkey data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect SharePoint with SAP SuccessFactors LMS Data through external lists
Provide SAP SuccessFactors LMS data to SharePoint users as an external list.
-
Automated Continuous Placid Replication to MongoDB
Use CData Sync for automated, continuous, customizable Placid replication to MongoDB.
-
Connect to Reckon Accounts Hosted from Asprova with CData Software ODBC Driver for Reckon Accounts Hosted
This article shows how to connect faster to Reckon Accounts Hosted data from Asprova.
-
Build Semantic Layer Views for Discord Data in APOS Live Data Gateway
Use the CData Connector for Discord in APOS Live Data Gateway to build Semantic Layer Views for Discord data.
-
How to Easily Query Okta Data in OpenOffice Base
Connect to Okta data in OpenOffice Base using the CData ODBC Driver for Okta and generate reports with live data insights.
-
Build Redis-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Redis data without replication.
-
Connect to Flowlu Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Flowlu data.
-
Integrating QuickBooks Time Data in Talend Cloud Data Management Platform
Connect QuickBooks Time Data with Talend Cloud Data Management Platform using the CData JDBC Driver for QuickBooks Time.
-
Back Up Customer.io 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 Customer.io data data.
-
Automated Continuous Google Calendar Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Calendar replication to Databricks.
-
Connect to Real-Time Codat Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Codat data in Power Apps.
-
Automated Continuous Factorial Replication to MongoDB
Use CData Sync for automated, continuous, customizable Factorial replication to MongoDB.
-
Use Dash to Build to Web Apps on Elorus Data
Create Python applications that use pandas and Dash to build Elorus-connected web apps.
-
Automated Continuous NASA Replication to SQL Server
Use CData Sync for automated, continuous, customizable NASA replication to SQL Server.
-
Create Data Visualizations in Cognos BI with Rebilly Data
Access Rebilly data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Claude Code CLI with Cloudant 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.
-
Create Data Visualizations in Cognos BI with AgileCRM Data
Access AgileCRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.