CData Software - Knowledge Base
Recent Articles
-
Integrate Open WebUI with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live IBM Cloud Object Storage from within the chat interface.
-
Design BIRT Reports on BigQuery Data
Provide current Google BigQuery to your embedded analytics.
-
Feed Asana Data into FineReport
How to set Asana as a JDBC data source in FineReport.
-
How to Connect to Live Kintone 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 Kintone for you.
-
Create Dynamic SAS xpt Grids Using the Infragistics XamDataGrid
Learn how you can connect SAS xpt to Infragistics XamDataGrid to build dynamic grids.
-
Build Visualizations of BenchmarkEmail Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of BenchmarkEmail in Birst.
-
Using the CData Software ODBC Driver for RSS in PyCharm
Connect to RSS as an ODBC data source in PyCharm using the CData Software ODBC Driver for RSS.
-
Manage Microsoft Teams Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Teams.
-
Integrating Antigravity CLI with GraphQL via CData CLI
Connect GraphQL to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Natively Connect to Float Data in PHP
The CData ODBC driver for Float enables you to create PHP applications with connectivity to Float. Leverage the native support for ODBC in PHP.
-
Integrate Asana Data in Pentaho Data Integration
Build ETL pipelines based on Asana in the Pentaho Data Integration tool.
-
Build Apps with Live YouTube Analytics in Adalo using CData Connect AI
Use CData Connect AI to integrate live YouTube Analytics into the Adalo platform and build custom mobile and web applications with real-time YouTube Analytics.
-
A PostgreSQL Interface for SAP Business Warehouse Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Business Warehouse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate SAP HANA XS Advanced Data from PowerShell
Write a quick PowerShell script to query SAP HANA XS Advanced. Use connectivity to the live data to replicate SAP HANA XS Advanced to SQL Server.
-
How to integrate Metabase with ActiveCampaign Data
Use CData Connect AI to connect to live ActiveCampaign and create an interactive dashboard in Metabase from ActiveCampaign.
-
Getting Started with the CData ADO.NET Provider for Opsgenie
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Back Up Procore 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 Procore data.
-
Excel Spreadsheet Automation on ZohoPeople Data with the QUERY Formula
Pull data from ZohoPeople, automate spreadsheets, and more with the QUERY formula.
-
How to integrate Keap with Apache Airflow
Access and process Keap in Apache Airflow using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Freshservice 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 Freshservice into a Java-based ORM framework, Hibernate.
-
Automated Continuous ShipStation Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ShipStation replication to delimited files (CSV/TSV).
-
Access Live EnterpriseDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live EnterpriseDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for VWO from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for VWO to connect to VWO from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring VWO in Excel.
-
Connect to Stack Exchange Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Stack Exchange as an External Source in Dremio.
-
Access Coda Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Coda from your Oracle system.
-
Connect to Clari Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Clari.
-
Automated Continuous SAP Netweaver Gateway Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Apache Kafka.
-
Connect to and Query Tally Data in QlikView over ODBC
Create data visualizations with Tally ERP in QlikView.
-
Connect to Microsoft OneDrive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft OneDrive and the SQL Gateway to access Microsoft OneDrive from Google Apps Script.
-
Import Zoom Data Using Azure Data Factory
Use CData Connect AI to connect to Zoom Data from Azure Data Factory and import live Zoom.
-
How to Query Live Todoist Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Todoist data in natural language using Python.
-
Create Active Directory Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Active Directory from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Oracle Service Cloud-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Service Cloud.
-
Analyze Nuclia Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Nuclia in Microsoft R Open.
-
Connect to Couchbase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Couchbase Data and connect to Couchbase in Akorbi Digital RunMyProcess.
-
Build MongoDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MongoDB Data from Zoho Analytics and import live MongoDB.
-
Viewing Close Data in RAD Studio Data Explorer
How to view Close in RAD Studio Data Explorer using the CData ODBC Driver for Close.
-
Integrate JSON Services into Power Automate Desktop using CData Connect
CData Connect for JSON Services enables you to integrate JSON into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Unbounce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Unbounce replication to Amazon S3.
-
Viewing CSV Data in RAD Studio Data Explorer
How to view CSV/TSV Files in RAD Studio Data Explorer using the CData ODBC Driver for CSV.
-
Automated Continuous Wrike Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Wrike replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Tableau Connector for SendPulse
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Back Up Grafana 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 Grafana data.
-
Extract, Transform, and Load Google Directory Data in Informatica PowerCenter
Create a simple Workflow for Google Directory in Informatica PowerCenter.
-
Connect Insightly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Insightly using the CData Python MCP Server.
-
Query, Visualize, and Share live Trello Data in Redash
Use CData Connect AI to connect to live Trello in Redash for querying, visualizing, and sharing.
-
Connect to Cloudant Data in CloverDX (formerly CloverETL)
Transfer IBM Cloudant using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Harvest Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Harvest replication to PostgreSQL.
-
Feed Facebook Data into FineReport
How to set Facebook as a JDBC data source in FineReport.
-
Automated Continuous xBase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable xBase replication to IBM DB2.
-
Build Dashboards with Excel Online Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Excel Online in Dundas BI.
-
Viewing Stack Exchange Data in RAD Studio Data Explorer
How to view Stack Exchange in RAD Studio Data Explorer using the CData ODBC Driver for Stack Exchange.
-
Access Live Copper Data in AWS Lambda
Connect to live Copper in AWS Lambda using the CData JDBC Driver.
-
Connect to Freshservice from a Connection Pool in WebLogic
Use the CData JDBC Driver for Freshservice to connect to Freshservice from Web applications running on WebLogic.
-
Integrate Live Outlook Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Outlook to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Import Office 365 Data Using Azure Data Factory
Use CData Connect AI to connect to Office 365 Data from Azure Data Factory and import live Microsoft Office 365.
-
Automated Continuous OnePageCrm Replication to SQL Server
Use CData Sync for automated, continuous, customizable OnePageCrm replication to SQL Server.
-
Build Data Flows from SAP Fieldglass to SQL Server using SSIS
Easily back up SAP Fieldglass to SQL Server using the SSIS components for SAP Fieldglass.
-
Connecting Agentforce with Amazon Athena Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Amazon Athena for you.
-
DataBind Controls to Microsoft Planner Data in Delphi
DataBind to Microsoft Planner in Delphi with standard data access components and controls.
-
How to Connect to Live Zoho Creator Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Creator securely in real time.
-
Analyze BenchmarkEmail Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BenchmarkEmail from Power Pivot. You will use the Table Import Wizard to load BenchmarkEmail. You can visually build the import query or use any SQL supported by the driver.
-
Build an OLAP Cube in SSAS from PivotalTracker Data
Establish a connection to PivotalTracker data from SQL Server Analysis Services, and use the PivotalTracker Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Teamwork Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Teamwork replication to delimited files (CSV/TSV).
-
Build MVC Applications with Connectivity to Notion Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Notion from an ASP.NET MVC application.
-
How to Visualize MYOB AccountRight 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 MYOB AccountRight in Python.
-
Connect to Amazon DynamoDB Data in RazorSQL
Connect to Amazon DynamoDB from wizards and query Amazon DynamoDB from the GUI in the RazorSQL database management tool.
-
Connect and Query Live Phoenix Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache Phoenix into Databricks
-
Edit and Search External SAP Concur Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Concur to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Concur Data objects that you can access from apps and the dashboard.
-
Import Epicor Kinetic Data Using Azure Data Factory
Use CData Connect AI to connect to Epicor Kinetic Data from Azure Data Factory and import live Epicor Kinetic.
-
How to create an RPA flow for Exa Data in UiPath Studio
Use the Exa ODBC Driver to create workflows that access real-time Exa without any coding.
-
Publish Sentry-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sentry.
-
How to publish and share Google Tasks Data dashboards with Tableau Server
The CData ODBC driver for Google Tasks enables you integrate Google Tasks into Tableau dashboards.
-
Import Redis Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Redis Data and provide access to live Redis for custom reports in the Power BI Service.
-
Query Vercel Data in DataGrip
Create a Data Source for Vercel in DataGrip and use SQL to query live Vercel.
-
How to Connect to & Open Marketo Data in Microsoft Excel
This article uses the CData ODBC driver for Marketo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
DataBind Controls to Drip Data in Delphi
DataBind to Drip in Delphi with standard data access components and controls.
-
Bridge Perigon Connectivity with Apache NiFi
Access and process Perigon in Apache NiFi using the CData JDBC Driver.
-
Provide OData Services of Zoho Recruit Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Recruit by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Reply.io in MicroStrategy
Connect to Reply.io in MicroStrategy Developer using the CData Software ODBC Driver for Reply.io.
-
Extend Google Sheets with ServiceNow Data
Make calls to ServiceNow from Google Apps Script via the API Server.
-
Integrate Cursor with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Active Directory from within the editor.
-
Automated Continuous MYOB AccountRight Replication to SQL Server
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SQL Server.
-
Publish Crystal Reports on ZohoExpense Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoExpense.
-
LINQ to Microsoft Ads 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 Microsoft Ads Data Provider.
-
Analyze Webflow Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Webflow with the CData JDBC Driver for Webflow.
-
Build Dashboards with SAP Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP ERP/NetWeaver in DBxtra.
-
Build Google Cloud Storage-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Google Cloud Storage to explore live Google Cloud Storage Data in Cursor to assist with building Google Cloud Storage-powered applications.
-
Automated Continuous LightSpeedRetail Replication to MongoDB
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to MongoDB.
-
Integrate with Live Microsoft Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Ads from the MuleSoft Anypoint Platform to integrate live Microsoft Ads into custom reports and dashboards.
-
Create Informatica Mappings From/To a JDBC Data Source for Tavily
Create Tavily data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Live Facebook Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Facebook Ads using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Oracle Eloqua Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Eloqua with the CData JDBC Driver for Oracle Eloqua.
-
Add TigerGraph Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for TigerGraph with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy Desktop
Connect to Paylocity in MicroStrategy Desktop using the CData Software ODBC Driver for Paylocity.
-
Access Live MongoDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MongoDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Basecamp Data in Google Apps Script via Connect AI
Use CData Connect AI to access Basecamp in Google Apps Script.
-
Operational Reporting on Sybase IQ Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sybase IQ.
-
Analyze Redis Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Redis with the CData JDBC Driver for Redis.
-
Connecting GenSpark with Redis Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Redis without any replication or custom integration required.