CData Software - Knowledge Base
Recent Articles
-
How to Access Live SingleStore Data in Visual Studio Code via Cline
Run CData MCP Server for SingleStore on Windows Subsytem for Linux (WSL) and connect to live SingleStore from the Cline extension in Visual Studio Code.
-
Seamlessly Bring Amazon Marketplace Data into Retool Using CData Connect AI
Integrate Amazon Marketplace data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Apps with Live Suadeo Data Using the Low-Code Development Platform of Mendix
Connect Suadeo with Mendix to build apps using the CData JDBC Driver for Suadeo.
-
How to Connect to & Open SpaceX Data in Microsoft Excel
This article uses the CData ODBC driver for SpaceX to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon S3 using the Model Context Protocol.
-
SAS Data Sets Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAS Data Sets through CData Connect AI using different applications and tools.
-
Build Confluence-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Confluence Data and create custom apps in Mendix.
-
Connect to HelloSign Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to HelloSign and work with HelloSign in your FileMaker applications.
-
A PostgreSQL Interface for Contentful Data using the CData ODBC Driver
Use the SQL Gateway and Contentful ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Teamgate Data in Ruby
Connect to Teamgate in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Oracle Sales Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle Sales from PowerShell? This article demonstrates how to utilize the Oracle Sales Cmdlets for tasks like connecting to Oracle Sales, automating operations, downloading data, and more.
-
Access Live Twitter Ads Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Twitter Ads through MCP integration.
-
Analyze Access Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Access and visualize live Microsoft Access in Infragistics Reveal.
-
Integrate Reckon Data in the Pentaho Report Designer
Publish reports based on Reckon in the Pentaho BI tool.
-
Integrate Shippo Data in Pentaho Data Integration
Build ETL pipelines based on Shippo in the Pentaho Data Integration tool.
-
Build a PostgreSQL Interface for ActiveCampaign Data using the CData JDBC Driver
Use the Remoting features of the ActiveCampaign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bridge ClickTime Connectivity with Apache NiFi
Access and process ClickTime in Apache NiFi using the CData JDBC Driver.
-
Access MailChimp Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MailChimp from HeidiSQL.
-
How to Query Live Cassandra Data in Claude Desktop
Connect to and query live Cassandra Data in Claude Desktop using CData MCP Server.
-
Automated Continuous Couchbase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Couchbase replication to OneLake in Microsoft Fabric.
-
Build Apps with Live MarkLogic Data Using the Low-Code Development Platform of Mendix
Connect MarkLogic with Mendix to build apps using the CData JDBC Driver for MarkLogic.
-
Integrate Theia IDE with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData ODBC Driver for Acumatica from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica ERP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Acumatica ERP in Excel.
-
How to connect to SFTP Data from Spring Boot
Connect to SFTP in a Spring Boot Application using the CData JDBC Driver for SFTP
-
Replicate Multiple CouchDB Accounts via the CData Sync CLI
Replicate multiple CouchDB accounts to one or many databases.
-
Integrate with Email Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Email in SnapLogic.
-
How to connect to Grafana Data from IntelliJ
Integrate connectivity to Grafana with wizards in IntelliJ.
-
How to create Drift federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Drift in MySQL .
-
Explore Geographical Relationships in Delighted Data with Power Map
Create data visualizations with Delighted in Power Map.
-
How to Connect to Live SAP Business One Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Business One without replication.
-
Create Hive-Connected Dashboards in Grafana
Connect to Hive Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apache Hive.
-
Automated Continuous Bugsnag Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bugsnag replication to Google BigQuery.
-
Connect to Box from Asprova with CData Software ODBC Driver for Box
This article shows how to connect faster to Box data from Asprova.
-
Visualize Live QuickBooks Time Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live QuickBooks Time using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect eBay Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your eBay using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to HubSpot in SpagoBI
Create reports featuring live HubSpot in SpagoBI Studio. Host HubSpot reports on SpagoBI Server.
-
Connect to AdRoll Data in HULFT Integrate
Connect to AdRoll as a JDBC data source in HULFT Integrate
-
Deploy the ADO.NET Provider for JobNimbus on an SSRS Report Server
Connect to JobNimbus from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to and Visualize Live Beeminder Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Beeminder.
-
How to Connect to Live Facebook Ads 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 Facebook Ads for you.
-
How to create an RPA flow for EnterpriseDB Data in UiPath Studio
Use the EnterpriseDB ODBC Driver to create workflows that access real-time EnterpriseDB without any coding.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cvent
Provide connectivity to Cvent through an SAP BusinessObjects universe.
-
Automated Continuous Delighted Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Delighted replication to Google BigQuery.
-
Integrating Claude Code CLI with Toggl 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 and Query Mistral AI Data in QlikView over ODBC
Create data visualizations with Mistral AI in QlikView.
-
Build Dashboards with HubSpot Data in Dundas BI
Create dynamic dashboards and perform analytics based on HubSpot in Dundas BI.
-
Visualize Live Outlook Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Outlook.
-
Replicate Act CRM Data from PowerShell
Write a quick PowerShell script to query Act CRM. Use connectivity to the live data to replicate Act CRM to SQL Server.
-
How to Access Live Hugging Face Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Hugging Face enables you to integrate Hugging Face into workflows built using Microsoft Power Automate Desktop.
-
Connect to Google Tasks Data in HULFT Integrate
Connect to Google Tasks as a JDBC data source in HULFT Integrate
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Greenhouse
Provide connectivity to Greenhouse through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Box in MicroStrategy Desktop
Connect to Box in MicroStrategy Desktop using the CData Software ODBC Driver for Box.
-
Connect to Amplitude Data in JRuby
Create a simple JRuby app with access to live Amplitude.
-
Create Power BI Reports on Real-Time Phoenix Data
Use the CData ODBC Driver for Phoenix to visualize Apache Phoenix in Power BI Desktop.
-
Replicate Oracle Eloqua Reporting Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Eloqua Reporting to disparate databases with a single configuration.
-
How to Connect to & Open Adobe Commerce Data in Microsoft Excel
This article uses the CData ODBC driver for Adobe Commerce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Claude Code CLI with Freshteam 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.
-
Build Okta-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Okta Data from Zoho Analytics and import live Okta.
-
How to Connect Google Sheets Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Sheets data in real time using natural language.
-
Build Kintone-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Kintone Data from Zoho Analytics and import live Kintone.
-
How to create ChargeOver federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ChargeOver in MySQL .
-
Build AI/ML Models with Live Freshservice Data using Dataiku
Connect Freshservice Data with Dataiku using the CData API Driver for JDBC.
-
Validate Billsby Data with QuerySurge
Access and validate Billsby in QuerySurge using the CData JDBC Driver.
-
How to Build an ETL App for Salesforce CRM Analytics Data in Python with CData
Create ETL applications and real-time data pipelines for Salesforce CRM Analytics in Python with petl.
-
Integrating LangGraph with Jira Assets Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Jira Assets within automated workflows.
-
Connect to Opsgenie Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Opsgenie and the SQL Gateway to access Opsgenie from Google Apps Script.
-
Connect to Real-Time ZeroBounce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZeroBounce in Power Apps.
-
A PostgreSQL Interface for Recurly Data using the CData ODBC Driver
Use the SQL Gateway and Recurly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Datasets from ChartMogul in Domo Workbench and Build Visualizations of ChartMogul Data in Domo
Use the CData Software ODBC Driver for ChartMogul to create datasets from ChartMogul in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Cvent Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cvent from your Excel spreadsheets.
-
Back Up Elasticsearch to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Elasticsearch. In this article, we will employ an SSIS workflow to populate a database with Elasticsearch data.
-
Connect to and Query Cohere Data in QlikView over ODBC
Create data visualizations with Cohere in QlikView.
-
Connect to Sendwithus Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sendwithus as an External Source in Dremio.
-
Build a Simple VCL Application for Workable Data
How to build a simple VCL Application to view Workable in RAD Studio using the CData ODBC Driver for Workable.
-
Integrating Kiro CLI with Miro 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 with Redshift Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Amazon Redshift in SnapLogic.
-
Access Live Microsoft Entra ID Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Entra ID from your Google Sheets.
-
Create Reports from GraphQL Data in Looker Studio
Use CData Connect AI to gain access to live GraphQL and create custom reports in Looker Studio.
-
A PostgreSQL Interface for QuickBooks Time Data (MySQL Remoting via JDBC)
Use the Remoting features of the QuickBooks Time JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Sendwithus Data with Squirrel SQL client
Connect to Sendwithus and execute queries in the Squirrel SQL Client.
-
Replicate Multiple MongoDB Accounts via the CData Sync CLI
Replicate multiple MongoDB accounts to one or many databases.
-
How to Query Live Salesforce Data in Perplexity MacOS Desktop
Connect to and query live Salesforce Data in Perplexity Desktop using CData MCP Server.
-
Analyze Microsoft Dataverse Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Dataverse (CDS) and visualize live Microsoft Dataverse (CDS) in Infragistics Reveal.
-
Automated Continuous ConvertKit Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ConvertKit replication to Google BigQuery.
-
How to Connect Flowise AI Agents to Live Amazon S3 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 Amazon S3 without replication.
-
Migrating data from LightSpeedRetail to Databricks using CData SSIS Components.
Easily push LightSpeedRetail to Databricks using the CData SSIS Tasks for LightSpeedRetail and Databricks.
-
How to create Office 365 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Office 365 in MySQL .
-
Connect Okta Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Okta using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Suadeo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Suadeo data access from reports, embedded analytics, and more.
-
Connect to Shippo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Shippo to connect to Shippo and execute queries in PowerBuilder.
-
Use Dash to Build Web Apps on Amazon Marketplace Data via CData Connect AI
Build interactive Dash web apps on live Amazon Marketplace using pandas and the CData Connect AI Python SDK.
-
Integrating Cursor CLI with Bullhorn CRM 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.
-
Replicate Perplexity Data to Multiple Databases
Replicate Perplexity to disparate databases with a point-and-click configuration.
-
Integrate with Parquet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Parquet to a JSON file on disk.
-
Use the CData Software ODBC Driver for GitLab in MicroStrategy
Connect to GitLab in MicroStrategy Developer using the CData Software ODBC Driver for GitLab.
-
Integrate with Telegram Data in JReport Designer
Create charts and reports based on Telegram in JReport Designer.
-
Connect to Oracle Eloqua Reporting Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle Eloqua Reporting and the SQL Gateway to access Oracle Eloqua Reporting from Google Apps Script.
-
Integrate with TigerGraph Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy TigerGraph to a JSON file on disk.
-
Build Automated Workflows with Live Oracle Data in Workato
Use CData Connect AI to connect to live Oracle Database and build automated workflows in Workato.
-
Connect to LinkedIn Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LinkedIn Ads.