CData Software - Knowledge Base
Recent Articles
-
Use Agno to Talk to Your Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Bright Data data for you.
-
Use Microsoft Copilot Studio to talk to your GetResponse 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 GetResponse data for you.
-
Integrating Cursor with DocuSign 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.
-
Work with Freshsales Data in FoxPro
Load Freshsales data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to and Query Printful Data in QlikView over ODBC
Create data visualizations with Printful data in QlikView.
-
Connect to Oracle SCM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle SCM data in Google Apps Script.
-
Query Redshift Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Redshift entities in PHP by modeling them as objects.
-
Operational Reporting on Productboard Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Productboard data.
-
Automated Continuous Paymo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Paymo replication to Google BigQuery.
-
Automated Continuous Flowlu Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Flowlu replication to IBM DB2.
-
Connect to Excel Online Data from PowerBuilder via JDBC
This article demonstrates how to access Excel Online data from PowerBuilder using the Excel Online JDBC Driver.
-
Integrate Auth0 Data in Pentaho Data Integration
Build ETL pipelines based on Auth0 data in the Pentaho Data Integration tool.
-
View Reports on Real-Time SAP SuccessFactors LMS Data in Power BI Report Server
Use the CData ODBC Driver for SAP SuccessFactors LMS to visualize SAP SuccessFactors LMS data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Biml to Build SSIS Tasks to Replicate Oracle HCM Cloud Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle HCM Cloud data to SQL Server.
-
How to Connect Flowise AI Agents to Live Tally 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 Tally data without replication.
-
Integrate Goose with Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Salesforce Pardot data from within the local AI agent.
-
How to connect to Telegram Data with Squirrel SQL client
Connect to Telegram data and execute queries in the Squirrel SQL Client.
-
Integrate Dify with Live SendGrid Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SendGrid data.
-
Connect to LinkedIn Ads Data from a Connection Pool in Jetty
The LinkedIn Ads JDBC Driver supports connection pooling: This article shows how to connect faster to LinkedIn Ads data from Web apps in Jetty.
-
How to integrate Bannerbear with Apache Airflow
Access and process Bannerbear data in Apache Airflow using the CData JDBC Driver.
-
Automate DB2 for i Data Replication to Azure Synapse
Use CData Sync to customize and automate DB2 for i data replication to Azure Synapse.
-
Integrate Cursor with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Gmail data from within the editor.
-
Establish a Live Connection with SAP Ariba Procurement Data using Tableau Bridge
The CData ODBC Driver for SAP Ariba Procurement enables you to integrate live SAP Ariba Procurement data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to SAS xpt Data from HeidiSQL
Use CData Connect AI to connect to and query live SAS xpt data from HeidiSQL.
-
Natively Connect to Greenhouse Data in PHP
The CData ODBC driver for Greenhouse enables you to create PHP applications with connectivity to Greenhouse data. Leverage the native support for ODBC in PHP.
-
Replicate Teradata Data from PowerShell
Write a quick PowerShell script to query Teradata data. Use connectivity to the live data to replicate Teradata data to SQL Server.
-
Stream Oracle Eloqua Data into Apache Kafka Topics
Access and stream Oracle Eloqua data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous GitLab Replication to SQL Server
Use CData Sync for automated, continuous, customizable GitLab replication to SQL Server.
-
Connect to Reckon Accounts Hosted Data from PowerBuilder via JDBC
This article demonstrates how to access Reckon Accounts Hosted data from PowerBuilder using the Reckon Accounts Hosted JDBC Driver.
-
Replicate Redis Data in Heroku for Use in Salesforce Connect
Replicate Redis data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Zuora from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zuora to connect to Zuora data from Web applications running on WebLogic.
-
Replicate XML Data to Multiple Databases via the CData Sync CLI
Replicate XML data to disparate databases with a single configuration.
-
Connecting GenSpark with Oracle SCM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle SCM data without any replication or custom integration required.
-
Connect to Pushbullet from Asprova with CData Software ODBC Driver for Pushbullet
This article shows how to connect faster to Pushbullet data from Asprova.
-
Create Power BI Reports on Real-Time Zoho Projects Data
Use the CData ODBC Driver for Zoho Projects to visualize Zoho Projects data in Power BI Desktop.
-
Connecting Agentforce with BigQuery Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your BigQuery data for you.
-
How to Access Live SAP Concur Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Concur enables you to integrate SAP Concur data into workflows built using Microsoft Power Automate Desktop.
-
Build AI Agents with AgileCRM 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 AgileCRM data through CData Connect AI.
-
Automated Continuous Zoho Recruit Replication to MySQL
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to MySQL.
-
Automated Continuous Samanage Replication to Databricks
Use CData Sync for automated, continuous, customizable Samanage replication to Databricks.
-
Visualize IBM Cloud Object Storage Data in TIBCO Spotfire through OData
Integrate IBM Cloud Object Storage data into dashboards in TIBCO Spotfire.
-
Automated Continuous Quickbase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Quickbase replication to delimited files (CSV/TSV).
-
Process & Analyze Invoiced Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Invoiced Data.
-
How to Use a Microsoft Access Database to Update Amazon DynamoDB Data in Real Time
Update Amazon DynamoDB data by creating a linked table in Microsoft Access with the CData Amazon DynamoDB ODBC Driver.
-
Connect to Helpscout Data in RazorSQL
Connect to Helpscout from wizards and query Helpscout data from the GUI in the RazorSQL database management tool.
-
Access MailerSend Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MailerSend data from your Oracle system.
-
How to connect to Bugsnag Data with Squirrel SQL client
Connect to Bugsnag data and execute queries in the Squirrel SQL Client.
-
Replicate Quaderno Data from PowerShell
Write a quick PowerShell script to query Quaderno data. Use connectivity to the live data to replicate Quaderno data to SQL Server.
-
Build a Simple VCL Application for Sage Cloud Accounting Data
How to build a simple VCL Application to view Sage Cloud Accounting data in RAD Studio using the CData ODBC Driver for Sage Cloud Accounting.
-
How to Connect to & Open IBM Informix Data in Microsoft Excel
This article uses the CData ODBC driver for IBM Informix to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Paylocity Data from MySQL in PHP
Connect to Paylocity through the standard MySQL libraries in PHP.
-
Visualize PabblySubscriptions Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load PabblySubscriptions data into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Hacker News in MicroStrategy Web
Connect to Hacker News data in MicroStrategy Web using the CData Software JDBC Driver for Hacker News.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for IBM Cloud Object Storage
Provide connectivity to IBM Cloud Object Storage data through an SAP BusinessObjects universe.
-
Connect to MailChimp Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MailChimp data.
-
Integrate with Xero Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Xero data in SnapLogic.
-
Automate CampaignMonitor Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CampaignMonitor data from PowerShell? This article demonstrates how to utilize the CampaignMonitor Cmdlets for tasks like connecting to CampaignMonitor data, automating operations, downloading data, and more.
-
Create Timely-Connected Business Apps in AppSheet
Connect to Timely Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Timely data.
-
How to Access Act-On Data Using Entity Framework
This article shows how to access Act-On data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Salesforce Data 360 Data from AWS Glue
Use CData Connect AI to gain access to live Salesforce Data 360 data from your AWS Glue jobs.
-
How to Use a Microsoft Access Database to Update GitHub Data in Real Time
Update GitHub data by creating a linked table in Microsoft Access with the CData GitHub ODBC Driver.
-
Connect to Cloudflare Data from PowerBuilder via JDBC
This article demonstrates how to access Cloudflare data from PowerBuilder using the Cloudflare JDBC Driver.
-
Connect to SAP HANA XS Advanced in SpagoBI
Create reports featuring live SAP HANA XS Advanced data in SpagoBI Studio. Host SAP HANA XS Advanced reports on SpagoBI Server.
-
How to create Reckon federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Reckon data in MySQL .
-
DataBind Charts to Ontraport Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Ontraport data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use Grok to Talk to Your MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your MongoDB data for you.
-
Automated Continuous Avaza Replication to SQLite
Use CData Sync for automated, continuous, customizable Avaza replication to SQLite.
-
How to Work with Blackbaud FE NXT Data in AWS Glue Jobs Using JDBC
Connect to Blackbaud FE NXT from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Antigravity CLI with Flowlu data via CData CLI
Connect Flowlu data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Establish a Live Connection with IBM Cloud Object Storage Data using Tableau Bridge
The CData ODBC Driver for IBM Cloud Object Storage enables you to integrate live IBM Cloud Object Storage data into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish Deel-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Deel data.
-
Analyze Coda Data in Looker
Use CData Connect AI to connect to Coda Data from Looker and build custom apps using live Coda data.
-
Search External Freshservice Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Freshservice data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Freshservice Data objects that you can access from apps and the dashboard.
-
How to load ZohoDesk data into Elasticsearch via Logstash
Introducing a simple method to load ZohoDesk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Quaderno Data from MySQL in Amazon QuickSight
Connect to Quaderno and build visualizations of Quaderno data using a MySQL Connection in Amazon QuickSight.
-
Create Dashboards and Visualize Live Avro Data in Geckoboard
Use CData Connect AI to connect to live Avro data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData SSIS Components to Insert New or Update Existing CouchDB Records from SQL Server
Easily push SQL Server data to CouchDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into CouchDB or update existing records with data from a SQL Server database.
-
View Reports on Real-Time JotForm Data in Power BI Report Server
Use the CData ODBC Driver for JotForm to visualize JotForm data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Insightly
Provide connectivity to Insightly data through an SAP BusinessObjects universe.
-
Seamlessly Bring HBase Data into Retool Using CData Connect AI
Integrate HBase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Prepare, Blend, and Analyze Epicor Kinetic Data in Alteryx Designer (Connect AI)
Build workflows to access live Epicor Kinetic data for self-service data analytics.
-
Automated Continuous Sugar CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Google Cloud SQL.
-
Getting Started with the CData JDBC Driver for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Snapchat Ads.
-
Connect to Mailgun Data from HeidiSQL
Use CData Connect AI to connect to and query live Mailgun data from HeidiSQL.
-
Connect to PolarTeamPro Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PolarTeamPro data using standard SQL.
-
Automated Continuous Postmark Replication to SQLite
Use CData Sync for automated, continuous, customizable Postmark replication to SQLite.
-
Create a Data Access Object for Tickspot Data using JDBI
A brief overview of creating a SQL Object API for Tickspot data in JDBI.
-
Automated Continuous Hugging Face Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Hugging Face replication to Apache Cassandra.
-
Migrating data from OneNote to Snowflake using CData SSIS Components.
Easily push OneNote data to Snowflake using the CData SSIS Tasks for OneNote and Snowflake.
-
Automated SAP HANA XS Advanced Data Replication to Teradata
Use CData Sync to Customize and automate SAP HANA XS Advanced data replication to Teradata.
-
Automated Continuous Vault CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Vault CRM replication to PostgreSQL.
-
Create SSAS Tabular Models from Opsgenie Data
How to build a SQL Server Analysis Service Tabular Model from Opsgenie data using CData drivers.
-
Create Reports with OnePageCrm Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OnePageCrm data.
-
Connect and Visualize Live Facebook Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Facebook data into the Databricks platform and create visualization dashboards with real-time Facebook data.
-
Connect to Kafka Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Kafka data using standard SQL.
-
Connect to Box Data from HeidiSQL
Use CData Connect AI to connect to and query live Box data from HeidiSQL.
-
Build Semantic Layer Views for MariaDB Data in APOS Live Data Gateway
Use the CData Connector for MariaDB in APOS Live Data Gateway to build Semantic Layer Views for MariaDB data.
-
Integrate Browserless Data in Pentaho Data Integration
Build ETL pipelines based on Browserless data in the Pentaho Data Integration tool.
-
How to Connect DBeaver to Guru via a JDBC Driver
Manage Guru data with visual tools in DBeaver like the query browser.
-
Analyze Spotify Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Spotify data in Microsoft R Open.