CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with SendInBlue 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 SendInBlue into a Java-based ORM framework, Hibernate.
-
Build Apps with Live Stripe in Adalo using CData Connect AI
Use CData Connect AI to integrate live Stripe into the Adalo platform and build custom mobile and web applications with real-time Stripe.
-
Automated Continuous Microsoft Planner Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Amazon Redshift.
-
Use Databricks Agent Bricks to Talk to Your Zoho Inventory Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zoho Inventory for you.
-
Feed Guru Data into FineReport
How to set Guru as a JDBC data source in FineReport.
-
Import Zendesk Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zendesk Data and provide access to live Zendesk for custom reports in the Power BI Service.
-
Connect to Webflow Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Webflow to connect to Webflow and execute queries in PowerBuilder.
-
Analyze QuickBooks Time Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of QuickBooks Time and visualize live QuickBooks Time in Infragistics Reveal.
-
Use the CData Software JDBC Driver for Missive in MicroStrategy Desktop
Connect to Missive in MicroStrategy Desktop using the CData Software JDBC Driver for Missive.
-
Build Oracle SCM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle SCM Data and create custom apps in Bubble.
-
Integrating Claude Code CLI with Salesforce Data 360 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.
-
Access Live Spotify Data in Coginiti Pro
Connect to and query live Spotify from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Exa-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Exa and build web apps with connectivity to live Exa.
-
Integrating Boomi Agentstudio with Facebook Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Facebook Ads, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Flowlu Data to Multiple Databases via the CData Sync CLI
Replicate Flowlu to disparate databases with a single configuration.
-
Automated Continuous Gorgias Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Gorgias replication to Amazon S3.
-
Connect to Factorial from a Connection Pool in WebLogic
Use the CData JDBC Driver for Factorial to connect to Factorial from Web applications running on WebLogic.
-
Replicate Adobe Analytics Data to Multiple Databases via the CData Sync CLI
Replicate Adobe Analytics to disparate databases with a single configuration.
-
Build a Singer.io Tap for MongoDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MongoDB data using
-
Extend Google Sheets with SQL Server Data
Make calls to SQL Server from Google Apps Script via the API Server.
-
Create Datasets from Float in Domo Workbench and Build Visualizations of Float Data in Domo
Use the CData Software ODBC Driver for Float to create datasets from Float in Domo Workbench and then build visualizations in the Domo service.
-
DataBind Avro Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Avro with the DevExpress Windows Forms and Web controls to provide Apache Avro to a chart.
-
Extend Google Sheets with SAP Fieldglass Data
Make calls to SAP Fieldglass from Google Apps Script via the API Server.
-
Connect to SendInBlue Data in DBArtisan
Use wizards in DBArtisan to configure SendInBlue as a data source.
-
How to Address ‘Token has been expired or revoked.’ Errors When Using OAuth 2.0 grant_type=refresh_token with Google Cloud Platform
How to troubleshoot and resolve “Token has been expired or revoked” errors when using OAuth 2.0 grant_type=refresh_token in GCP, with recommended best practices.
-
Access Live HCL Domino Data in Coginiti Pro
Connect to and query live HCL Domino from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Multiple PayPal Accounts
Replicate multiple PayPal accounts to one or many databases.
-
Load Trello Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Trello to a database.
-
Automate Azure DevOps Data Replication to Azure Data Lake
Use CData Sync to customize and automate Azure DevOps replication to Azure Data Lake.
-
Build SAP BusinessObjects BI-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP BusinessObjects BI to explore live SAP BusinessObjects BI Data in Claude Code to assist with building SAP BusinessObjects BI-powered applications.
-
Connect to Box Data from PowerBuilder via JDBC
This article demonstrates how to access Box from PowerBuilder using the Box JDBC Driver.
-
Build Apps with Live Zoho Inventory in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoho Inventory into the Adalo platform and build custom mobile and web applications with real-time Zoho Inventory.
-
How to use SQLAlchemy ORM to access SAP HANA XS Advanced Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP HANA XS Advanced.
-
Access Live Typeform Data in Coginiti Pro
Connect to and query live Typeform from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Xero Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Xero data access from reports, embedded analytics, and more.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft OneDrive Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft OneDrive.
-
Visualize HDFS Data in TIBCO Spotfire through ADO.NET
Integrate Apache HDFS into dashboards in TIBCO Spotfire.
-
Connect to Microsoft Planner Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Planner.
-
How to Access Live MySQL Data in Visual Studio Code via Cline
Run CData MCP Server for MySQL on Windows Subsytem for Linux (WSL) and connect to live MySQL from the Cline extension in Visual Studio Code.
-
Query Anaplan Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Anaplan entities in PHP by modeling them as objects.
-
Connect to SingleStore Data in ACL Analytics
Connect to SingleStore via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SingleStore.
-
Connect to Live Office 365 Data in MicroStrategy through CData Connect AI
Create a live connection to Office 365 Data in CData Connect AI and connect to your Microsoft Office 365 from MicroStrategy.
-
Use Dash to Build to Web Apps on Azure Synapse Data
Create Python applications that use pandas and Dash to build Azure Synapse-connected web apps.
-
Publish LeadDesk-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LeadDesk.
-
Using the CData Software ODBC Driver for Procore in PyCharm
Connect to Procore as an ODBC data source in PyCharm using the CData Software ODBC Driver for Procore.
-
Easily Integrate Hubstaff Data in Lazarus Pascal IDE
Learn how to easily integrate live Hubstaff in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Kintone Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Kintone in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Migrating data from Rebilly to Google BigQuery using CData SSIS Components.
Easily push Rebilly to Google BigQuery using the CData SSIS Tasks for Rebilly and Google BigQuery.
-
Create Oracle Service Cloud-Connected Applications in Appsmith
Connect to Oracle Service Cloud Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Service Cloud.
-
Build SAP SuccessFactors LMS-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP SuccessFactors LMS to explore live SAP SuccessFactors LMS Data in Claude Code to assist with building SAP SuccessFactors LMS-powered applications.
-
Integrating Kiro CLI with Dropbox 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.
-
Use Databricks Agent Bricks to Talk to Your Zoho Books Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zoho Books for you.
-
Connect Copper to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Copper with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Vault CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Vault CRM replication to MySQL.
-
Use Azure AI Foundry to Talk to Your Google Ad Manager 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 Google Ad Manager for you.
-
How to Connect the Power BI Service to Snowflake: Complete Guide
Connect to the CData Software Power BI Connector for Snowflake from PowerBI.com to provide real-time Snowflake across the organization.
-
Build Apps with Live Stripe Data Using the Low-Code Development Platform of Mendix
Connect Stripe with Mendix to build apps using the CData JDBC Driver for Stripe.
-
Operational Reporting on Amplitude Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amplitude.
-
Connect to Databricks Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Databricks Data and connect to Databricks in Akorbi Digital RunMyProcess.
-
How to integrate SAP HANA with Apache Airflow
Access and process SAP HANA in Apache Airflow using the CData JDBC Driver.
-
Use JayDeBeApi to access Databricks Data in Python
Use standard Python scripting and the development environment of your choice to access live Databricks.
-
Automated Continuous IBM Informix Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable IBM Informix replication to Apache Cassandra.
-
Consume SAP Business Warehouse OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Business Warehouse as OData feeds from PowerBuilder using the API Server.
-
Connect to Optimizely Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Optimizely.
-
A Comparison of JDBC & ODBC Drivers for Amazon Athena
A performance comparison of the CData JDBC Driver and ODBC Driver for Amazon Athena and the Amazon-supported Athena JDBC Driver and ODBC Driver.
-
Connect Pipeliner CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pipeliner CRM using the CData Python MCP Server.
-
Replicate Microsoft OneLake Data to Multiple Databases
Replicate Microsoft OneLake to disparate databases with a point-and-click configuration.
-
Automate Zuora Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zuora replication to Azure Data Lake.
-
Connecting Mastra with Zuora 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 Zuora, no replication required.
-
How to Connect to Live Airtable 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 Airtable for you.
-
Use the CData SSIS Components to Insert New or Update Existing Sybase IQ Records from SQL Server
Easily push SQL Server data to Sybase IQ using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sybase IQ or update existing records with data from a SQL Server database.
-
Getting Started with the CData Power BI Connector for Todoist
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live Confluence Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Atlassian Confluence from your Google Sheets.
-
Replicate Chargebee Data in Heroku for Use in Salesforce Connect
Replicate Chargebee to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Cursor with Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache CouchDB from within the editor.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Parallel
Provide connectivity to Parallel through an SAP BusinessObjects universe.
-
Migrating data from Nuclia to Databricks using CData SSIS Components.
Easily push Nuclia to Databricks using the CData SSIS Tasks for Nuclia and Databricks.
-
Build Google Spanner Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Spanner and build visualizations in Tableau Cloud.
-
Integrate LightSpeedRetail with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LightSpeedRetail with External Services.
-
Connect to Raisers Edge NXT Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT and execute queries in PowerBuilder.
-
Oracle HCM Cloud Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle HCM Cloud facts in real time.
-
How to work with Workable Data in Apache Spark using SQL
Access and process Workable Data in Apache Spark using the CData Software JDBC Driver.
-
Bind Live Quickbase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Quickbase data
-
Connecting Moonlit Workflow with Marketo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Marketo in real time.
-
Query, Visualize, and Share live GitHub Data in Redash
Use CData Connect AI to connect to live GitHub in Redash for querying, visualizing, and sharing.
-
Connect to NetSuite Data in Aqua Data Studio
Access NetSuite CRM & ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData SSIS Components for Autopilot
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Autopilot.
-
How to Connect the Power BI Service to Spark: Complete Guide
Connect to the CData Software Power BI Connector for Spark from PowerBI.com to provide real-time Apache Spark SQL across the organization.
-
Extract, Transform, and Load Azure Analysis Services Data in Informatica PowerCenter
Create a simple Workflow for Azure Analysis Services in Informatica PowerCenter.
-
Extract, Transform, and Load Mistral AI Data in Informatica PowerCenter
Create a simple Workflow for Mistral AI in Informatica PowerCenter.
-
Analyze SAP Netweaver Gateway Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Netweaver Gateway from Power Pivot. You will use the Table Import Wizard to load SAP Netweaver Gateway. You can visually build the import query or use any SQL supported by the driver.
-
Import Real-Time SparkPost Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SparkPost in ColdFusion.
-
Use the CData ODBC Driver for ZohoSubscriptions in Microsoft Power Query
You can use the CData ZohoSubscriptions ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZohoSubscriptions into Microsoft Power Query.
-
How to Access Adobe Experience Manager Data Using Entity Framework
This article shows how to access Adobe Experience Manager using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Rapidly Develop Dynamics 365-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 Dynamics 365.
-
How to Import Data from Dynamics 365 Business Central into Google Sheets
Import Dynamics 365 Business Central into a Google spreadsheet that is automatically refreshed.
-
Build AI/ML Models with Live Placid Data using Dataiku
Connect Placid Data with Dataiku using the CData API Driver for JDBC.
-
Analyze Aha! Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Aha! with the CData JDBC Driver for Aha!.
-
Publish Crystal Reports on Testmonitor Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Testmonitor.
-
Integrating LlamaIndex with WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on WordPress in real time.