CData Software - Knowledge Base
Recent Articles
-
Access Live CampaignMonitor Data in Coginiti Pro
Connect to and query live CampaignMonitor data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize ConvertAPI Data in TIBCO Spotfire through ADO.NET
Integrate ConvertAPI data into dashboards in TIBCO Spotfire.
-
Replicate Autopilot Data to Multiple Databases via the CData Sync CLI
Replicate Autopilot data to disparate databases with a single configuration.
-
Analyze Greenplum Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Greenplum data with the CData JDBC Driver for Greenplum.
-
Connect to Square Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Square as an External Source in Dremio.
-
Extract, Transform, and Load Moosend Data in Informatica PowerCenter
Create a simple Workflow for Moosend data in Informatica PowerCenter.
-
Build Google Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Ads Data and create custom apps in Bubble.
-
Viewing Nuclia Data in RAD Studio Data Explorer
How to view Nuclia data in RAD Studio Data Explorer using the CData ODBC Driver for Nuclia.
-
Excel Spreadsheet Automation on SendGrid Data with the QUERY Formula
Pull data from SendGrid, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Gumroad in MicroStrategy Desktop
Connect to Gumroad data in MicroStrategy Desktop using the CData Software ODBC Driver for Gumroad.
-
Connect to Optimizely 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 Optimizely and work with Optimizely data in your FileMaker application.
-
How to Visualize Tavily 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 Tavily data in Python.
-
Use Azure AI Foundry to Talk to Your Bannerbear 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 Bannerbear data for you.
-
How to Seamlessly Import Missive Data into IBM SPSS Modeler
Integrate Missive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect to Cosmos DB Data from IntelliJ
Integrate connectivity to Cosmos DB data with wizards in IntelliJ.
-
Build Coda-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Coda data and build web apps with connectivity to live Coda data.
-
Connect to GitLab Data in HULFT Integrate
Connect to GitLab as a JDBC data source in HULFT Integrate
-
How to Keep Microsoft Access Working After an ERP Cloud Migration
A guide on using the CData ODBC Driver to restore Microsoft Access connectivity after a cloud ERP migration to NetSuite, Acumatica, or Business Central, enabling finance teams to run existing queries against live ERP data without rebuilding workflows.
-
How to Work with Wave Financial Data in AWS Glue Jobs Using JDBC
Connect to Wave Financial from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Perplexity Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Perplexity data from your Excel spreadsheets.
-
Integrating OpenCode with ElevenLabs 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 Email Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Email data with the CData JDBC Driver for Email.
-
Moving Data from SAP Fieldglass to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Fieldglass data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Gmail 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 Gmail data.
-
Automated Continuous LDAP Replication to SQLite
Use CData Sync for automated, continuous, customizable LDAP replication to SQLite.
-
How to Work with BigCommerce Data in AWS Glue Jobs Using JDBC
Connect to BigCommerce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Zuora-Connected Apps in Choreo
Use CData Connect AI to connect to Zuora Data from Choreo and build custom apps using live Zuora data.
-
Import Real-Time Bugsnag Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bugsnag data in ColdFusion.
-
Build Shortcut-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 Shortcut data without replication.
-
Integrating Zoho CRM Data in Talend Cloud Data Management Platform
Connect Zoho CRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zoho CRM.
-
Replicate Freshsales Data to Multiple Databases via the CData Sync CLI
Replicate Freshsales data to disparate databases with a single configuration.
-
Excel Spreadsheet Automation on Microsoft Entra ID Data with the QUERY Formula
Pull data from Microsoft Entra ID, automate spreadsheets, and more with the QUERY formula.
-
Integrate with live Salesforce Data 360 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce Data 360 data in Jitterbit.
-
Use the CData ODBC Driver for Codat in Microsoft Power Query
You can use the CData Codat ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Codat data into Microsoft Power Query.
-
Integrating Claude Code with XML Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on XML data within assisted coding and automated development workflows.
-
Connect to Nuclia Data in Jaspersoft Studio
Execute SQL to remote Nuclia data in Jaspersoft Studio.
-
Import Real-Time Phoenix Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Phoenix data in ColdFusion.
-
Natively Connect to GitLab Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to GitLab data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Cohere Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Cohere replication to PostgreSQL.
-
How to Connect to Live Impala Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Impala data without replication.
-
Analyze Live SAP ByDesign Data in SAS Viya
Use CData Connect AI to connect to SAP ByDesign data from SAS Viya and deploy self-service analytics using live SAP ByDesign data.
-
Access Paylocity 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 Paylocity data.
-
Access Live Bullhorn CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Bullhorn CRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Dashboards with Factorial Data in DBxtra
Create dynamic dashboards and perform analytics based on Factorial data in DBxtra.
-
Use the CData Software JDBC Driver for Adobe Experience Manager in MicroStrategy Web
Connect to Adobe Experience Manager data in MicroStrategy Web using the CData Software JDBC Driver for Adobe Experience Manager.
-
Query SAP Concur Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Concur data from Node.js.
-
Integrate with live Toggl Data in Jitterbit
Use CData Connect AI to connect to and integrate live Toggl data in Jitterbit.
-
Integrating Cursor with Nuclia 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.
-
Process & Analyze Google Cloud Storage Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Cloud Storage Data.
-
Visualize Live Act-On Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Act-On data.
-
Integrate Live Oracle Service Cloud Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle Service Cloud data to Blue Prism using the CData ODBC Driver for Oracle Service Cloud to create automated workflows for repetitive business tasks.
-
Integrate Google's Vertex AI Agent with Live Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Freshteam data within intelligent workflows.
-
Integrate Amazon Marketplace Data in Pentaho Data Integration
Build ETL pipelines based on Amazon Marketplace data in the Pentaho Data Integration tool.
-
Provide OData Services of Email Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Email data by developing a WCF Service Application.
-
How to import HelloSign Data into Apache Solr
Use the CData Software JDBC Driver for HelloSign in Data Import Handler and create an automated import of HelloSign data to Apache Solr Enterprise Search platform.
-
Access Live Jira Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Jira data from your Google Sheets.
-
How to Connect to SendInBlue Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SendInBlue data. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for Cloudant in MicroStrategy
Connect to Cloudant data in MicroStrategy Developer using the CData Software ODBC Driver for Cloudant.
-
Integrate Live ServiceDesk Plus Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ServiceDesk Plus from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ServiceDesk Plus data.
-
Connect to Freshteam Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshteam data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Bidirectional Access to PostgreSQL Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PostgreSQL data in Filemaker Pro for Mac or Windows.
-
How to Build an ETL App for Shopify Data in Python with CData Connect AI
Build ETL pipelines that read and write live Shopify data in Python with petl and the CData Connect AI Python SDK.
-
Build Data Flows from SQL Server to Exact Online through SSIS
Easily push SQL Server data to Exact Online using the CData SSIS Tasks for Exact Online.
-
Connect to AgileCRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for AgileCRM data.
-
Visualize HubDB Data in TIBCO Spotfire through OData
Integrate HubDB data into dashboards in TIBCO Spotfire.
-
Connect to Copper Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Copper data in the Denodo Virtual DataPort Administrator.
-
Build SAP SuccessFactors Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP SuccessFactors data and build visualizations in Tableau.
-
Access Live Microsoft Entra ID Data in TIBCO Data Virtualization
Use the Microsoft Entra ID Tibco DV Adapter to create a Microsoft Entra ID data data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Entra ID data from your TDV Server.
-
Visualize Live PabblySubscriptions Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PabblySubscriptions data.
-
Connecting GenSpark with Aweber Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Aweber data without any replication or custom integration required.
-
Integrating GitHub Copilot with QuickBooks 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.
-
Use JayDeBeApi to access Contentful Data in Python
Use standard Python scripting and the development environment of your choice to access live Contentful data.
-
How to integrate PingOne with Apache Airflow
Access and process PingOne data in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Figshare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Figshare data.
-
Connecting Mastra with Google Calendar 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 Google Calendar data, no replication required.
-
Publish Crystal Reports on OpenWeatherMap Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date OpenWeatherMap data.
-
Integrating Gumloop with Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Klipfolio data within automated workflows.
-
Work with Amplitude Data in FoxPro
Load Amplitude data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate SparkPost Data from PowerShell
Write a quick PowerShell script to query SparkPost data. Use connectivity to the live data to replicate SparkPost data to SQL Server.
-
Integrate Open WebUI with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ADP data from within the chat interface.
-
Replicate Brex Data from PowerShell
Write a quick PowerShell script to query Brex data. Use connectivity to the live data to replicate Brex data to SQL Server.
-
Integrating Codex with Workday 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.
-
Natively Connect to AlloyDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to AlloyDB data. Leverage the native support for ODBC in PHP.
-
Add SFTP Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SFTP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Google Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to Google Cloud SQL.
-
Connect to Cvent Data in CloverDX (formerly CloverETL)
Transfer Cvent data using the visual workflow in the CloverDX data integration tool.
-
Visualize Live ServiceDesk Plus Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ServiceDesk Plus data into custom reports in Power BI.
-
Automated Continuous SAP Ariba Procurement Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to MySQL.
-
Consume OneNote OData Feeds in PowerBuilder
This article demonstrates how to consume OneNote data as OData feeds from PowerBuilder using the API Server.
-
How to Connect to Live ClickUp 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 ClickUp data for you.
-
Create Apps from Gong Data in Qlik Sense Cloud
Use CData Connect AI to connect to Gong Data and build apps from live Gong data in Qlik Sense Cloud.
-
Visualize Grafana Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Grafana data.
-
Use Microsoft Copilot Studio to talk to your Google Ads 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 Ads data for you.
-
Build AI Agents with Workday 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 Workday data through CData Connect AI.
-
Integrate with NetSuite Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy NetSuite data to a JSON file on disk.
-
How to Connect Flowise AI Agents to Live Dynamics 365 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 Dynamics 365 data without replication.
-
Integrate Live Microsoft Exchange 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 Microsoft Exchange data from within the IDE.
-
Analyze Exact Online Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Exact Online from Power Pivot. You will use the Table Import Wizard to load Exact Online data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Google Contacts from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Contacts data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze FreeAgent Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze FreeAgent data in Microsoft R Open.