CData Software - Knowledge Base
Recent Articles
-
Access Live Simplesat Data in AWS Lambda
Connect to live Simplesat data in AWS Lambda using the CData JDBC Driver.
-
Build a PostgreSQL Interface for Gmail Data using the CData JDBC Driver
Use the Remoting features of the Gmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Grok to Talk to Your Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Marketo data for you.
-
Query Cassandra Data in ColdFusion
Write standard ColdFusion data access code to connect to Cassandra data.
-
Access Live SAP SuccessFactors LMS Data in Excel 365 Online (Excel for the web)
Connect to SAP SuccessFactors LMS data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Google Campaign Manager 360 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Campaign Manager 360 data from HeidiSQL.
-
Build Visualizations of Clari Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Clari data in Birst.
-
Automated Continuous AdRoll Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable AdRoll replication to Azure SQL Database.
-
How to connect to ConvertAPI Data in DBVisualizer
Integrate ConvertAPI data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to ServiceNow Data from Crystal Reports
Use CData Connect AI to connect to and report on live ServiceNow data from Crystal Reports.
-
Integrating GitHub Copilot with Kintone 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 and Visualize Live Cassandra Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Cassandra data into the Databricks platform and create visualization dashboards with real-time Cassandra data.
-
Visualize Live Wrike Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Wrike data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Codex with ChargeOver 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.
-
Build AI/ML Models with Live ServiceNow Data using Dataiku
Connect ServiceNow Data with Dataiku using the CData JDBC Driver for ServiceNow.
-
Connect to PabblySubscriptions Data in Ruby
Connect to PabblySubscriptions data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Work with Google Tasks Data in AWS Glue Jobs Using JDBC
Connect to Google Tasks from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Anaplan-Connected Business Apps in AppSheet
Connect to Anaplan Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Anaplan data.
-
Build an OLAP Cube in SSAS from Vercel Data
Establish a connection to Vercel data data from SQL Server Analysis Services, and use the Vercel Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Short.io Data to Multiple Databases
Replicate Short.io data to disparate databases with a point-and-click configuration.
-
Visualize Live DocuSign Data in the Power BI Service
Use CData Connect AI to connect to live DocuSign data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build NetSuite SuiteAnalytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live NetSuite SuiteAnalytics data and build visualizations in Tableau.
-
Connect to Jumpseller Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Jumpseller and work with Jumpseller data in your FileMaker application.
-
Connect and Visualize Live SAP Business One Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Business One data into the Databricks platform and create visualization dashboards with real-time SAP Business One data.
-
Use the CData Software ODBC Driver for Mocean in SAS for Real-Time Reporting and Analytics
Connect to real-time Mocean data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mocean.
-
Getting Started with the CData Excel Add-In for BigCommerce
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for BigCommerce.
-
Build Dashboards with Outlook Data in DBxtra
Create dynamic dashboards and perform analytics based on Outlook data in DBxtra.
-
Integrate Live Wave Financial 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 Wave Financial data from within the IDE.
-
Enable the SAP Concur JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Concur data.
-
Replicate Figshare Data to Multiple Databases
Replicate Figshare data to disparate databases with a point-and-click configuration.
-
Integrate Cursor with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ServiceNow data from within the editor.
-
Integrate Salesforce Pardot Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Salesforce Pardot data and integrate live Salesforce Pardot data into your Power Automate tasks.
-
Use the CData Software ODBC Driver for Cosmos DB in SAS for Real-Time Reporting and Analytics
Connect to real-time Cosmos DB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cosmos DB.
-
Integrate Mouseflow Data in Pentaho Data Integration
Build ETL pipelines based on Mouseflow data in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with RabbitMQ Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to RabbitMQ data.
-
Integrate with HubSpot Data in SnapLogic
Use CData Connect AI to connect to and integrate with live HubSpot data in SnapLogic.
-
Connect to SAP Business One Data in HULFT Integrate
Connect to SAP Business One as a JDBC data source in HULFT Integrate
-
Connect to Missive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Missive to connect to Missive data from Web applications running on WebLogic.
-
Query RabbitMQ Data as a MySQL Database in Node.js
Execute MySQL queries against RabbitMQ data from Node.js.
-
Automated Continuous ElevenLabs Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ElevenLabs replication to Apache Kafka.
-
How to Connect to Live Amazon Athena 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 Amazon Athena data for you.
-
Analyze MariaDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MariaDB data with the CData JDBC Driver for MariaDB.
-
Connecting Moonlit Workflow with Twitter Ads 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 Twitter Ads data in real time.
-
Getting Started with the CData Tableau Connector for Short.io
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Rapidly Develop BenchmarkEmail-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by BenchmarkEmail.
-
How to Query Pipeline CRM Data in MySQL Workbench
Execute MySQL queries against live Pipeline CRM data from MySQL Workbench.
-
Connect to ShipStation Data from PowerBuilder via JDBC
This article demonstrates how to access ShipStation data from PowerBuilder using the ShipStation JDBC Driver.
-
Access Live MailChimp Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MailChimp data from your Google Sheets.
-
Publish Crystal Reports on Pinterest Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pinterest data.
-
How to Connect to Live xBase 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 xBase data for you.
-
Easily Integrate Salesforce Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Process & Analyze ScrapingBee Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ScrapingBee Data.
-
How to Work with Greenplum Data in ETL Validator JDBC
Connect to Greenplum from ETL Validator jobs using the CData Software JDBC Driver.
-
Consume XML OData Feeds in SAP Lumira
Use the API Server to create data visualizations on XML feeds that reflect any changes in SAP Lumira.
-
Integrate Live Access Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Access data to Blue Prism using the CData ODBC Driver for Access to create automated workflows for repetitive business tasks.
-
Use Databricks Agent Bricks to Talk to Your Zendesk Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zendesk data for you.
-
How to Build an ETL App for Aweber Data in Python with CData Connect AI
Extract and transform live Aweber data in Python with petl and the CData Connect AI Python SDK.
-
Integrating Codex with Trello 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.
-
Analyze SurveyMonkey Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SurveyMonkey data and visualize live SurveyMonkey data in Infragistics Reveal.
-
Automated Continuous Invoiced Replication to MySQL
Use CData Sync for automated, continuous, customizable Invoiced replication to MySQL.
-
SharePoint Excel Services Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SharePoint Excel Services facts in real time.
-
Integrate OpenCode with Live Microsoft Entra ID Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Microsoft Entra ID data from within your AI coding agent.
-
DataBind Charts to Front Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Front 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.
-
Integrate with AfterShip Data in SnapLogic
Use CData Connect AI to connect to and integrate with live AfterShip data in SnapLogic.
-
Automated Continuous Workday Replication to Oracle
Use CData Sync for automated, continuous, customizable Workday replication to Oracle.
-
Connect to Clio Data from PowerBuilder via JDBC
This article demonstrates how to access Clio data from PowerBuilder using the Clio JDBC Driver.
-
Use the CData Software JDBC Driver for Opsgenie in MicroStrategy Web
Connect to Opsgenie data in MicroStrategy Web using the CData Software JDBC Driver for Opsgenie.
-
Interact with Live Redis Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Redis data.
-
Add Bullhorn CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bullhorn CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Hacker News Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Hacker News replication to Google BigQuery.
-
Connect to Active Directory Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Active Directory data from Filemaker Pro on Mac.
-
Access Live Shortcut 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 Shortcut data through MCP integration.
-
How to Work with Slack Data in ETL Validator JDBC
Connect to Slack from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate NetSuite SuiteAnalytics Data in Heroku for Use in Salesforce Connect
Replicate NetSuite SuiteAnalytics data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect Amazon QuickSight to SAP BusinessObjects BI Data
Create a connection to SAP BusinessObjects BI data in CData Connect AI and insert SAP BusinessObjects BI data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software JDBC Driver for Onfleet in MicroStrategy Desktop
Connect to Onfleet data in MicroStrategy Desktop using the CData Software JDBC Driver for Onfleet.
-
Integrating OpenCode with Salesforce Data 360 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.
-
Automated Continuous Attio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Attio replication to SQL Server.
-
Connect to Redis Data in Aqua Data Studio
Access Redis data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Dashboards and Visualize Live SQL Analysis Services Data in Geckoboard
Use CData Connect AI to connect to live SQL Analysis Services data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate iContact Data to Multiple Databases
Replicate iContact data to disparate databases with a point-and-click configuration.
-
Integrate Cline with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon Athena data from within your IDE.
-
How to update MariaDB from Excel
This article explains how to transfer data from Excel to MariaDB using the Excel Add-In for MariaDB.
-
Publish OpenWeatherMap-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OpenWeatherMap data.
-
Publish Reports with eBay Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date eBay Analytics data.
-
Explore Geographical Relationships in BenchmarkEmail Data with Power Map
Create data visualizations with BenchmarkEmail data in Power Map.
-
Build Data Flows from Discourse to SQL Server using SSIS
Easily back up Discourse data to SQL Server using the SSIS components for Discourse.
-
Rapidly Develop Amazon S3-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Amazon S3.
-
Create Reports with Excel Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Excel Online data.
-
How to work with JDBC-ODBC Bridge Data in Apache Spark using SQL
Access and process JDBC-ODBC Bridge Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Outreach.io Data in NetBeans
Connect to Outreach.io data in NetBeans with the data source configuration wizard.
-
How to Connect to Live Sage Cloud Accounting 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 Sage Cloud Accounting data for you.
-
Build Apps with Live Acumatica Data Using the Low-Code Development Platform of Mendix
Connect Acumatica data with Mendix to build apps using the CData JDBC Driver for Acumatica.
-
Build AI/ML Models with Live Azure DevOps Data using Dataiku
Connect Azure DevOps Data with Dataiku using the CData JDBC Driver for Azure DevOps.
-
Edit and Search External Box Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Box data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Box Data objects that you can access from apps and the dashboard.
-
Build a Singer.io Tap for LaunchDarkly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LaunchDarkly data using the CData Python Connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Missive
Provide connectivity to Missive data through an SAP BusinessObjects universe.
-
Migrating data from SAP to Databricks using CData SSIS Components.
Easily push SAP data to Databricks using the CData SSIS Tasks for SAP and Databricks.
-
Connect to NASA Data from a Connection Pool in JBoss
Integrate NASA data into Java servlets: Use the Management Console in JBoss to install the NASA JDBC Driver.
-
Automate Google Contacts Data Replication to SAP HANA
Use CData Sync to customize and automate Google Contacts data replication to SAP HANA.