CData Software - Knowledge Base
Recent Articles
-
Query Live BigCommerce 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 BigCommerce data through a conversational interface.
-
Connect to Ontraport Data in HULFT Integrate
Connect to Ontraport as a JDBC data source in HULFT Integrate
-
Integrate Trae with Live Salesloft Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Salesloft data from within the AI-powered IDE.
-
Integrating Codex with Sendwithus 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.
-
Create Dynamic CouchDB Grids Using the Infragistics XamDataGrid
Learn how you can connect CouchDB to Infragistics XamDataGrid to build dynamic grids.
-
Using the CData Software ODBC Driver for GitHub in PyCharm
Connect to GitHub as an ODBC data source in PyCharm using the CData Software ODBC Driver for GitHub.
-
Integrate with Live ConstantContact Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ConstantContact from the MuleSoft Anypoint Platform to integrate live ConstantContact data into custom reports and dashboards.
-
How to Visualize Optimizely Data in Python with pandas
Use pandas and other modules to analyze and visualize live Optimizely data in Python.
-
Automate Parquet Data Replication to Azure Synapse
Use CData Sync to customize and automate Parquet data replication to Azure Synapse.
-
Integrating Dataiku with SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Ariba Procurement data.
-
Automated Continuous Zoho Projects Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho Projects replication to AlloyDB.
-
Query YouTube Analytics Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume YouTube Analytics entities in PHP by modeling them as objects.
-
How to integrate ZohoPeople with Apache Airflow
Access and process ZohoPeople data in Apache Airflow using the CData JDBC Driver.
-
Create Datasets from Google Analytics in Domo Workbench and Build Visualizations of Google Analytics Data in Domo
Use the CData Software ODBC Driver for Google Analytics to create datasets from Google Analytics data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with SAP Business One Data in JReport Designer
Create charts and reports based on SAP Business One data in JReport Designer.
-
Connecting Mastra with Zoom 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 Zoom data, no replication required.
-
Build a PostgreSQL Interface for Notion Data using the CData JDBC Driver
Use the Remoting features of the Notion JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Boomi Agentstudio with AgileCRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to AgileCRM data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Data Visualizations in Cognos BI with SpaceX Data
Access SpaceX data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Work with HCL Domino Data in FoxPro
Load HCL Domino data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Link Parquet with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Parquet data in Filemaker Pro for Mac or Windows.
-
Publish Google Contacts-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Contacts data.
-
Connect to Adobe Experience Manager 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 Adobe Experience Manager data.
-
Migrating data from Shopify to Databricks using CData SSIS Components.
Easily push Shopify data to Databricks using the CData SSIS Tasks for Shopify and Databricks.
-
Create Datasets from Google Tasks in Domo Workbench and Build Visualizations of Google Tasks Data in Domo
Use the CData Software ODBC Driver for Google Tasks to create datasets from Google Tasks data in Domo Workbench and then build visualizations in the Domo service.
-
Stream Office 365 Data into Apache Kafka Topics
Access and stream Office 365 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Visualizations of Act CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Act CRM data in Birst.
-
Add Placid Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Placid with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Dashboards with Quaderno Data in Dundas BI
Create dynamic dashboards and perform analytics based on Quaderno data in Dundas BI.
-
Create Act CRM-Connected Dashboards in Grafana
Connect to Act CRM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Act CRM data.
-
How to create Avaza federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Avaza data in MySQL .
-
Create Data Visualizations Based On MongoDB Data in Mode
Use CData Connect AI to connect to MongoDB Data from Mode and build visualizations using live MongoDB data.
-
Access Live Jira Data in Excel 365 Online (Excel for the web)
Connect to Jira data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Multiple Wave Financial Accounts via the CData Sync CLI
Replicate multiple Wave Financial accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoho Projects.
-
Build Apps with Live Azure DevOps data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure DevOps data into the Adalo platform and build custom mobile and web applications with real-time Azure DevOps data.
-
Query ShipStation Data in ColdFusion
Write standard ColdFusion data access code to connect to ShipStation data.
-
Getting Started with the CData Excel Add-In for Cohere
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cohere.
-
How to Access SAP Data Using Entity Framework
This article shows how to access SAP data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Wave Financial Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Wave Financial data from your Google Sheets.
-
Integrate Google's Antigravity Agent with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Greenhouse data using the Model Context Protocol.
-
Build Semantic Layer Views for ServiceDesk Plus Data in APOS Live Data Gateway
Use the CData Connector for ServiceDesk Plus in APOS Live Data Gateway to build Semantic Layer Views for ServiceDesk Plus data.
-
Consume Google Search OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Search feeds that reflect any changes in SAP Lumira.
-
Connect to SQL Server Data in RazorSQL
Connect to SQL Server from wizards and query SQL Server data from the GUI in the RazorSQL database management tool.
-
Connect to Salesforce Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Salesforce data in Airbyte.
-
How to work with PostgreSQL Data in Apache Spark using SQL
Access and process PostgreSQL Data in Apache Spark using the CData Software JDBC Driver.
-
Edit and Search External Instagram Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Instagram data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Instagram Data objects that you can access from apps and the dashboard.
-
Connect to Jumpseller Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Jumpseller data.
-
How to Connect DBeaver to Demio via a JDBC Driver
Manage Demio data with visual tools in DBeaver like the query browser.
-
Cvent Reporting in OBIEE with the Cvent JDBC Driver
Deploy the Cvent JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Oracle HCM Cloud-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle HCM Cloud Data from Choreo and build custom apps using live Oracle HCM Cloud data.
-
Use the CData Software ODBC Driver for Pinecone in MicroStrategy
Connect to Pinecone data in MicroStrategy Developer using the CData Software ODBC Driver for Pinecone.
-
Build QuickBooks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live QuickBooks data and build visualizations in Tableau Cloud.
-
Natively Connect to Elasticsearch Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Elasticsearch data. Leverage the native support for ODBC in PHP.
-
Integrate Live PostgreSQL Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PostgreSQL data to Blue Prism using the CData ODBC Driver for PostgreSQL to create automated workflows for repetitive business tasks.
-
Build AI/ML Models with Live SingleStore Data using Dataiku
Connect SingleStore Data with Dataiku using the CData JDBC Driver for SingleStore.
-
How to Connect to Live MySQL Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MySQL data securely in real time.
-
Integrate Dify with Live Cosmos DB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Cosmos DB data.
-
View Reports on Real-Time Discord Data in Power BI Report Server
Use the CData ODBC Driver for Discord to visualize Discord data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create ZohoDesk-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ZohoDesk Data from Klipfolio and build custom visualizations using live ZohoDesk data.
-
Automated Continuous HubSpot Replication to Oracle
Use CData Sync for automated, continuous, customizable HubSpot replication to Oracle.
-
How to use SQLAlchemy ORM to access Microsoft Planner Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Planner data.
-
How to load Box data into Elasticsearch via Logstash
Introducing a simple method to load Box data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to use SQLAlchemy ORM to access Airtable Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Airtable data.
-
Connect to SAP Business One Data from a Connection Pool in Jetty
The SAP Business One JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Business One data from Web apps in Jetty.
-
Publish Reports with SAS Data Sets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS Data Sets data.
-
Operational Reporting on Epicor Kinetic Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Epicor Kinetic data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Tally
Provide connectivity to Tally data through an SAP BusinessObjects universe.
-
Analyze SparkPost Data in Cognos Analytics
Use CData Connect AI to connect to SparkPost Data from Cognos Analytics and analyze live SparkPost data.
-
Access Live Aweber Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Aweber data from your Google Sheets.
-
Use JayDeBeApi to access Google Campaign Manager 360 Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Campaign Manager 360 data.
-
Connect to Dropbox Data in Aqua Data Studio
Access Dropbox data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build JSON-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live JSON services and build JSON-connected web apps with Axios.
-
Replicate Auth0 Data to Multiple Databases via the CData Sync CLI
Replicate Auth0 data to disparate databases with a single configuration.
-
Create Apps from Adobe Commerce Data in Qlik Sense Cloud
Use CData Connect AI to connect to Adobe Commerce Data and build apps from live Adobe Commerce data in Qlik Sense Cloud.
-
Query Live Google Forms 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 Google Forms data directly from the development environment.
-
Design BIRT Reports on MailChimp Data
Provide current MailChimp data to your embedded analytics.
-
How to connect to Outlook Data in DBVisualizer
Integrate Outlook data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to create Coda federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Coda data in MySQL .
-
Publish Crystal Reports on SuiteCRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SuiteCRM data.
-
Use the CData Software JDBC Driver for Zoho CRM in MicroStrategy Web
Connect to Zoho CRM data in MicroStrategy Web using the CData Software JDBC Driver for Zoho CRM.
-
Visualize Live Oracle Financials Cloud Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle Financials Cloud data.
-
How to Connect to Live EnterpriseDB Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your EnterpriseDB data for you.
-
How to Access Deel Data Using Entity Framework
This article shows how to access Deel data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Enable the IBM Cloud Object Storage JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with IBM Cloud Object Storage data.
-
Use the CData Software JDBC Driver for ScrapingBee in MicroStrategy Web
Connect to ScrapingBee data in MicroStrategy Web using the CData Software JDBC Driver for ScrapingBee.
-
Connect Stack Exchange to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Stack Exchange data using the CData Python MCP Server.
-
How to Query Active Directory Data in MySQL Workbench
Execute MySQL queries against live Active Directory data from MySQL Workbench.
-
Build Pipelines with Live Microsoft OneDrive Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft OneDrive from Google Cloud Data Fusion, enabling the integration of live Microsoft OneDrive data into the building and management of effective data pipelines.
-
How to connect to Missive Data in DBVisualizer
Integrate Missive data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports with Missive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Missive data.
-
Connect to Klaviyo Data from AWS Glue
Use CData Connect AI to gain access to live Klaviyo data from your AWS Glue jobs.
-
Back Up Moosend data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Moosend data data.
-
Build an OLAP Cube in SSAS from Greenplum Data
Establish a connection to Greenplum data data from SQL Server Analysis Services, and use the Greenplum Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Access EmailOctopus Data Using Entity Framework
This article shows how to access EmailOctopus data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Google Campaign Manager 360 Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Campaign Manager 360 data.
-
Connect to Campaigner Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Campaigner data in Airbyte.
-
Natively Connect to Clockify Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Clockify data. Leverage the native support for ODBC in PHP.
-
Integrating Kiro with BigCommerce 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.
-
Access Live Active Directory Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Active Directory data into the statistical analysis tools available in SAS JMP. This article shows how to use Active Directory data in the Graph Builder and Query Builder.