CData Software - Knowledge Base
Recent Articles
-
Integrating LangGraph with LDAP Objects via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on LDAP objects within automated workflows.
-
How to connect to Redis Data with Squirrel SQL client
Connect to Redis data and execute queries in the Squirrel SQL Client.
-
Viewing Moosend Data in RAD Studio Data Explorer
How to view Moosend data in RAD Studio Data Explorer using the CData ODBC Driver for Moosend.
-
Build SQL Analysis Services Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SQL Analysis Services data and build visualizations in Tableau Cloud.
-
Getting Started with the CData Excel Add-In for Calendly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Calendly.
-
Analyze Mode Data in Looker
Use CData Connect AI to connect to Mode Data from Looker and build custom apps using live Mode data.
-
Bridge CloudConvert Connectivity with Apache NiFi
Access and process CloudConvert data in Apache NiFi using the CData JDBC Driver.
-
Integrating Cursor with SQL Analysis Services 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.
-
Integrate OpenCode with Live Google Spanner Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Google Spanner data from within your AI coding agent.
-
Build a Singer.io Tap for Google Spanner With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Spanner data using the CData Python Connector.
-
Access Live BigQuery Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BigQuery data into the statistical analysis tools available in SAS JMP. This article shows how to use BigQuery data in the Graph Builder and Query Builder.
-
Build Automated Workflows with Live SharePoint Data in Workato
Use CData Connect AI to connect to live SharePoint data and build automated workflows in Workato.
-
Validate Salesforce Data 360 Data with QuerySurge
Access and validate Salesforce Data 360 data in QuerySurge using the CData JDBC Driver.
-
Create SSAS Tabular Models from Rebilly Data
How to build a SQL Server Analysis Service Tabular Model from Rebilly data using CData drivers.
-
A PostgreSQL Interface for Google Search Results (MySQL Remoting via JDBC)
Use the Remoting features of the Google Search JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Sybase IQ 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 Sybase IQ data for you.
-
Use Dash to Build Web Apps on Couchbase Data via CData Connect AI
Build interactive Dash web apps on live Couchbase data using pandas and the CData Connect AI Python SDK.
-
Connect to Perigon Data in Aqua Data Studio
Access Perigon data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect DBeaver to Aha! via a JDBC Driver
Manage Aha! data with visual tools in DBeaver like the query browser.
-
Integrating Codex with Freshdesk 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 Paymo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Paymo replication to Azure SQL Database.
-
Integrate Zoho Creator Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Creator data from Informatica Cloud.
-
Moving Data from Ontraport to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Ontraport data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Wistia 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 Wistia data without replication.
-
Integrating Bugsnag Data in Talend Cloud Data Management Platform
Connect Bugsnag Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Visualizations of Codat Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Codat data in Birst.
-
Use Microsoft Copilot Studio to talk to your Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Bitbucket data for you.
-
Connect to SAP Netweaver Gateway Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Netweaver Gateway data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Netweaver Gateway.
-
Use the CData SSIS Components to Insert New or Update Existing Reckon Records from SQL Server
Easily push SQL Server data to Reckon using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Reckon or update existing records with data from a SQL Server database.
-
Configuring ODBC Connections in Informatica on Linux
To connect to CData ODBC Drivers from Informatica on Linux, set the Driver Manager for Linux to unixODBC 2.3.x
-
Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy
Connect to eBay Analytics data in MicroStrategy Developer using the CData Software JDBC Driver for eBay Analytics.
-
How to Visualize ChartMogul Data in Python with pandas
Use pandas and other modules to analyze and visualize live ChartMogul data in Python.
-
Connect and Visualize Live Excel Online Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Excel Online data into the Databricks platform and create visualization dashboards with real-time Excel Online data.
-
Connect to ZeroBounce Data in Ruby
Connect to ZeroBounce data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
LINQ to Google Drive 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 Google Drive Data Provider.
-
Consume Adobe Commerce OData Feeds in PowerBuilder
This article demonstrates how to consume Adobe Commerce data as OData feeds from PowerBuilder using the API Server.
-
Create Nuclia Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Nuclia data access from reports, embedded analytics, and more.
-
Connecting Mastra with ADP 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 ADP data, no replication required.
-
Build Facebook-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Facebook Data from Zoho Analytics and import live Facebook data.
-
Configure the CData JDBC Driver for Pingdom in a Connection Pool in Tomcat
Connect to Pingdom data from a connection pool in Tomcat.
-
Analyze PostgreSQL Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PostgreSQL data in Microsoft R Open.
-
Build MVC Applications with Connectivity to Sage 200 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage 200 from an ASP.NET MVC application.
-
Query MessageBird Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MessageBird data from Node.js.
-
Integrating Gumloop with WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on WooCommerce data within automated workflows.
-
Moving Data from PolarTeamPro to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PolarTeamPro data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect DBeaver to Clio via a JDBC Driver
Manage Clio data with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Power BI Connector for HDFS
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for HDFS.
-
Automated Continuous Oracle Sales Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Google Cloud SQL.
-
Automated Continuous Zoho Books Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho Books replication to PostgreSQL.
-
How to connect and process Raisers Edge NXT data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Raisers Edge NXT data.
-
Integrating OpenCode with Harvest 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 LlamaIndex with Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Data Catalog data in real time.
-
Validate Asana Data with QuerySurge
Access and validate Asana data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Box Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Box replication to Amazon Redshift.
-
Getting Started with the CData ADO.NET Provider for Teamwork
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData ODBC Driver for Invoiced from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Invoiced to connect to Invoiced data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Invoiced data in Excel.
-
Access Jumpseller Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Jumpseller data from your Oracle system.
-
Migrating data from PagerDuty to Snowflake using CData SSIS Components.
Easily push PagerDuty data to Snowflake using the CData SSIS Tasks for PagerDuty and Snowflake.
-
View Reports on Real-Time Stack Exchange Data in Power BI Report Server
Use the CData ODBC Driver for Stack Exchange to visualize Stack Exchange data in Power BI Desktop and then publish them to Power BI Report Server.
-
Viewing SharePoint Data in RAD Studio Data Explorer
How to view SharePoint data in RAD Studio Data Explorer using the CData ODBC Driver for SharePoint.
-
Integrating Antigravity CLI with Databricks data via CData CLI
Connect Databricks data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Model Azure Synapse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Synapse, enabling the direct import of real-time Azure Synapse data.
-
Connect to Outreach.io Data from PowerBuilder via ADO.NET
This article demonstrates how to access Outreach.io data from Appeon PowerBuilder using the CData ADO.NET Provider for Outreach.io.
-
Build a Simple VCL Application for Paddle Data
How to build a simple VCL Application to view Paddle data in RAD Studio using the CData ODBC Driver for Paddle.
-
Use the CData Software JDBC Driver for Clio in MicroStrategy Web
Connect to Clio data in MicroStrategy Web using the CData Software JDBC Driver for Clio.
-
HCL Domino REST API Part 1: How to set up the environment
The first article in an article series that goes over the HCL Domino REST API. This article is a guide for how to get started with and setup the Domino REST API.
-
Build Charts with WordPress Data in Clear Analytics
Create dynamic charts and perform analytics based on WordPress data in Clear Analytics.
-
Visualize Tally Data in TIBCO Spotfire through ADO.NET
Integrate Tally data into dashboards in TIBCO Spotfire.
-
Automate Reply.io Data Replication to SAP HANA
Use CData Sync to customize and automate Reply.io data replication to SAP HANA.
-
Visualize Rebilly Data in Tableau
The CData ODBC driver for Rebilly enables you integrate Rebilly data into Tableau dashboards.
-
Query SAP BusinessObjects BI Data as a MySQL Database in Node.js
Execute MySQL queries against SAP BusinessObjects BI data from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for Bugsnag
Create Bugsnag data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Live Wistia Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Wistia data into custom reports in Power BI.
-
Create Twilio-Connected Applications in Appsmith
Connect to Twilio Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Twilio data.
-
How to Work with Front Data in AWS Glue Jobs Using JDBC
Connect to Front from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Charts with Amazon DynamoDB Data in Clear Analytics
Create dynamic charts and perform analytics based on Amazon DynamoDB data in Clear Analytics.
-
Build AI/ML Models with Live ChartMogul Data using Dataiku
Connect ChartMogul Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Live Brex Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Brex data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Apps with Live Parquet Data Using the Low-Code Development Platform of Mendix
Connect Parquet data with Mendix to build apps using the CData JDBC Driver for Parquet.
-
Use Microsoft Copilot Studio to talk to your Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Planner data for you.
-
Use the CData ODBC Driver for Freshservice from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Freshservice to connect to Freshservice data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Freshservice data in Excel.
-
How to Create Power BI Visual Reports with Real-Time Act CRM Data
Use CData Power BI Connectors to visualize Act CRM data in Power BI.
-
Use the CData Software ODBC Driver for ZohoPeople in MicroStrategy
Connect to ZohoPeople data in MicroStrategy Developer using the CData Software ODBC Driver for ZohoPeople.
-
Analyze Square Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Square data in Microsoft R Open.
-
Integrate Live Cvent Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cvent from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Cvent data.
-
Build a Singer.io Tap for ADP With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ADP data using the CData Python Connector.
-
Access Live Sugar CRM Data in Excel 365 Online (Excel for the web)
Connect to Sugar CRM data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Perigon Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Perigon replication to Google Cloud SQL.
-
Stream Facebook Data into Apache Kafka Topics
Access and stream Facebook data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Load Stripe Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Stripe data to a database.
-
Connect to Jira Assets Data from AWS Glue
Use CData Connect AI to gain access to live Jira Assets data from your AWS Glue jobs.
-
Build Oracle Service Cloud Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Service Cloud data and build visualizations in Tableau.
-
Connect to Real-Time Miro Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Miro data in Power Apps.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Netweaver Gateway
Create SAP Netweaver Gateway data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Sage Cloud Accounting Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage Cloud Accounting data from Node.js.
-
A PostgreSQL Interface for Reckon Accounts Hosted Data (MySQL Remoting via JDBC)
Use the Remoting features of the Reckon Accounts Hosted JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to XML 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 XML data.
-
Consume Amazon DynamoDB OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon DynamoDB data as OData feeds from PowerBuilder using the API Server.
-
Build AI/ML Models with Live REST Data using Dataiku
Connect REST Data with Dataiku using the CData JDBC Driver for REST.
-
Integrate Goose with Live Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Figshare data from within the local AI agent.