CData Software - Knowledge Base
Recent Articles
-
Automate SAP HANA XS Advanced Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP HANA XS Advanced replication to Azure Synapse.
-
Build Slack-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Slack to explore live Slack Data in Claude Code to assist with building Slack-powered applications.
-
Build Google Sheets-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Sheets Data and create custom apps in Bubble.
-
Connect to Airtable Data in RazorSQL
Connect to Airtable from wizards and query Airtable from the GUI in the RazorSQL database management tool.
-
Load Perigon Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Perigon to a database.
-
Design BIRT Reports on Sage Intacct Data
Provide current Sage Intacct to your embedded analytics.
-
Create CouchDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CouchDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Paymo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Paymo from HeidiSQL.
-
Import FreeAgent Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access FreeAgent. In this article, you will use the OData format to import FreeAgent into Microsoft Power Query.
-
Connect to and Visualize Live Google Spanner Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Spanner.
-
How to connect PolyBase to Presto
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Presto.
-
Use the CData ODBC Driver for Jumpseller in Microsoft Power Query
You can use the CData Jumpseller ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Jumpseller into Microsoft Power Query.
-
How to connect PolyBase to BigQuery
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google BigQuery.
-
Integrating Codex CLI with PagerDuty 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Vercel
Create an ODBC connection to Vercel in Informatica and browse and transfer Vercel.
-
Connect to FHIR Data in Aqua Data Studio
Access FHIR from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate Act CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Act CRM from PowerShell? This article demonstrates how to utilize the Act CRM Cmdlets for tasks like connecting to Act CRM, automating operations, downloading data, and more.
-
How to Query ServiceDesk Plus Data in MySQL Workbench
Execute MySQL queries against live ServiceDesk Plus from MySQL Workbench.
-
Automated Continuous Coinbase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Coinbase replication to Snowflake.
-
How to connect SharePoint with Microsoft Dataverse Data through external lists
Provide Microsoft Dataverse (CDS) to SharePoint users as an external list.
-
How to Build an ETL App for Ontraport Data in Python with CData
Create ETL applications and real-time data pipelines for Ontraport in Python with petl.
-
Viewing Pipedrive Data in RAD Studio Data Explorer
How to view Pipedrive in RAD Studio Data Explorer using the CData ODBC Driver for Pipedrive.
-
Build an OLAP Cube in SSAS from Sage Intacct Data
Establish a connection to Sage Intacct data from SQL Server Analysis Services, and use the Sage Intacct Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Azure Table Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Table Storage.
-
Visualize Live Outlook Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Outlook using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Object-Relational Mapping (ORM) with Gorgias 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 Gorgias into a Java-based ORM framework, Hibernate.
-
Integrating Codex CLI with Accelo 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.
-
Automate Sage Cloud Accounting Data Replication to Couchbase
Use CData Sync to Customize and automate Sage Business Cloud Accounting replication to Couchbase.
-
Extend Google Sheets with Redis Data
Make calls to Redis from Google Apps Script via the API Server.
-
Operational Reporting on Zuora Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zuora.
-
Query BigQuery Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google BigQuery and perform CRUD operations on BigQuery from Node.js.
-
Back Up Unbounce 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 Unbounce data.
-
Deploy the ADO.NET Provider for Microsoft Entra ID on an SSRS Report Server
Connect to Microsoft Entra ID 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.
-
DataBind Controls to Front Data in Delphi
DataBind to Front in Delphi with standard data access components and controls.
-
Connect to PDFMonkey Data in RapidMiner
Integrate PDFMonkey with standard components and data source configuration wizards in RapidMiner Studio.
-
Consume Rootly OData Feeds in PowerBuilder
This article demonstrates how to consume Rootly as OData feeds from PowerBuilder using the API Server.
-
Bridge GitLab Connectivity with Apache NiFi
Access and process GitLab in Apache NiFi using the CData JDBC Driver.
-
Connect to Close Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Close using standard SQL.
-
Build Dashboards with ZohoMarketingHub Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZohoMarketingHub in Dundas BI.
-
Publish Couchbase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Couchbase.
-
Build Zoho Projects Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Projects and build visualizations in Tableau.
-
How to Connect DBeaver to Confluence via a JDBC Driver
Manage Atlassian Confluence with visual tools in DBeaver like the query browser.
-
Integrate Blackbaud FE NXT with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Blackbaud FE NXT with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Blackbaud FE NXT.
-
Configure the CData JDBC Driver for Google Cloud Storage in a Connection Pool in Tomcat
Connect to Google Cloud Storage from a connection pool in Tomcat.
-
Access Live Redis Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Redis in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to and Query PolarTeamPro Data in QlikView over ODBC
Create data visualizations with PolarTeamPro in QlikView.
-
Building Dynamic Web Pages with Chargebee Data Using AngularJS
Create single-page applications with live connectivity to Chargebee using the CData API Server.
-
Configure the CData JDBC Driver for Omnisend in a Connection Pool in Tomcat
Connect to Omnisend from a connection pool in Tomcat.
-
Build a Singer.io Tap for Raisers Edge NXT With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Raisers Edge NXT data using
-
How to Access Oracle HCM Cloud Data Using Entity Framework
This article shows how to access Oracle HCM Cloud using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to import MailerSend Data into Apache Solr
Use the CData Software JDBC Driver for MailerSend in Data Import Handler and create an automated import of MailerSend to Apache Solr Enterprise Search platform.
-
Access Live Coda Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Coda data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect CampaignMonitor to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CampaignMonitor using the CData Python MCP Server.
-
Automated Continuous Google Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Ads replication to Google BigQuery.
-
Create Power BI Reports on Real-Time Missive Data
Use the CData ODBC Driver for Missive to visualize Missive in Power BI Desktop.
-
Visualize Live ZarMoney Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZarMoney using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with CSV Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CSV/TSV Files to a JSON file on disk.
-
Integrating Codex CLI with Google Contacts 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.
-
Validate ChartMogul Data with QuerySurge
Access and validate ChartMogul in QuerySurge using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time SingleStore Data
Use CData Power BI Connectors to visualize SingleStore in Power BI.
-
Build Automated Workflows with Live Facebook Ads Data in Workato
Use CData Connect AI to connect to live Facebook Ads and build automated workflows in Workato.
-
A PostgreSQL Interface for MessageBird Data using the CData ODBC Driver
Use the SQL Gateway and MessageBird ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share Freshdesk Data dashboards with Tableau Server
The CData ODBC driver for Freshdesk enables you integrate Freshdesk into Tableau dashboards.
-
Create a Data Access Object for Snowflake Data using JDBI
A brief overview of creating a SQL Object API for Snowflake in JDBI.
-
Consume Salesforce Marketing OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce Marketing feeds that reflect any changes in SAP Lumira.
-
Creating Raisers Edge NXT-Connected Applications in Unqork
You can use CData Connect AI to feed Raisers Edge NXT to Unqork and build custom business apps.
-
VWO Reporting in OBIEE with the VWO JDBC Driver
Deploy the VWO JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Import Data from ConvertKit into Google Sheets
Import ConvertKit into a Google spreadsheet that is automatically refreshed.
-
Integrating LlamaIndex with Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Campaign Manager 360 in real time.
-
Connect to Dynamics 365 Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Dynamics 365 from HeidiSQL.
-
How to Query Live PostgreSQL Data in Claude Desktop
Connect to and query live PostgreSQL Data in Claude Desktop using CData MCP Server.
-
Use Manus AI to Talk to Your Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Gong.
-
How to connect to SAP SuccessFactors LMS Data from IntelliJ
Integrate connectivity to SAP SuccessFactors LMS with wizards in IntelliJ.
-
Analyze Acumatica Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Acumatica ERP and visualize live Acumatica ERP in Infragistics Reveal.
-
How to Access Live Invoiced Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Invoiced from the Cline extension in Visual Studio Code.
-
Analyze FreshBooks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FreshBooks from Power Pivot. You will use the Table Import Wizard to load FreshBooks. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy Desktop
Connect to SAP Ariba Source in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Source.
-
Connect to Workable Data in RapidMiner
Integrate Workable with standard components and data source configuration wizards in RapidMiner Studio.
-
Enable the Google Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Analytics.
-
LINQ to Authorize.Net 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 Authorize.Net Data Provider.
-
Stream Authorize.Net Data into Apache Kafka Topics
Access and stream Authorize.Net in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SFTP
Provide connectivity to SFTP through an SAP BusinessObjects universe.
-
How to connect to Workable Data with Squirrel SQL client
Connect to Workable and execute queries in the Squirrel SQL Client.
-
Excel Spreadsheet Automation on PabblySubscriptions Data with the QUERY Formula
Pull data from PabblySubscriptions, automate spreadsheets, and more with the QUERY formula.
-
Build Adobe Experience Manager-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Adobe Experience Manager to explore live Adobe Experience Manager Data in Gemini Code Assist to assist with building Adobe Experience Manager-powered applications.
-
Access Live Apollo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apollo into the statistical analysis tools available in SAS JMP. This article shows how to use Apollo in the Graph Builder and Query Builder.
-
Automated Continuous HDFS Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HDFS replication to IBM DB2.
-
ETL Parallel in Oracle Data Integrator
This article shows how to transfer Parallel into a data warehouse using Oracle Data Integrator.
-
Connect to OpenWeatherMap Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for OpenWeatherMap in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData ADO.NET Provider for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP SuccessFactors LMS.
-
Enable the Perplexity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Perplexity.
-
Using the CData Software ODBC Driver for Avro in PyCharm
Connect to Avro as an ODBC data source in PyCharm using the CData Software ODBC Driver for Avro.
-
Analyze EnterpriseDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze EnterpriseDB in Microsoft R Open.
-
Integrate Webflow Data in Pentaho Data Integration
Build ETL pipelines based on Webflow in the Pentaho Data Integration tool.
-
Automated Continuous SpaceX Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SpaceX replication to delimited files (CSV/TSV).
-
Migrating data from Oracle Eloqua Reporting to Snowflake using CData SSIS Components.
Easily push Oracle Eloqua Reporting to Snowflake using the CData SSIS Tasks for Oracle Eloqua Reporting and Snowflake.
-
Integrate JDBC-ODBC Bridge Data in the Pentaho Report Designer
Publish reports based on JDBC-ODBC Bridge in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for BigQuery in MicroStrategy Web
Connect to Google BigQuery in MicroStrategy Web using the CData Software ODBC Driver for BigQuery.
-
Build Drift-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Drift Data in GitHub Copilot to assist with building Drift-powered applications.
-
Connecting Mastra with BambooHR Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time BambooHR, no replication required.