CData Software - Knowledge Base
Recent Articles
-
How to integrate Phoenix with Apache Airflow
Access and process Apache Phoenix in Apache Airflow using the CData JDBC Driver.
-
How to connect SharePoint with Oracle Eloqua Reporting Data through external lists
Provide Oracle Eloqua Reporting to SharePoint users as an external list.
-
Automated Continuous Box Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Box replication to Apache Kafka.
-
Create Pipedrive-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Pipedrive Data from OutSystems and build custom enterprise apps using live Pipedrive.
-
Use the CData Software JDBC Driver for Adobe Analytics in MicroStrategy Desktop
Connect to Adobe Analytics in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Analytics.
-
Analyze Contentful Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Contentful from Power Pivot. You will use the Table Import Wizard to load Contentful. You can visually build the import query or use any SQL supported by the driver.
-
Use CData Connect AI to Access Couchbase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Couchbase in the Power Pivot business intelligence tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live NetSuite CRM & ERP using the Model Context Protocol.
-
Query Microsoft Ads Data in DataGrip
Create a Data Source for Microsoft Ads in DataGrip and use SQL to query live Microsoft Ads.
-
Connect to Delighted Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to publish and share MarkLogic Data dashboards with Tableau Server
The CData ODBC driver for MarkLogic enables you integrate MarkLogic into Tableau dashboards.
-
Access Live Accelo Data in Coginiti Pro
Connect to and query live Accelo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to DB2 Data in HULFT Integrate
Connect to DB2 as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Power BI Connector for SAP HANA
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP HANA.
-
Importing Google BigQuery Data into H2O
Use the CData JDBC Driver for Google BigQuery in R and Python to import BigQuery data into H2O for machine learning and AI.
-
Integrating Gumloop with Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Quickbase within automated workflows.
-
Bind Live Outreach.io Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Outreach.io data
-
Getting Started with the CData ADO.NET Provider for Airtable
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Airtable.
-
Visualize GetResponse 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 GetResponse into TIBCO Spotfire.
-
Use Biml to Build SSIS Tasks to Replicate Keap Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Keap to SQL Server.
-
Automated Continuous HCL Domino Replication to Snowflake
Use CData Sync for automated, continuous, customizable HCL Domino replication to Snowflake.
-
Visualize Live API Data in the Power BI Service
Use CData Connect AI to connect to live API and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Reply.io Data as a MySQL Database in Node.js
Execute MySQL queries against Reply.io from Node.js.
-
Build FTP Visualizations in Tableau Cloud
Use CData Connect AI to connect to live FTP Servers and build visualizations in Tableau Cloud.
-
Creating ServiceNow-Connected Applications in Unqork
You can use CData Connect AI to feed ServiceNow to Unqork and build custom business apps.
-
Access SAP Concur Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Concur from HeidiSQL.
-
Automate Attio Data Replication to Azure Synapse
Use CData Sync to customize and automate Attio replication to Azure Synapse.
-
Import Twitter Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Twitter Ads Data from Azure Data Factory and import live Twitter Ads.
-
Use Claude to Talk to Your Jira 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 Atlassian Jira for you.
-
Automated Continuous WordPress Replication to MongoDB
Use CData Sync for automated, continuous, customizable WordPress replication to MongoDB.
-
Establish a Live Connection with Egnyte Data using Tableau Bridge
The CData ODBC Driver for Egnyte enables you to integrate live Egnyte into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Kiro CLI with Teamgate 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.
-
How to Access Live Jumpseller Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Jumpseller enables you to integrate Jumpseller into workflows built using Microsoft Power Automate Desktop.
-
How to connect Amazon QuickSight to Instagram Data
Create a connection to Instagram in CData Connect AI and insert Instagram into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Gumloop with NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on NetSuite CRM & ERP within automated workflows.
-
Load GitLab Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load GitLab to a database.
-
Getting Started with the CData Tableau Connector for Oracle
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle.
-
Connect to SAP SuccessFactors LMS Data in RapidMiner
Integrate SAP SuccessFactors LMS with standard components and data source configuration wizards in RapidMiner Studio.
-
Work with Oracle HCM Cloud Data in FoxPro
Load Oracle HCM Cloud into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate TigerGraph with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate TigerGraph with External Services.
-
Use the CData Software ODBC Driver for Amazon S3 in MicroStrategy Web
Connect to Amazon S3 in MicroStrategy Web using the CData Software ODBC Driver for Amazon S3.
-
Import Real-Time ChargeOver Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ChargeOver in ColdFusion.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Oracle
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Oracle.
-
Integrate Oracle Service Cloud Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle Service Cloud and integrate live Oracle Service Cloud into your Power Automate tasks.
-
Integrate Timely with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Timely with External Services.
-
Access Live Salesforce Data in Excel 365 Online (Excel for the web)
Connect to Salesforce & Force.com from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Vimeo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Vimeo with External Services.
-
Build AI/ML Models with Live Azure Analysis Services Data using Dataiku
Connect Azure Analysis Services Data with Dataiku using the CData JDBC Driver for Azure Analysis Services.
-
Use the CData Software JDBC Driver for Supabase in MicroStrategy Desktop
Connect to Supabase in MicroStrategy Desktop using the CData Software JDBC Driver for Supabase.
-
Connect to Klipfolio Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Klipfolio using standard SQL.
-
Integrating Claude Code with Zoho CRM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zoho CRM within assisted coding and automated development workflows.
-
Connect to Beeminder Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Freshservice Data in Coginiti Pro
Connect to and query live Freshservice from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Greenhouse Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Greenhouse with the DevExpress Windows Forms and Web controls to provide Greenhouse to a chart.
-
Access Live Sybase Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sybase from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Data Visualizations in Cognos BI with Facebook Ads Data
Access Facebook Ads as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Seamlessly Bring Outreach.io Data into Retool Using CData Connect AI
Integrate Outreach.io data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Stripe Data in Excel 365 Online (Excel for the web)
Connect to Stripe from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live Raisers Edge NXT Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Raisers Edge NXT from your Google Sheets.
-
How to load MailerLite data into Elasticsearch via Logstash
Introducing a simple method to load MailerLite data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Data Visualizations Based On IBM Informix Data in Mode
Use CData Connect AI to connect to IBM Informix Data from Mode and build visualizations using live
-
Integrating LangChain with Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Salesforce & Force.com within automated workflows.
-
Build Dashboards with Mode Data in DBxtra
Create dynamic dashboards and perform analytics based on Mode in DBxtra.
-
Integrating Claude Code CLI with Freshservice 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.
-
Getting Started with the CData Power BI Connector for Jumpseller
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize Live Short.io Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Short.io using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to Figshare
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Figshare.
-
Build AI/ML Models with Live MongoDB Data using Dataiku
Connect MongoDB Data with Dataiku using the CData JDBC Driver for MongoDB.
-
Build a Singer.io Tap for Vercel With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Vercel data using
-
Connect Rootly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Rootly using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Access Live Pipedrive Data in Visual Studio Code via Cline
Run CData MCP Server for Pipedrive on Windows Subsytem for Linux (WSL) and connect to live Pipedrive from the Cline extension in Visual Studio Code.
-
Automated Continuous Samanage Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Samanage replication to AlloyDB.
-
Connect to PayPal Data in Aqua Data Studio
Access PayPal from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Humanity Data in the Pentaho Report Designer
Publish reports based on Humanity in the Pentaho BI tool.
-
Connect to ZeroBounce from Asprova with CData Software ODBC Driver for ZeroBounce
This article shows how to connect faster to ZeroBounce data from Asprova.
-
How to Connect to Live HCL Domino 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 HCL Domino without replication.
-
Design BIRT Reports on LionDesk Data
Provide current LionDesk to your embedded analytics.
-
Operational Reporting on Twitter Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Twitter Ads.
-
Getting Started with the CData JDBC Driver for XML
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for XML.
-
Build AI/ML Models with Live Mode Data using Dataiku
Connect Mode Data with Dataiku using the CData API Driver for JDBC.
-
Process & Analyze Google Ad Manager Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Ad Manager Data.
-
Automated Continuous Supabase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Supabase replication to OneLake in Microsoft Fabric.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Synapse
Provide connectivity to Azure Synapse through an SAP BusinessObjects universe.
-
Connect to GetResponse Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time GetResponse using standard SQL.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Netweaver Gateway in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Migrating data from ServiceNow to Databricks using CData SSIS Components.
Easily push ServiceNow to Databricks using the CData SSIS Tasks for ServiceNow and Databricks.
-
Automated Continuous Salesforce CRM Analytics Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to SQL Server.
-
Create PingOne Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PingOne from PowerBI.com to create Power BI Dataflows with real-time data.
-
Working with Instantly Data in LINQPad
Execute LINQ queries to Instantly in LINQPad.
-
How to Access Foursquare Data Using Entity Framework
This article shows how to access Foursquare using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Instagram Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Instagram.
-
Operational Reporting on Oracle Financials Cloud Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Financials Cloud.
-
Integrating Claude Code with Dropbox Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Dropbox within assisted coding and automated development workflows.
-
Query SharePoint Excel Services Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SharePoint Excel Services and perform CRUD operations on SharePoint Excel Services from Node.js.
-
Consume Adobe Target OData Feeds in PowerBuilder
This article demonstrates how to consume Adobe Target as OData feeds from PowerBuilder using the API Server.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Salesforce Marketing actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Query MySQL Data from Node.js
Use the OData endpoint of the CData API Server to connect to your MySQL and perform CRUD operations on MySQL from Node.js.
-
How to Connect to Live Marketo 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 Marketo without replication.
-
Connect to Attio Data in JRuby
Create a simple JRuby app with access to live Attio.
-
Connect to Vercel Data in Aqua Data Studio
Access Vercel from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.