CData Software - Knowledge Base
Recent Articles
-
Access Live Quickbase Data in Coginiti Pro
Connect to and query live Quickbase data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Salesforce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce and the SQL Gateway to access Salesforce data from Google Apps Script.
-
Automated Continuous Confluence Replication to Databricks
Use CData Sync for automated, continuous, customizable Confluence replication to Databricks.
-
Access Discourse Data from MySQL in Amazon QuickSight
Connect to Discourse and build visualizations of Discourse data using a MySQL Connection in Amazon QuickSight.
-
Access Live Gmail Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gmail data from your Google Sheets.
-
Getting Started with the CData ADO.NET Provider for Power BI XMLA
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Power BI XMLA.
-
Work with Printify Data in FoxPro
Load Printify data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Egnyte Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Egnyte data into the statistical analysis tools available in SAS JMP. This article shows how to use Egnyte data in the Graph Builder and Query Builder.
-
Access Live Unbounce Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Unbounce data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Printify 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 Printify data.
-
Integrate with live HubDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live HubDB data in Jitterbit.
-
Integrate Trae with Live MarkLogic Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live MarkLogic data from within the AI-powered IDE.
-
Validate Pipedrive Data with QuerySurge
Access and validate Pipedrive data in QuerySurge using the CData JDBC Driver.
-
Integrate Postmark Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Postmark data from Informatica Cloud.
-
How to Work with SparkPost Data in ETL Validator JDBC
Connect to SparkPost from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Snowflake Data
Use CData Power BI Connectors to visualize Snowflake data in Power BI.
-
Import Real-Time Rootly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Rootly data in ColdFusion.
-
Create Dynamic SAP Concur Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Concur to Infragistics XamDataGrid to build dynamic grids.
-
Build AI/ML Models with Live xBase Data using Dataiku
Connect xBase Data with Dataiku using the CData JDBC Driver for xBase.
-
Integrating OpenCode 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.
-
Moving Data from Google Forms to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Forms data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Phoenix Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Phoenix replication to Azure SQL Database.
-
Automated Timely Data Replication to Teradata
Use CData Sync to Customize and automate Timely data replication to Teradata.
-
Automated Continuous CloudConvert Replication to Vertica
Use CData Sync for automated, continuous, customizable CloudConvert replication to Vertica.
-
Migrating data from Mouseflow to Google BigQuery using CData SSIS Components.
Easily push Mouseflow data to Google BigQuery using the CData SSIS Tasks for Mouseflow and Google BigQuery.
-
Getting Started with the CData Tableau Connector for GitLab
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Getting Started with the CData Excel Add-In for Parquet
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Parquet.
-
Load ZohoPeople Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoPeople data to a database.
-
Automated Continuous Azure DevOps Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Azure SQL Database.
-
How to Seamlessly Import Marketo Data into IBM SPSS Modeler
Integrate Marketo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Migrating data from Azure Analysis Services to Snowflake using CData SSIS Components.
Easily push Azure Analysis Services data to Snowflake using the CData SSIS Tasks for Azure Analysis Services and Snowflake.
-
How to Connect to ZohoPeople Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoPeople data. Leverage the pyodbc module for ODBC in Python.
-
Build Data Flows from Dynamics NAV to SQL Server using SSIS
Easily back up Dynamics NAV data to SQL Server using the SSIS components for Dynamics NAV.
-
Use Dash to Build Web Apps on ShipEngine Data via CData Connect AI
Build interactive Dash web apps on live ShipEngine data using pandas and the CData Connect AI Python SDK.
-
Integrate Live Xero Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Xero from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Xero data.
-
Connecting Moonlit Workflow with Outreach.io 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 Outreach.io data in real time.
-
How to Connect to Live Box Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Box data for you.
-
Use Manus AI to Talk to Your Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Zoho Creator data.
-
Access Live Azure Data Catalog Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Data Catalog data from your Excel spreadsheets.
-
Query Workday Data in DataGrip
Create a Data Source for Workday in DataGrip and use SQL to query live Workday data.
-
Automated Continuous Azure Data Catalog Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Google BigQuery.
-
How to Build an ETL App for DocuSign Data in Python with CData
Create ETL applications and real-time data pipelines for DocuSign data in Python with petl.
-
Build Greenplum-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 Greenplum data without replication.
-
Use Microsoft Copilot Studio to talk to your SAP ByDesign 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 SAP ByDesign data for you.
-
Automated Continuous Foursquare Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Foursquare replication to Google BigQuery.
-
Query Blackbaud FE NXT Data as a MySQL Database in Node.js
Execute MySQL queries against Blackbaud FE NXT data from Node.js.
-
How to publish and share GitLab Data dashboards with Tableau Server
The CData ODBC driver for GitLab enables you integrate GitLab data into Tableau dashboards.
-
Publish Crystal Reports on Freshsales Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Freshsales data.
-
Build Voice Agents in ElevenLabs with access to Live PayPal Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live PayPal data.
-
Use the CData Software JDBC Driver for MailerSend in MicroStrategy Desktop
Connect to MailerSend data in MicroStrategy Desktop using the CData Software JDBC Driver for MailerSend.
-
Getting Started with the CData ADO.NET Provider for Xero
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Xero.
-
Access Live Highrise Data in Coginiti Pro
Connect to and query live Highrise data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Operational Reporting on Paylocity Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Paylocity data.
-
Write a Simple Go Application to work with Google Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Ads data.
-
Feed PabblySubscriptions Data into FineReport
How to set PabblySubscriptions data as a JDBC data source in FineReport.
-
Create Reckon-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Reckon Data from Klipfolio and build custom visualizations using live Reckon data.
-
Query Live eBay Analytics 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 eBay Analytics data through a conversational interface.
-
A PostgreSQL Interface for Avaza Data (MySQL Remoting via JDBC)
Use the Remoting features of the Avaza JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate MySQL Data Replication to Couchbase
Use CData Sync to Customize and automate MySQL data replication to Couchbase.
-
Integrate Live Monday.com Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Monday.com data to Blue Prism using the CData ODBC Driver for Monday.com to create automated workflows for repetitive business tasks.
-
Integrating Cursor with BigQuery 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.
-
Integrate Snowflake Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Snowflake data from Informatica Cloud.
-
Build Agents in Relevance AI with Access to Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Splunk data within intelligent agent workflows.
-
Access Live Amazon S3 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Amazon S3 data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Ads
Provide connectivity to Google Ads data through an SAP BusinessObjects universe.
-
Connect to Live Box Data in MicroStrategy through CData Connect AI
Create a live connection to Box Data in CData Connect AI and connect to your Box data from MicroStrategy.
-
A PostgreSQL Interface for Elorus Data using the CData ODBC Driver
Use the SQL Gateway and Elorus ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Telegram Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Telegram and the SQL Gateway to access Telegram data from Google Apps Script.
-
Connect to QuickBooks Online Data in DBeaver
Use the CData ODBC Driver to connect to QuickBooks Online data in DBeaver.
-
Access MessageBird Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MessageBird data from your Oracle system.
-
Connect SAP Business One Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Business One data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Biml to Build SSIS Tasks to Replicate Scrapfly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Scrapfly data to SQL Server.
-
Interact with Live Omnisend Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Omnisend data.
-
Connect to Apollo Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Apollo data.
-
Access HDFS Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HDFS data from HeidiSQL.
-
Connect to Cloudant Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Cloudant and the Script function in FileMaker Pro to connect to Cloudant and work with Cloudant data in your FileMaker application.
-
Access Guru 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 Guru data.
-
How to Visualize Snapchat Ads Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Snapchat Ads data in Python.
-
Access Workday Data from MySQL in PHP
Connect to Workday through the standard MySQL libraries in PHP.
-
Build SendPulse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SendPulse data and build visualizations in Tableau Cloud.
-
How to Connect to Live QuickBooks Time Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your QuickBooks Time data through natural language.
-
Visualize Cloudflare Data in Sisense
Create an ElastiCube in Sisense app with access to Cloudflare data.
-
Integrate Brex Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Brex data from Informatica Cloud.
-
Getting Started with the CData Connect AI Python SDK for SAP Concur
Install the CData Connect AI Python SDK to read and write live SAP Concur data with standard DB-API 2.0 Python code.
-
Replicate AdRoll Data in Heroku for Use in Salesforce Connect
Replicate AdRoll data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Azure Analysis Services with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Analysis Services with External Services.
-
Connect to SAP SuccessFactors Data from PowerBuilder via JDBC
This article demonstrates how to access SAP SuccessFactors data from PowerBuilder using the SAP SuccessFactors JDBC Driver.
-
Back Up Microsoft Teams data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Teams. In this article, we will employ an SSIS workflow to populate a database with Microsoft Teams data data.
-
Interact with Live WooCommerce Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live WooCommerce data.
-
Build Dashboards with Square Data in DBxtra
Create dynamic dashboards and perform analytics based on Square data in DBxtra.
-
Integrating OpenCode with Jodoo 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 Drip Data in JRuby
Create a simple JRuby app with access to live Drip data.
-
Configure the CData JDBC Driver for Attio in a Connection Pool in Tomcat
Connect to Attio data from a connection pool in Tomcat.
-
Build Apps with Live Teamwork Data Using the Low-Code Development Platform of Mendix
Connect Teamwork data with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze PabblySubscriptions Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PabblySubscriptions from Power Pivot. You will use the Table Import Wizard to load PabblySubscriptions data. You can visually build the import query or use any SQL supported by the driver.
-
Enable the Azure Analysis Services JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure Analysis Services data.
-
Visualize Live Dynamics 365 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Dynamics 365 data into custom reports in Power BI.
-
Connect SharePoint to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SharePoint data using the CData Python MCP Server.
-
Automate Salesforce Pardot Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce Pardot data replication to Azure Synapse.
-
Integrate Zendesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zendesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zendesk data.