CData Software - Knowledge Base
Recent Articles
-
Replicate Impala Data in Heroku for Use in Salesforce Connect
Replicate Apache Impala to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Presto-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Presto.
-
Connect to Adobe Analytics Data in DBArtisan
Use wizards in DBArtisan to configure Adobe Analytics as a data source.
-
Integrating OpenCode Terminal with Customer.io 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.
-
Object-Relational Mapping (ORM) with Pushbullet 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 Pushbullet into a Java-based ORM framework, Hibernate.
-
Building Dynamic Web Pages with Coinbase Data Using AngularJS
Create single-page applications with live connectivity to Coinbase using the CData API Server.
-
Access SAP SuccessFactors LMS Data from MySQL in PHP
Connect to SAP SuccessFactors LMS through the standard MySQL libraries in PHP.
-
Automate Excel Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Excel and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Consume Printify OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Printify feeds that reflect any changes in SAP Lumira.
-
Work with Live SAS Data Sets Data in Power Query
Use CData Connect AI to connect to SAS Data Sets and work with live SAS Data Sets in Microsoft Power Query.
-
Connect to Reckon Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon.
-
How to Visualize Procore Data in Python with pandas
Use pandas and other modules to analyze and visualize live Procore in Python.
-
Connect to Notion Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Notion to connect to Notion and execute queries in PowerBuilder.
-
Access Live Redis Data in Coginiti Pro
Connect to and query live Redis from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Visualize Azure DevOps Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure DevOps in Python.
-
Import Real-Time Box Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Box in ColdFusion.
-
Connect to SharePoint Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft SharePoint.
-
Connect to Front Data in Aqua Data Studio
Access Front from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Real-Time Sage 300 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage 300 and Dataflow to import and use Sage 300 in Power Apps.
-
Moving Data from SAP SuccessFactors LMS to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP SuccessFactors LMS data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Biml to Build SSIS Tasks to Replicate LDAP Objects to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LDAP to SQL Server.
-
Connect to Aweber Data from PowerBuilder via JDBC
This article demonstrates how to access Aweber from PowerBuilder using the Aweber JDBC Driver.
-
Deploy the ADO.NET Provider for Google Analytics on an SSRS Report Server
Connect to Google Analytics 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.
-
Establish a Live Connection with Billsby Data using Tableau Bridge
The CData ODBC Driver for Billsby enables you to integrate live Billsby into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Pinecone Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pinecone from Node.js.
-
How to Connect DBeaver to Missive via a JDBC Driver
Manage Missive with visual tools in DBeaver like the query browser.
-
Build MVC Applications with Connectivity to Freshteam Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Freshteam from an ASP.NET MVC application.
-
Visualize Live Mouseflow Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mouseflow.
-
Integrating OpenCode Terminal with Todoist 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.
-
DataBind Controls to Postmark Data in Delphi
DataBind to Postmark in Delphi with standard data access components and controls.
-
Stream Keap Data into Apache Kafka Topics
Access and stream Keap in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Highrise-Connected Nintex Workflows
Use CData Connect AI to connect to Highrise Data from Nintex Workflow Cloud and build custom workflows using live Highrise CRM.
-
Access Blackbaud FE NXT Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Blackbaud FE NXT from HeidiSQL.
-
How to Connect to & Open Pipeliner CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Pipeliner CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Query Microsoft Exchange Data in MySQL Workbench
Execute MySQL queries against live Microsoft Exchange from MySQL Workbench.
-
How to Import Data from Shippo into Google Sheets
Import Shippo into a Google spreadsheet that is automatically refreshed.
-
Connect to WooCommerce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to WooCommerce as an External Source in Dremio.
-
Easily Integrate GraphQL Data in Lazarus Pascal IDE
Learn how to easily integrate live GraphQL in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Replicate Oracle SCM Data from PowerShell
Write a quick PowerShell script to query Oracle SCM. Use connectivity to the live data to replicate Oracle SCM to SQL Server.
-
How to Connect to Live Certinia Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Certinia for you.
-
Automate Eventbrite Data Replication to SAP HANA
Use CData Sync to customize and automate Eventbrite replication to SAP HANA.
-
Integrate with Workable Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Workable to a JSON file on disk.
-
Connect and Query Live Splunk Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Splunk into Databricks
-
Connect to and Visualize Live Mocean Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mocean.
-
Query PolarTeamPro Data in ColdFusion
Write standard ColdFusion data access code to connect to PolarTeamPro.
-
Integrating Cursor CLI with SFTP 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.
-
Object-Relational Mapping (ORM) with Simplesat 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 Simplesat into a Java-based ORM framework, Hibernate.
-
A PostgreSQL Interface for Elasticsearch Data using the CData ODBC Driver
Use the SQL Gateway and Elasticsearch ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Avalara AvaTax Data as a MySQL Database in Node.js
Execute MySQL queries against Avalara AvaTax from Node.js.
-
Connect to Front Data from a Connection Pool in JBoss
Integrate Front into Java servlets: Use the Management Console in JBoss to install the Front JDBC Driver.
-
Integrating Antigravity CLI with Adobe Experience Manager via CData CLI
Connect Adobe Experience Manager to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Access Live Microsoft Teams Data in Visual Studio Code via Cline
Run CData MCP Server for Microsoft Teams on Windows Subsytem for Linux (WSL) and connect to live Microsoft Teams from the Cline extension in Visual Studio Code.
-
Access Sendwithus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sendwithus from HeidiSQL.
-
Integrating Codex CLI with Strava 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 Query Live ZohoSubscriptions Data in Claude Desktop
Connect to and query live ZohoSubscriptions Data in Claude Desktop using CData MCP Server.
-
Import and Visualize Avro Data in Power View
Create data visualizations based on Apache Avro in Excel.
-
Access Google Search Results as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Search from your Oracle system.
-
Integrating OpenCode Terminal with Google Drive 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.
-
Connecting GenSpark with API Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to API without any replication or custom integration required.
-
Integrate Live Splunk Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automate JotForm Data Replication to SAP HANA
Use CData Sync to customize and automate JotForm replication to SAP HANA.
-
How to Connect Twitter Ads Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Twitter Ads data in real time using natural language.
-
How to Import Data from Coda into Google Sheets
Import Coda into a Google spreadsheet that is automatically refreshed.
-
Integrate Real-Time Access to Zoho Inventory in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho Inventory in real time.
-
How to Query Live Nethunt Data in Claude Desktop
Connect to and query live Nethunt Data in Claude Desktop using CData MCP Server.
-
Create Datasets from Zuora in Domo Workbench and Build Visualizations of Zuora Data in Domo
Use the CData Software ODBC Driver for Zuora to create datasets from Zuora in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData SSIS Components to Insert New or Update Existing Salesforce Records from SQL Server
Easily push SQL Server data to Salesforce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce or update existing records with data from a SQL Server database.
-
Use the CData API Server to Access OnePageCrm Data in Microsoft PowerPivot
Use the CData API Server to connect to live OnePageCrm in the Power Pivot business intelligence tool.
-
Build a Simple VCL Application for ActiveCampaign Data
How to build a simple VCL Application to view ActiveCampaign in RAD Studio using the CData ODBC Driver for ActiveCampaign.
-
Consume Splunk OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Splunk feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData JDBC Driver for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Elasticsearch.
-
Use Azure AI Foundry to Talk to Your Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Vertica for you.
-
Connecting GenSpark with Phoenix Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apache Phoenix without any replication or custom integration required.
-
Connect to CampaignMonitor Data in DBeaver
Use the CData ODBC Driver to connect to CampaignMonitor in DBeaver.
-
How to Connect to & Open OnePageCrm Data in Microsoft Excel
This article uses the CData ODBC driver for OnePageCrm to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Dataiku with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Search.
-
Use Agno to Talk to Your Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Oracle Service Cloud for you.
-
Automate Active Directory Data Replication to SAP HANA
Use CData Sync to customize and automate Active Directory replication to SAP HANA.
-
Connect to Tavily Data in JRuby
Create a simple JRuby app with access to live Tavily.
-
Integrate ShipEngine Data in the Pentaho Report Designer
Publish reports based on ShipEngine in the Pentaho BI tool.
-
Access Live GraphQL Data in Excel 365 Online (Excel for the web)
Connect to GraphQL from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Phoenix Data from HeidiSQL
Use CData Connect AI to connect to and query live Apache Phoenix from HeidiSQL.
-
Access Live Discourse Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Discourse data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Rapidly Develop YouTube Analytics-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 YouTube Analytics.
-
Build Semantic Layer Views for Microsoft Ads Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Ads in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Ads.
-
Integrating Codex CLI with Amazon Marketplace 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.
-
Integrate Azure Analysis Services Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Analysis Services and integrate live Azure Analysis Services into your Power Automate tasks.
-
Use the CData Software JDBC Driver for Wrike in MicroStrategy
Connect to Wrike in MicroStrategy Developer using the CData Software JDBC Driver for Wrike.
-
Viewing Sage Cloud Accounting Data in RAD Studio Data Explorer
How to view Sage Business Cloud Accounting in RAD Studio Data Explorer using the CData ODBC Driver for Sage Cloud Accounting.
-
Connect to OpenWeatherMap Data in Jaspersoft Studio
Execute SQL to remote OpenWeatherMap in Jaspersoft Studio.
-
How to connect PolyBase to Unbounce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Unbounce.
-
Use JayDeBeApi to access Mocean Data in Python
Use standard Python scripting and the development environment of your choice to access live Mocean.
-
Visualize GitHub Data in TIBCO Spotfire through ADO.NET
Integrate GitHub into dashboards in TIBCO Spotfire.
-
Use ChatGPT to Talk to Your LinkedIn Ads 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 LinkedIn Ads for you.
-
Use JayDeBeApi to access Everhour Data in Python
Use standard Python scripting and the development environment of your choice to access live Everhour.
-
Getting Started with the CData ADO.NET Provider for Ontraport
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to and Query Unbounce Data in QlikView over ODBC
Create data visualizations with Unbounce in QlikView.
-
Connect to Hugging Face Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Hugging Face in the Denodo Virtual DataPort Administrator.
-
Bind Live Dynamics 365 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Dynamics 365 data
-
Replicate Multiple MessageBird Accounts via the CData Sync CLI
Replicate multiple MessageBird accounts to one or many databases.