CData Software - Knowledge Base
Recent Articles
-
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 data in Dundas BI.
-
Connect to Pipeline CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Pipeline CRM.
-
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 data in Jaspersoft Studio.
-
Query Live Confluence Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Confluence data through a conversational interface.
-
Work with AlloyDB Data in FoxPro
Load AlloyDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Salesloft Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesloft data from your Excel spreadsheets.
-
Replicate Elasticsearch Data to Multiple Databases via the CData Sync CLI
Replicate Elasticsearch data 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 data in DBxtra.
-
Create Dashboards and Visualize Live VWO Data in Geckoboard
Use CData Connect AI to connect to live VWO data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Pingdom Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pingdom data from Informatica Cloud.
-
Build a Simple VCL Application for NASA Data
How to build a simple VCL Application to view NASA data 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 data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Kiro 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 data across the organization.
-
Work with Salesforce Data in FoxPro
Load Salesforce data 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.
-
Publish ChartMogul-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ChartMogul data.
-
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 data from Web applications running on WebLogic.
-
Integrating Kiro 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 data 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 data 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 data 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 data 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 data 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.
-
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 data 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 data from within the local AI agent.
-
Extract, Transform, and Load Tavily Data in Informatica PowerCenter
Create a simple Workflow for Tavily data in Informatica PowerCenter.
-
Integrate OpenCode with Live Dynamics 365 Business Central Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Dynamics 365 Business Central data from within your AI coding agent.
-
Bridge Salesforce Marketing Connectivity with Apache NiFi
Access and process Salesforce Marketing data in Apache NiFi using the CData JDBC Driver.
-
How to connect to MYOB AccountRight Data in DBVisualizer
Integrate MYOB AccountRight data 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 AlloyDB data and visualize AlloyDB data in SAP Analytics Cloud.
-
Use JayDeBeApi to access SpaceX Data in Python
Use standard Python scripting and the development environment of your choice to access live SpaceX data.
-
DataBind Charts to ZendeskSell Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZendeskSell 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.
-
Migrating data from LinkedIn to Databricks using CData SSIS Components.
Easily push LinkedIn data 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 data from your Oracle system.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ElevenLabs
Provide connectivity to ElevenLabs data 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 data into workflows built using Microsoft Power Automate Desktop.
-
Prepare, Blend, and Analyze Okta Data in Alteryx Designer (ODBC)
Build workflows to access live Okta data 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 data 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 data.
-
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 data through an SAP BusinessObjects universe.
-
Connect to Mailjet Data in DBArtisan
Use wizards in DBArtisan to configure Mailjet data as a data source.
-
Use Claude to Talk to Your Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Optimizely data for you.
-
Create SSAS Tabular Models from Yelp Data
How to build a SQL Server Analysis Service Tabular Model from Yelp data using CData drivers.
-
Use the CData Software ODBC Driver for MariaDB in SAS for Real-Time Reporting and Analytics
Connect to real-time MariaDB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MariaDB.
-
Replicate ElevenLabs Data to Multiple Databases via the CData Sync CLI
Replicate ElevenLabs data to disparate databases with a single configuration.
-
Access Live Ontraport Data in Coginiti Pro
Connect to and query live Ontraport data 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 data 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 data into TIBCO Spotfire.
-
Connect to Wave Financial Data in JRuby
Create a simple JRuby app with access to live Wave Financial data.
-
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 data 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 data 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 data.
-
How to Query SpaceX Data in MySQL Workbench
Execute MySQL queries against live SpaceX data 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.
-
Link Oracle Financials Cloud with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Financials Cloud data in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Adobe Target in MicroStrategy Web
Connect to Adobe Target data 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 data with the changes you make to Visio master shapes.
-
Build Cloudflare-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Cloudflare data without replication.
-
How to use SQLAlchemy ORM to access Phoenix Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Phoenix data.
-
Connect to Drip from a Connection Pool in WebLogic
Use the CData JDBC Driver for Drip to connect to Drip data from Web applications running on WebLogic.
-
Integrating Cursor 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 data from Node.js.
-
Access Excel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Excel data from your Oracle system.
-
Search External Avro Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Avro data 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 data 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 data.
-
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 data 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 data.
-
Query Coinbase Data as a MySQL Database in Node.js
Execute MySQL queries against Coinbase data 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 data.
-
Automate Landbot Data Replication to Azure Synapse
Use CData Sync to customize and automate Landbot data replication to Azure Synapse.
-
Import Real-Time Productboard Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Productboard data in ColdFusion.
-
Build Splunk Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Splunk data and build visualizations in Tableau Cloud.
-
Build Apps with Live Pipeliner CRM Data Using the Low-Code Development Platform of Mendix
Connect Pipeliner CRM data 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 data to SQL Server.
-
Model, Search, and Visualize Live SAP ByDesign Data in ThoughtSpot
Use CData Connect AI to connect to live SAP ByDesign data for modeling, searching, and visualizing.
-
Back Up Omnisend 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 Omnisend data data.
-
Work with ClickTime Data in FoxPro
Load ClickTime data 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 data from HeidiSQL.
-
Connect to Zoom Data from AWS Glue
Use CData Connect AI to gain access to live Zoom data 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 data, 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 Vault CRM data 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 data from SQL Server Analysis Services, and use the Mistral AI Data Provider to build OLAP cubes for use in analytics and reporting.
-
Establish a Live Connection with FHIR Data using Tableau Bridge
The CData ODBC Driver for FHIR enables you to integrate live FHIR data into Tableau Cloud dashboards using the Tableau Bridge.