CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Quaderno Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Quaderno data in ColdFusion.
-
Easily Integrate Printful Data in Lazarus Pascal IDE
Learn how to easily integrate live Printful data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query, Visualize, and Share live Amazon Marketplace Data in Redash
Use CData Connect AI to connect to live Amazon Marketplace data in Redash for querying, visualizing, and sharing.
-
Access Live Pinterest Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Pinterest data from your Excel spreadsheets.
-
How to connect to ConstantContact Data with Squirrel SQL client
Connect to ConstantContact data and execute queries in the Squirrel SQL Client.
-
Use Databricks Agent Bricks to Talk to Your Sage Intacct Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sage Intacct data for you.
-
Seamlessly Bring Azure Table Data into Retool Using CData Connect AI
Integrate Azure Table data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Operational Reporting on Superchat Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Superchat data.
-
Back Up MYOB AccountRight data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MYOB AccountRight. In this article, we will employ an SSIS workflow to populate a database with MYOB AccountRight data data.
-
Query Airtable Data as a SQL Server Database in Node.js
Execute SQL Server queries against Airtable data from Node.js.
-
Connect to Landbot Data in DBArtisan
Use wizards in DBArtisan to configure Landbot data as a data source.
-
Connect to Paylocity from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Paylocity data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData JDBC Driver for Salesforce in MicroStrategy Web
Connect to Salesforce data in MicroStrategy Web using the CData JDBC Driver for Salesforce.
-
A PostgreSQL Interface for Clio Data using the CData ODBC Driver
Use the SQL Gateway and Clio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations in Cognos BI with Oracle Financials Cloud Data
Access Oracle Financials Cloud data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to ZohoSubscriptions Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ZohoSubscriptions Data and connect to ZohoSubscriptions data in Akorbi Digital RunMyProcess.
-
Object-Relational Mapping (ORM) with Perigon Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Perigon data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Jumpseller Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Jumpseller data replication to OneLake in Microsoft Fabric.
-
Edit and Search External MongoDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MongoDB data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MongoDB Data objects that you can access from apps and the dashboard.
-
Using the CData Software ODBC Driver for Raisers Edge NXT in PyCharm
Connect to Raisers Edge NXT as an ODBC data source in PyCharm using the CData Software ODBC Driver for Raisers Edge NXT.
-
Integrate with Live Microsoft Dataverse Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Dataverse from the MuleSoft Anypoint Platform to integrate live Microsoft Dataverse data into custom reports and dashboards.
-
Getting Started with the CData ODBC Driver for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for RabbitMQ.
-
Use the CData Software ODBC Driver for TaxJar in MicroStrategy
Connect to TaxJar data in MicroStrategy Developer using the CData Software ODBC Driver for TaxJar.
-
Integrating Cursor with Kafka 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.
-
Feed Grafana Data into FineReport
How to set Grafana data as a JDBC data source in FineReport.
-
Automated Continuous Clari Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Clari replication to Apache Cassandra.
-
How to create Greenplum federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Greenplum data in MySQL .
-
Connect to Azure Analysis Services Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Azure Analysis Services Data and connect to Azure Analysis Services data in Akorbi Digital RunMyProcess.
-
Integrate Dify with Live Asana 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 Asana data.
-
Automate PabblySubscriptions Data Replication to Azure Synapse
Use CData Sync to customize and automate PabblySubscriptions data replication to Azure Synapse.
-
Automated Continuous Instagram Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Instagram replication to Apache Cassandra.
-
Connect to Redshift in SpagoBI
Create reports featuring live Redshift data in SpagoBI Studio. Host Redshift reports on SpagoBI Server.
-
Connect to Sybase IQ Data in HULFT Integrate
Connect to Sybase IQ as a JDBC data source in HULFT Integrate
-
Analyze Suadeo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Suadeo data with the CData JDBC Driver for Suadeo.
-
Connect to Billsby Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Billsby as an External Source in Dremio.
-
Connect to TaxJar Data from HeidiSQL
Use CData Connect AI to connect to and query live TaxJar data from HeidiSQL.
-
Object-Relational Mapping (ORM) with ScrapingBee Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to ScrapingBee data into a Java-based ORM framework, Hibernate.
-
Connect to Reply.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Reply.io and the SQL Gateway to access Reply.io data from Google Apps Script.
-
Use the CData SSIS Components to Insert New or Update Existing Impala Records from SQL Server
Easily push SQL Server data to Impala using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Impala or update existing records with data from a SQL Server database.
-
Use the CData Software JDBC Driver for Mixpanel in MicroStrategy
Connect to Mixpanel data in MicroStrategy Developer using the CData Software JDBC Driver for Mixpanel.
-
Automate Teamwork Data Replication to Couchbase
Use CData Sync to Customize and automate Teamwork data replication to Couchbase.
-
Integrating Codex with Oracle 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.
-
Prepare, Blend, and Analyze MongoDB Data in Alteryx Designer (Connect AI)
Build workflows to access live MongoDB data for self-service data analytics.
-
Analyze Square Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Square data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Open WebUI with Live RSS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live RSS feeds from within the chat interface.
-
Connect to Impala Data in DBArtisan
Use wizards in DBArtisan to configure Impala data as a data source.
-
Build Agents in Relevance AI with Access to Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Greenhouse data within intelligent agent workflows.
-
Integrate Cursor with Live Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Guru data from within the editor.
-
Build Visualizations of Sendwithus Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sendwithus data in Birst.
-
Use the CData Software JDBC Driver for Shippo in MicroStrategy Desktop
Connect to Shippo data in MicroStrategy Desktop using the CData Software JDBC Driver for Shippo.
-
Use the CData Software JDBC Driver for Adobe Commerce in MicroStrategy Desktop
Connect to Adobe Commerce data in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Commerce.
-
Create a Data Access Object for ZohoDesk Data using JDBI
A brief overview of creating a SQL Object API for ZohoDesk data in JDBI.
-
Use Dash to Build Web Apps on Basecamp Data via CData Connect AI
Build interactive Dash web apps on live Basecamp data using pandas and the CData Connect AI Python SDK.
-
Integrate Databricks Data in Pentaho Data Integration
Build ETL pipelines based on Databricks data in the Pentaho Data Integration tool.
-
Build Agents in Relevance AI with Access to Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Excel Online data within intelligent agent workflows.
-
Access Live Moosend Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Moosend data into the statistical analysis tools available in SAS JMP. This article shows how to use Moosend data in the Graph Builder and Query Builder.
-
Connect to Oracle HCM Cloud Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle HCM Cloud data from Crystal Reports.
-
Connect to SendPulse Data from PowerBuilder via ADO.NET
This article demonstrates how to access SendPulse data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Migrating data from Impala to Snowflake using CData SSIS Components.
Easily push Impala data to Snowflake using the CData SSIS Tasks for Impala and Snowflake.
-
Manage CapsuleCRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CapsuleCRM.
-
Build AI/ML Models with Live Oracle HCM Cloud Data using Dataiku
Connect Oracle HCM Cloud Data with Dataiku using the CData JDBC Driver for Oracle HCM Cloud.
-
Automated Continuous Cloudflare Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cloudflare replication to Apache Kafka.
-
Visualize Hive Data in Sisense
Create an ElastiCube in Sisense app with access to Hive data.
-
Automated Continuous Cvent Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cvent replication to SQL Server.
-
How to Query Live Active Directory Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Active Directory data data in natural language using Python.
-
Automated Continuous Postmark Replication to MySQL
Use CData Sync for automated, continuous, customizable Postmark replication to MySQL.
-
Explore Geographical Relationships in Coda Data with Power Map
Create data visualizations with Coda data in Power Map.
-
Automate Amazon S3 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon S3 data from PowerShell? This article demonstrates how to utilize the Amazon S3 Cmdlets for tasks like connecting to Amazon S3 data, automating operations, downloading data, and more.
-
Automated Continuous Tally Replication to SQLite
Use CData Sync for automated, continuous, customizable Tally replication to SQLite.
-
Build Semantic Layer Views for ADP Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ADP data.
-
Integrating Gumloop with Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Redis data within automated workflows.
-
How to Connect to Front Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Front data. Leverage the pyodbc module for ODBC in Python.
-
DataBind Controls to Act CRM Data in Delphi
DataBind to Act CRM data in Delphi with standard data access components and controls.
-
Create Data Visualizations in Cognos BI with Teamgate Data
Access Teamgate data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Google Search Results Using Azure Data Factory
Use CData Connect AI to connect to Google Search Results from Azure Data Factory and import live Google Search results.
-
Build Tavily-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Tavily Data and create custom apps in Bubble.
-
Connect to Missive Data in RazorSQL
Connect to Missive from wizards and query Missive data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData ADO.NET Provider for Figshare
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Missive Replication to MySQL
Use CData Sync for automated, continuous, customizable Missive replication to MySQL.
-
Moving Data from Hive to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Hive data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live GetResponse Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GetResponse data from your Google Sheets.
-
Connect to and Query Exa Data in QlikView over ODBC
Create data visualizations with Exa data in QlikView.
-
Access Live Raisers Edge NXT Data in AWS Lambda
Connect to live Raisers Edge NXT data in AWS Lambda using the CData JDBC Driver.
-
How to publish and share ZohoInvoice Data dashboards with Tableau Server
The CData ODBC driver for ZohoInvoice enables you integrate ZohoInvoice data into Tableau dashboards.
-
How to Connect Raisers Edge NXT Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Raisers Edge NXT data in real time using natural language.
-
Use the CData ODBC Driver for Timely in Microsoft Power Query
You can use the CData Timely ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Timely data into Microsoft Power Query.
-
Integrate Live Perplexity Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Perplexity data from within the IDE.
-
How to Connect DBeaver to Teamwork via a JDBC Driver
Manage Teamwork data with visual tools in DBeaver like the query browser.
-
Working with Everhour Data in LINQPad
Execute LINQ queries to Everhour data in LINQPad.
-
Natively Connect to GitLab Data in PHP
The CData ODBC driver for GitLab enables you to create PHP applications with connectivity to GitLab data. Leverage the native support for ODBC in PHP.
-
Build Agents in Relevance AI with Access to Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Highrise data within intelligent agent workflows.
-
Create Data Visualizations Based On Zoho CRM Data in Mode
Use CData Connect AI to connect to Zoho CRM Data from Mode and build visualizations using live Zoho CRM data.
-
Integrate Dify with Live CockroachDB 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 CockroachDB data.
-
Automate Amazon DynamoDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon DynamoDB data replication to Azure Data Lake.
-
Viewing ShipEngine Data in RAD Studio Data Explorer
How to view ShipEngine data in RAD Studio Data Explorer using the CData ODBC Driver for ShipEngine.
-
Connect PhantomBuster Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PhantomBuster data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Microsoft Copilot Studio to talk to your ZohoPeople 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 ZohoPeople data for you.
-
Natively Connect to Sybase IQ Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sybase IQ data. Leverage the native support for ODBC in PHP.
-
Publish Crystal Reports on MYOB AccountRight Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MYOB AccountRight data.
-
Create Apps from Gmail Data in Qlik Sense Cloud
Use CData Connect AI to connect to Gmail Data and build apps from live Gmail data in Qlik Sense Cloud.