CData Software - Knowledge Base
Recent Articles
-
Integrating LangChain with Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Shippo data within automated workflows.
-
Use the CData Software ODBC Driver for ScrapingBee in MicroStrategy Desktop
Connect to ScrapingBee data in MicroStrategy Desktop using the CData Software ODBC Driver for ScrapingBee.
-
Analyze Shippo Data in Looker
Use CData Connect AI to connect to Shippo Data from Looker and build custom apps using live Shippo data.
-
Connect to Real-Time Perplexity Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Perplexity data in Power Apps.
-
Build Data Flows from Blackbaud FE NXT to SQL Server using SSIS
Easily back up Blackbaud FE NXT data to SQL Server using the SSIS components for Blackbaud FE NXT.
-
Getting Started with the CData Tableau Connector for SendInBlue
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect and process Avro data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Avro data.
-
Access Live ServiceNow Data in Coginiti Pro
Connect to and query live ServiceNow data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Prepare, Blend, and Analyze SAP HANA XS Advanced Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP HANA XS Advanced data for self-service data analytics.
-
Integrate Campaigner Data in Pentaho Data Integration
Build ETL pipelines based on Campaigner data in the Pentaho Data Integration tool.
-
Replicate Miro Data in Heroku for Use in Salesforce Connect
Replicate Miro data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Work with Blackbaud FE NXT Data in FoxPro
Load Blackbaud FE NXT data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Google Sheets from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Sheets to connect to Google Sheets data from Web applications running on WebLogic.
-
Connecting GenSpark with SAP Business Warehouse Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Business Warehouse data without any replication or custom integration required.
-
Replicate Multiple GitLab Accounts
Replicate multiple GitLab accounts to one or many databases.
-
Connect to Tickspot Data in Ruby
Connect to Tickspot data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Rapidly Develop Float-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 Float.
-
Use the CData Software ODBC Driver for CockroachDB in SAS for Real-Time Reporting and Analytics
Connect to real-time CockroachDB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CockroachDB.
-
Connect to IBM Cloud Object Storage Data in Ruby
Connect to IBM Cloud Object Storage data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Add Foursquare Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Foursquare with the Informatica Enterprise Data Catalog to classify and organize data.
-
Excel Spreadsheet Automation on Gong Data with the QUERY Formula
Pull data from Gong, automate spreadsheets, and more with the QUERY formula.
-
How to connect PolyBase to Amazon Marketplace
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon Marketplace data.
-
Connect to eBay Data as an External Source in Dremio
Use the CData JDBC Driver to connect to eBay as an External Source in Dremio.
-
Connect to Pinecone Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pinecone data.
-
How to Visualize Dynamics NAV Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dynamics NAV data in Python.
-
Integrating SAP Ariba Procurement Data in Talend Cloud Data Management Platform
Connect SAP Ariba Procurement Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Ariba Procurement.
-
Deploy the ADO.NET Provider for LDAP on an SSRS Report Server
Connect to LDAP objects 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.
-
Choosing the Best Method to Connect JobNimbus to SQL Server: 5 Options Explained
Discover multiple ways to connect and use JobNimbus data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to PingOne Data in RapidMiner
Integrate PingOne data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create an RPA flow for Telegram Data in UiPath Studio
Use the Telegram ODBC Driver to create workflows that access real-time Telegram data without any coding.
-
Import Real-Time ZohoInvoice Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoInvoice data in ColdFusion.
-
Build Asana-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Asana Data and create custom apps in Mendix.
-
Use the CData Software JDBC Driver for Hugging Face in MicroStrategy Desktop
Connect to Hugging Face data in MicroStrategy Desktop using the CData Software JDBC Driver for Hugging Face.
-
Connecting Pipedream with Square 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 Square data in real time.
-
Integrate Google's Vertex AI Agent with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Ads data within intelligent workflows.
-
Edit and Search External Salesloft Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Salesloft data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Salesloft Data objects that you can access from apps and the dashboard.
-
Build Adobe Target-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Adobe Target Data from Zoho Analytics and import live Adobe Target data.
-
Connect to Amazon Marketplace Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Amazon Marketplace data from Filemaker Pro on Mac.
-
Connect to Placid Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Placid and the SQL Gateway to access Placid data from Google Apps Script.
-
Build Agents in Relevance AI with Access to Live SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Fieldglass data within intelligent agent workflows.
-
How to Connect DBeaver to Opsgenie via a JDBC Driver
Manage Opsgenie data with visual tools in DBeaver like the query browser.
-
Build Charts with Kintone Data in Clear Analytics
Create dynamic charts and perform analytics based on Kintone data in Clear Analytics.
-
Write a Simple Go Application to work with Trello Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Trello data.
-
Visualize Campaigner Data in Sisense
Create an ElastiCube in Sisense app with access to Campaigner data.
-
Connect to Sage 200 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sage 200 Data and connect to Sage 200 data in Akorbi Digital RunMyProcess.
-
Access Live Tavily Data in Coginiti Pro
Connect to and query live Tavily data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query Salesforce Pardot Data as a MySQL Database in Node.js
Execute MySQL queries against Salesforce Pardot data from Node.js.
-
Connect to Stripe Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Stripe Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use Dash to Build Web Apps on Highrise Data via CData Connect AI
Build interactive Dash web apps on live Highrise data using pandas and the CData Connect AI Python SDK.
-
Connect to Azure Data Catalog Data from a Connection Pool in Jetty
The Azure Data Catalog JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Data Catalog data from Web apps in Jetty.
-
Access Paymo 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 Paymo data.
-
Integrating GitHub Copilot with Adobe Analytics 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 Easily Query Google Forms Data in OpenOffice Base
Connect to Google Forms data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Analyze Sage Cloud Accounting Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sage Cloud Accounting data with the CData JDBC Driver for Sage Cloud Accounting.
-
Query Salesforce Data as a MySQL Database in Node.js
Execute MySQL queries against Salesforce data from Node.js.
-
Build Hugging Face-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Hugging Face data and build web apps with connectivity to live Hugging Face data.
-
Connect to SAP Business One Data in Jaspersoft Studio
Execute SQL to remote SAP Business One data in Jaspersoft Studio.
-
Use Manus AI to Talk to Your Avalara AvaTax 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 Avalara AvaTax data.
-
Visualize MailerSend Data in Sisense
Create an ElastiCube in Sisense app with access to MailerSend data.
-
Build Apps with Live Paymo data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Paymo data into the Adalo platform and build custom mobile and web applications with real-time Paymo data.
-
How to Connect to Live ZohoExpense 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 ZohoExpense data for you.
-
Link ChargeOver with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ChargeOver data in Filemaker Pro for Mac or Windows.
-
Connect to Real-Time Rebilly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Rebilly data in Power Apps.
-
Create Datasets from Cloudflare in Domo Workbench and Build Visualizations of Cloudflare Data in Domo
Use the CData Software ODBC Driver for Cloudflare to create datasets from Cloudflare data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Live Oracle Sales Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle Sales data to Blue Prism using the CData ODBC Driver for Oracle Sales to create automated workflows for repetitive business tasks.
-
Analyze Basecamp Data in Cognos Analytics
Use CData Connect AI to connect to Basecamp Data from Cognos Analytics and analyze live Basecamp data.
-
Build Automated Workflows with Live Pipedrive Data in Workato
Use CData Connect AI to connect to live Pipedrive data and build automated workflows in Workato.
-
Work with Live Active Directory Data in Power Query
Use CData Connect AI to connect to Active Directory data and work with live Active Directory data in Microsoft Power Query.
-
Access Live Microsoft Planner Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Planner data from your Excel spreadsheets.
-
Access Trello Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Trello data from your Oracle system.
-
Create Placid Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Placid from PowerBI.com to create Power BI Dataflows with real-time data.
-
Supporting CDC from a Oracle Multitenant Deployment with CData Sync
A basic guide to configuring CDC for a Oracle Multitenant Database Instance as a source in CData Sync.
-
Connect to Real-Time SAP Fieldglass Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP Fieldglass and Dataflow to import and use SAP Fieldglass data in Power Apps.
-
Access Bullhorn CRM Data from MySQL in PHP
Connect to Bullhorn CRM through the standard MySQL libraries in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Notion
Provide connectivity to Notion data through an SAP BusinessObjects universe.
-
Connect SAP SuccessFactors LMS to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP SuccessFactors LMS data using the CData Python MCP Server.
-
Integrate Goose with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Facebook Ads data from within the local AI agent.
-
Automated Continuous Unbounce Replication to Databricks
Use CData Sync for automated, continuous, customizable Unbounce replication to Databricks.
-
Connect to Sugar CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Sugar CRM data from HeidiSQL.
-
Operational Reporting on Google Cloud Storage Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Cloud Storage data.
-
Use the CData Software ODBC Driver for Shortcut in MicroStrategy Desktop
Connect to Shortcut data in MicroStrategy Desktop using the CData Software ODBC Driver for Shortcut.
-
Model, Search, and Visualize Live Notion Data in ThoughtSpot
Use CData Connect AI to connect to live Notion data for modeling, searching, and visualizing.
-
Build Zoom-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 Zoom data without replication.
-
How to connect SharePoint with SingleStore Data through external lists
Provide SingleStore data to SharePoint users as an external list.
-
Build a Simple VCL Application for ZohoDesk Data
How to build a simple VCL Application to view ZohoDesk data in RAD Studio using the CData ODBC Driver for ZohoDesk.
-
Search External Aweber Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Aweber data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Aweber Data objects that you can access from apps and the dashboard.
-
Migrating data from Microsoft Planner to Google BigQuery using CData SSIS Components.
Easily push Microsoft Planner data to Google BigQuery using the CData SSIS Tasks for Microsoft Planner and Google BigQuery.
-
Access Live Helpscout Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Helpscout data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous ZohoMarketingHub Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Apache Cassandra.
-
How to Connect Flowise AI Agents to Live QuickBooks Online 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 QuickBooks Online data without replication.
-
Integrate FreshBooks Data into Power Automate Desktop using CData Connect
CData Connect for FreshBooks Data enables you to integrate FreshBooks data into workflows built using Microsoft Power Automate Desktop.
-
How to connect PolyBase to ActiveCampaign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ActiveCampaign data.
-
Visualize CockroachDB Data in Sisense
Create an ElastiCube in Sisense app with access to CockroachDB data.
-
Visualize Live SendGrid Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SendGrid data into custom reports in Power BI.
-
Integrate SAP Netweaver Gateway with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Netweaver Gateway with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Netweaver Gateway data.
-
Build NetSuite SuiteAnalytics-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Zoho Analytics and import live NetSuite SuiteAnalytics data.
-
Automated Continuous Simplesat Replication to SQLite
Use CData Sync for automated, continuous, customizable Simplesat replication to SQLite.
-
Publish Google Translate-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Translate data.
-
Prepare, Blend, and Analyze SendPulse Data in Alteryx Designer (Connect AI)
Build workflows to access live SendPulse data for self-service data analytics.
-
Bridge Microsoft Ads Connectivity with Apache NiFi
Access and process Microsoft Ads data in Apache NiFi using the CData JDBC Driver.