CData Software - Knowledge Base
Recent Articles
-
Integrate Cline with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Epicor Kinetic from within your IDE.
-
Access Live Stripe Data in AWS Lambda
Connect to live Stripe in AWS Lambda using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Hive
Provide connectivity to Apache Hive through an SAP BusinessObjects universe.
-
Validate Google Drive Data with QuerySurge
Access and validate Google Drive in QuerySurge using the CData JDBC Driver.
-
How to Use a Microsoft Access Database to Update Splunk Data in Real Time
Update Splunk data by creating a linked table in Microsoft Access with the CData Splunk ODBC Driver.
-
ETL Discord in Oracle Data Integrator
This article shows how to transfer Discord into a data warehouse using Oracle Data Integrator.
-
Query Landbot Data in ColdFusion
Write standard ColdFusion data access code to connect to Landbot.
-
Use Grok to Talk to Your Azure DevOps 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 Azure DevOps for you.
-
Load AdRoll Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load AdRoll to a database.
-
Visualize Oracle HCM Cloud Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle HCM Cloud.
-
Use Microsoft Copilot Studio to talk to your AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google AlloyDB for you.
-
Automated Continuous SAP ByDesign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to PostgreSQL.
-
Integrate Theia IDE with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Amazon Athena Replication to SQL Server
Use CData Sync for automated, continuous, customizable Amazon Athena replication to SQL Server.
-
Integrate Trello Data into Power Automate Desktop using CData Connect
CData Connect for Trello Data enables you to integrate Trello into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Google Search Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Search replication to PostgreSQL.
-
Prepare, Blend, and Analyze Snowflake Data in Alteryx Designer (Connect AI)
Build workflows to access live Snowflake for self-service data analytics.
-
Create SAP Concur-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Concur Data from Klipfolio and build custom visualizations using live SAP Concur.
-
Connect to ClickTime Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ClickTime.
-
Integrate Reckon Accounts Hosted Data into Power Automate Desktop using CData Connect
CData Connect for Reckon Accounts Hosted Data enables you to integrate Reckon Accounts Hosted into workflows built using Microsoft Power Automate Desktop.
-
Build Data Flows from Quaderno to SQL Server using SSIS
Easily back up Quaderno to SQL Server using the SSIS components for Quaderno.
-
Connect to MailerSend Data from a Connection Pool in JBoss
Integrate MailerSend into Java servlets: Use the Management Console in JBoss to install the MailerSend JDBC Driver.
-
Use the CData ODBC Driver for Google Forms in Microsoft Power Query
You can use the CData Google Forms ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Forms into Microsoft Power Query.
-
Build Semantic Layer Views for SAS xpt Data in APOS Live Data Gateway
Use the CData Connector for SAS xpt in APOS Live Data Gateway to build Semantic Layer Views for SAS XPORT.
-
Visualize Live Phoenix Data in the Power BI Service
Use CData Connect AI to connect to live Apache Phoenix and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to use SQLAlchemy ORM to access MongoDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MongoDB.
-
Getting Started with the CData ADO.NET Provider for Onfleet
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Replicate Multiple Sage 300 Accounts
Replicate multiple Sage 300 accounts to one or many databases.
-
Analyze FHIR Data in Cognos Analytics
Use CData Connect AI to connect to FHIR Data from Cognos Analytics and analyze live FHIR.
-
Build Pipedrive-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Pipedrive to explore live Pipedrive Data in Gemini Code Assist to assist with building Pipedrive-powered applications.
-
Seamlessly Bring Hive Data into Retool Using CData Connect AI
Integrate Hive data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Oracle Sales Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle Sales from Informatica Cloud.
-
Visualize Superchat Data in Tableau
The CData ODBC driver for Superchat enables you integrate Superchat into Tableau dashboards.
-
Integrate Live Aircall Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Aircall to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Reports with Optimizely Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Optimizely.
-
Query Teamwork Data in ColdFusion
Write standard ColdFusion data access code to connect to Teamwork.
-
Publish Square-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Square.
-
AdRoll Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on AdRoll facts in real time.
-
Query Live Slack Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Slack directly from the development environment.
-
Feed Google Forms Data into FineReport
How to set Google Forms as a JDBC data source in FineReport.
-
Object-Relational Mapping (ORM) with Exa 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 Exa into a Java-based ORM framework, Hibernate.
-
Integrating Antigravity CLI with WordPress via CData CLI
Connect WordPress to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream ZarMoney Data into Apache Kafka Topics
Access and stream ZarMoney in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Zoho Inventory Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Inventory from your Excel spreadsheets.
-
How to use SQLAlchemy ORM to access Parquet Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Parquet.
-
Back Up Oracle SCM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle SCM. In this article, we will employ an SSIS workflow to populate a database with Oracle SCM data.
-
Bidirectional Access to Deel Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Deel in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for SAP Business One in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Business One in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Business One.
-
Access Live Highrise Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Highrise data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Stream PayPal Data into Apache Kafka Topics
Access and stream PayPal in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Google Ad Manager Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Ad Manager through CData Connect AI using different applications and tools.
-
Use Dash to Build to Web Apps on Amplitude Data
Create Python applications that use pandas and Dash to build Amplitude-connected web apps.
-
Integrate Datadog Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Datadog from Informatica Cloud.
-
Connect to Gumroad Data in Aqua Data Studio
Access Gumroad from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software JDBC Driver for Planio in MicroStrategy Desktop
Connect to Planio in MicroStrategy Desktop using the CData Software JDBC Driver for Planio.
-
Integrating OpenCode Terminal with Asana 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.
-
Connecting Mastra with Twitter Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Twitter Ads, no replication required.
-
Connect Close Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Close using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Write a Simple Go Application to work with Adobe Experience Manager Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Experience Manager.
-
Connect to XML Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for XML and the SQL Gateway to access XML Files from Google Apps Script.
-
Use the CData Software ODBC Driver for Splunk in MicroStrategy Desktop
Connect to Splunk in MicroStrategy Desktop using the CData Software ODBC Driver for Splunk.
-
Create Reports from Salesforce Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce & Force.com and create custom reports in Looker Studio.
-
How to Build an ETL App for Snowflake Data in Python with CData
Create ETL applications and real-time data pipelines for Snowflake in Python with petl.
-
Connect to Rootly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Rootly to connect to Rootly from Web applications running on WebLogic.
-
Build an OLAP Cube in SSAS from Tavily Data
Establish a connection to Tavily data from SQL Server Analysis Services, and use the Tavily Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Toggl Data to Multiple Databases via the CData Sync CLI
Replicate Toggl to disparate databases with a single configuration.
-
Automated Continuous Amazon Marketplace Replication to MySQL
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to MySQL.
-
Write a Simple Go Application to work with Coinbase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Coinbase.
-
Import Real-Time Snowflake Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Snowflake in ColdFusion.
-
Analyze SharePoint Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SharePoint from Power Pivot. You will use the Table Import Wizard to load Microsoft SharePoint. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Zoom Data from IntelliJ
Integrate connectivity to Zoom with wizards in IntelliJ.
-
Viewing Strava Data in RAD Studio Data Explorer
How to view Strava in RAD Studio Data Explorer using the CData ODBC Driver for Strava.
-
How to connect to SAP Ariba Source Data in DBVisualizer
Integrate SAP Ariba Source with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live Asana Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Asana for you.
-
Getting Started with the CData ADO.NET Provider for Foursquare
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Datasets from Timely in Domo Workbench and Build Visualizations of Timely Data in Domo
Use the CData Software ODBC Driver for Timely to create datasets from Timely in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Live GraphQL 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 GraphQL for you.
-
Automated Continuous Coinbase Replication to MySQL
Use CData Sync for automated, continuous, customizable Coinbase replication to MySQL.
-
Prepare, Blend, and Analyze Acumatica Data in Alteryx Designer (ODBC)
Build workflows to access live Acumatica ERP for self-service data analytics.
-
Integrate Cursor with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Procore from within the editor.
-
Create Data Visualizations in Cognos BI with Okta Data
Access Okta as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to create Visio diagrams from Sugar CRM Data
Automatically update Sugar CRM with the changes you make to Visio master shapes.
-
Query Cosmos DB Data as a MySQL Database in Node.js
Execute MySQL queries against Azure Cosmos DB from Node.js.
-
Create Dynamic Microsoft Planner Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Planner to Infragistics XamDataGrid to build dynamic grids.
-
Connect Avaza Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Avaza using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to GitLab Data from a Connection Pool in Jetty
The GitLab JDBC Driver supports connection pooling: This article shows how to connect faster to GitLab from Web apps in Jetty.
-
How to create Bannerbear federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bannerbear in MySQL .
-
Build MailChimp-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MailChimp Data and create custom apps in Bubble.
-
Getting Started with the CData Tableau Connector for OneNote
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for OneNote.
-
Analyze Aircall Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Aircall with the CData JDBC Driver for Aircall.
-
Connect to NASA Data as an External Source in Dremio
Use the CData JDBC Driver to connect to NASA as an External Source in Dremio.
-
Build Visualizations of Microsoft Exchange Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Exchange in Birst.
-
Create Data Visualizations in Cognos BI with AfterShip Data
Access AfterShip as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Zendesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zendesk.
-
How to Work with LeadDesk Data in ETL Validator JDBC
Connect to LeadDesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with Act-On 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 to Klipfolio Data from IntelliJ
Integrate connectivity to Klipfolio with wizards in IntelliJ.
-
Add Reply.io Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Reply.io with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Jira Assets Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Jira Assets from your Excel spreadsheets.
-
Import Google Spreadsheets data into FileMaker Pro
You can use the CData ODBC Driver for Google Spreadsheets to access Google Spreadsheets in FileMaker Pro as a live data source.