CData Software - Knowledge Base
Recent Articles
-
Connecting GenSpark with Dropbox Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Dropbox without any replication or custom integration required.
-
Build a Singer.io Tap for Databricks With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Databricks data using
-
Build MailChimp-Connected Apps in Choreo
Use CData Connect AI to connect to MailChimp Data from Choreo and build custom apps using live MailChimp.
-
Visualize Sage Intacct Data in TIBCO Spotfire through ADO.NET
Integrate Sage Intacct into dashboards in TIBCO Spotfire.
-
Connect to Access Data in JRuby
Create a simple JRuby app with access to live Microsoft Access.
-
How to Visualize Drip Data in Python with pandas
Use pandas and other modules to analyze and visualize live Drip in Python.
-
Connecting Agentforce with Azure Analysis Services 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 Azure Analysis Services for you.
-
Connect to Retently Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Retently as an External Source in Dremio.
-
Configure the CData JDBC Driver for Sage Intacct in a Connection Pool in Tomcat
Connect to Sage Intacct from a connection pool in Tomcat.
-
Provide OData Services of Drift Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Drift by developing a WCF Service Application.
-
Connect to Ontraport Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Ontraport and the SQL Gateway to access Ontraport from Google Apps Script.
-
Validate MailChimp Data with QuerySurge
Access and validate MailChimp in QuerySurge using the CData JDBC Driver.
-
Import Real-Time Codat Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Codat in ColdFusion.
-
How to connect to Tanda Data from Spring Boot
Connect to Tanda in a Spring Boot Application using the CData API Driver for JDBC
-
Deploy the ADO.NET Provider for Email on an SSRS Report Server
Connect to Email 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.
-
Integrate Cursor with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Splunk from within the editor.
-
How to Connect the Power BI Service to Oracle: Complete Guide
Connect to the CData Software Power BI Connector for Oracle from PowerBI.com to provide real-time Oracle Database across the organization.
-
Build Automated Workflows with Live Impala Data in Workato
Use CData Connect AI to connect to live Apache Impala and build automated workflows in Workato.
-
Access Spark Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Spark SQL from your Oracle system.
-
Automated Continuous Printful Replication to SingleStore
Use CData Sync for automated, continuous, customizable Printful replication to SingleStore.
-
Connect to LinkedIn Data in Ruby
Connect to LinkedIn in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Real-Time Simplesat Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Simplesat in Power Apps.
-
Access Salesforce CRM Analytics Data from MySQL in PHP
Connect to Salesforce CRM Analytics through the standard MySQL libraries in PHP.
-
Access Live Supabase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Supabase in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Power BI XMLA Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Power BI XMLA from Node.js.
-
Visualize Live Snapchat Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Snapchat Ads into custom reports in Power BI.
-
Access Azure DevOps Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure DevOps from your Oracle system.
-
How to Connect to Live Redis 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 Redis for you.
-
Create Informatica Mappings From/To a JDBC Data Source for iContact
Create iContact data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Perigon Data in Ruby
Connect to Perigon in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Demio
Provide connectivity to Demio through an SAP BusinessObjects universe.
-
Analyze Exact Online Data in Looker
Use CData Connect AI to connect to Exact Online Data from Looker and build custom apps using live Exact Online.
-
Integrating Kiro CLI with Pipedrive 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.
-
Query Insightly Data as a MySQL Database in Node.js
Execute MySQL queries against Insightly from Node.js.
-
Getting Started with the CData Power BI Connector for Timely
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Analyze Live Okta Data in SAS Viya
Use CData Connect AI to connect to Okta from SAS Viya and deploy self-service analytics using live Okta.
-
How to Easily Query ShipStation Data in OpenOffice Base
Connect to ShipStation data in OpenOffice Base using the CData ODBC Driver for ShipStation and generate reports with live data insights.
-
How to Work with NASA Data in AWS Glue Jobs Using JDBC
Connect to NASA from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate Bugsnag Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Bugsnag from PowerShell? This article demonstrates how to utilize the Bugsnag Cmdlets for tasks like connecting to Bugsnag, automating operations, downloading data, and more.
-
Build Visualizations of Invoiced Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Invoiced in Birst.
-
How to create an RPA flow for IBM Informix Data in UiPath Studio
Use the IBM Informix ODBC Driver to create workflows that access real-time IBM Informix without any coding.
-
Establish a Live Connection with Snapchat Ads Data using Tableau Bridge
The CData ODBC Driver for Snapchat Ads enables you to integrate live Snapchat Ads into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Mocean Data in Tableau
The CData ODBC driver for Mocean enables you integrate Mocean into Tableau dashboards.
-
Use ChatGPT to Talk to Your Zoho Books 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 Zoho Books for you.
-
Connect to Dynamics NAV Data in Ruby
Connect to Microsoft Dynamics NAV in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Oracle SCM Data in NetBeans
Connect to Oracle SCM in NetBeans with the data source configuration wizard.
-
Connect to Snowflake Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Snowflake as an External Source in Dremio.
-
Use Biml to Build SSIS Tasks to Replicate NetSuite Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate NetSuite CRM & ERP to SQL Server.
-
Automated Continuous Procore Replication to MySQL
Use CData Sync for automated, continuous, customizable Procore replication to MySQL.
-
Create Salesforce-Connected Dashboards in Grafana
Connect to Salesforce Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Salesforce & Force.com.
-
A PostgreSQL Interface for Azure Table Data using the CData ODBC Driver
Use the SQL Gateway and Azure Table ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Eventbrite Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect to FreshBooks Data in DBVisualizer
Integrate FreshBooks with visual data analysis tools and data connection wizards in DBVisualizer
-
Provide OData Services of Omnisend Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Omnisend by developing a WCF Service Application.
-
Automated Continuous Dynamics NAV Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Google Cloud SQL.
-
Integrate Live OneNote Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connecting Agentforce with SAP Netweaver Gateway 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 SAP Netweaver Gateway for you.
-
Create Dynamic GitLab Grids Using the Infragistics XamDataGrid
Learn how you can connect GitLab to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Hugging Face Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Hugging Face in Microsoft R Open.
-
Create Microsoft Exchange-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Exchange Data from Klipfolio and build custom visualizations using live Microsoft Exchange.
-
Getting Started with the CData JDBC Driver for eBay
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for eBay.
-
Build SAP Ariba Source-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP Ariba Source to explore live SAP Ariba Source Data in Claude Code to assist with building SAP Ariba Source-powered applications.
-
Analyze Cosmos DB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cosmos DB from Power Pivot. You will use the Table Import Wizard to load Azure Cosmos DB. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software ODBC Driver for Shortcut in MicroStrategy
Connect to Shortcut in MicroStrategy Developer using the CData Software ODBC Driver for Shortcut.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho Recruit
Create an ODBC connection to Zoho Recruit in Informatica and browse and transfer Zoho Recruit.
-
Build Charts with PolarTeamPro Data in Clear Analytics
Create dynamic charts and perform analytics based on PolarTeamPro in Clear Analytics.
-
A PostgreSQL Interface for Cohere Data using the CData ODBC Driver
Use the SQL Gateway and Cohere ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Visualizations of BigCommerce Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of BigCommerce in Birst.
-
Build Visualizations of Oracle Eloqua Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Eloqua in Birst.
-
Visualize FTP Data in TIBCO Spotfire through ADO.NET
Integrate FTP Servers into dashboards in TIBCO Spotfire.
-
Connect to Jira Data from a Connection Pool in Jetty
The Jira JDBC Driver supports connection pooling: This article shows how to connect faster to Atlassian Jira from Web apps in Jetty.
-
Access CockroachDB Data from MySQL in Amazon QuickSight
Connect to CockroachDB and build visualizations of CockroachDB using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData ADO.NET Provider for Freshteam
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Visualize Acumatica 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 Acumatica ERP in Python.
-
Connecting Pipedream with Google Contacts Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Contacts data in real time.
-
Use CData Connect AI to Access QuickBooks Time Data in Microsoft Power Pivot
Use CData Connect AI to connect to live QuickBooks Time in the Power Pivot business intelligence tool.
-
A PostgreSQL Interface for Splunk Data using the CData ODBC Driver
Use the SQL Gateway and Splunk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from SAP ByDesign to SQL Server using SSIS
Easily back up SAP Business ByDesign to SQL Server using the SSIS components for SAP ByDesign.
-
Build Voice Agents in ElevenLabs with access to Live Certinia Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Certinia.
-
Connect to Stack Exchange Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create SSAS Tabular Models from Suadeo Data
How to build a SQL Server Analysis Service Tabular Model from Suadeo using CData drivers.
-
Connect to Lakebase Data in JRuby
Create a simple JRuby app with access to live Lakebase.
-
Use the CData Software JDBC Driver for HDFS in MicroStrategy Web
Connect to Apache HDFS in MicroStrategy Web using the CData Software JDBC Driver for HDFS.
-
Access Live IBM Cloud Object Storage Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate IBM Cloud Object Storage into the statistical analysis tools available in SAS JMP. This article shows how to use IBM Cloud Object Storage in the Graph Builder and Query Builder.
-
How to Visualize Cvent Data in Python with pandas
Use pandas and other modules to analyze and visualize live Cvent in Python.
-
Connect to DB2 Data in Jaspersoft Studio
Execute SQL to remote IBM DB2 in Jaspersoft Studio.
-
Migrating data from Egnyte to Databricks using CData SSIS Components.
Easily push Egnyte to Databricks using the CData SSIS Tasks for Egnyte and Databricks.
-
Getting Started with the CData Excel Add-In for Klipfolio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Klipfolio.
-
Replicate Multiple Testmonitor Accounts
Replicate multiple Testmonitor accounts to one or many databases.
-
How to connect Amazon QuickSight to Amazon Athena Data
Create a connection to Amazon Athena in CData Connect AI and insert Amazon Athena into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to & Open HCL Domino Data in Microsoft Excel
This article uses the CData ODBC driver for HCL Domino to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
DataBind LionDesk Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide LionDesk to a chart.
-
Create FTP-Connected Applications in Appsmith
Connect to FTP Data via CData Connect AI in Appsmith and create custom business applications with real-time access to FTP Servers.
-
Consume ShipStation OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ShipStation feeds that reflect any changes in SAP Lumira.
-
How to Seamlessly Import Adobe Target Data into IBM SPSS Modeler
Integrate Adobe Target data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Excel Spreadsheet Automation on Hugging Face Data with the QUERY Formula
Pull data from Hugging Face, automate spreadsheets, and more with the QUERY formula.
-
Connect to Clockify Data in Ruby
Connect to Clockify in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for PolarTeamPro in MicroStrategy Desktop
Connect to PolarTeamPro in MicroStrategy Desktop using the CData Software ODBC Driver for PolarTeamPro.
-
Visualize Live Ontraport Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Ontraport using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Adobe Target-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Adobe Target to explore live Adobe Target Data in Cursor to assist with building Adobe Target-powered applications.