CData Software - Knowledge Base
Recent Articles
-
Integrate Oracle with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Database.
-
Connecting Moonlit Workflow with Microsoft Entra ID Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft Entra ID in real time.
-
Create Snowflake Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Snowflake data access from reports, embedded analytics, and more.
-
Visualize Procore Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Procore.
-
How to load ChartMogul data into Elasticsearch via Logstash
Introducing a simple method to load ChartMogul data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dashboards and Visualize Live Zoho Projects Data in Geckoboard
Use CData Connect AI to connect to live Zoho Projects and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Aha! Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Aha! and work with Aha! in your FileMaker applications.
-
Feed Mixpanel Data into FineReport
How to set Mixpanel as a JDBC data source in FineReport.
-
Add Mixpanel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mixpanel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Spark-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache Spark SQL.
-
Model, Search, and Visualize Live Google Calendar Data in ThoughtSpot
Use CData Connect AI to connect to live Google Calendar for modeling, searching, and visualizing.
-
Connect to and Query Zoho Creator Data in QlikView over ODBC
Create data visualizations with Zoho Creator in QlikView.
-
Integrate Cline with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live MYOB AccountRight from within your IDE.
-
Excel Spreadsheet Automation on QuickBooks Data with the QUERY Formula
Pull data from QuickBooks, automate spreadsheets, and more with the QUERY formula.
-
Connect to Facebook Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Facebook Ads from PowerBuilder using the Facebook Ads JDBC Driver.
-
Create Klaviyo-Connected Applications in Appsmith
Connect to Klaviyo Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Klaviyo.
-
Integrating Claude Code CLI with Drift 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.
-
Migrating data from Templated to Google BigQuery using CData SSIS Components.
Easily push Templated to Google BigQuery using the CData SSIS Tasks for Templated and Google BigQuery.
-
Bind Live CSV Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live CSV data
-
Import and Visualize Vimeo Data in Power View
Create data visualizations based on Vimeo in Excel.
-
Visualize Blackbaud FE NXT Data in TIBCO Spotfire through ADO.NET
Integrate Blackbaud FE NXT into dashboards in TIBCO Spotfire.
-
Integrate Live Asana Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Asana from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Asana.
-
Getting Started with the CData Power BI Connector for Paylocity
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Paylocity.
-
Extract, Transform, and Load Parallel Data in Informatica PowerCenter
Create a simple Workflow for Parallel in Informatica PowerCenter.
-
Integrate Live Snapchat Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Snapchat Ads and integrate live Snapchat Ads into apps built in Microsoft Power Apps.
-
Model, Search, and Visualize Live Highrise Data in ThoughtSpot
Use CData Connect AI to connect to live Highrise CRM for modeling, searching, and visualizing.
-
Connect to Coinbase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Coinbase.
-
Automated Continuous EmailOctopus Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Apache Kafka.
-
Build Kintone-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Kintone.
-
Stream ZendeskSell Data into Apache Kafka Topics
Access and stream ZendeskSell in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Guru Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Guru from Informatica Cloud.
-
How to use SQLAlchemy ORM to access Excel Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Excel.
-
How to Query Microsoft Planner Data in MySQL Workbench
Execute MySQL queries against live Microsoft Planner from MySQL Workbench.
-
Access Live SAS xpt Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAS XPORT in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Gong Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Gong and build visualizations in Tableau.
-
Integrating OpenCode Terminal with Microsoft Exchange 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.
-
Connect to HubDB Data in Ruby
Connect to HubDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate SuiteCRM Data from PowerShell
Write a quick PowerShell script to query SuiteCRM. Use connectivity to the live data to replicate SuiteCRM to SQL Server.
-
Replicate Act-On Data to Multiple Databases via the CData Sync CLI
Replicate Act-On to disparate databases with a single configuration.
-
Getting Started with the CData JDBC Driver for HubDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HubDB.
-
Automated Continuous ShipStation Replication to MongoDB
Use CData Sync for automated, continuous, customizable ShipStation replication to MongoDB.
-
Extract, Transform, and Load SharePoint Data in Informatica PowerCenter
Create a simple Workflow for Microsoft SharePoint in Informatica PowerCenter.
-
How to Seamlessly Import Zoho CRM Data into IBM SPSS Modeler
Integrate Zoho CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Wistia Data in JRuby
Create a simple JRuby app with access to live Wistia.
-
Automated Continuous iContact Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable iContact replication to OneLake in Microsoft Fabric.
-
How to connect to Dynamics CRM Data from Spring Boot
Connect to Dynamics CRM in a Spring Boot Application using the CData JDBC Driver for Dynamics CRM
-
How to load Zoho Projects data into Elasticsearch via Logstash
Introducing a simple method to load Zoho Projects data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Google Drive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Drive and build Google Drive-connected web apps with Axios.
-
Use the CData Software JDBC Driver for Scrapfly in MicroStrategy
Connect to Scrapfly in MicroStrategy Developer using the CData Software JDBC Driver for Scrapfly.
-
Build a Simple VCL Application for Auth0 Data
How to build a simple VCL Application to view Auth0 in RAD Studio using the CData ODBC Driver for Auth0.
-
Getting Started with the CData SSIS Components for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho CRM.
-
Getting Started with the CData Python Connector for Oracle
Learn to install and license the CData Python Connector
-
Connect to Hubstaff Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Hubstaff.
-
Process & Analyze SageHR Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SageHR Data.
-
Model Salesforce Marketing Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce Marketing, enabling the direct import of real-time Salesforce Marketing Cloud.
-
Import Power BI XMLA Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Power BI XMLA Data and provide access to live Power BI XMLA for custom reports in the Power BI Service.
-
Connect to Adobe Commerce Data from HeidiSQL
Use CData Connect AI to connect to and query live Adobe Commerce from HeidiSQL.
-
Work with YouTube Analytics Data in FoxPro
Load YouTube Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Exact Online 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 Exact Online.
-
Build Dashboards with Eventbrite Data in Dundas BI
Create dynamic dashboards and perform analytics based on Eventbrite in Dundas BI.
-
Build a PostgreSQL Interface for ZohoExpense Data using the CData JDBC Driver
Use the Remoting features of the ZohoExpense JDBC Driver to create a PostgreSQL entry-point for data access.
-
Configure the CData JDBC Driver for Vimeo in a Connection Pool in Tomcat
Connect to Vimeo from a connection pool in Tomcat.
-
Build Visualizations of Zoho Recruit Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Recruit in Birst.
-
Automated Continuous ZohoDesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoDesk replication to OneLake in Microsoft Fabric.
-
Visualize FormSite Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FormSite.
-
How to connect to Toggl Data with Squirrel SQL client
Connect to Toggl and execute queries in the Squirrel SQL Client.
-
Automated Continuous EmailOctopus Replication to Snowflake
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Snowflake.
-
Connect Codat to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Codat with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous SAP SuccessFactors Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to SQLite.
-
How to connect to Oracle SCM Data with Squirrel SQL client
Connect to Oracle SCM and execute queries in the Squirrel SQL Client.
-
A PostgreSQL Interface for Landbot Data using the CData ODBC Driver
Use the SQL Gateway and Landbot ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Dynamics CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics CRM.
-
Connect to Real-Time HDFS Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HDFS and Dataflow to import and use Apache HDFS in Power Apps.
-
Create Smartsheet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Smartsheet data access from reports, embedded analytics, and more.
-
How to Query Campaigner Data in MySQL Workbench
Execute MySQL queries against live Campaigner from MySQL Workbench.
-
Connect to SAP Concur Data in Ruby
Connect to SAP Concur in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate SQL Server Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft SQL Server to disparate databases with a single configuration.
-
Integrate Live Reckon Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Reckon to Blue Prism using the CData ODBC Driver for Reckon to create automated workflows for repetitive business tasks.
-
How to connect to Quaderno Data in DBVisualizer
Integrate Quaderno with visual data analysis tools and data connection wizards in DBVisualizer
-
Feed ActiveCampaign Data into FineReport
How to set ActiveCampaign as a JDBC data source in FineReport.
-
Natively Connect to Demio Data in PHP
The CData ODBC driver for Demio enables you to create PHP applications with connectivity to Demio. Leverage the native support for ODBC in PHP.
-
How to Connect to Live BambooHR Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your BambooHR for you.
-
Connect to ZarMoney Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Replicate Multiple ZendeskSell Accounts via the CData Sync CLI
Replicate multiple ZendeskSell accounts to one or many databases.
-
How to Query Live LinkedIn Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LinkedIn data in natural language using Python.
-
Connect to Scrapfly Data in Ruby
Connect to Scrapfly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect DBeaver to Salesforce Pardot via a JDBC Driver
Manage Salesforce Pardot with visual tools in DBeaver like the query browser.
-
Connect to Real-Time Microsoft Exchange Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Exchange and Dataflow to import and use Microsoft Exchange in Power Apps.
-
DataBind Controls to SendGrid Data in C++Builder
DataBind to SendGrid in C++Builder with standard components and controls.
-
How to Build an ETL App for Cloudant Data in Python with CData
Create ETL applications and real-time data pipelines for IBM Cloudant in Python with petl.
-
Integrating Boomi Agentstudio with Sage Cloud Accounting Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sage Business Cloud Accounting, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to import SAP Data into Apache Solr
Use the CData Software JDBC Driver for SAP in Data Import Handler and create an automated import of SAP ERP/NetWeaver to Apache Solr Enterprise Search platform.
-
Build MVC Applications with Connectivity to Excel Online Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Excel Online from an ASP.NET MVC application.
-
How to Connect to Live DB2 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 IBM DB2 for you.
-
Query Box Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Box and perform CRUD operations on Box from Node.js.
-
Connect to ShipEngine Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ShipEngine using standard SQL.
-
Getting Started with OAuth in CData Connectivity Solutions
Configuring OAuth with CData Connectivity Solutions for Desktop, Web Application and Headless Machines
-
Getting Started with the CData Excel Add-In for Redshift
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Redshift.
-
Access Live Reckon Accounts Hosted Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Reckon Accounts Hosted in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate CouchDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CouchDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache CouchDB.