CData Software - Knowledge Base
Recent Articles
-
Use Claude to Talk to Your FreshBooks 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 FreshBooks for you.
-
Integrating Codex CLI with Certinia 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.
-
Connect to and Visualize Live Couchbase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Couchbase.
-
Automated Continuous SAP Ariba Source Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Apache Kafka.
-
Build Automated Workflows with Live CockroachDB Data in Workato
Use CData Connect AI to connect to live CockroachDB and build automated workflows in Workato.
-
Operational Reporting on Stack Exchange Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Stack Exchange.
-
Automated Continuous EnterpriseDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to SQL Server.
-
Build Automated Workflows with Live LinkedIn Data in Workato
Use CData Connect AI to connect to live LinkedIn and build automated workflows in Workato.
-
Visualize Shortcut Data in TIBCO Spotfire through ADO.NET
Integrate Shortcut into dashboards in TIBCO Spotfire.
-
Query Mixpanel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mixpanel from Node.js.
-
Working with Amazon Marketplace Data in LINQPad
Execute LINQ queries to Amazon Marketplace in LINQPad.
-
Build Salesloft-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesloft.
-
Automate Azure Synapse Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Synapse replication to Couchbase.
-
Automated Continuous Microsoft Teams Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Amazon S3.
-
Replicate Multiple Opsgenie Accounts via the CData Sync CLI
Replicate multiple Opsgenie accounts to one or many databases.
-
Stream Productboard Data into Apache Kafka Topics
Access and stream Productboard in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Dash to Build Web Apps on WooCommerce Data via CData Connect AI
Build interactive Dash web apps on live WooCommerce using pandas and the CData Connect AI Python SDK.
-
Create Datasets from Humanity in Domo Workbench and Build Visualizations of Humanity Data in Domo
Use the CData Software ODBC Driver for Humanity to create datasets from Humanity in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData ODBC Driver for Elorus in Microsoft Power Query
You can use the CData Elorus ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Elorus into Microsoft Power Query.
-
Integrate with live Google Contacts Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Contacts in Jitterbit.
-
How to Query Live Google Sheets Data in Perplexity MacOS Desktop
Connect to and query live Google Sheets Data in Perplexity Desktop using CData MCP Server.
-
Access Live Delighted Data in AWS Lambda
Connect to live Delighted in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Coinbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Coinbase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Coinbase.
-
Build a Simple VCL Application for Square Data
How to build a simple VCL Application to view Square in RAD Studio using the CData ODBC Driver for Square.
-
Automated Continuous Reckon Replication to MongoDB
Use CData Sync for automated, continuous, customizable Reckon replication to MongoDB.
-
How to Connect DBeaver to Epicor Kinetic via a JDBC Driver
Manage Epicor Kinetic with visual tools in DBeaver like the query browser.
-
Use Biml to Build SSIS Tasks to Replicate SAP SuccessFactors Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP SuccessFactors to SQL Server.
-
Build a Simple VCL Application for Amazon DynamoDB Data
How to build a simple VCL Application to view Amazon DynamoDB in RAD Studio using the CData ODBC Driver for Amazon DynamoDB.
-
How to Connect the Power BI Service to Square: Complete Guide
Connect to the CData Software Power BI Connector for Square from PowerBI.com to provide real-time Square across the organization.
-
Build SAS xpt-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAS xpt to explore live SAS xpt Data in Gemini Code Assist to assist with building SAS xpt-powered applications.
-
Explore Geographical Relationships in MongoDB Data with Power Map
Create data visualizations with MongoDB in Power Map.
-
Replicate Oracle Financials Cloud Data in Heroku for Use in Salesforce Connect
Replicate Oracle Financials Cloud to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Salesforce Data 360 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce Data 360 from your Oracle system.
-
Automated Continuous Sugar CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Snowflake.
-
Automated Continuous Adobe Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to SingleStore.
-
Provide OData Services of LightSpeedRetail Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LightSpeedRetail by developing a WCF Service Application.
-
How to Connect to Live ShipStation Data 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 ShipStation for you.
-
Connect to SAP Data in HULFT Integrate
Connect to SAP as a JDBC data source in HULFT Integrate
-
Connect to JobNimbus Data from a Connection Pool in JBoss
Integrate JobNimbus into Java servlets: Use the Management Console in JBoss to install the JobNimbus JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Spanner
Create an ODBC connection to Google Spanner in Informatica and browse and transfer Google Spanner.
-
Connect to ServiceNow from a Connection Pool in WebLogic
Use the CData JDBC Driver for ServiceNow to connect to ServiceNow from Web applications running on WebLogic.
-
How to Query Live Clio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Clio data in natural language using Python.
-
Automated Continuous LionDesk Replication to Databricks
Use CData Sync for automated, continuous, customizable LionDesk replication to Databricks.
-
Establish a Live Connection with SAP SuccessFactors LMS Data using Tableau Bridge
The CData ODBC Driver for SAP SuccessFactors LMS enables you to integrate live SAP SuccessFactors LMS into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to BigCommerce Data in DBVisualizer
Integrate BigCommerce with visual data analysis tools and data connection wizards in DBVisualizer
-
Use CData Connect AI to Access LinkedIn Ads Data in Microsoft Power Pivot
Use CData Connect AI to connect to live LinkedIn Ads in the Power Pivot business intelligence tool.
-
How to connect and process Deel from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Deel.
-
Import and Visualize Klaviyo Data in Power View
Create data visualizations based on Klaviyo in Excel.
-
Access LionDesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LionDesk from HeidiSQL.
-
Create Dynamic Microsoft Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Ads to Infragistics XamDataGrid to build dynamic grids.
-
How to connect PolyBase to ZohoDesk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZohoDesk.
-
Getting Started with the CData Python Connector for Auth0
Learn to install and license the CData Python Connector
-
Access Live Zuora Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zuora from your Google Sheets.
-
Add OData Services to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for OData with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect SharePoint with MailChimp Data through external lists
Provide MailChimp to SharePoint users as an external list.
-
Automated Continuous CSV Replication to MySQL
Use CData Sync for automated, continuous, customizable CSV replication to MySQL.
-
Automate Oracle Sales Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Sales replication to Couchbase.
-
Getting Started with the CData Python Connector for Nethunt
Learn to install and license the CData Python Connector
-
Connect to Google Tasks Data in Jaspersoft Studio
Execute SQL to remote Google Tasks in Jaspersoft Studio.
-
Access Live Azure Table Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Azure Table Storage through MCP integration.
-
Connect to Apify Data in HULFT Integrate
Connect to Apify as a JDBC data source in HULFT Integrate
-
Connecting Mastra with Procore Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Procore, no replication required.
-
Load ClickUp Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ClickUp to a database.
-
Visualize LDAP Objects in TIBCO Spotfire through OData
Integrate LDAP into dashboards in TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Optimizely
Provide connectivity to Optimizely through an SAP BusinessObjects universe.
-
How to Connect to Live Google Ads Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Ads without replication.
-
Build Apps with Live Amazon Athena in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon Athena into the Adalo platform and build custom mobile and web applications with real-time Amazon Athena.
-
Visualize Wave Financial Data in TIBCO Spotfire through OData
Integrate Wave Financial into dashboards in TIBCO Spotfire.
-
Edit and Search OneNote External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft OneNote to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create OneNote objects that you can access from apps and the dashboard.
-
Connect to Reckon Accounts Hosted Data in DBArtisan
Use wizards in DBArtisan to configure Reckon Accounts Hosted as a data source.
-
DataBind Omnisend Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Omnisend to a chart.
-
How to create ZarMoney federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ZarMoney in MySQL .
-
Build AI/ML Models with Live Copper Data using Dataiku
Connect Copper Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Quickbase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Quickbase replication to OneLake in Microsoft Fabric.
-
Automated Continuous Pipeliner CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to AlloyDB.
-
Access Live Clari Data in Coginiti Pro
Connect to and query live Clari from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import and Visualize Twitter Ads Data in Power View
Create data visualizations based on Twitter Ads in Excel.
-
Build Voice Agents in ElevenLabs with access to Live Adobe Analytics Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Adobe Analytics.
-
How to Easily Query Aircall Data in OpenOffice Base
Connect to Aircall data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Migrating data from Google Forms to Databricks using CData SSIS Components.
Easily push Google Forms to Databricks using the CData SSIS Tasks for Google Forms and Databricks.
-
Connect and Visualize Live MYOB AccountRight Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MYOB AccountRight into the Databricks platform and create visualization dashboards with real-time MYOB AccountRight.
-
How to Connect Flowise AI Agents to Live API Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live API without replication.
-
Use the CData ODBC Driver for iContact from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for iContact to connect to iContact from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring iContact in Excel.
-
Query Stack Exchange Data in ColdFusion
Write standard ColdFusion data access code to connect to Stack Exchange.
-
Automated Continuous Teradata Replication to Snowflake
Use CData Sync for automated, continuous, customizable Teradata replication to Snowflake.
-
LINQ to Retently 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 Retently Data Provider.
-
Replicate Telegram Data from PowerShell
Write a quick PowerShell script to query Telegram. Use connectivity to the live data to replicate Telegram to SQL Server.
-
Easily Integrate HelloSign Data in Lazarus Pascal IDE
Learn how to easily integrate live HelloSign in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Power BI XMLA Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Power BI XMLA data access from reports, embedded analytics, and more.
-
Integrating GitHub Copilot CLI with IBM Informix 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 Flowise AI Agents to Live SAP ByDesign Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live SAP Business ByDesign without replication.
-
Automated MessageBird Data Replication to Teradata
Use CData Sync to Customize and automate MessageBird replication to Teradata.
-
Use the CData Software ODBC Driver for eBay in MicroStrategy
Connect to eBay in MicroStrategy Developer using the CData Software ODBC Driver for eBay.
-
Build Azure DevOps-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure DevOps and build Azure DevOps-connected web apps with Axios.
-
How to Access Live HubSpot Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HubSpot enables you to integrate HubSpot into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Wistia Data with Squirrel SQL client
Connect to Wistia and execute queries in the Squirrel SQL Client.
-
Provide OData Services of AlloyDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google AlloyDB by developing a WCF Service Application.
-
How to connect PolyBase to Act-On
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Act-On.
-
Integrate Live Billsby Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Billsby to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Getting Started with the CData ADO.NET Provider for eBay
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for eBay.