CData Software - Knowledge Base
Recent Articles
-
Work with Live ClickUp Data in Power Query
Use CData Connect AI to connect to ClickUp data and work with live ClickUp data in Microsoft Power Query.
-
Create Kintone-Connected Applications in Appsmith
Connect to Kintone Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Kintone data.
-
Connect to Oracle Eloqua Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Eloqua data in Google Apps Script.
-
Visualize PDFMonkey Data in Sisense
Create an ElastiCube in Sisense app with access to PDFMonkey data.
-
How to integrate WooCommerce with Apache Airflow
Access and process WooCommerce data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to & Open Elasticsearch Data in Microsoft Excel
This article uses the CData ODBC driver for Elasticsearch to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Oracle HCM Cloud Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle HCM Cloud data and build visualizations in Tableau.
-
Access Live Google Tasks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Tasks data into the statistical analysis tools available in SAS JMP. This article shows how to use Google Tasks data in the Graph Builder and Query Builder.
-
Integrating Antigravity CLI with Recurly data via CData CLI
Connect Recurly data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze PingOne Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PingOne data in Microsoft R Open.
-
Design BIRT Reports on PostgreSQL Data
Provide current PostgreSQL data to your embedded analytics.
-
Automate Nuclia Data Replication to Azure Synapse
Use CData Sync to customize and automate Nuclia data replication to Azure Synapse.
-
Analyze Active Directory Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Active Directory data with the CData JDBC Driver for Active Directory.
-
Connect Cvent Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Cvent data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Trae with Live MariaDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live MariaDB data from within the AI-powered IDE.
-
Build Azure DevOps-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure DevOps Data from Zoho Analytics and import live Azure DevOps data.
-
Automated Continuous Beeminder Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Beeminder replication to Google Cloud SQL.
-
Use the CData Software ODBC Driver for Gmail in SAS for Real-Time Reporting and Analytics
Connect to real-time Gmail data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gmail.
-
Query Asana Data in ColdFusion
Write standard ColdFusion data access code to connect to Asana data.
-
Query Reckon Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Reckon entities in PHP by modeling them as objects.
-
Build Data Flows from Elasticsearch to SQL Server using SSIS
Easily back up Elasticsearch data to SQL Server using the SSIS components for Elasticsearch.
-
Access Live SAS xpt Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS xpt data from your Google Sheets.
-
Automated Continuous GetResponse Replication to MongoDB
Use CData Sync for automated, continuous, customizable GetResponse replication to MongoDB.
-
How to Work with Epicor Kinetic Data in AWS Glue Jobs Using JDBC
Connect to Epicor Kinetic from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Kafka-Connected Apps in Choreo
Use CData Connect AI to connect to Kafka Data from Choreo and build custom apps using live Kafka data.
-
Connect to Bannerbear Data in Google Apps Script via Connect AI
Use CData Connect AI to access Bannerbear data in Google Apps Script.
-
Import Testmonitor Data Using Azure Data Factory
Use CData Connect AI to connect to Testmonitor Data from Azure Data Factory and import live Testmonitor data.
-
How to Connect to Live Optimizely 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 Optimizely data through natural language.
-
Analyze Sybase IQ Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sybase IQ data with the CData JDBC Driver for Sybase IQ.
-
Connect to Live Certinia Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Certinia in CData Connect AI and connect to your Certinia data from PostgreSQL.
-
Connect to Mode 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 Mode data.
-
Access Live Shippo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Shippo data from your Excel spreadsheets.
-
Query Instagram Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Instagram data from Node.js.
-
Integrate with Live BigCommerce Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BigCommerce from the MuleSoft Anypoint Platform to integrate live BigCommerce data into custom reports and dashboards.
-
Create Freshdesk-Connected Nintex Workflows
Use CData Connect AI to connect to Freshdesk Data from Nintex Workflow Cloud and build custom workflows using live Freshdesk data.
-
Moving Data from ServiceNow to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ServiceNow data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Google's Antigravity Agent with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Stripe data using the Model Context Protocol.
-
Choosing the Best Method to Connect AlloyDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use AlloyDB data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Omnisend Data Replication to SAP HANA
Use CData Sync to customize and automate Omnisend data replication to SAP HANA.
-
Access Elasticsearch Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Elasticsearch data from your Oracle system.
-
Create Deel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Deel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Interact with Live Microsoft Teams Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Microsoft Teams data.
-
Getting Started with the CData ADO.NET Provider for Discord
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Square Replication to Oracle
Use CData Sync for automated, continuous, customizable Square replication to Oracle.
-
Create SSAS Tabular Models from Rootly Data
How to build a SQL Server Analysis Service Tabular Model from Rootly data using CData drivers.
-
Integrating LangChain with Adobe Target Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Adobe Target data within automated workflows.
-
Connect to CapsuleCRM Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CapsuleCRM and work with CapsuleCRM data in your FileMaker applications.
-
Create Reports with ZarMoney Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZarMoney data.
-
Enable the CloudConvert JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CloudConvert data.
-
Create Dynamic Microsoft Dataverse Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Dataverse to Infragistics XamDataGrid to build dynamic grids.
-
Integrate with live Oracle Financials Cloud Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle Financials Cloud data in Jitterbit.
-
Prepare, Blend, and Analyze Salesforce Pardot Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesforce Pardot data for self-service data analytics.
-
Import and Visualize Azure Data Lake Storage Data in Power View
Create data visualizations based on Azure Data Lake Storage data in Excel.
-
Build LDAP-Connected Apps in Choreo
Use CData Connect AI to connect to LDAP Objects from Choreo and build custom apps using live LDAP objects.
-
Connect to ShipStation Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ShipStation data.
-
Integrating Codex with Nethunt 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 Live Box 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 Box data for you.
-
Automated Continuous GetResponse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GetResponse replication to Google BigQuery.
-
Integrating LangGraph with SAP SuccessFactors LMS Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP SuccessFactors LMS data within automated workflows.
-
Use Azure AI Foundry to Talk to Your GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your GitHub data for you.
-
Automated Continuous SageHR Replication to SingleStore
Use CData Sync for automated, continuous, customizable SageHR replication to SingleStore.
-
Use Dash to Build to Web Apps on Monday.com Data
Create Python applications that use pandas and Dash to build Monday.com-connected web apps.
-
Build AI/ML Models with Live Salesforce Data using Dataiku
Connect Salesforce Data with Dataiku using the CData JDBC Driver for Salesforce.
-
Replicate CSV Data to Multiple Databases
Replicate CSV data to disparate databases with a point-and-click configuration.
-
Integrate with Live SharePoint Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SharePoint from the MuleSoft Anypoint Platform to integrate live SharePoint data into custom reports and dashboards.
-
Connect to Cosmos DB Data in DBArtisan
Use wizards in DBArtisan to configure Cosmos DB data as a data source.
-
Model, Search, and Visualize Live Snapchat Ads Data in ThoughtSpot
Use CData Connect AI to connect to live Snapchat Ads data for modeling, searching, and visualizing.
-
Integrating LlamaIndex with ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ShipStation data in real time.
-
Build Dashboards with MailerSend Data in DBxtra
Create dynamic dashboards and perform analytics based on MailerSend data in DBxtra.
-
Connect to CSV Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CSV and the SQL Gateway to access CSV data from Google Apps Script.
-
How to Access Acumatica Data Using Entity Framework
This article shows how to access Acumatica data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to work with ChartMogul Data in Apache Spark using SQL
Access and process ChartMogul Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous HubSpot Replication to SQLite
Use CData Sync for automated, continuous, customizable HubSpot replication to SQLite.
-
Integrate Discourse Data in the Pentaho Report Designer
Publish reports based on Discourse data in the Pentaho BI tool.
-
Integrating Dataiku with Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Presto data.
-
Access Live Rebilly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Rebilly data into the statistical analysis tools available in SAS JMP. This article shows how to use Rebilly data in the Graph Builder and Query Builder.
-
Use Azure AI Foundry to Talk to Your ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your ConstantContact data for you.
-
Access Live Airtable Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Airtable data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Google Calendar Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Calendar data in Google Apps Script.
-
Connect to Figshare Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Figshare to connect to Figshare data and execute queries in PowerBuilder.
-
Create BenchmarkEmail-Connected Nintex Workflows
Use CData Connect AI to connect to BenchmarkEmail Data from Nintex Workflow Cloud and build custom workflows using live BenchmarkEmail data.
-
Integrate AfterShip Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live AfterShip data from Informatica Cloud.
-
How to connect Amazon QuickSight to Stripe Data
Create a connection to Stripe data in CData Connect AI and insert Stripe data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData ODBC Driver for PDFMonkey in Microsoft Power Query
You can use the CData PDFMonkey ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PDFMonkey data into Microsoft Power Query.
-
Analyze Greenplum Data in Cognos Analytics
Use CData Connect AI to connect to Greenplum Data from Cognos Analytics and analyze live Greenplum data.
-
Choosing the Best Method to Connect Salesforce Data 360 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce Data 360 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations in Cognos BI with Bright Data Data
Access Bright Data data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Migrating data from Salesforce Pardot to Google BigQuery using CData SSIS Components.
Easily push Salesforce Pardot data to Google BigQuery using the CData SSIS Tasks for Salesforce Pardot and Google BigQuery.
-
Connect to PagerDuty Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PagerDuty data.
-
How to Connect to Mistral AI Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mistral AI data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Elasticsearch Data from Crystal Reports
Use CData Connect AI to connect to and report on live Elasticsearch data from Crystal Reports.
-
Connect to Office 365 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Office 365 to connect to Office 365 data from Web applications running on WebLogic.
-
Automated Continuous Oracle Service Cloud Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to SQL Server.
-
Connect to ShipEngine Data in RapidMiner
Integrate ShipEngine data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect the Power BI Service to SAP Ariba Procurement: Complete Guide
Connect to the CData Software Power BI Connector for SAP Ariba Procurement from PowerBI.com to provide real-time SAP Ariba Procurement data across the organization.
-
How to Connect Flowise AI Agents to Live ClickUp Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live ClickUp data without replication.
-
Access Live Adobe Target Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Adobe Target data from your Excel spreadsheets.
-
Create Informatica Mappings From/To an ODBC Data Source for Aircall
Create an ODBC connection to Aircall in Informatica and browse and transfer Aircall data.
-
Connect to ADP Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ADP Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze MailerLite Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MailerLite data with the CData JDBC Driver for MailerLite.