CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Paddle Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Paddle.
-
Access Cvent Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Cvent from HeidiSQL.
-
Migrating data from OData to Snowflake using CData SSIS Components.
Easily push OData to Snowflake using the CData SSIS Tasks for OData and Snowflake.
-
How to create an RPA flow for Nethunt Data in UiPath Studio
Use the Nethunt ODBC Driver to create workflows that access real-time Nethunt without any coding.
-
Back Up HelloSign 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 HelloSign data.
-
Build SAP Ariba Procurement Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Ariba Procurement and build visualizations in Tableau.
-
How to publish and share Raisers Edge NXT Data dashboards with Tableau Server
The CData ODBC driver for Raisers Edge NXT enables you integrate Raisers Edge NXT into Tableau dashboards.
-
Replicate Multiple Cosmos DB Accounts via the CData Sync CLI
Replicate multiple Cosmos DB accounts to one or many databases.
-
Build Odoo-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Odoo Data and create custom apps in Bubble.
-
Use Dash to Build Web Apps on ADP Data via CData Connect AI
Build interactive Dash web apps on live ADP using pandas and the CData Connect AI Python SDK.
-
Replicate Multiple Autopilot Accounts
Replicate multiple Autopilot accounts to one or many databases.
-
How to Query Paddle Data in MySQL Workbench
Execute MySQL queries against live Paddle from MySQL Workbench.
-
Integrate Live SAP Hybris C4C Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Hybris C4C and integrate live SAP Hybris C4C into apps built in Microsoft Power Apps.
-
Working with Cvent Data in LINQPad
Execute LINQ queries to Cvent in LINQPad.
-
Connect to PhantomBuster Data in DBeaver
Use the CData ODBC Driver to connect to PhantomBuster in DBeaver.
-
Build Sage Cloud Accounting-Connected Apps in Choreo
Use CData Connect AI to connect to Sage Cloud Accounting Data from Choreo and build custom apps using live Sage Business Cloud Accounting.
-
Automated Continuous Sage Cloud Accounting Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Apache Cassandra.
-
How to Connect to Autopilot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Autopilot. Leverage the pyodbc module for ODBC in Python.
-
Feed Outlook Data into FineReport
How to set Outlook as a JDBC data source in FineReport.
-
How to create TaxJar federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for TaxJar in MySQL .
-
Analyze Azure Analysis Services Data in Cognos Analytics
Use CData Connect AI to connect to Azure Analysis Services Data from Cognos Analytics and analyze live Azure Analysis Services.
-
Perform Batch Operations with HubSpot Data in Apache NiFi
Connect to HubSpot and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Pushbullet Data in Ruby
Connect to Pushbullet in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData Connect AI Python SDK for SAP ByDesign
Install the CData Connect AI Python SDK to read and write live SAP Business ByDesign with standard DB-API 2.0 Python code.
-
Automated Continuous Instagram Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Instagram replication to Azure SQL Database.
-
Visualize Browserless Data in Sisense
Create an ElastiCube in Sisense app with access to Browserless.
-
Getting Started with the CData Power BI Connector for Harvest
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automate BenchmarkEmail Data Replication to Azure Synapse
Use CData Sync to customize and automate BenchmarkEmail replication to Azure Synapse.
-
Build Semantic Layer Views for Webflow Data in APOS Live Data Gateway
Use the CData Connector for Webflow in APOS Live Data Gateway to build Semantic Layer Views for Webflow.
-
Connect to Hugging Face from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hugging Face to connect to Hugging Face from Web applications running on WebLogic.
-
How to publish and share ElevenLabs Data dashboards with Tableau Server
The CData ODBC driver for ElevenLabs enables you integrate ElevenLabs into Tableau dashboards.
-
How to Connect to Live MySQL 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 MySQL for you.
-
Connect to SQL Server Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SQL Server and the SQL Gateway to access Microsoft SQL Server from Google Apps Script.
-
Create a Data Access Object for ZohoExpense Data using JDBI
A brief overview of creating a SQL Object API for ZohoExpense in JDBI.
-
Query Rebilly Data as a MySQL Database in Node.js
Execute MySQL queries against Rebilly from Node.js.
-
Connect Coda to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Coda using the CData Python MCP Server.
-
How to Query Live eBay Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live eBay data in natural language using Python.
-
Bridge Cohere Connectivity with Apache NiFi
Access and process Cohere in Apache NiFi using the CData JDBC Driver.
-
Connect to Hive Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Hive Data and connect to Apache Hive in Akorbi Digital RunMyProcess.
-
How to use SQLAlchemy ORM to access Outreach.io Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Outreach.io.
-
Integrate with live LinkedIn Ads Data in Jitterbit
Use CData Connect AI to connect to and integrate live LinkedIn Ads in Jitterbit.
-
Getting Started with the CData SSIS Components for Mailjet
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mailjet.
-
Access Live Zoho Creator Data in AWS Lambda
Connect to live Zoho Creator in AWS Lambda using the CData JDBC Driver.
-
Visualize QuickBooks Online Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to QuickBooks Online.
-
Connect to Coda Data from PowerBuilder via ADO.NET
This article demonstrates how to access Coda from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to and Visualize Live Samanage Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Samanage.
-
Create Informatica Mappings From/To an ODBC Data Source for Foursquare
Create an ODBC connection to Foursquare in Informatica and browse and transfer Foursquare.
-
Visualize Confluence Data in TIBCO Spotfire through ADO.NET
Integrate Atlassian Confluence into dashboards in TIBCO Spotfire.
-
Access Live Avalara AvaTax Data in AWS Lambda
Connect to live Avalara AvaTax in AWS Lambda using the CData JDBC Driver.
-
LINQ to ZeroBounce 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 ZeroBounce Data Provider.
-
Visualize Live ADP Data in the Power BI Service
Use CData Connect AI to connect to live ADP and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Authorize.Net Data in Google Apps Script via Connect AI
Use CData Connect AI to access Authorize.Net in Google Apps Script.
-
How to use SQLAlchemy ORM to access Redshift Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon Redshift.
-
Getting Started with the CData Tableau Connector for PayPal
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for PayPal.
-
How to connect to Klaviyo Data with Squirrel SQL client
Connect to Klaviyo and execute queries in the Squirrel SQL Client.
-
A PostgreSQL Interface for Moosend Data using the CData ODBC Driver
Use the SQL Gateway and Moosend ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with Microsoft Planner Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Planner within assisted coding and automated development workflows.
-
Automate Azure DevOps Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure DevOps and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Eventbrite from Asprova with CData Software ODBC Driver for Eventbrite
This article shows how to connect faster to Eventbrite data from Asprova.
-
How to Query Live BigQuery Data in Claude Desktop
Connect to and query live BigQuery Data in Claude Desktop using CData MCP Server.
-
Integrate PingOne Data in Pentaho Data Integration
Build ETL pipelines based on PingOne in the Pentaho Data Integration tool.
-
Import IBM Cloud Object Storage Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access IBM Cloud Object Storage. In this article, you will use the OData format to import IBM Cloud Object Storage into Microsoft Power Query.
-
How to integrate Metabase with FTP Data
Use CData Connect AI to connect to live FTP Servers and create an interactive dashboard in Metabase from FTP Servers.
-
Choosing the Best Method to Connect Pinterest to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pinterest from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with Cloudflare Data in Dundas BI
Create dynamic dashboards and perform analytics based on Cloudflare in Dundas BI.
-
How to create Visio diagrams from Microsoft Exchange Data
Automatically update Microsoft Exchange with the changes you make to Visio master shapes.
-
Integrating Cursor CLI with ZohoExpense 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.
-
Integrating Dataiku with Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Smartsheet.
-
Access Live Google Analytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Analytics from your Excel spreadsheets.
-
Automate Google Tasks Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Tasks replication to Azure Data Lake.
-
Getting Started with the CData Excel Add-In for WordPress
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for WordPress.
-
How to Query Power BI XMLA Data in MySQL Workbench
Execute MySQL queries against live Power BI XMLA from MySQL Workbench.
-
Getting Started with the CData Python Connector for SendPulse
Learn to install and license the CData Python Connector
-
Viewing Mistral AI Data in RAD Studio Data Explorer
How to view Mistral AI in RAD Studio Data Explorer using the CData ODBC Driver for Mistral AI.
-
Integrate Cursor with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live WordPress from within the editor.
-
Connecting Agentforce with Reckon Accounts Hosted 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 Reckon Accounts Hosted for you.
-
Build AI/ML Models with Live Mixpanel Data using Dataiku
Connect Mixpanel Data with Dataiku using the CData API Driver for JDBC.
-
Working with LaunchDarkly Data in LINQPad
Execute LINQ queries to LaunchDarkly in LINQPad.
-
Connect to Square Data in HULFT Integrate
Connect to Square as a JDBC data source in HULFT Integrate
-
Connect to Redshift 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 Redshift.
-
Oracle Sales Reporting in OBIEE with the Oracle Sales JDBC Driver
Deploy the Oracle Sales JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for Drip in MicroStrategy Desktop
Connect to Drip in MicroStrategy Desktop using the CData Software ODBC Driver for Drip.
-
Getting Started with the CData JDBC Driver for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Experience Manager.
-
Connect to Google Forms Data from a Connection Pool in JBoss
Integrate Google Forms into Java servlets: Use the Management Console in JBoss to install the Google Forms JDBC Driver.
-
Access Adobe Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Adobe Analytics from HeidiSQL.
-
How to Connect MailChimp Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MailChimp data in real time using natural language.
-
Excel Spreadsheet Automation on Aha! Data with the QUERY Formula
Pull data from Aha!, automate spreadsheets, and more with the QUERY formula.
-
Moving Data from Dynamics 365 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dynamics 365 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Stream RSS Feeds into Apache Kafka Topics
Access and stream RSS Feeds in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous PabblySubscriptions Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to OneLake in Microsoft Fabric.
-
Connect to Twilio 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 Twilio.
-
Connect to Procore Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Procore.
-
Integrate Live BigCommerce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to BigCommerce and integrate live BigCommerce into apps built in Microsoft Power Apps.
-
Work with Attio Data in FoxPro
Load Attio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Adobe Commerce Data in Excel 365 Online (Excel for the web)
Connect to Adobe Commerce from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads through natural language.
-
Process & Analyze Amplitude Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Amplitude Data.
-
Microsoft OneDrive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft OneDrive through CData Connect AI using different applications and tools.
-
Create Dynamic Templated Grids Using the Infragistics XamDataGrid
Learn how you can connect Templated to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Grafana Data in Pentaho Data Integration
Build ETL pipelines based on Grafana in the Pentaho Data Integration tool.