CData Software - Knowledge Base
Recent Articles
-
Connect to Qualaroo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Qualaroo.
-
Connect to Act-On from a Connection Pool in WebLogic
Use the CData JDBC Driver for Act-On to connect to Act-On data from Web applications running on WebLogic.
-
Edit and Search External Sybase IQ Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sybase IQ data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sybase IQ Data objects that you can access from apps and the dashboard.
-
Use JayDeBeApi to access Avaza Data in Python
Use standard Python scripting and the development environment of your choice to access live Avaza data.
-
Prepare, Blend, and Analyze JotForm Data in Alteryx Designer (ODBC)
Build workflows to access live JotForm data for self-service data analytics.
-
Access Live Spark Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Spark data into the statistical analysis tools available in SAS JMP. This article shows how to use Spark data in the Graph Builder and Query Builder.
-
Replicate OneNote Data to Multiple Databases
Replicate OneNote data to disparate databases with a point-and-click configuration.
-
Automated Continuous API Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable API replication to Apache Kafka.
-
Work with ServiceDesk Plus Data in FoxPro
Load ServiceDesk Plus data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Cursor with HubSpot 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.
-
Import Real-Time Landbot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Landbot data in ColdFusion.
-
Create SSAS Tabular Models from AdRoll Data
How to build a SQL Server Analysis Service Tabular Model from AdRoll data using CData drivers.
-
Getting Started with the CData ODBC Driver for ShipEngine
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ShipEngine.
-
Automated Continuous Exa Replication to SingleStore
Use CData Sync for automated, continuous, customizable Exa replication to SingleStore.
-
How to publish and share Typeform Data dashboards with Tableau Server
The CData ODBC driver for Typeform enables you integrate Typeform data into Tableau dashboards.
-
Query SQL Server Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SQL Server data from Node.js.
-
Build Apps with Live ZohoDesk Data Using the Low-Code Development Platform of Mendix
Connect ZohoDesk data with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for Guru in MicroStrategy Desktop
Connect to Guru data in MicroStrategy Desktop using the CData Software JDBC Driver for Guru.
-
Connect to Google Campaign Manager 360 from Asprova with CData Software ODBC Driver for Google Campaign Manager 360
This article shows how to connect faster to Google Campaign Manager 360 data from Asprova.
-
Use JayDeBeApi to access TigerGraph Data in Python
Use standard Python scripting and the development environment of your choice to access live TigerGraph data.
-
Connect to ServiceNow Data from a Connection Pool in JBoss
Integrate ServiceNow data into Java servlets: Use the Management Console in JBoss to install the ServiceNow JDBC Driver.
-
Connect and Query Live Google Cloud Storage Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Cloud Storage data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Productboard Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Productboard data from Informatica Cloud.
-
Model, Search, and Visualize Live ActiveCampaign Data in ThoughtSpot
Use CData Connect AI to connect to live ActiveCampaign data for modeling, searching, and visualizing.
-
Build a Simple VCL Application for Databricks Data
How to build a simple VCL Application to view Databricks data in RAD Studio using the CData ODBC Driver for Databricks.
-
Build a PostgreSQL Interface for iContact Data using the CData JDBC Driver
Use the Remoting features of the iContact JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Bright Data from Asprova with CData Software ODBC Driver for Bright Data
This article shows how to connect faster to Bright Data data from Asprova.
-
Choosing the Best Method to Connect Airtable to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Airtable data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Bitbucket-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Bitbucket Data from OutSystems and build custom enterprise apps using live Bitbucket data.
-
Analyze Microsoft Dataverse Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Dataverse data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Connect to Live Shippo Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Shippo data for you.
-
Integrating Cursor with SAP HANA 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.
-
Use Dash to Build Web Apps on GraphQL Data via CData Connect AI
Build interactive Dash web apps on live GraphQL data using pandas and the CData Connect AI Python SDK.
-
Create Grafana Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Grafana data access from reports, embedded analytics, and more.
-
Use CData Connect AI to Access Blackbaud FE NXT Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Blackbaud FE NXT data in the Power Pivot business intelligence tool.
-
Build Apps with Live Perplexity Data Using the Low-Code Development Platform of Mendix
Connect Perplexity data with Mendix to build apps using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Calendar
Create Google Calendar data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Goose with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Exchange data from within the local AI agent.
-
A PostgreSQL Interface for Databricks Data using the CData ODBC Driver
Use the SQL Gateway and Databricks ODBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to Quickbase 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 Quickbase Data Provider.
-
Automated Continuous Google Forms Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Forms replication to SQLite.
-
Use the CData Software JDBC Driver for Bitbucket in MicroStrategy Web
Connect to Bitbucket data in MicroStrategy Web using the CData Software JDBC Driver for Bitbucket.
-
Automated Continuous Sybase IQ Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Apache Cassandra.
-
Build Adobe Analytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Analytics data.
-
Build a Simple VCL Application for SAS xpt Data
How to build a simple VCL Application to view SAS xpt data in RAD Studio using the CData ODBC Driver for SAS xpt.
-
How to Connect to Live FHIR 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 FHIR data for you.
-
How to Connect Flowise AI Agents to Live Zuora 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 Zuora data without replication.
-
Feed Trello Data into FineReport
How to set Trello data as a JDBC data source in FineReport.
-
Integrate Yelp Data into Power Automate Desktop using CData Connect
CData Connect for Yelp Data enables you to integrate Yelp data into workflows built using Microsoft Power Automate Desktop.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Directory
Create an ODBC connection to Google Directory in Informatica and browse and transfer Google Directory data.
-
Working with MySQL Data in LINQPad
Execute LINQ queries to MySQL data in LINQPad.
-
Query Azure Analysis Services Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Analysis Services data from Node.js.
-
Getting Started with the CData Excel Add-In for Rebilly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Rebilly.
-
Automated Continuous Retently Replication to Databricks
Use CData Sync for automated, continuous, customizable Retently replication to Databricks.
-
Integrate Bright Data with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bright Data with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bright Data data.
-
Integrate Open WebUI with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live IBM Cloud Object Storage data from within the chat interface.
-
Design BIRT Reports on BigQuery Data
Provide current BigQuery data to your embedded analytics.
-
Feed Asana Data into FineReport
How to set Asana data as a JDBC data source in FineReport.
-
How to Connect to Live Kintone 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 Kintone data for you.
-
Create Dynamic SAS xpt Grids Using the Infragistics XamDataGrid
Learn how you can connect SAS xpt to Infragistics XamDataGrid to build dynamic grids.
-
Build Visualizations of BenchmarkEmail Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of BenchmarkEmail data in Birst.
-
Using the CData Software ODBC Driver for RSS in PyCharm
Connect to RSS as an ODBC data source in PyCharm using the CData Software ODBC Driver for RSS.
-
Manage Microsoft Teams Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Teams.
-
Integrating Antigravity CLI with GraphQL data via CData CLI
Connect GraphQL data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Natively Connect to Float Data in PHP
The CData ODBC driver for Float enables you to create PHP applications with connectivity to Float data. Leverage the native support for ODBC in PHP.
-
Integrate Asana Data in Pentaho Data Integration
Build ETL pipelines based on Asana data in the Pentaho Data Integration tool.
-
Build Apps with Live YouTube Analytics data in Adalo using CData Connect AI
Use CData Connect AI to integrate live YouTube Analytics data into the Adalo platform and build custom mobile and web applications with real-time YouTube Analytics data.
-
A PostgreSQL Interface for SAP Business Warehouse Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Business Warehouse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate SAP HANA XS Advanced Data from PowerShell
Write a quick PowerShell script to query SAP HANA XS Advanced data. Use connectivity to the live data to replicate SAP HANA XS Advanced data to SQL Server.
-
Use Manus AI to Talk to Your Exa 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 Exa data.
-
How to integrate Metabase with ActiveCampaign Data
Use CData Connect AI to connect to live ActiveCampaign data and create an interactive dashboard in Metabase from ActiveCampaign data.
-
Getting Started with the CData ADO.NET Provider for Opsgenie
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Back Up Procore data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Procore data data.
-
Excel Spreadsheet Automation on ZohoPeople Data with the QUERY Formula
Pull data from ZohoPeople, automate spreadsheets, and more with the QUERY formula.
-
How to integrate Keap with Apache Airflow
Access and process Keap data in Apache Airflow using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Freshservice 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 Freshservice data into a Java-based ORM framework, Hibernate.
-
Automated Continuous ShipStation Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ShipStation replication to delimited files (CSV/TSV).
-
Access Live EnterpriseDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live EnterpriseDB data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create xBase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to xBase Data from Klipfolio and build custom visualizations using live xBase data.
-
Use the CData ODBC Driver for VWO from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for VWO to connect to VWO data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring VWO data in Excel.
-
Build Bright Data-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Bright Data Data from Zoho Analytics and import live Bright Data data.
-
Connect to Stack Exchange Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Stack Exchange as an External Source in Dremio.
-
Access Coda Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Coda data from your Oracle system.
-
Connect and Visualize Live PolarTeamPro Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live PolarTeamPro data into the Databricks platform and create visualization dashboards with real-time PolarTeamPro data.
-
Connect to Clari Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Clari data.
-
Automated Continuous SAP Netweaver Gateway Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Apache Kafka.
-
Integrate Klipfolio Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Klipfolio data and integrate live Klipfolio data into your Power Automate tasks.
-
Connect to and Query Tally Data in QlikView over ODBC
Create data visualizations with Tally data in QlikView.
-
Connect to Microsoft OneDrive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft OneDrive and the SQL Gateway to access Microsoft OneDrive data from Google Apps Script.
-
Import Zoom Data Using Azure Data Factory
Use CData Connect AI to connect to Zoom Data from Azure Data Factory and import live Zoom data.
-
How to Query Live Todoist Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Todoist data data in natural language using Python.
-
Create Active Directory Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Active Directory from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Oracle Service Cloud-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Service Cloud data.
-
Analyze Nuclia Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Nuclia data in Microsoft R Open.
-
Connect to Wave Financial Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Wave Financial Data and connect to Wave Financial data in Akorbi Digital RunMyProcess.
-
Connect to Couchbase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Couchbase Data and connect to Couchbase data in Akorbi Digital RunMyProcess.
-
Build MongoDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MongoDB Data from Zoho Analytics and import live MongoDB data.
-
Viewing Close Data in RAD Studio Data Explorer
How to view Close data in RAD Studio Data Explorer using the CData ODBC Driver for Close.
-
Integrate JSON Services into Power Automate Desktop using CData Connect
CData Connect for JSON Services enables you to integrate JSON services into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Unbounce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Unbounce replication to Amazon S3.