CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Connect AI Python SDK for Salesloft
Install the CData Connect AI Python SDK to read and write live Salesloft data with standard DB-API 2.0 Python code.
-
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 data into Java servlets: Use the Management Console in JBoss to install the JobNimbus JDBC Driver.
-
Connect to Jumpseller Data in Google Apps Script via Connect AI
Use CData Connect AI to access Jumpseller data in Google Apps Script.
-
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 data.
-
Connect to ServiceNow from a Connection Pool in WebLogic
Use the CData JDBC Driver for ServiceNow to connect to ServiceNow data 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 data in natural language using Python.
-
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 data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to BigCommerce Data in DBVisualizer
Integrate BigCommerce data 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 data in the Power Pivot business intelligence tool.
-
How to connect and process Deel data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Deel data.
-
Import and Visualize Klaviyo Data in Power View
Create data visualizations based on Klaviyo data in Excel.
-
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 data.
-
Getting Started with the CData Python Connector for Auth0
Learn to install and license the CData Python Connector and configure a connection to live Auth0 data.
-
Access Live Zuora Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zuora data 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 data 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 data replication to Couchbase.
-
Import Yelp Data Using Azure Data Factory
Use CData Connect AI to connect to Yelp Data from Azure Data Factory and import live Yelp data.
-
Create Data Visualizations Based On xBase Data in Mode
Use CData Connect AI to connect to xBase Data from Mode and build visualizations using live xBase data.
-
Getting Started with the CData Python Connector for Nethunt
Learn to install and license the CData Python Connector and configure a connection to live Nethunt data.
-
Connect to Google Tasks Data in Jaspersoft Studio
Execute SQL to remote Google Tasks data 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 data through MCP integration.
-
Build AfterShip-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 AfterShip data without replication.
-
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 data, 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 data to a database.
-
Visualize LDAP Objects in TIBCO Spotfire through OData
Integrate LDAP objects into dashboards in TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Optimizely
Provide connectivity to Optimizely data through an SAP BusinessObjects universe.
-
How to Connect to Live Google Ads 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 Google Ads data without replication.
-
Build Apps with Live Amazon Athena data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon Athena data into the Adalo platform and build custom mobile and web applications with real-time Amazon Athena data.
-
Visualize Wave Financial Data in TIBCO Spotfire through OData
Integrate Wave Financial data into dashboards in TIBCO Spotfire.
-
Connect to Live SendPulse Data in MicroStrategy through CData Connect AI
Create a live connection to SendPulse Data in CData Connect AI and connect to your SendPulse data from MicroStrategy.
-
Analyze Sage 300 Data in Looker
Use CData Connect AI to connect to Sage 300 Data from Looker and build custom apps using live Sage 300 data.
-
Connect to Reckon Accounts Hosted Data in DBArtisan
Use wizards in DBArtisan to configure Reckon Accounts Hosted data 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 data 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 data in MySQL .
-
Interact with Live Cassandra Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Cassandra data.
-
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 data 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 data 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 data 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 data.
-
Automated Continuous Pinecone Replication to SQLite
Use CData Sync for automated, continuous, customizable Pinecone replication to SQLite.
-
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 data 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 data into the Databricks platform and create visualization dashboards with real-time MYOB AccountRight data.
-
Connecting Pipedream with ZohoMarketingHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ZohoMarketingHub data in real time.
-
Build Agents in Relevance AI with Access to Live ShipEngine Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ShipEngine data within intelligent agent workflows.
-
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 data 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 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring iContact data in Excel.
-
Build Agents in Relevance AI with Access to Live SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SFTP data within intelligent agent workflows.
-
Query Stack Exchange Data in ColdFusion
Write standard ColdFusion data access code to connect to Stack Exchange data.
-
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.
-
Access Live PingOne Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PingOne data from your Excel spreadsheets.
-
Replicate Telegram Data from PowerShell
Write a quick PowerShell script to query Telegram data. Use connectivity to the live data to replicate Telegram data to SQL Server.
-
Easily Integrate HelloSign Data in Lazarus Pascal IDE
Learn how to easily integrate live HelloSign data 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 with IBM Informix 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.
-
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 ByDesign data without replication.
-
Automated MessageBird Data Replication to Teradata
Use CData Sync to Customize and automate MessageBird data replication to Teradata.
-
Use the CData Software ODBC Driver for eBay in MicroStrategy
Connect to eBay data 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 data 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 data into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Wistia Data with Squirrel SQL client
Connect to Wistia data 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 AlloyDB data 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 data.
-
Use Manus AI to Talk to Your Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Guru data.
-
Integrate Live Billsby Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Billsby data 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.
-
Build FreshBooks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live FreshBooks data and build visualizations in Tableau Cloud.
-
Automate Microsoft Dataverse Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Dataverse data replication to Azure Synapse.
-
Build Marketo-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Marketo Data and create custom apps in Bubble.
-
Model Timely Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Timely, enabling the direct import of real-time Timely data.
-
Establish a Live Connection with ZeroBounce Data using Tableau Bridge
The CData ODBC Driver for ZeroBounce enables you to integrate live ZeroBounce data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous QuickBooks Online Replication to Oracle
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Oracle.
-
Bridge NASA Connectivity with Apache NiFi
Access and process NASA data in Apache NiFi using the CData JDBC Driver.
-
Create SAP Business Warehouse-Connected Business Apps in AppSheet
Connect to SAP Business Warehouse Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Business Warehouse data.
-
Analyze Salesforce Pardot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Pardot data with the CData JDBC Driver for Salesforce Pardot.
-
How to Connect to Live Tally Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Tally data for you.
-
Integrate Real-Time Access to Excel Online in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Excel Online data in real time.
-
Analyze Amazon DynamoDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Amazon DynamoDB data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Real-Time Egnyte Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Egnyte data in Power Apps.
-
How to connect PolyBase to MySQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MySQL data.
-
Use the CData Software JDBC Driver for Grafana in MicroStrategy
Connect to Grafana data in MicroStrategy Developer using the CData Software JDBC Driver for Grafana.
-
Use the CData ODBC Driver for Sage Intacct in Microsoft Power Query
You can use the CData Sage Intacct ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage Intacct data into Microsoft Power Query.
-
Integrating GitHub Copilot with Moosend 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.
-
Automated Continuous Salesforce Marketing Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to delimited files (CSV/TSV).
-
Getting Started with the CData Tableau Connector for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft OneDrive.
-
Enable the Teamgate JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Teamgate data.
-
Connect to API 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 API data.
-
Access Live Google Sheets Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Sheets data into the statistical analysis tools available in SAS JMP. This article shows how to use Google Sheets data in the Graph Builder and Query Builder.
-
Integrate Open WebUI with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live LinkedIn data from within the chat interface.
-
Load Active Directory Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Active Directory data to a database.
-
Build Semantic Layer Views for Azure Table Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Table data.
-
How to import Snowflake Data into Apache Solr
Use the CData Software JDBC Driver for Snowflake in Data Import Handler and create an automated import of Snowflake data to Apache Solr Enterprise Search platform.