CData Software - Knowledge Base
Recent Articles
-
How to Access Live CloudConvert Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CloudConvert enables you to integrate CloudConvert data into workflows built using Microsoft Power Automate Desktop.
-
Query Live Email 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 Email data through a conversational interface.
-
Connect to GetResponse Data in HULFT Integrate
Connect to GetResponse as a JDBC data source in HULFT Integrate
-
Integrate Real-Time Access to DB2 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to DB2 data in real time.
-
Connect to Azure Analysis Services from Asprova with CData Software ODBC Driver for Azure Analysis Services
This article shows how to connect faster to Azure Analysis Services data from Asprova.
-
How to Visualize Guru Data in Python with pandas
Use pandas and other modules to analyze and visualize live Guru data in Python.
-
Automated Continuous Redis Replication to Databricks
Use CData Sync for automated, continuous, customizable Redis replication to Databricks.
-
Connect to CampaignMonitor Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CampaignMonitor and work with CampaignMonitor data in your FileMaker applications.
-
Connect to ZohoExpense Data in JRuby
Create a simple JRuby app with access to live ZohoExpense data.
-
How to update Databricks from Excel
This article explains how to transfer data from Excel to Databricks using the Excel Add-In for Databricks.
-
How to Connect to SharePoint Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SharePoint data. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for JobNimbus in MicroStrategy
Connect to JobNimbus data in MicroStrategy Developer using the CData Software ODBC Driver for JobNimbus.
-
Prepare, Blend, and Analyze FTP Data in Alteryx Designer (Connect AI)
Build workflows to access live FTP data for self-service data analytics.
-
Create Snapchat Ads-Connected Applications in Appsmith
Connect to Snapchat Ads Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Snapchat Ads data.
-
Integrate Mode Data in the Pentaho Report Designer
Publish reports based on Mode data in the Pentaho BI tool.
-
Integrate with AfterShip Data in JReport Designer
Create charts and reports based on AfterShip data in JReport Designer.
-
Work with Discourse Data in FoxPro
Load Discourse data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Planio Data in CloverDX (formerly CloverETL)
Transfer Planio data using the visual workflow in the CloverDX data integration tool.
-
Access Postmark Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Postmark data from your Oracle system.
-
Connect to Cassandra from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Cassandra data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect to Optimizely Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Optimizely data. Leverage the pyodbc module for ODBC in Python.
-
How to Query PolarTeamPro Data in MySQL Workbench
Execute MySQL queries against live PolarTeamPro data from MySQL Workbench.
-
Connect to JSON Services in Ruby
Connect to JSON services in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with SendPulse Data in JReport Designer
Create charts and reports based on SendPulse data in JReport Designer.
-
Connect to HCL Domino Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for HCL Domino data in Airbyte.
-
Replicate Sage 200 Data in Heroku for Use in Salesforce Connect
Replicate Sage 200 data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to publish and share Aweber Data dashboards with Tableau Server
The CData ODBC driver for Aweber enables you integrate Aweber data into Tableau dashboards.
-
Visualize Live Azure Synapse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Synapse data.
-
Process & Analyze Epicor Kinetic Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Epicor Kinetic Data.
-
Publish Crystal Reports on Missive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Missive data.
-
Query RabbitMQ Data in ColdFusion
Write standard ColdFusion data access code to connect to RabbitMQ data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BigCommerce
Provide connectivity to BigCommerce data through an SAP BusinessObjects universe.
-
Build an OLAP Cube in SSAS from Miro Data
Establish a connection to Miro data data from SQL Server Analysis Services, and use the Miro Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Cloudflare-Connected Dashboards in Grafana
Connect to Cloudflare Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Cloudflare data.
-
Import Real-Time SFTP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SFTP data in ColdFusion.
-
Connect Clockify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Clockify data using the CData Python MCP Server.
-
Getting Started with the CData Tableau Connector for Access
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Access.
-
Use the CData Software JDBC Driver for Office 365 in MicroStrategy
Connect to Office 365 data in MicroStrategy Developer using the CData Software JDBC Driver for Office 365.
-
Access Excel Data from MySQL in Amazon QuickSight
Connect to Excel and build visualizations of Excel data using a MySQL Connection in Amazon QuickSight.
-
Integrate with Epicor Kinetic Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Epicor Kinetic data in SnapLogic.
-
Connect to Aweber Data in ACL Analytics
Connect to Aweber data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Aweber data.
-
Automate Everhour Data Replication to Azure Data Lake
Use CData Sync to customize and automate Everhour data replication to Azure Data Lake.
-
How to Connect to Live SendPulse 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 SendPulse data without replication.
-
Connecting Mastra with Anaplan 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 Anaplan data, no replication required.
-
Connect to SparkPost Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SparkPost data from Filemaker Pro on Mac.
-
How to Connect to SAP HANA XS Advanced Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP HANA XS Advanced data. Leverage the pyodbc module for ODBC in Python.
-
Publish Crystal Reports on Adobe Target Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Adobe Target data.
-
How to connect to Bitly Data from Spring Boot
Connect to Bitly in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Act CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Act CRM data from PowerBuilder using the Act CRM JDBC Driver.
-
Build Salesforce Marketing-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Salesforce Marketing data.
-
Integrate Goose with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Vault CRM data from within the local AI agent.
-
Reckon Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Reckon facts in real time.
-
Automate Trello Data Replication to Couchbase
Use CData Sync to Customize and automate Trello data replication to Couchbase.
-
Automated Continuous Aha! Replication to MongoDB
Use CData Sync for automated, continuous, customizable Aha! replication to MongoDB.
-
Query Live Greenplum 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 Greenplum data directly from the development environment.
-
Access Live Salesforce CRM Analytics Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Salesforce CRM Analytics data through MCP integration.
-
Integrate Goose with Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SQL Analysis Services data from within the local AI agent.
-
Getting Started with the CData ODBC Driver for Avaza
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Avaza.
-
Query Google Sheets Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Sheets data.
-
Use ChatGPT to Talk to Your Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Anaplan data for you.
-
Connect to and Query FreeAgent Data in QlikView over ODBC
Create data visualizations with FreeAgent data in QlikView.
-
How to Connect to Live Bitly Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Bitly data for you.
-
How to import Tally Data into Apache Solr
Use the CData Software JDBC Driver for Tally in Data Import Handler and create an automated import of Tally data to Apache Solr Enterprise Search platform.
-
Connect to Raisers Edge NXT Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Raisers Edge NXT data in Airbyte.
-
How to Visualize ZohoSubscriptions Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoSubscriptions data in Python.
-
How to Connect to CapsuleCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CapsuleCRM data. Leverage the pyodbc module for ODBC in Python.
-
Use Microsoft Copilot Studio to talk to your ServiceDesk Plus 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 ServiceDesk Plus data for you.
-
Integrating Boomi Agentstudio with Zoho CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho CRM data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software JDBC Driver for Salesforce Marketing in MicroStrategy
Connect to Salesforce Marketing data in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce Marketing.
-
How to Create Power BI Visual Reports with Real-Time Amazon Marketplace Data
Use CData Power BI Connectors to visualize Amazon Marketplace data in Power BI.
-
Integrating Cursor with SAP Ariba Procurement 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.
-
Integrating Codex with Salesloft 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.
-
Migrating data from TaxJar to Google BigQuery using CData SSIS Components.
Easily push TaxJar data to Google BigQuery using the CData SSIS Tasks for TaxJar and Google BigQuery.
-
Analyze Jira Data in Looker
Use CData Connect AI to connect to Jira Data from Looker and build custom apps using live Jira data.
-
Use the CData Software ODBC Driver for PayPal in SAS for Real-Time Reporting and Analytics
Connect to real-time PayPal data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PayPal.
-
Use the CData ODBC Driver for Confluence from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Confluence to connect to Confluence data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Confluence data in Excel.
-
Automated Continuous SAP SuccessFactors Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP SuccessFactors data replication to OneLake in Microsoft Fabric.
-
Automate ZohoPeople Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoPeople data from PowerShell? This article demonstrates how to utilize the ZohoPeople Cmdlets for tasks like connecting to ZohoPeople data, automating operations, downloading data, and more.
-
How to Connect to Live Cassandra 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 Cassandra data through natural language.
-
Connect to Dynamics NAV Data from PowerBuilder via JDBC
This article demonstrates how to access Dynamics NAV data from PowerBuilder using the Dynamics NAV JDBC Driver.
-
Build OneNote-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to OneNote Data from Zoho Analytics and import live OneNote data.
-
Replicate Omnisend Data in Heroku for Use in Salesforce Connect
Replicate Omnisend data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate with Mistral AI Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mistral AI data to a JSON file on disk.
-
Automated Continuous AfterShip Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AfterShip replication to delimited files (CSV/TSV).
-
Create SAP Hybris C4C-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Hybris C4C Data from OutSystems and build custom enterprise apps using live SAP Hybris C4C data.
-
Build Automated SAP Hybris C4C-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Hybris C4C data and build automated workflows in Zapier.
-
Use ChatGPT to Talk to Your HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your HCL Domino data for you.
-
Build an OLAP Cube in SSAS from Zoho Creator Data
Establish a connection to Zoho Creator data data from SQL Server Analysis Services, and use the Zoho Creator Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize TigerGraph Data in Sisense
Create an ElastiCube in Sisense app with access to TigerGraph data.
-
Create SSAS Tabular Models from iContact Data
How to build a SQL Server Analysis Service Tabular Model from iContact data using CData drivers.
-
Integrate OpenCode with Live Microsoft Exchange Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Microsoft Exchange data from within your AI coding agent.
-
Integrate Open WebUI with Live Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Wistia data from within the chat interface.
-
How to update Stripe from Excel
This article explains how to transfer data from Excel to Stripe using the Excel Add-In for Stripe.
-
Automated Continuous Parquet Replication to Databricks
Use CData Sync for automated, continuous, customizable Parquet replication to Databricks.
-
Access Klipfolio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Klipfolio data from HeidiSQL.
-
Automated Continuous ServiceDesk Plus Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to delimited files (CSV/TSV).
-
Automated Continuous SAP Ariba Procurement Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to SQL Server.
-
Use the CData Software JDBC Driver for Figshare in MicroStrategy
Connect to Figshare data in MicroStrategy Developer using the CData Software JDBC Driver for Figshare.
-
Connect to Teamwork in SpagoBI
Create reports featuring live Teamwork data in SpagoBI Studio. Host Teamwork reports on SpagoBI Server.
-
Automate SAP Ariba Source Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Ariba Source data replication to SAP HANA.