CData Software - Knowledge Base
Recent Articles
-
Connecting Pipedream with Snapchat Ads 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 Snapchat Ads data in real time.
-
Operational Reporting on Accelo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Accelo.
-
Build MVC Applications with Connectivity to Zoho Recruit Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Recruit from an ASP.NET MVC application.
-
How to connect SharePoint with SAP Business Warehouse Data through external lists
Provide SAP Business Warehouse to SharePoint users as an external list.
-
Visualize Telegram Data in Sisense
Create an ElastiCube in Sisense app with access to Telegram.
-
How to import Oracle HCM Cloud Data into Apache Solr
Use the CData Software JDBC Driver for Oracle HCM Cloud in Data Import Handler and create an automated import of Oracle HCM Cloud to Apache Solr Enterprise Search platform.
-
Create Data Visualizations Based On Twitter Ads Data in Mode
Use CData Connect AI to connect to Twitter Ads Data from Mode and build visualizations using live
-
Publish ClickUp-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ClickUp.
-
Write a Simple Go Application to work with CloudConvert Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to CloudConvert.
-
Access Live ChargeOver Data in AWS Lambda
Connect to live ChargeOver in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous SAP Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP replication to SQL Server.
-
Connect to HBase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Establish a Live Connection with ConvertAPI Data using Tableau Bridge
The CData ODBC Driver for ConvertAPI enables you to integrate live ConvertAPI into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect Templated to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Templated using the CData Python MCP Server.
-
Viewing OneNote Data in RAD Studio Data Explorer
How to view Microsoft OneNote in RAD Studio Data Explorer using the CData ODBC Driver for OneNote.
-
Choosing the Best Method to Connect Okta to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Okta from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Parallel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Parallel from your Oracle system.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MessageBird
Provide connectivity to MessageBird through an SAP BusinessObjects universe.
-
Deploy the ADO.NET Provider for Freshteam on an SSRS Report Server
Connect to Freshteam 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.
-
Connecting Moonlit Workflow with Oracle Eloqua Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle Eloqua in real time.
-
Access Live Mixpanel Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mixpanel in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with CapsuleCRM Data in JReport Designer
Create charts and reports based on CapsuleCRM in JReport Designer.
-
Connect to Twitter Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live Twitter Ads from HeidiSQL.
-
Automated Continuous LinkedIn Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LinkedIn replication to Amazon Redshift.
-
Use Claude to Talk to Your SAP Hybris C4C 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 SAP Hybris C4C for you.
-
Process & Analyze Dynamics CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics CRM Data.
-
Integrating Kiro CLI with BenchmarkEmail 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 Connect to Live CockroachDB Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your CockroachDB for you.
-
Visualize LinkedIn Ads Data in Sisense
Create an ElastiCube in Sisense app with access to LinkedIn Ads.
-
Connect Templated to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Templated with IBM WebSphere for seamless data integration and connectivity.
-
Establish a Live Connection with Gorgias Data using Tableau Bridge
The CData ODBC Driver for Gorgias enables you to integrate live Gorgias into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Live Gong Data in MicroStrategy through CData Connect AI
Create a live connection to Gong Data in CData Connect AI and connect to your Gong from MicroStrategy.
-
Connect to Zoho Recruit Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Zoho Recruit and work with Zoho Recruit in your FileMaker applications.
-
Access ADP Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ADP.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Wistia
Provide connectivity to Wistia through an SAP BusinessObjects universe.
-
Automated Continuous Stripe Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Stripe replication to Apache Cassandra.
-
Getting Started with the CData Excel Add-In for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ElevenLabs.
-
ETL Amazon DynamoDB in Oracle Data Integrator
This article shows how to transfer Amazon DynamoDB into a data warehouse using Oracle Data Integrator.
-
ETL Tanda in Oracle Data Integrator
This article shows how to transfer Tanda into a data warehouse using Oracle Data Integrator.
-
How to Connect the Power BI Service to Sybase: Complete Guide
Connect to the CData Software Power BI Connector for Sybase from PowerBI.com to provide real-time Sybase across the organization.
-
Stream Wistia Data into Apache Kafka Topics
Access and stream Wistia in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use ChatGPT to Talk to Your PayPal 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 PayPal for you.
-
Use Biml to Build SSIS Tasks to Replicate Bitbucket Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bitbucket to SQL Server.
-
Access Live Presto Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Presto into the statistical analysis tools available in SAS JMP. This article shows how to use Presto in the Graph Builder and Query Builder.
-
Manage Wrike Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Wrike.
-
Consume Snowflake OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Snowflake feeds that reflect any changes in SAP Lumira.
-
Automated Continuous ZarMoney Replication to Databricks
Use CData Sync for automated, continuous, customizable ZarMoney replication to Databricks.
-
DataBind Elasticsearch Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Elasticsearch with the DevExpress Windows Forms and Web controls to provide Elasticsearch to a chart.
-
Analyze CouchDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Apache CouchDB and visualize live Apache CouchDB in Infragistics Reveal.
-
Integrating Kiro CLI with Paylocity 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.
-
Load SAS xpt Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAS XPORT to a database.
-
Using the CData Software ODBC Driver for Zoho CRM in PyCharm
Connect to Zoho CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho CRM.
-
Automate Wistia Data Replication to Couchbase
Use CData Sync to Customize and automate Wistia replication to Couchbase.
-
Query Excel Online Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Excel Online from Node.js.
-
Rapidly Develop Quickbase-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 Quickbase.
-
Integrate Live LionDesk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LionDesk to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Live PayPal Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PayPal to Blue Prism using the CData ODBC Driver for PayPal to create automated workflows for repetitive business tasks.
-
Model, Search, and Visualize Live Facebook Ads Data in ThoughtSpot
Use CData Connect AI to connect to live Facebook Ads for modeling, searching, and visualizing.
-
How to connect to ActiveCampaign Data from Spring Boot
Connect to ActiveCampaign in a Spring Boot Application using the CData JDBC Driver for ActiveCampaign
-
Automated Continuous QuickBooks Replication to MongoDB
Use CData Sync for automated, continuous, customizable QuickBooks replication to MongoDB.
-
Integrate with live HubSpot Data in Jitterbit
Use CData Connect AI to connect to and integrate live HubSpot in Jitterbit.
-
Provide OData Services of AgileCRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for AgileCRM by developing a WCF Service Application.
-
Natively Connect to SparkPost Data in PHP
The CData ODBC driver for SparkPost enables you to create PHP applications with connectivity to SparkPost. Leverage the native support for ODBC in PHP.
-
View Reports on Real-Time Aircall Data in Power BI Report Server
Use the CData ODBC Driver for Aircall to visualize Aircall in Power BI Desktop and then publish them to Power BI Report Server.
-
Moving Data from Power BI XMLA to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Power BI XMLA data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Quickbase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Quickbase from your Oracle system.
-
Create Microsoft Planner Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Planner from PowerBI.com to create Power BI Dataflows with real-time data.
-
Choosing the Best Method to Connect Vercel to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Vercel from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Prepare, Blend, and Analyze Email Data in Alteryx Designer (ODBC)
Build workflows to access live Email for self-service data analytics.
-
Feed Avaza Data into FineReport
How to set Avaza as a JDBC data source in FineReport.
-
Use Dash to Build to Web Apps on SharePoint Excel Services Data
Create Python applications that use pandas and Dash to build SharePoint Excel Services-connected web apps.
-
Integrating LeadDesk Data in Talend Cloud Data Management Platform
Connect LeadDesk Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Humanity-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Humanity and build web apps with connectivity to live Humanity.
-
Analyze Hive Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Apache Hive and visualize live Apache Hive in Infragistics Reveal.
-
Use the CData Software JDBC Driver for Webflow in MicroStrategy Web
Connect to Webflow in MicroStrategy Web using the CData Software JDBC Driver for Webflow.
-
Automated Continuous Avaza Replication to Oracle
Use CData Sync for automated, continuous, customizable Avaza replication to Oracle.
-
Connect to Office 365 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Office 365 Data and connect to Microsoft Office 365 in Akorbi Digital RunMyProcess.
-
How to Access Live GraphQL Data in Visual Studio Code via Cline
Run CData MCP Server for GraphQL on Windows Subsytem for Linux (WSL) and connect to live GraphQL from the Cline extension in Visual Studio Code.
-
How to connect to OData Services from IntelliJ
Integrate connectivity to OData with wizards in IntelliJ.
-
A Performance Comparison of Drivers for Azure Cosmos DB
An article comparing the read performance of CData Software Drivers for MongoDB with the C# and .NET MongoDB Driver and the native ODBC Driver.
-
Visualize Live Short.io Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Short.io.
-
Consume WordPress OData Feeds in PowerBuilder
This article demonstrates how to consume WordPress as OData feeds from PowerBuilder using the API Server.
-
Connect to Azure Data Catalog Data from PowerBuilder via ADO.NET
This article demonstrates how to access Azure Data Catalog from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Data Catalog.
-
How to connect to Drip Data from Spring Boot
Connect to Drip in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Authorize.Net Data in RazorSQL
Connect to Authorize.Net from wizards and query Authorize.Net from the GUI in the RazorSQL database management tool.
-
Connect to Discord Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build an OLAP Cube in SSAS from Notion Data
Establish a connection to Notion data from SQL Server Analysis Services, and use the Notion Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish Office 365-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Office 365.
-
DataBind Controls to Azure Analysis Services Data in Delphi
DataBind to Azure Analysis Services in Delphi with standard data access components and controls.
-
Choosing the Best Method to Connect Office 365 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Office 365 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Visualizations of ChartMogul Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ChartMogul in Birst.
-
Connect to Cvent Data from PowerBuilder via ADO.NET
This article demonstrates how to access Cvent from Appeon PowerBuilder using the CData ADO.NET Provider for Cvent.
-
Automated Continuous Epicor Kinetic Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to IBM DB2.
-
Replicate Oracle Eloqua Reporting Data from PowerShell
Write a quick PowerShell script to query Oracle Eloqua Reporting. Use connectivity to the live data to replicate Oracle Eloqua Reporting to SQL Server.
-
Query Zoho Recruit Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Recruit from Node.js.
-
Create MySQL-Connected Applications in Appsmith
Connect to MySQL Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MySQL.
-
Create SSAS Tabular Models from Microsoft Entra ID Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Entra ID using CData drivers.
-
Connect to Superchat Data in Jaspersoft Studio
Execute SQL to remote Superchat in Jaspersoft Studio.
-
Integrate with ElevenLabs Data in JReport Designer
Create charts and reports based on ElevenLabs in JReport Designer.
-
How to Connect to & Open CloudConvert Data in Microsoft Excel
This article uses the CData ODBC driver for CloudConvert to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.