CData Software - Knowledge Base
Recent Articles
-
Automated Continuous DocuSign Replication to Amazon S3
Use CData Sync for automated, continuous, customizable DocuSign replication to Amazon S3.
-
Getting Started with the CData SSIS Components for Apify
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Apify.
-
Create Reports with SAP BusinessObjects BI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP BusinessObjects BI data.
-
Integrate Goose with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Sheets data from within the local AI agent.
-
Object-Relational Mapping (ORM) with Demio 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 Demio data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Discord Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Discord replication to PostgreSQL.
-
Connect to Tavily Data in Jaspersoft Studio
Execute SQL to remote Tavily data in Jaspersoft Studio.
-
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 data.
-
Connect to Moosend in SpagoBI
Create reports featuring live Moosend data in SpagoBI Studio. Host Moosend reports on SpagoBI Server.
-
Connect to WordPress Data in Aqua Data Studio
Access WordPress data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Freshteam Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Freshteam data.
-
How to Connect DBeaver to Greenplum via a JDBC Driver
Manage Greenplum data with visual tools in DBeaver like the query browser.
-
Automated Harvest Data Replication to Teradata
Use CData Sync to Customize and automate Harvest data replication to Teradata.
-
Connect to SingleStore Data in ACL Analytics
Connect to SingleStore data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SingleStore data.
-
Access Live iContact Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live iContact data from your Excel spreadsheets.
-
Build Dashboards with Sugar CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Sugar CRM data in DBxtra.
-
Getting Started with the CData Connect AI Python SDK for Sage Cloud Accounting
Install the CData Connect AI Python SDK to read and write live Sage Cloud Accounting data with standard DB-API 2.0 Python code.
-
Consume AlloyDB OData Feeds in PowerBuilder
This article demonstrates how to consume AlloyDB data as OData feeds from PowerBuilder using the API Server.
-
Create eBay Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time eBay Analytics data access from reports, embedded analytics, and more.
-
Seamlessly Bring SendGrid Data into Retool Using CData Connect AI
Integrate SendGrid data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Work with Onfleet Data in FoxPro
Load Onfleet data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Rapidly Develop Postmark-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 Postmark.
-
Prepare, Blend, and Analyze ADP Data in Alteryx Designer (Connect AI)
Build workflows to access live ADP data for self-service data analytics.
-
Migrating data from Rebilly to Google BigQuery using CData SSIS Components.
Easily push Rebilly data to Google BigQuery using the CData SSIS Tasks for Rebilly and Google BigQuery.
-
Automated Continuous Pipedrive Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pipedrive data replication to OneLake in Microsoft Fabric.
-
Connect to Zoho Projects Data in HULFT Integrate
Connect to Zoho Projects as a JDBC data source in HULFT Integrate
-
Office 365 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Office 365 data through CData Connect AI using different applications and tools.
-
Access Invoiced Data from MySQL in Amazon QuickSight
Connect to Invoiced and build visualizations of Invoiced data using a MySQL Connection in Amazon QuickSight.
-
Integrating Kiro 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.
-
Access Live Close Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Close data into the statistical analysis tools available in SAS JMP. This article shows how to use Close data in the Graph Builder and Query Builder.
-
Automated Continuous Access Replication to Snowflake
Use CData Sync for automated, continuous, customizable Access replication to Snowflake.
-
Provide OData Services of Clio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Clio data by developing a WCF Service Application.
-
Analyze Live Zoho Creator Data in SAS Viya
Use CData Connect AI to connect to Zoho Creator data from SAS Viya and deploy self-service analytics using live Zoho Creator data.
-
Automated Continuous Shippo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Shippo replication to MongoDB.
-
Getting Started with the CData Excel Add-In for Sybase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sybase.
-
How to connect and process LeadDesk data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live LeadDesk data.
-
Build Apps with Live Stripe Data Using the Low-Code Development Platform of Mendix
Connect Stripe data with Mendix to build apps using the CData JDBC Driver for Stripe.
-
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 data in Akorbi Digital RunMyProcess.
-
Model TaxJar Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and TaxJar, enabling the direct import of real-time TaxJar data.
-
Visualize ZeroBounce Data in Tableau
The CData ODBC driver for ZeroBounce enables you integrate ZeroBounce data into Tableau dashboards.
-
Use the CData Software ODBC Driver for SuiteCRM in SAS for Real-Time Reporting and Analytics
Connect to real-time SuiteCRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SuiteCRM.
-
Use JayDeBeApi to access Databricks Data in Python
Use standard Python scripting and the development environment of your choice to access live Databricks data.
-
Integrate ZohoMarketingHub Data in the Pentaho Report Designer
Publish reports based on ZohoMarketingHub data in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for Aircall in SAS for Real-Time Reporting and Analytics
Connect to real-time Aircall data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Aircall.
-
Use the CData Software ODBC Driver for Clockify in MicroStrategy
Connect to Clockify data in MicroStrategy Developer using the CData Software ODBC Driver for Clockify.
-
How to connect to Microsoft Dataverse Data from Spring Boot
Connect to Microsoft Dataverse in a Spring Boot Application using the CData JDBC Driver for Microsoft Dataverse
-
Integrate LibreChat with Live Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Figshare data from within the chat interface.
-
Access Live Sage 300 Data in Excel 365 Online (Excel for the web)
Connect to Sage 300 data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Live Azure Synapse Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Synapse from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Synapse data.
-
How to connect to Clockify Data from Spring Boot
Connect to Clockify in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live Microsoft Dataverse Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Dataverse data from your Excel spreadsheets.
-
Connect to Salesforce CRM Analytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce CRM Analytics Data and connect to Salesforce CRM Analytics data in Akorbi Digital RunMyProcess.
-
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 data for you.
-
How to Access Live Phoenix Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Phoenix enables you to integrate Phoenix data into workflows built using Microsoft Power Automate Desktop.
-
Connect to OpenWeatherMap from a Connection Pool in WebLogic
Use the CData JDBC Driver for OpenWeatherMap to connect to OpenWeatherMap data from Web applications running on WebLogic.
-
Establish a Live Connection with Productboard Data using Tableau Bridge
The CData ODBC Driver for Productboard enables you to integrate live Productboard data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connecting Mastra with Vertica 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 Vertica data, no replication required.
-
Create Microsoft Teams-Connected Applications in Appsmith
Connect to Microsoft Teams Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Teams data.
-
Use the CData Software JDBC Driver for Vault CRM in MicroStrategy Desktop
Connect to Vault CRM data in MicroStrategy Desktop using the CData Software JDBC Driver for Vault CRM.
-
Automated Continuous SharePoint Replication to Databricks
Use CData Sync for automated, continuous, customizable SharePoint replication to Databricks.
-
Connect to Basecamp Data in RapidMiner
Integrate Basecamp data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Vault CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Vault CRM data in Google Apps Script.
-
Use the CData Software JDBC Driver for Sentry in MicroStrategy Web
Connect to Sentry data in MicroStrategy Web using the CData Software JDBC Driver for Sentry.
-
Query Phoenix Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Phoenix data from Node.js.
-
Access Live Confluence Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Confluence data from your Google Sheets.
-
Integrate OpenCode with Live GraphQL Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live GraphQL data from within your AI coding agent.
-
Integrate Google's Vertex AI Agent with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Dynamics CRM data within intelligent workflows.
-
Getting Started with the CData Connect AI Python SDK for BenchmarkEmail
Install the CData Connect AI Python SDK to read live BenchmarkEmail data with standard DB-API 2.0 Python code.
-
Create Informatica Mappings From/To an ODBC Data Source for ConvertKit
Create an ODBC connection to ConvertKit in Informatica and browse and transfer ConvertKit data.
-
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 CouchDB data from within the editor.
-
Query Live Oracle SCM Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Oracle SCM data through a conversational interface.
-
Query Cosmos DB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Cosmos DB data from Node.js.
-
Query SharePoint Excel Services Data as a MySQL Database in Node.js
Execute MySQL queries against SharePoint Excel Services data from Node.js.
-
Enable the ShipEngine JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ShipEngine data.
-
Build SAP ByDesign-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP ByDesign data and build SAP ByDesign-connected web apps with Axios.
-
Automate Snapchat Ads Data Replication to Azure Synapse
Use CData Sync to customize and automate Snapchat Ads data replication to Azure Synapse.
-
Extract, Transform, and Load Azure Analysis Services Data in Informatica PowerCenter
Create a simple Workflow for Azure Analysis Services data in Informatica PowerCenter.
-
Build Apps with Live Exact Online data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Exact Online data into the Adalo platform and build custom mobile and web applications with real-time Exact Online data.
-
Use Dash to Build to Web Apps on Zuora Data
Create Python applications that use pandas and Dash to build Zuora-connected web apps.
-
Build Dashboards with MailerLite Data in Dundas BI
Create dynamic dashboards and perform analytics based on MailerLite data in Dundas BI.
-
How to Access Adobe Experience Manager Data Using Entity Framework
This article shows how to access Adobe Experience Manager data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Deploy the ADO.NET Provider for Toggl on an SSRS Report Server
Connect to Toggl data 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.
-
Connecting Pipedream with HBase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on HBase data in real time.
-
Integrate Adobe Experience Manager Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Experience Manager data in the Pentaho Data Integration tool.
-
DataBind Charts to Stack Exchange Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Stack Exchange data 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.
-
Query BigQuery Data as a MySQL Database in Node.js
Execute MySQL queries against BigQuery data from Node.js.
-
Analyze Aha! Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Aha! data with the CData JDBC Driver for Aha!.
-
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 data in real time.
-
Create SAP Business One Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Business One data access from reports, embedded analytics, and more.
-
Connect to CockroachDB Data in CloverDX (formerly CloverETL)
Transfer CockroachDB data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous REST Replication to SQLite
Use CData Sync for automated, continuous, customizable REST replication to SQLite.
-
Creating Microsoft Ads-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Ads data to Unqork and build custom business apps.
-
Automated Continuous Moosend Replication to Oracle
Use CData Sync for automated, continuous, customizable Moosend replication to Oracle.
-
Operational Reporting on Invoiced Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Invoiced data.
-
Publish Crystal Reports on Snowflake Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Snowflake data.
-
Integrate Zoho Projects Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoho Projects data and integrate live Zoho Projects data into your Power Automate tasks.
-
Query Salesforce CRM Analytics Data in DataGrip
Create a Data Source for Salesforce CRM Analytics in DataGrip and use SQL to query live Salesforce CRM Analytics data.
-
Create Data Visualizations in Cognos BI with HDFS Data
Access HDFS data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to BambooHR Data from PowerBuilder via JDBC
This article demonstrates how to access BambooHR data from PowerBuilder using the BambooHR JDBC Driver.
-
Automated Continuous Adobe Analytics Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to delimited files (CSV/TSV).