CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to Close: Complete Guide
Connect to the CData Software Power BI Connector for Close from PowerBI.com to provide real-time Close across the organization.
-
Create Reports with Miro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Miro.
-
Integrate Real-Time Access to Amazon Athena in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Athena in real time.
-
Automated Continuous Oracle Financials Cloud Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to IBM DB2.
-
Query Facebook Data as a MySQL Database in Node.js
Execute MySQL queries against Facebook from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for SendGrid
Create SendGrid data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Dashboards with MYOB AccountRight Data in Dundas BI
Create dynamic dashboards and perform analytics based on MYOB AccountRight in Dundas BI.
-
Connect to Pipeline CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build AI/ML Models with Live TigerGraph Data using Dataiku
Connect TigerGraph Data with Dataiku using the CData JDBC Driver for TigerGraph.
-
Connect to Harvest Data in Jaspersoft Studio
Execute SQL to remote Harvest in Jaspersoft Studio.
-
Work with AlloyDB Data in FoxPro
Load Google AlloyDB into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Elasticsearch Data to Multiple Databases via the CData Sync CLI
Replicate Elasticsearch to disparate databases with a single configuration.
-
Build Dashboards with Azure DevOps Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure DevOps in DBxtra.
-
Integrate Pingdom Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pingdom from Informatica Cloud.
-
Build a Simple VCL Application for NASA Data
How to build a simple VCL Application to view NASA in RAD Studio using the CData ODBC Driver for NASA.
-
Create Datasets from Trello in Domo Workbench and Build Visualizations of Trello Data in Domo
Use the CData Software ODBC Driver for Trello to create datasets from Trello in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Kiro CLI with Dotmailer 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.
-
How to Connect the Power BI Service to ClickUp: Complete Guide
Connect to the CData Software Power BI Connector for ClickUp from PowerBI.com to provide real-time ClickUp across the organization.
-
Work with Salesforce Data in FoxPro
Load Salesforce & Force.com into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Keap Replication to SQLite
Use CData Sync for automated, continuous, customizable Keap replication to SQLite.
-
Import Reckon Accounts Hosted Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Reckon Accounts Hosted. In this article, you will use the OData format to import Reckon Accounts Hosted into Microsoft Power Query.
-
Publish ChartMogul-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ChartMogul.
-
Getting Started with the CData SSIS Components for Browserless
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Browserless.
-
Connect to GetResponse from a Connection Pool in WebLogic
Use the CData JDBC Driver for GetResponse to connect to GetResponse from Web applications running on WebLogic.
-
Integrating Kiro CLI with Strava 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.
-
Visualize Live YouTube Analytics Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live YouTube Analytics into custom reports in Power BI.
-
Access Live Azure Data Lake Storage Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Azure Data Lake Storage through MCP integration.
-
Build Visualizations of ConstantContact Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ConstantContact in Birst.
-
Build Pipelines with Live Elasticsearch Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Elasticsearch from Google Cloud Data Fusion, enabling the integration of live Elasticsearch into the building and management of effective data pipelines.
-
Connect PayPal Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PayPal using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Work with Airtable Data in AWS Glue Jobs Using JDBC
Connect to Airtable from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Work with PivotalTracker Data in FoxPro
Load PivotalTracker into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData ADO.NET Provider for Gumroad
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Demio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Demio from Informatica Cloud.
-
Integrate Goose with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoho Books from within the local AI agent.
-
Extract, Transform, and Load Tavily Data in Informatica PowerCenter
Create a simple Workflow for Tavily in Informatica PowerCenter.
-
Bridge Salesforce Marketing Connectivity with Apache NiFi
Access and process Salesforce Marketing Cloud in Apache NiFi using the CData JDBC Driver.
-
How to connect to MYOB AccountRight Data in DBVisualizer
Integrate MYOB AccountRight with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze AlloyDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google AlloyDB and visualize Google AlloyDB in SAP Analytics Cloud.
-
Build Impala-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Impala to explore live Impala Data in Claude Code to assist with building Impala-powered applications.
-
Use JayDeBeApi to access SpaceX Data in Python
Use standard Python scripting and the development environment of your choice to access live SpaceX.
-
DataBind Charts to ZendeskSell Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZendeskSell 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.
-
Migrating data from LinkedIn to Databricks using CData SSIS Components.
Easily push LinkedIn to Databricks using the CData SSIS Tasks for LinkedIn and Databricks.
-
Access Float Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Float from your Oracle system.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ElevenLabs
Provide connectivity to ElevenLabs through an SAP BusinessObjects universe.
-
Build Data Flows from SQL Server to Oracle through SSIS
Easily push SQL Server data to Oracle using the CData SSIS Tasks for Oracle.
-
How to Access Live eBay Analytics Data in Power Automate Desktop via ODBC
The CData ODBC Driver for eBay Analytics enables you to integrate eBay Analytics into workflows built using Microsoft Power Automate Desktop.
-
Prepare, Blend, and Analyze Okta Data in Alteryx Designer (ODBC)
Build workflows to access live Okta for self-service data analytics.
-
Automated Continuous Dotmailer Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dotmailer replication to IBM DB2.
-
Visualize Retently Data in Tableau
The CData ODBC driver for Retently enables you integrate Retently into Tableau dashboards.
-
Build Rootly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Rootly.
-
How to Easily Query JobNimbus Data in OpenOffice Base
Connect to JobNimbus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Egnyte
Provide connectivity to Egnyte through an SAP BusinessObjects universe.
-
Connect to Mailjet Data in DBArtisan
Use wizards in DBArtisan to configure Mailjet as a data source.
-
Create SSAS Tabular Models from Yelp Data
How to build a SQL Server Analysis Service Tabular Model from Yelp using CData drivers.
-
Use the CData Software ODBC Driver for MariaDB in SAS for Real-Time Reporting and Analytics
Connect to real-time MariaDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MariaDB.
-
Access Live Ontraport Data in Coginiti Pro
Connect to and query live Ontraport from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build AI Agents with WordPress 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 WordPress through CData Connect AI.
-
Visualize Webex 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 Webex into TIBCO Spotfire.
-
Connect to Wave Financial Data in JRuby
Create a simple JRuby app with access to live Wave Financial.
-
Build Data Flows from SQL Server to JSON through SSIS
Easily push SQL Server data to JSON using the CData SSIS Tasks for JSON.
-
Automated Continuous Flowlu Replication to SingleStore
Use CData Sync for automated, continuous, customizable Flowlu replication to SingleStore.
-
Configure the CData JDBC Driver for Hugging Face in a Connection Pool in Tomcat
Connect to Hugging Face from a connection pool in Tomcat.
-
Integrating Claude Code with Microsoft Exchange Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Exchange within assisted coding and automated development workflows.
-
Model Amazon DynamoDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon DynamoDB, enabling the direct import of real-time Amazon DynamoDB.
-
How to Query SpaceX Data in MySQL Workbench
Execute MySQL queries against live SpaceX from MySQL Workbench.
-
How to update HubSpot from Excel
This article explains how to transfer data from Excel to HubSpot using the Excel Add-In for HubSpot.
-
Bidirectional Access to Oracle Financials Cloud Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Financials Cloud in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Adobe Target in MicroStrategy Web
Connect to Adobe Target in MicroStrategy Web using the CData Software ODBC Driver for Adobe Target.
-
How to create Visio diagrams from SAP HANA Data
Automatically update SAP HANA with the changes you make to Visio master shapes.
-
How to use SQLAlchemy ORM to access Phoenix Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Phoenix.
-
Connect to Drip from a Connection Pool in WebLogic
Use the CData JDBC Driver for Drip to connect to Drip from Web applications running on WebLogic.
-
Integrating Cursor CLI with Act CRM 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.
-
Query SAP Ariba Source Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Ariba Source from Node.js.
-
Access Excel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Excel from your Oracle system.
-
Edit and Search External Avro Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apache Avro to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Avro Data objects that you can access from apps and the dashboard.
-
Automated Continuous Cloudflare Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Cloudflare replication to Google Cloud SQL.
-
Automate Azure DevOps Data Replication to Azure Synapse
Use CData Sync to customize and automate Azure DevOps replication to Azure Synapse.
-
Create Reports with WooCommerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date WooCommerce.
-
Analyze RSS Feeds in Infragistics Reveal
Use the CData API Server to create an OData API on top of RSS Feeds and visualize live RSS Feeds in Infragistics Reveal.
-
Create Informatica Mappings From/To a JDBC Data Source for Dropbox
Create Dropbox data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Adobe Commerce Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Adobe Commerce in Airbyte.
-
Create Authorize.Net-Connected Business Apps in AppSheet
Connect to Authorize.Net Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Authorize.Net.
-
Query Coinbase Data as a MySQL Database in Node.js
Execute MySQL queries against Coinbase from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for Factorial
Create an ODBC connection to Factorial in Informatica and browse and transfer Factorial.
-
Import Real-Time Productboard Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Productboard in ColdFusion.
-
Build Splunk Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Splunk and build visualizations in Tableau Cloud.
-
Build Apps with Live Pipeliner CRM Data Using the Low-Code Development Platform of Mendix
Connect Pipeliner CRM with Mendix to build apps using the CData API Driver for JDBC.
-
Use Biml to Build SSIS Tasks to Replicate WooCommerce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate WooCommerce to SQL Server.
-
Model, Search, and Visualize Live SAP ByDesign Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Business ByDesign for modeling, searching, and visualizing.
-
Back Up Omnisend 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 Omnisend data.
-
Work with ClickTime Data in FoxPro
Load ClickTime into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous PabblySubscriptions Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to delimited files (CSV/TSV).
-
Access SAP Business One Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Business One from HeidiSQL.
-
Connect to Zoom Data from AWS Glue
Use CData Connect AI to gain access to live Zoom from your AWS Glue jobs.
-
Automated Continuous Square Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Square replication to Apache Kafka.
-
Integrating Boomi Agentstudio with Google Spanner Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Spanner, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software ODBC Driver for Vault CRM in MicroStrategy
Connect to Veeva Vault & Vault CRM in MicroStrategy Developer using the CData Software ODBC Driver for Vault CRM.
-
How to Connect to & Open Redshift Data in Microsoft Excel
This article uses the CData ODBC driver for Redshift to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build an OLAP Cube in SSAS from Mistral AI Data
Establish a connection to Mistral AI data from SQL Server Analysis Services, and use the Mistral AI Data Provider to build OLAP cubes for use in analytics and reporting.