CData Software - Knowledge Base
Recent Articles
-
Access Autopilot 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 Autopilot.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Freshservice within intelligent workflows.
-
Replicate Multiple Testmonitor Accounts via the CData Sync CLI
Replicate multiple Testmonitor accounts to one or many databases.
-
Build Email-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Email Data and create custom apps in Mendix.
-
How to Connect to Live Redis 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 Redis for you.
-
How to Connect to Live Highrise 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 Highrise CRM for you.
-
Add Microsoft OneDrive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft OneDrive with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Work with Acumatica Data in ETL Validator JDBC
Connect to Acumatica from ETL Validator jobs using the CData Software JDBC Driver.
-
Explore Geographical Relationships in SAP Hybris C4C Data with Power Map
Create data visualizations with SAP Hybris C4C in Power Map.
-
Build AI Agents with Xero Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Xero Accounting through CData Connect AI.
-
Analyze Cosmos DB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure Cosmos DB in Microsoft R Open.
-
Connecting Mastra with Cloudant 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 IBM Cloudant, no replication required.
-
Automated Continuous Zoom Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoom replication to Google BigQuery.
-
Consume SFTP OData Feeds in PowerBuilder
This article demonstrates how to consume SFTP as OData feeds from PowerBuilder using the API Server.
-
Connect to LinkedIn Data in ACL Analytics
Connect to LinkedIn via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to LinkedIn.
-
How to Work with Microsoft OneDrive Data in ETL Validator JDBC
Connect to Microsoft OneDrive from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Paymo Data in DBArtisan
Use wizards in DBArtisan to configure Paymo as a data source.
-
Automated Continuous BambooHR Replication to MySQL
Use CData Sync for automated, continuous, customizable BambooHR replication to MySQL.
-
Connect to Google Contacts Data in Aqua Data Studio
Access Google Contacts from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Paddle Data in Aqua Data Studio
Access Paddle from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Planio from a Connection Pool in WebLogic
Use the CData JDBC Driver for Planio to connect to Planio from Web applications running on WebLogic.
-
Model, Search, and Visualize Live Dynamics 365 Business Central Data in ThoughtSpot
Use CData Connect AI to connect to live Dynamics 365 Business Central for modeling, searching, and visualizing.
-
Publish Paddle-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Paddle.
-
Integrating Claude Code CLI with ZeroBounce 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.
-
Publish HBase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache HBase.
-
How to Query Live VWO Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live VWO data in natural language using Python.
-
Integrate Insightly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Insightly from Informatica Cloud.
-
Migrating data from Mistral AI to Databricks using CData SSIS Components.
Easily push Mistral AI to Databricks using the CData SSIS Tasks for Mistral AI and Databricks.
-
DataBind Stripe Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Stripe with the DevExpress Windows Forms and Web controls to provide Stripe to a chart.
-
Publish Crystal Reports on ConvertKit Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ConvertKit.
-
Integrating Cursor CLI with Campaigner 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.
-
Getting Started with the CData ADO.NET Provider for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft Teams.
-
Integrate with Vimeo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Vimeo to a JSON file on disk.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Spanner
Provide connectivity to Google Spanner through an SAP BusinessObjects universe.
-
Create Snowflake-Connected Nintex Workflows
Use CData Connect AI to connect to Snowflake Data from Nintex Workflow Cloud and build custom workflows using live Snowflake.
-
Visualize Slack Data in TIBCO Spotfire through ADO.NET
Integrate Slack into dashboards in TIBCO Spotfire.
-
Build Semantic Layer Views for ZendeskSell Data in APOS Live Data Gateway
Use the CData Connector for ZendeskSell in APOS Live Data Gateway to build Semantic Layer Views for ZendeskSell.
-
Create Data Visualizations in Cognos BI with Teradata Data
Access Teradata as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Explore Geographical Relationships in Flowlu Data with Power Map
Create data visualizations with Flowlu in Power Map.
-
Build a Singer.io Tap for Placid With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Placid data using
-
Automated Continuous Salesforce Marketing Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to MySQL.
-
How to Connect to & Open Google Search Results in Microsoft Excel
This article uses the CData ODBC driver for Google Search to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Cassandra Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Cassandra replication to Google Cloud SQL.
-
Automate Couchbase Data Replication to SAP HANA
Use CData Sync to customize and automate Couchbase replication to SAP HANA.
-
Import SQL Analysis Services Data Using Azure Data Factory
Use CData Connect AI to connect to SQL Analysis Services Data from Azure Data Factory and import live SQL Analysis Services.
-
Extend Google Sheets with LDAP Objects
Make calls to LDAP from Google Apps Script via the API Server.
-
Connect to Avro Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Avro Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Hugging Face Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Hugging Face.
-
How to Connect the Power BI Service to Clari: Complete Guide
Connect to the CData Software Power BI Connector for Clari from PowerBI.com to provide real-time Clari across the organization.
-
Visualize Brex Data in TIBCO Spotfire through ADO.NET
Integrate Brex into dashboards in TIBCO Spotfire.
-
Connect to Campaigner Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Campaigner in the Denodo Virtual DataPort Administrator.
-
How to Create Power BI Visual Reports with Real-Time Sage Cloud Accounting Data
Use CData Power BI Connectors to visualize Sage Business Cloud Accounting in Power BI.
-
Analyze MariaDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MariaDB and visualize live MariaDB in Infragistics Reveal.
-
Create Spark-Connected Business Apps in AppSheet
Connect to Spark Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Spark SQL.
-
Use Dash to Build to Web Apps on ZohoPeople Data
Create Python applications that use pandas and Dash to build ZohoPeople-connected web apps.
-
Write a Simple Go Application to work with Mixpanel Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mixpanel.
-
Build Dashboards with HelloSign Data in DBxtra
Create dynamic dashboards and perform analytics based on HelloSign in DBxtra.
-
Build a Simple VCL Application for Salesforce CRM Analytics Data
How to build a simple VCL Application to view Salesforce CRM Analytics in RAD Studio using the CData ODBC Driver for Salesforce CRM Analytics.
-
Integrate with Stripe Data in JReport Designer
Create charts and reports based on Stripe in JReport Designer.
-
Connect to Vercel Data in DBeaver
Use the CData ODBC Driver to connect to Vercel in DBeaver.
-
Publish Reports with Elasticsearch Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Elasticsearch.
-
Getting Started with the CData ADO.NET Provider for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Adobe Analytics.
-
Publish Crystal Reports on Cohere Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Cohere.
-
Connect to Klaviyo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Query Billsby Data in MySQL Workbench
Execute MySQL queries against live Billsby from MySQL Workbench.
-
Build a PostgreSQL Interface for Supabase Data using the CData JDBC Driver
Use the Remoting features of the Supabase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query ZohoExpense Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoExpense from Node.js.
-
Integrating LlamaIndex with CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on CSV/TSV Files in real time.
-
Automated Continuous LinkedIn Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to IBM DB2.
-
Query Live Zoho Inventory Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Zoho Inventory directly from the development environment.
-
How to Work with Telegram Data in AWS Glue Jobs Using JDBC
Connect to Telegram from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Edit and Search Azure Data Lake Storage External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Azure Data Lake Storage to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Azure Data Lake Storage objects that you can access from apps and the dashboard.
-
Connect to Insightly Data in NetBeans
Connect to Insightly in NetBeans with the data source configuration wizard.
-
Build Oracle Sales-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle Sales.
-
Import Real-Time Contentful Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Contentful in ColdFusion.
-
Automated Continuous SQL Server Replication to Databricks
Use CData Sync for automated, continuous, customizable SQL Server replication to Databricks.
-
Connect to Gorgias Data from PowerBuilder via JDBC
This article demonstrates how to access Gorgias from PowerBuilder using the Gorgias JDBC Driver.
-
Connect to Webex Data from PowerBuilder via ADO.NET
This article demonstrates how to access Webex from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating Yelp Data in Talend Cloud Data Management Platform
Connect Yelp Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to ShipStation Data in RapidMiner
Integrate ShipStation with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for Yelp in MicroStrategy
Connect to Yelp in MicroStrategy Developer using the CData Software ODBC Driver for Yelp.
-
Integrating LangChain with Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Table Storage within automated workflows.
-
Excel Spreadsheet Automation on Perplexity Data with the QUERY Formula
Pull data from Perplexity, automate spreadsheets, and more with the QUERY formula.
-
LINQ to Pipeline CRM 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 Pipeline CRM Data Provider.
-
Visualize Acumatica Data in Sisense
Create an ElastiCube in Sisense app with access to Acumatica ERP.
-
View Reports on Real-Time Campaigner Data in Power BI Report Server
Use the CData ODBC Driver for Campaigner to visualize Campaigner in Power BI Desktop and then publish them to Power BI Report Server.
-
How to create Clari federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Clari in MySQL .
-
How to Access Live QuickBooks Online Data in Visual Studio Code via Cline
Run CData MCP Server for QuickBooks Online on Windows Subsytem for Linux (WSL) and connect to live QuickBooks Online from the Cline extension in Visual Studio Code.
-
Integrate Real-Time Access to Sugar CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sugar CRM in real time.
-
Natively Connect to Intercom Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Intercom. Leverage the native support for ODBC in PHP.
-
Build Apps with Live Microsoft Dataverse (CDS) in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Dataverse (CDS) into the Adalo platform and build custom mobile and web applications with real-time Microsoft Dataverse (CDS).
-
Connect to Exa Data from a Connection Pool in JBoss
Integrate Exa into Java servlets: Use the Management Console in JBoss to install the Exa JDBC Driver.
-
Connect to Excel Online from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Excel Online, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to TaxJar Data from Spring Boot
Connect to TaxJar in a Spring Boot Application using the CData JDBC Driver for TaxJar
-
How to Query Live JobNimbus Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live JobNimbus data in natural language using Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Facebook Ads within intelligent workflows.
-
How to connect to Wrike Data in DBVisualizer
Integrate Wrike with visual data analysis tools and data connection wizards in DBVisualizer
-
Load Certinia Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Certinia to a database.
-
Access Live Procore Data in Coginiti Pro
Connect to and query live Procore from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData ODBC Driver for Attio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Attio.