CData Software - Knowledge Base
Recent Articles
-
Integrate Live OData Services into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live OData to Blue Prism using the CData ODBC Driver for OData to create automated workflows for repetitive business tasks.
-
How to Connect to Live Amazon DynamoDB Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Amazon DynamoDB for you.
-
How to Query MarkLogic Data in MySQL Workbench
Execute MySQL queries against live MarkLogic from MySQL Workbench.
-
Back Up Clio 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 Clio data.
-
Query Oracle Eloqua Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Eloqua from Node.js.
-
Visualize Demio 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 Demio into TIBCO Spotfire.
-
How to Work with GetResponse Data in ETL Validator JDBC
Connect to GetResponse from ETL Validator jobs using the CData Software JDBC Driver.
-
ClickUp Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ClickUp facts in real time.
-
How to Connect to Live Excel Online Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Microsoft Excel Online for you.
-
Use Manus AI to Talk to Your SingleStore 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 SingleStore.
-
Connect to Real-Time MarkLogic Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MarkLogic and Dataflow to import and use MarkLogic in Power Apps.
-
Integrating Claude Code CLI with RabbitMQ 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.
-
Bidirectional Access to Adobe Experience Manager Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Adobe Experience Manager in Filemaker Pro for Mac or Windows.
-
Connect to SAP Hybris C4C Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Hybris C4C in Airbyte.
-
Use the CData Software ODBC Driver for GitLab in MicroStrategy Web
Connect to GitLab in MicroStrategy Web using the CData Software ODBC Driver for GitLab.
-
Enable the Opsgenie JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Opsgenie.
-
Use the CData ODBC Driver for Wrike in Microsoft Power Query
You can use the CData Wrike ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Wrike into Microsoft Power Query.
-
How to Build an ETL App for Xero Data in Python with CData
Create ETL applications and real-time data pipelines for Xero Accounting in Python with petl.
-
Query Live Google Drive Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Drive directly from the development environment.
-
Automated Continuous SharePoint Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SharePoint replication to PostgreSQL.
-
Connect to Elasticsearch Data in HULFT Integrate
Connect to Elasticsearch as a JDBC data source in HULFT Integrate
-
Connect to SAS xpt in SpagoBI
Create reports featuring live SAS XPORT in SpagoBI Studio. Host SAS xpt reports on SpagoBI Server.
-
Model SurveyMonkey Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SurveyMonkey, enabling the direct import of real-time SurveyMonkey.
-
Create a Data Access Object for Factorial Data using JDBI
A brief overview of creating a SQL Object API for Factorial in JDBI.
-
Integrate Live MySQL Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MySQL and integrate live MySQL into apps built in Microsoft Power Apps.
-
Bind Live Slack Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Slack data
-
Build eBay-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live eBay and build eBay-connected web apps with Axios.
-
Access Drift Data from MySQL in Amazon QuickSight
Connect to Drift and build visualizations of Drift using a MySQL Connection in Amazon QuickSight.
-
Access Live Kintone Data in Coginiti Pro
Connect to and query live Kintone from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Nuclia Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Nuclia with the CData JDBC Driver for Nuclia.
-
Automated Continuous Freshdesk Replication to SingleStore
Use CData Sync for automated, continuous, customizable Freshdesk replication to SingleStore.
-
Connect to Certinia Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Certinia to connect to Certinia and execute queries in PowerBuilder.
-
Access MySQL Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MySQL from your Oracle system.
-
Building Dynamic Web Pages with CockroachDB Data Using AngularJS
Create single-page applications with live connectivity to CockroachDB using the CData API Server.
-
Establish a Live Connection with Teamgate Data using Tableau Bridge
The CData ODBC Driver for Teamgate enables you to integrate live Teamgate into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData Power BI Connector for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sybase IQ.
-
Integrating GitHub Copilot CLI with Browserless 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.
-
Import and Visualize Slack Data in Power View
Create data visualizations based on Slack in Excel.
-
Automated Continuous Gorgias Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Gorgias replication to Google BigQuery.
-
How to create an RPA flow for Nuclia Data in UiPath Studio
Use the Nuclia ODBC Driver to create workflows that access real-time Nuclia without any coding.
-
Access Live Bullhorn CRM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Bullhorn CRM from your Google Sheets.
-
How to Work with Webex Data in AWS Glue Jobs Using JDBC
Connect to Webex from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Oracle SCM in MicroStrategy
Connect to Oracle SCM in MicroStrategy Developer using the CData Software ODBC Driver for Oracle SCM.
-
Connect DB2 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect DB2 with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Zuora Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zuora replication to OneLake in Microsoft Fabric.
-
Automated Continuous MYOB AccountRight Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to delimited files (CSV/TSV).
-
Access Live Avro Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Avro from your Excel spreadsheets.
-
Use JayDeBeApi to access Exact Online Data in Python
Use standard Python scripting and the development environment of your choice to access live Exact Online.
-
Use the CData Software JDBC Driver for SAP Concur in MicroStrategy Desktop
Connect to SAP Concur in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Concur.
-
Create a Data Access Object for Redis Data using JDBI
A brief overview of creating a SQL Object API for Redis in JDBI.
-
Provide OData Services of HBase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache HBase by developing a WCF Service Application.
-
Automated Continuous IBM Cloud Object Storage Replication to SingleStore
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to SingleStore.
-
How to Query FormSite Data in MySQL Workbench
Execute MySQL queries against live FormSite from MySQL Workbench.
-
Integrate Live Shopify Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
IBM Informix Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on IBM Informix facts in real time.
-
Getting Started with the CData Python Connector for Email
Learn to install and license the CData Python Connector
-
Connect to Retently in SpagoBI
Create reports featuring live Retently in SpagoBI Studio. Host Retently reports on SpagoBI Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Cloudflare
Create Cloudflare data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Redis-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Redis Data from Klipfolio and build custom visualizations using live Redis.
-
Automated Continuous SAP Ariba Source Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Amazon Redshift.
-
Connect to Aweber Data from PowerBuilder via ADO.NET
This article demonstrates how to access Aweber from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous Tally Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Tally replication to IBM DB2.
-
Build Aweber-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Aweber.
-
Analyze Square Data in Looker
Use CData Connect AI to connect to Square Data from Looker and build custom apps using live Square.
-
How to Connect to Oracle Financials Cloud Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Financials Cloud. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for Klipfolio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Klipfolio to connect to Klipfolio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Klipfolio in Excel.
-
Design BIRT Reports on ConvertAPI Data
Provide current ConvertAPI to your embedded analytics.
-
View Reports on Real-Time Customer.io Data in Power BI Report Server
Use the CData ODBC Driver for Customer.io to visualize Customer.io in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Cursor with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure Analysis Services from within the editor.
-
Consume Reckon OData Feeds in PowerBuilder
This article demonstrates how to consume Reckon as OData feeds from PowerBuilder using the API Server.
-
How to import SharePoint Excel Services Data into Apache Solr
Use the CData Software JDBC Driver for SharePoint Excel Services in Data Import Handler and create an automated import of SharePoint Excel Services to Apache Solr Enterprise Search platform.
-
Load Zendesk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zendesk to a database.
-
Extract, Transform, and Load Airtable Data in Informatica PowerCenter
Create a simple Workflow for Airtable in Informatica PowerCenter.
-
Replicate Multiple Wistia Accounts
Replicate multiple Wistia accounts to one or many databases.
-
Integrate Real-Time Access to Vault CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Veeva Vault & Vault CRM in real time.
-
Import Pipedrive Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Pipedrive. In this article, you will use the OData format to import Pipedrive into Microsoft Power Query.
-
Feed Jumpseller Data into FineReport
How to set Jumpseller as a JDBC data source in FineReport.
-
Analyze Oracle Eloqua Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Eloqua in Microsoft R Open.
-
Easily Integrate Trello Data in Lazarus Pascal IDE
Learn how to easily integrate live Trello in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for EnterpriseDB
Provide connectivity to EnterpriseDB through an SAP BusinessObjects universe.
-
Build a Singer.io Tap for Greenplum With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Greenplum data using
-
Analyze Elorus Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Elorus in Microsoft R Open.
-
DataBind Charts to Exa Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Exa 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.
-
How to connect and process JobNimbus from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live JobNimbus.
-
Prepare, Blend, and Analyze MarkLogic Data in Alteryx Designer (Connect AI)
Build workflows to access live MarkLogic for self-service data analytics.
-
Connect to Retently Data in Ruby
Connect to Retently in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Microsoft OneDrive Data in TIBCO Spotfire through OData
Integrate Microsoft OneDrive into dashboards in TIBCO Spotfire.
-
Build an OLAP Cube in SSAS from ClickUp Data
Establish a connection to ClickUp data from SQL Server Analysis Services, and use the ClickUp Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Informatica Mappings From/To a JDBC Data Source for Datadog
Create Datadog data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Flowlu Data from MySQL in Amazon QuickSight
Connect to Flowlu and build visualizations of Flowlu using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Drip Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Drip replication to Google BigQuery.
-
Integrating Claude Code with SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Ariba Source within assisted coding and automated development workflows.
-
Integrate Real-Time Access to Salesforce CRM Analytics in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce CRM Analytics in real time.
-
OnePageCrm Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on OnePageCrm facts in real time.
-
Use the CData SSIS Components to Insert New or Update Existing ActiveCampaign Records from SQL Server
Easily push SQL Server data to ActiveCampaign using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into ActiveCampaign or update existing records with data from a SQL Server database.
-
Integrating Claude Code with Amazon Athena Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon Athena within assisted coding and automated development workflows.
-
Integrate with Live HubSpot Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to HubSpot from the MuleSoft Anypoint Platform to integrate live HubSpot into custom reports and dashboards.
-
Visualize Live Google Calendar Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Calendar using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with CloudConvert Data in AWS Glue Jobs Using JDBC
Connect to CloudConvert from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze ActiveCampaign Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ActiveCampaign in Microsoft R Open.