CData Software - Knowledge Base
Recent Articles
-
Connect to Eventbrite Data in Jaspersoft Studio
Execute SQL to remote Eventbrite in Jaspersoft Studio.
-
Use the CData Software JDBC Driver for Amplitude in MicroStrategy Desktop
Connect to Amplitude in MicroStrategy Desktop using the CData Software JDBC Driver for Amplitude.
-
Use Agno to Talk to Your MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MongoDB for you.
-
Integrate Open WebUI with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Salesforce Marketing Cloud from within the chat interface.
-
Bidirectional Access to Grafana Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Grafana in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Bright Data in MicroStrategy
Connect to Bright Data in MicroStrategy Developer using the CData Software ODBC Driver for Bright Data.
-
Build Semantic Layer Views for Square Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Square.
-
Automated Continuous Planio Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Planio replication to Google Cloud SQL.
-
Analyze Rootly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Rootly with the CData JDBC Driver for Rootly.
-
How to Query Live Parquet Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache Parquet data in natural language using Python.
-
How to Work with HBase Data in AWS Glue Jobs Using JDBC
Connect to HBase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build MVC Applications with Connectivity to Smartsheet Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Smartsheet from an ASP.NET MVC application.
-
Automated Continuous GitLab Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable GitLab replication to Amazon Redshift.
-
Analyze Gong Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Gong and visualize live Gong in Infragistics Reveal.
-
Integrating Claude Code CLI with Optimizely 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 BenchmarkEmail Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for BenchmarkEmail in the Denodo Virtual DataPort Administrator.
-
Connect Missive to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Missive with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Avro Data in Looker
Use CData Connect AI to connect to Avro Data from Looker and build custom apps using live Apache Avro.
-
Analyze ActiveCampaign Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ActiveCampaign and visualize live ActiveCampaign in Infragistics Reveal.
-
Build Outreach.io-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Outreach.io Data and create custom apps in Bubble.
-
How to Access Live Google Analytics Data in Visual Studio Code via Cline
Run CData MCP Server for Google Analytics on Windows Subsytem for Linux (WSL) and connect to live Google Analytics from the Cline extension in Visual Studio Code.
-
How to integrate SAP Hybris C4C with Apache Airflow
Access and process SAP Hybris C4C in Apache Airflow using the CData JDBC Driver.
-
Connect to Salesforce CRM Analytics Data in NetBeans
Connect to Salesforce CRM Analytics in NetBeans with the data source configuration wizard.
-
Use the CData Software JDBC Driver for Freshsales in MicroStrategy Desktop
Connect to Freshsales in MicroStrategy Desktop using the CData Software JDBC Driver for Freshsales.
-
Viewing Foursquare Data in RAD Studio Data Explorer
How to view Foursquare in RAD Studio Data Explorer using the CData ODBC Driver for Foursquare.
-
Publish Reports with Paylocity Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paylocity.
-
Access Airtable Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Airtable from your Oracle system.
-
Analyze Aweber Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Aweber and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use Dash to Build to Web Apps on HDFS Data
Create Python applications that use pandas and Dash to build HDFS-connected web apps.
-
Analyze Recurly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Recurly in Microsoft R Open.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Opsgenie to Power BI dashboards. Simply drag and drop Opsgenie into data visuals on the Power BI canvas.
-
Automated Continuous Omnisend Replication to MongoDB
Use CData Sync for automated, continuous, customizable Omnisend replication to MongoDB.
-
Model Oracle Service Cloud Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle Service Cloud, enabling the direct import of real-time Oracle Service Cloud.
-
How to Query Live Copper Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Copper data in natural language using Python.
-
Automate CSV Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live CSV/TSV Files and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build MVC Applications with Connectivity to Retently Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Retently from an ASP.NET MVC application.
-
Process & Analyze Facebook Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Facebook Data.
-
How to Connect to Live Sugar CRM Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Sugar CRM for you.
-
Connect to Zendesk Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zendesk as an External Source in Dremio.
-
Query Sybase Data in DataGrip
Create a Data Source for Sybase in DataGrip and use SQL to query live Sybase.
-
How to import Adobe Commerce Data into Apache Solr
Use the CData Software JDBC Driver for Adobe Commerce in Data Import Handler and create an automated import of Adobe Commerce to Apache Solr Enterprise Search platform.
-
Access Live OData Services in AWS Lambda
Connect to live OData in AWS Lambda using the CData JDBC Driver.
-
How to publish and share ChargeOver Data dashboards with Tableau Server
The CData ODBC driver for ChargeOver enables you integrate ChargeOver into Tableau dashboards.
-
How to import NASA Data into Apache Solr
Use the CData Software JDBC Driver for NASA in Data Import Handler and create an automated import of NASA to Apache Solr Enterprise Search platform.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Fieldglass
Provide connectivity to SAP Fieldglass through an SAP BusinessObjects universe.
-
Replicate Jodoo Data in Heroku for Use in Salesforce Connect
Replicate Jodoo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to import Bitly Data into Apache Solr
Use the CData Software JDBC Driver for Bitly in Data Import Handler and create an automated import of Bitly to Apache Solr Enterprise Search platform.
-
How to connect and process ConvertKit from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ConvertKit.
-
Connect to JotForm Data in RazorSQL
Connect to JotForm from wizards and query JotForm from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for Perplexity in MicroStrategy
Connect to Perplexity in MicroStrategy Developer using the CData Software JDBC Driver for Perplexity.
-
How to connect SharePoint with EnterpriseDB Data through external lists
Provide EnterpriseDB to SharePoint users as an external list.
-
Build Charts with Microsoft Ads Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Ads in Clear Analytics.
-
Integrate Square with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Square with External Services.
-
Rapidly Develop Slack-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Slack.
-
Integrating LlamaIndex with SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Business ByDesign in real time.
-
Visualize Brex Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Brex into TIBCO Spotfire.
-
Consume Harvest OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Harvest feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData Python Connector for Adobe Commerce
Learn to install and license the CData Python Connector
-
Explore Geographical Relationships in Pinecone Data with Power Map
Create data visualizations with Pinecone in Power Map.
-
Build Automated Vault CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Veeva Vault & Vault CRM and build automated workflows in Zapier.
-
Connect to SurveyMonkey Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SurveyMonkey to connect to SurveyMonkey and execute queries in PowerBuilder.
-
Connect to ElevenLabs Data in NetBeans
Connect to ElevenLabs in NetBeans with the data source configuration wizard.
-
Create FreshBooks-Connected Dashboards in Grafana
Connect to FreshBooks Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to FreshBooks.
-
Connect to Invoiced 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 Invoiced and work with Invoiced in your FileMaker application.
-
How to Work with Freshservice Data in ETL Validator JDBC
Connect to Freshservice from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Import Data from Adobe Commerce into Google Sheets
Import Adobe Commerce into a Google spreadsheet that is automatically refreshed.
-
Use the CData Software ODBC Driver for Microsoft OneDrive in MicroStrategy Desktop
Connect to Microsoft OneDrive in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft OneDrive.
-
Getting Started with the CData JDBC Driver for iContact
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for iContact.
-
Connect to Pinterest in SpagoBI
Create reports featuring live Pinterest in SpagoBI Studio. Host Pinterest reports on SpagoBI Server.
-
Analyze Unbounce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Unbounce from Power Pivot. You will use the Table Import Wizard to load Unbounce. You can visually build the import query or use any SQL supported by the driver.
-
Connecting Agentforce with Redshift Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Amazon Redshift for you.
-
Build Stripe-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Stripe to explore live Stripe Data in GitHub Copilot to assist with building Stripe-powered applications.
-
Build Automated Workflows with Live Oracle Service Cloud Data in Workato
Use CData Connect AI to connect to live Oracle Service Cloud and build automated workflows in Workato.
-
Connect to Dynamics 365 Business Central Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Dynamics 365 Business Central.
-
Build WooCommerce-Connected Apps in Choreo
Use CData Connect AI to connect to WooCommerce Data from Choreo and build custom apps using live WooCommerce.
-
Use the CData Software ODBC Driver for Elasticsearch in MicroStrategy Desktop
Connect to Elasticsearch in MicroStrategy Desktop using the CData Software ODBC Driver for Elasticsearch.
-
Automated Continuous Salesforce Pardot Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to SingleStore.
-
How to Connect to Live Cosmos DB 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 Azure Cosmos DB for you.
-
How to connect PolyBase to Reckon Accounts Hosted
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Reckon Accounts Hosted.
-
Connect to MailerSend Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MailerSend in the Denodo Virtual DataPort Administrator.
-
A PostgreSQL Interface for Perigon Data (MySQL Remoting via JDBC)
Use the Remoting features of the Perigon JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Dynamics 365 Business Central Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dynamics 365 Business Central from Power Pivot. You will use the Table Import Wizard to load Dynamics 365 Business Central. You can visually build the import query or use any SQL supported by the driver.
-
How to Query Live Procore Data in Perplexity MacOS Desktop
Connect to and query live Procore Data in Perplexity Desktop using CData MCP Server.
-
Use Grok to Talk to Your SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP Netweaver Gateway for you.
-
Automated Continuous Autopilot Replication to Vertica
Use CData Sync for automated, continuous, customizable Autopilot replication to Vertica.
-
Access Phoenix Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache Phoenix from HeidiSQL.
-
Analyze Snowflake Data in Looker
Use CData Connect AI to connect to Snowflake Data from Looker and build custom apps using live Snowflake.
-
Automated Continuous Microsoft Dataverse Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Vertica.
-
Visualize Vercel Data in Tableau
The CData ODBC driver for Vercel enables you integrate Vercel into Tableau dashboards.
-
Connect to Egnyte Data in RapidMiner
Integrate Egnyte with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for Bitbucket in SAS for Real-Time Reporting and Analytics
Connect to real-time Bitbucket in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Bitbucket.
-
Connect to Bugsnag Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bugsnag and the SQL Gateway to access Bugsnag from Google Apps Script.
-
Integrating GitHub Copilot CLI with JDBC-ODBC Bridge 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 Figshare to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Figshare using the CData Python MCP Server.
-
Create Reports with Microsoft Dataverse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dataverse (CDS).
-
Query Avaza Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Avaza and perform CRUD operations on Avaza from Node.js.
-
Visualize Toggl Data in TIBCO Spotfire through OData
Integrate Toggl into dashboards in TIBCO Spotfire.
-
View Reports on Real-Time Azure Synapse Data in Power BI Report Server
Use the CData ODBC Driver for Azure Synapse to visualize Azure Synapse in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live Oracle Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle Database.
-
Automated Continuous Front Replication to Oracle
Use CData Sync for automated, continuous, customizable Front replication to Oracle.