CData Software - Knowledge Base
Recent Articles
-
Publish Crystal Reports on Teradata Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teradata.
-
Query Microsoft Teams Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Teams entities in PHP by modeling them as objects.
-
Query, Visualize, and Share live Google Spanner Data in Redash
Use CData Connect AI to connect to live Google Spanner in Redash for querying, visualizing, and sharing.
-
Bridge PostgreSQL Connectivity with Apache NiFi
Access and process PostgreSQL in Apache NiFi using the CData JDBC Driver.
-
Access LinkedIn Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LinkedIn from HeidiSQL.
-
Integrate Lakebase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Lakebase and integrate live Lakebase into your Power Automate tasks.
-
Integrate Jira Assets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jira Assets with External Services.
-
How to connect SharePoint with Marketo Data through external lists
Provide Marketo to SharePoint users as an external list.
-
Access Live ZohoPeople Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live ZohoPeople data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Informatica Mappings From/To a JDBC Data Source for Qualaroo
Create Qualaroo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SAP Ariba Procurement in SpagoBI
Create reports featuring live SAP Ariba Procurement in SpagoBI Studio. Host SAP Ariba Procurement reports on SpagoBI Server.
-
How to create an RPA flow for SAP Ariba Source Data in UiPath Studio
Use the SAP Ariba Source ODBC Driver to create workflows that access real-time SAP Ariba Source without any coding.
-
Access Live Egnyte Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Egnyte in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live Impala 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 Apache Impala for you.
-
Import Authorize.Net Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Authorize.Net. In this article, you will use the OData format to import Authorize.Net into Microsoft Power Query.
-
Automated Continuous SAP Hybris C4C Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Apache Kafka.
-
How to Work with ZohoSubscriptions Data in AWS Glue Jobs Using JDBC
Connect to ZohoSubscriptions from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze GitLab Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of GitLab and visualize live GitLab in Infragistics Reveal.
-
Connect to Opsgenie Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Opsgenie to connect to Opsgenie and execute queries in PowerBuilder.
-
Use Dash to Build to Web Apps on Hacker News Data
Create Python applications that use pandas and Dash to build Hacker News-connected web apps.
-
Automated Continuous Oracle Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle replication to MongoDB.
-
Replicate Keap Data in Heroku for Use in Salesforce Connect
Replicate Keap to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Provide OData Services of Wistia Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Wistia by developing a WCF Service Application.
-
Integrating Codex CLI with SAP Ariba Source 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.
-
Integrating GitHub Copilot CLI with SharePoint Excel Services 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 HDFS Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache HDFS in Filemaker Pro for Mac or Windows.
-
Connect Landbot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Landbot with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Basecamp 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 Basecamp for you.
-
Add Landbot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Landbot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Moving Data from Scrapfly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Scrapfly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Authorize.Net Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Authorize.Net replication to OneLake in Microsoft Fabric.
-
Automate ZohoSubscriptions Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoSubscriptions replication to SAP HANA.
-
Connect to Oracle Financials Cloud Data from a Connection Pool in Jetty
The Oracle Financials Cloud JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Financials Cloud from Web apps in Jetty.
-
Integrating Tavily Data in Talend Cloud Data Management Platform
Connect Tavily Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Design BIRT Reports on YouTube Analytics Data
Provide current YouTube Analytics to your embedded analytics.
-
How to Import Data from Confluence into Google Sheets
Import Atlassian Confluence into a Google spreadsheet that is automatically refreshed.
-
Salesloft Reporting in OBIEE with the Salesloft JDBC Driver
Deploy the Salesloft JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData Power BI Connector for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for PostgreSQL.
-
Connecting Mastra with Dynamics 365 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 Microsoft Dynamics 365, no replication required.
-
Build Workday-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Workday and build web apps with connectivity to live Workday.
-
How to create an RPA flow for Reckon Accounts Hosted Data in UiPath Studio
Use the Reckon Accounts Hosted ODBC Driver to create workflows that access real-time Reckon Accounts Hosted without any coding.
-
Analyze Pinecone Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pinecone in Microsoft R Open.
-
Build Customer.io-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Customer.io Data in Cursor to assist with building Customer.io-powered applications.
-
Query Nethunt Data in ColdFusion
Write standard ColdFusion data access code to connect to Nethunt.
-
Access Live Datadog Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Datadog in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Claude Code CLI with Perplexity 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.
-
Build Oracle Eloqua Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle Eloqua and build visualizations in Tableau Cloud.
-
Enable the iContact JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with iContact.
-
How to create an RPA flow for Chargebee Data in UiPath Studio
Use the Chargebee ODBC Driver to create workflows that access real-time Chargebee without any coding.
-
Integrate LightSpeedRetail Data in Pentaho Data Integration
Build ETL pipelines based on LightSpeedRetail in the Pentaho Data Integration tool.
-
Create Data Visualizations Based On Greenplum Data in Mode
Use CData Connect AI to connect to Greenplum Data from Mode and build visualizations using live
-
Connect to NetSuite SuiteAnalytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access NetSuite SuiteAnalytics in Google Apps Script.
-
Connect to Pipedrive Data in Aqua Data Studio
Access Pipedrive from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to integrate Metabase with Raisers Edge NXT Data
Use CData Connect AI to connect to live Raisers Edge NXT and create an interactive dashboard in Metabase from Raisers Edge NXT.
-
Connect to Browserless Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Browserless to connect to Browserless and execute queries in PowerBuilder.
-
Import WooCommerce Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access WooCommerce. In this article, you will use the OData format to import WooCommerce into Microsoft Power Query.
-
Getting Started with the CData ADO.NET Provider for Gong
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Google Drive Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Drive from HeidiSQL.
-
Automated Continuous Presto Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Presto replication to OneLake in Microsoft Fabric.
-
Visualize LDAP Objects in Tableau
The CData ODBC driver for LDAP enables you integrate LDAP into Tableau dashboards.
-
Connecting GenSpark with SAS Data Sets 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 Data Sets without any replication or custom integration required.
-
Cloudflare Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cloudflare facts in real time.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy
Connect to Zoho Projects in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Projects.
-
Connect to Adobe Target Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Target using standard SQL.
-
Visualize Presto Data in TIBCO Spotfire through OData
Integrate Presto into dashboards in TIBCO Spotfire.
-
Create Data Visualizations Based On Act-On Data in Mode
Use CData Connect AI to connect to Act-On Data from Mode and build visualizations using live
-
Create Shopify-Connected Nintex Workflows
Use CData Connect AI to connect to Shopify Data from Nintex Workflow Cloud and build custom workflows using live Shopify.
-
Connect to Zoho Inventory Data in JRuby
Create a simple JRuby app with access to live Zoho Inventory.
-
Use the CData ODBC Driver for Marketo in Microsoft Power Query
You can use the CData Marketo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Marketo into Microsoft Power Query.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Stripe to Power BI dashboards. Simply drag and drop Stripe into data visuals on the Power BI canvas.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce
Create an ODBC connection to Salesforce in Informatica and browse and transfer Salesforce & Force.com.
-
Automated Continuous Google Campaign Manager 360 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Amazon S3.
-
Use the CData ODBC Driver for OnePageCrm in Microsoft Power Query
You can use the CData OnePageCrm ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import OnePageCrm into Microsoft Power Query.
-
Connect to ZohoPeople Data in HULFT Integrate
Connect to ZohoPeople as a JDBC data source in HULFT Integrate
-
How to publish and share SAP Business Warehouse Data dashboards with Tableau Server
The CData ODBC driver for SAP Business Warehouse enables you integrate SAP Business Warehouse into Tableau dashboards.
-
Build an OLAP Cube in SSAS from SAP Data
Establish a connection to SAP ERP/NetWeaver data from SQL Server Analysis Services, and use the SAP Data Provider to build OLAP cubes for use in analytics and reporting.
-
Validate Greenplum Data with QuerySurge
Access and validate Pivotal GreenPlum in QuerySurge using the CData JDBC Driver.
-
Analyze IBM Informix Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of IBM Informix and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Connect to Drip Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Drip. Leverage the pyodbc module for ODBC in Python.
-
How to Access Live Recurly Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Recurly from the Cline extension in Visual Studio Code.
-
Connect to Teradata Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Teradata as an External Source in Dremio.
-
Connect to Live Microsoft OneDrive Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft OneDrive in CData Connect AI and connect to your Microsoft OneDrive from PostgreSQL.
-
How to Access Live SharePoint Excel Services Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SharePoint Excel Services enables you to integrate SharePoint Excel Services into workflows built using Microsoft Power Automate Desktop.
-
Integrating Codex CLI with Delighted 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 Neo4J Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Neo4J with the DevExpress Windows Forms and Web controls to provide Neo4J to a chart.
-
Create Apps from SAP Ariba Procurement Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Ariba Procurement Data and build apps from live SAP Ariba Procurement in Qlik Sense Cloud.
-
Integrating Claude Code CLI with Grafana 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 integrate Metabase with Couchbase Data
Use CData Connect AI to connect to live Couchbase and create an interactive dashboard in Metabase from Couchbase.
-
Automated Continuous Instagram Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Instagram replication to AlloyDB.
-
Establish a Live Connection with Pipeliner CRM Data using Tableau Bridge
The CData ODBC Driver for Pipeliner CRM enables you to integrate live Pipeliner CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Perplexity Data in JReport Designer
Create charts and reports based on Perplexity in JReport Designer.
-
Connect to Cloudant 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 IBM Cloudant.
-
Working with SingleStore Data in LINQPad
Execute LINQ queries to SingleStore in LINQPad.
-
Build a PostgreSQL Interface for SAP Concur Data using the CData JDBC Driver
Use the Remoting features of the SAP Concur JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import QuickBooks Time Data into Apache Solr
Use the CData Software JDBC Driver for QuickBooks Time in Data Import Handler and create an automated import of QuickBooks Time to Apache Solr Enterprise Search platform.
-
Integrating OpenCode Terminal with Quaderno 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 Work with Instantly Data in AWS Glue Jobs Using JDBC
Connect to Instantly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use JayDeBeApi to access Reckon Data in Python
Use standard Python scripting and the development environment of your choice to access live Reckon.
-
Query Spark Data in DataGrip
Create a Data Source for Spark in DataGrip and use SQL to query live Apache Spark SQL.
-
A PostgreSQL Interface for Sage Cloud Accounting Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sage Cloud Accounting JDBC Driver to create a PostgreSQL entry-point for data access.