CData Software - Knowledge Base
Recent Articles
-
Integrate with PagerDuty Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PagerDuty to a JSON file on disk.
-
Edit and Search Kafka External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Kafka to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Kafka objects that you can access from apps and the dashboard.
-
Connect LionDesk to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect LionDesk with IBM WebSphere for seamless data integration and connectivity.
-
Create Datasets from Coda in Domo Workbench and Build Visualizations of Coda Data in Domo
Use the CData Software ODBC Driver for Coda to create datasets from Coda in Domo Workbench and then build visualizations in the Domo service.
-
Create Vault CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Vault CRM Data from Klipfolio and build custom visualizations using live Veeva Vault & Vault CRM.
-
Process & Analyze BambooHR Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live BambooHR Data.
-
Automated Continuous MariaDB Replication to Vertica
Use CData Sync for automated, continuous, customizable MariaDB replication to Vertica.
-
Create Informatica Mappings From/To an ODBC Data Source for Impala
Create an ODBC connection to Impala in Informatica and browse and transfer Apache Impala.
-
Create SSAS Tabular Models from Wistia Data
How to build a SQL Server Analysis Service Tabular Model from Wistia using CData drivers.
-
Access Live Facebook Ads Data in TIBCO Data Virtualization
Use the Facebook Ads Tibco DV Adapter to create a Facebook Ads data source in TIBCO Data Virtualization Studio and gain access to live Facebook Ads from your TDV Server.
-
Create a Data Access Object for Helpscout Data using JDBI
A brief overview of creating a SQL Object API for Helpscout in JDBI.
-
Create Apps from LinkedIn Data in Qlik Sense Cloud
Use CData Connect AI to connect to LinkedIn Data and build apps from live LinkedIn in Qlik Sense Cloud.
-
How to Access Live Azure Data Catalog Data in Visual Studio Code via Cline
Run CData MCP Server for Azure Data Catalog on Windows Subsytem for Linux (WSL) and connect to live Azure Data Catalog from the Cline extension in Visual Studio Code.
-
Visualize FTP Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FTP Servers.
-
Query Calendly Data in DataGrip
Create a Data Source for Calendly in DataGrip and use SQL to query live Calendly.
-
Use the CData Software JDBC Driver for Hacker News in MicroStrategy Web
Connect to Hacker News in MicroStrategy Web using the CData Software JDBC Driver for Hacker News.
-
Use Claude to Talk to Your Confluence 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 Confluence for you.
-
Build GitHub-Connected Apps in Choreo
Use CData Connect AI to connect to GitHub Data from Choreo and build custom apps using live GitHub.
-
Build Visualizations of Azure Data Lake Storage Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Data Lake Storage in Birst.
-
Connect to NetSuite Data in Claris FileMaker Pro
Use the CData ODBC Driver for NetSuite in FileMaker Pro to connect to NetSuite and work with NetSuite CRM & ERP in your FileMaker applications.
-
How to Access Live SAP Business One Data in Visual Studio Code via Cline
Run CData MCP Server for SAP Business One on Windows Subsytem for Linux (WSL) and connect to live SAP Business One from the Cline extension in Visual Studio Code.
-
Replicate Yelp Data from PowerShell
Write a quick PowerShell script to query Yelp. Use connectivity to the live data to replicate Yelp to SQL Server.
-
Use Microsoft Copilot Studio to talk to your HBase 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 Apache HBase for you.
-
Build SendGrid-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SendGrid Data and create custom apps in Mendix.
-
Create Office 365-Connected Applications in Appsmith
Connect to Office 365 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Office 365.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Salesforce & Force.com to Power BI dashboards. Simply drag and drop Salesforce & Force.com into data visuals on the Power BI canvas.
-
How to Access Live Pipeline CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pipeline CRM enables you to integrate Pipeline CRM into workflows built using Microsoft Power Automate Desktop.
-
Integrating OpenCode Terminal with SharePoint 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.
-
Connect and Visualize Live Google Drive Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Drive into the Databricks platform and create visualization dashboards with real-time Google Drive.
-
Configure the CData JDBC Driver for Oracle Financials Cloud in a Connection Pool in Tomcat
Connect to Oracle Financials Cloud from a connection pool in Tomcat.
-
Use the CData Software JDBC Driver for Okta in MicroStrategy
Connect to Okta in MicroStrategy Developer using the CData Software JDBC Driver for Okta.
-
Getting Started with the CData SSIS Components for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Ariba Procurement.
-
Integrating Dataiku with Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Analytics.
-
Automated Continuous Drip Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Drip replication to Amazon Redshift.
-
Import OneNote Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft OneNote. In this article, you will use the OData format to import Microsoft OneNote into Microsoft Power Query.
-
Trigger Databricks IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Databricks with standard wizards in Logic Apps.
-
Build a PostgreSQL Interface for Spotify Data using the CData JDBC Driver
Use the Remoting features of the Spotify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Object-Relational Mapping (ORM) with IBM Cloud Object Storage Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to IBM Cloud Object Storage into a Java-based ORM framework, Hibernate.
-
Edit and Search External Freshservice Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Freshservice to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Freshservice Data objects that you can access from apps and the dashboard.
-
Use Claude to Talk to Your Marketing Data
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your marketing data for you.
-
Connect to OneNote Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft OneNote in Google Apps Script.
-
How to connect to Helpscout Data from Spring Boot
Connect to Helpscout in a Spring Boot Application using the CData API Driver for JDBC
-
Build a Singer.io Tap for Xero With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Xero data using
-
Automated Continuous Intercom Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Intercom replication to OneLake in Microsoft Fabric.
-
How to Visualize FHIR 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 FHIR in Python.
-
Connecting GenSpark with SAS xpt Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAS XPORT without any replication or custom integration required.
-
Automated Continuous QuickBooks Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable QuickBooks Desktop replication to OneLake in Microsoft Fabric.
-
DataBind Charts to Splunk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Splunk from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
A PostgreSQL Interface for ChartMogul Data (MySQL Remoting via JDBC)
Use the Remoting features of the ChartMogul JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to use SQLAlchemy ORM to access OneNote Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft OneNote.
-
Connect to Zoho CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho CRM using standard SQL.
-
Feed Oracle Eloqua Data into FineReport
How to set Oracle Eloqua as a JDBC data source in FineReport.
-
Object-Relational Mapping (ORM) with Hive Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Apache Hive into a Java-based ORM framework, Hibernate.
-
Build SAS xpt-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAS XPORT.
-
Build a Singer.io Tap for Zoho CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho CRM data using
-
Build MYOB AccountRight-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for MYOB AccountRight to explore live MYOB AccountRight Data in GitHub Copilot to assist with building MYOB AccountRight-powered applications.
-
How to Work with Raisers Edge NXT Data in ETL Validator JDBC
Connect to Raisers Edge NXT from ETL Validator jobs using the CData Software JDBC Driver.
-
Operational Reporting on LinkedIn Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LinkedIn Ads.
-
Integrate with Oracle Financials Cloud Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle Financials Cloud in SnapLogic.
-
Connect Elorus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Elorus with IBM WebSphere for seamless data integration and connectivity.
-
Use ChatGPT to Talk to Your Slack 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 Slack for you.
-
Replicate Multiple Greenhouse Accounts
Replicate multiple Greenhouse accounts to one or many databases.
-
Integrate Everhour with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Everhour with External Services.
-
How to Access JSON Services Using Entity Framework
This article shows how to access JSON using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to Google Ad Manager Data from Spring Boot
Connect to Google Ad Manager in a Spring Boot Application using the CData JDBC Driver for Google Ad Manager
-
Configure the CData JDBC Driver for Chargebee in a Connection Pool in Tomcat
Connect to Chargebee from a connection pool in Tomcat.
-
Import Real-Time Adobe Target Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Adobe Target in ColdFusion.
-
Integrate Amplitude Data in the Pentaho Report Designer
Publish reports based on Amplitude in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for OneNote in MicroStrategy Web
Connect to Microsoft OneNote in MicroStrategy Web using the CData Software ODBC Driver for OneNote.
-
How to connect to Vercel Data with Squirrel SQL client
Connect to Vercel and execute queries in the Squirrel SQL Client.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Klipfolio
Provide connectivity to Klipfolio through an SAP BusinessObjects universe.
-
Use Microsoft Copilot Studio to talk to your Jira Assets 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 Jira Assets for you.
-
Access Live Lakebase Data in TIBCO Data Virtualization
Use the Lakebase Tibco DV Adapter to create a Lakebase data source in TIBCO Data Virtualization Studio and gain access to live Lakebase from your TDV Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Vimeo
Create an ODBC connection to Vimeo in Informatica and browse and transfer Vimeo.
-
LINQ to Google Translate 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 Google Translate Data Provider.
-
Connect to and Query BambooHR Data in QlikView over ODBC
Create data visualizations with BambooHR in QlikView.
-
Access CloudConvert Data from MySQL in PHP
Connect to CloudConvert through the standard MySQL libraries in PHP.
-
Getting Started with the CData ODBC Driver for BambooHR
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for BambooHR.
-
Connect to YouTube Analytics Data in CloverDX (formerly CloverETL)
Transfer YouTube Analytics using the visual workflow in the CloverDX data integration tool.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SAP Concur actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrate Parallel Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Parallel from Informatica Cloud.
-
Build Sybase IQ-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Sybase IQ Data and create custom apps in Bubble.
-
Integrating Cursor CLI with Aha! 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.
-
Publish Reports with PostgreSQL Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PostgreSQL.
-
How to Connect to & Open Klaviyo Data in Microsoft Excel
This article uses the CData ODBC driver for Klaviyo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData JDBC Driver for BigCommerce
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for BigCommerce.
-
How to Connect to Live Dropbox 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 Dropbox without replication.
-
Perform Batch Operations with Pipedrive Data in Apache NiFi
Connect to Pipedrive and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Connect Flowise AI Agents to Live Redis 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 Redis without replication.
-
Process & Analyze Slack Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Slack Data.
-
How to connect and process Beeminder from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Beeminder.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Salesforce CRM Analytics within intelligent workflows.
-
Build a Simple VCL Application for Shortcut Data
How to build a simple VCL Application to view Shortcut in RAD Studio using the CData ODBC Driver for Shortcut.
-
Build an OLAP Cube in SSAS from Delighted Data
Establish a connection to Delighted data from SQL Server Analysis Services, and use the Delighted Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live Discord Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Discord using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Greenplum Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Pivotal GreenPlum.
-
Automated Continuous Bannerbear Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Bannerbear replication to PostgreSQL.
-
Automated Continuous GitLab Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GitLab replication to OneLake in Microsoft Fabric.
-
Use JayDeBeApi to access Jumpseller Data in Python
Use standard Python scripting and the development environment of your choice to access live Jumpseller.
-
Access Live SQL Analysis Services Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SQL Analysis Services data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.