CData Software - Knowledge Base
Recent Articles
-
ActiveCampaign Reporting in OBIEE with the ActiveCampaign JDBC Driver
Deploy the ActiveCampaign JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Crystal Reports on AdRoll Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date AdRoll data.
-
Connect to Oracle Financials Cloud Data in HULFT Integrate
Connect to Oracle Financials Cloud as a JDBC data source in HULFT Integrate
-
Automated Continuous Copper Replication to SQL Server
Use CData Sync for automated, continuous, customizable Copper replication to SQL Server.
-
Access Live Microsoft OneDrive Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft OneDrive data from your Excel spreadsheets.
-
Back Up HBase data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HBase. In this article, we will employ an SSIS workflow to populate a database with HBase data data.
-
Getting Started with the CData ODBC Driver for Google Contacts
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Contacts.
-
How to Connect to Live HubSpot 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 HubSpot data for you.
-
Connect to PagerDuty from a Connection Pool in WebLogic
Use the CData JDBC Driver for PagerDuty to connect to PagerDuty data from Web applications running on WebLogic.
-
Rapidly Develop Onfleet-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 Onfleet.
-
Build an OLAP Cube in SSAS from Raisers Edge NXT Data
Establish a connection to Raisers Edge NXT data data from SQL Server Analysis Services, and use the Raisers Edge NXT Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize SAS Data Sets Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAS Data Sets data.
-
Automated Continuous Stack Exchange Replication to Vertica
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Vertica.
-
Integrate Google's Antigravity Agent with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP SuccessFactors LMS data using the Model Context Protocol.
-
Connect to FormSite Data from PowerBuilder via ADO.NET
This article demonstrates how to access FormSite data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Adobe Analytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Adobe Analytics Data and connect to Adobe Analytics data in Akorbi Digital RunMyProcess.
-
Connect to SharePoint Excel Services Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SharePoint Excel Services data using standard SQL.
-
Access Impala Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Impala data from HeidiSQL.
-
Build Automated Workflows with Live Avalara AvaTax Data in Workato
Use CData Connect AI to connect to live Avalara AvaTax data and build automated workflows in Workato.
-
Connect to Jumpseller in SpagoBI
Create reports featuring live Jumpseller data in SpagoBI Studio. Host Jumpseller reports on SpagoBI Server.
-
Connect to Short.io in SpagoBI
Create reports featuring live Short.io data in SpagoBI Studio. Host Short.io reports on SpagoBI Server.
-
Building Dynamic Web Pages with OneNote Data Using AngularJS
Create single-page applications with live connectivity to OneNote using the CData API Server.
-
Use Claude to Talk to Your Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Spark data for you.
-
How to Connect to GetResponse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to GetResponse data. Leverage the pyodbc module for ODBC in Python.
-
Bridge Google Sheets Connectivity with Apache NiFi
Access and process Google Sheets data in Apache NiFi using the CData JDBC Driver.
-
How to Connect Flowise AI Agents to Live Oracle 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 Oracle data without replication.
-
Using the CData Software ODBC Driver for Demio in PyCharm
Connect to Demio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Demio.
-
Getting Started with the CData Python Connector for Guru
Learn to install and license the CData Python Connector and configure a connection to live Guru data.
-
Use the CData Software ODBC Driver for Marketo in MicroStrategy Desktop
Connect to Marketo data in MicroStrategy Desktop using the CData Software ODBC Driver for Marketo.
-
ZohoMarketingHub Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ZohoMarketingHub data through CData Connect AI using different applications and tools.
-
Connect to Retently Data in RapidMiner
Integrate Retently data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData ADO.NET Provider for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Campaign Manager 360.
-
Connecting Pipedream with API 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 API data in real time.
-
Build MailerLite-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live MailerLite data without replication.
-
Back Up Bitly 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 Bitly data data.
-
Connect to Google Tasks Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Tasks data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Query Live Cosmos DB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Cosmos DB data data in natural language using Python.
-
Visualize Facebook Data in Sisense
Create an ElastiCube in Sisense app with access to Facebook data.
-
Enable the XML JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with XML data.
-
Connect to PolarTeamPro 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 PolarTeamPro and work with PolarTeamPro data in your FileMaker application.
-
Natively Connect to Sage Intacct Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage Intacct data. Leverage the native support for ODBC in PHP.
-
Build Apps with Live Microsoft Exchange Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Exchange data with Mendix to build apps using the CData JDBC Driver for Microsoft Exchange.
-
Integrate Live Box Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Box from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Box data.
-
Integrate with live Discord Data in Jitterbit
Use CData Connect AI to connect to and integrate live Discord data in Jitterbit.
-
How to use SQLAlchemy ORM to access Nethunt Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Nethunt data.
-
Manage SAP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP.
-
Query Oracle Data in DataGrip
Create a Data Source for Oracle in DataGrip and use SQL to query live Oracle data.
-
Seamlessly Bring Adobe Commerce Data into Retool Using CData Connect AI
Integrate Adobe Commerce data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Building Dynamic Web Pages with DB2 Data Using AngularJS
Create single-page applications with live connectivity to DB2 using the CData API Server.
-
Connect to LDAP in SpagoBI
Create reports featuring live LDAP objects in SpagoBI Studio. Host LDAP reports on SpagoBI Server.
-
Automate eBay Data Replication to Azure Data Lake
Use CData Sync to customize and automate eBay data replication to Azure Data Lake.
-
Configure the CData JDBC Driver for Discourse in a Connection Pool in Tomcat
Connect to Discourse data from a connection pool in Tomcat.
-
Integrating LlamaIndex with SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAS xpt data in real time.
-
Enable the Amazon Marketplace JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amazon Marketplace data.
-
Stream Odoo Data into Apache Kafka Topics
Access and stream Odoo data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create SurveyMonkey-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SurveyMonkey Data from OutSystems and build custom enterprise apps using live SurveyMonkey data.
-
Query, Visualize, and Share live Figshare Data in Redash
Use CData Connect AI to connect to live Figshare data in Redash for querying, visualizing, and sharing.
-
Bridge Google Analytics Connectivity with Apache NiFi
Access and process Google Analytics data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live MailerLite Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MailerLite data securely in real time.
-
Automated Continuous Webflow Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Webflow replication to delimited files (CSV/TSV).
-
Replicate Freshsales Data to Multiple Databases
Replicate Freshsales data to disparate databases with a point-and-click configuration.
-
Integrating Antigravity CLI with Snowflake data via CData CLI
Connect Snowflake data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Apps with Live Square Data Using the Low-Code Development Platform of Mendix
Connect Square data with Mendix to build apps using the CData JDBC Driver for Square.
-
How to use SQLAlchemy ORM to access GitLab Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GitLab data.
-
Use CData Connect AI to Access SAP Concur Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Concur data in the Power Pivot business intelligence tool.
-
Integrate Productboard Data in Pentaho Data Integration
Build ETL pipelines based on Productboard data in the Pentaho Data Integration tool.
-
Connect to and Query Ontraport Data in QlikView over ODBC
Create data visualizations with Ontraport data in QlikView.
-
Integrate with live OneNote Data in Jitterbit
Use CData Connect AI to connect to and integrate live OneNote data in Jitterbit.
-
Connect to JSON Services in Google Apps Script via SQL Gateway
Use the ODBC Driver for JSON and the SQL Gateway to access JSON services from Google Apps Script.
-
Visualize Live Google Sheets Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Sheets data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous PayPal Replication to Vertica
Use CData Sync for automated, continuous, customizable PayPal replication to Vertica.
-
Connect Exact Online to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Exact Online data using the CData Python MCP Server.
-
Choosing the Best Method to Connect eBay to SQL Server: 5 Options Explained
Discover multiple ways to connect and use eBay data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
A PostgreSQL Interface for Azure Analysis Services Data using the CData ODBC Driver
Use the SQL Gateway and Azure Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Bannerbear Data from HeidiSQL
Use CData Connect AI to connect to and query live Bannerbear data from HeidiSQL.
-
Automated Continuous ActiveCampaign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to PostgreSQL.
-
Use the CData Software JDBC Driver for OnePageCrm in MicroStrategy
Connect to OnePageCrm data in MicroStrategy Developer using the CData Software JDBC Driver for OnePageCrm.
-
How to Connect to Live Apify 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 Apify data for you.
-
How to Work with Google Translate Data in ETL Validator JDBC
Connect to Google Translate from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Live Dropbox 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 Dropbox data through a conversational interface.
-
Getting Started with the CData ADO.NET Provider for Paddle
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Tavily from Asprova with CData Software ODBC Driver for Tavily
This article shows how to connect faster to Tavily data from Asprova.
-
Access SingleStore Data from MySQL in PHP
Connect to SingleStore through the standard MySQL libraries in PHP.
-
Getting Started with the CData Power BI Connector for Foursquare
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to load SAP Hybris C4C data into Elasticsearch via Logstash
Introducing a simple method to load SAP Hybris C4C data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Seamlessly Bring Oracle Service Cloud Data into Retool Using CData Connect AI
Integrate Oracle Service Cloud data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize MongoDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MongoDB data.
-
How to Visualize SAP HANA XS Advanced Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP HANA XS Advanced data in Python.
-
LINQ to Azure Table Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Azure Table Data Provider.
-
Integrating Codex with Insightly 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.
-
Use Databricks Agent Bricks to Talk to Your xBase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your xBase data for you.
-
Visualize Scrapfly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Scrapfly data.
-
Automated Continuous Zoho Projects Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Snowflake.
-
Integrate CampaignMonitor Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CampaignMonitor data from Informatica Cloud.
-
Build Zoom Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoom data and build visualizations in Tableau Cloud.
-
How to Access Supabase Data Using Entity Framework
This article shows how to access Supabase data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Testmonitor from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Testmonitor data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Planio Data in Sisense
Create an ElastiCube in Sisense app with access to Planio data.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage 200
Create Sage 200 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Sendwithus-Connected Apps in Choreo
Use CData Connect AI to connect to Sendwithus Data from Choreo and build custom apps using live Sendwithus data.