CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Todoist
Provide connectivity to Todoist data through an SAP BusinessObjects universe.
-
Integrate OpenCode with Live Sage 200 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sage 200 data from within your AI coding agent.
-
Connect to OneNote from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from OneNote data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData ADO.NET Provider for SQL Analysis Services
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SQL Analysis Services.
-
Automated Continuous Azure Synapse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Google Cloud SQL.
-
How to Connect DBeaver to Landbot via a JDBC Driver
Manage Landbot data with visual tools in DBeaver like the query browser.
-
Consume Cloudant OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Cloudant feeds that reflect any changes in SAP Lumira.
-
Migrating data from ZendeskSell to Databricks using CData SSIS Components.
Easily push ZendeskSell data to Databricks using the CData SSIS Tasks for ZendeskSell and Databricks.
-
How to Connect DBeaver to Codat via a JDBC Driver
Manage Codat data with visual tools in DBeaver like the query browser.
-
Integrating Guru Data in Talend Cloud Data Management Platform
Connect Guru Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Reckon Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Reckon Data and connect to Reckon data in Akorbi Digital RunMyProcess.
-
Import Real-Time GitHub Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use GitHub data in ColdFusion.
-
Integrate Teradata Data in Pentaho Data Integration
Build ETL pipelines based on Teradata data in the Pentaho Data Integration tool.
-
Access Live MailerSend Data in AWS Lambda
Connect to live MailerSend data in AWS Lambda using the CData JDBC Driver.
-
Create Power BI Reports on Real-Time SAP ByDesign Data
Use the CData ODBC Driver for SAP ByDesign to visualize SAP ByDesign data in Power BI Desktop.
-
Build FHIR Visualizations in Tableau Cloud
Use CData Connect AI to connect to live FHIR data and build visualizations in Tableau Cloud.
-
Migrating data from Asana to Google BigQuery using CData SSIS Components.
Easily push Asana data to Google BigQuery using the CData SSIS Tasks for Asana and Google BigQuery.
-
Integrate Live Microsoft Entra ID Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Entra ID data and integrate live Microsoft Entra ID data into apps built in Microsoft Power Apps.
-
How to use SQLAlchemy ORM to access Recurly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Recurly data.
-
Connect to Zoho CRM Data in CloverDX (formerly CloverETL)
Transfer Zoho CRM data using the visual workflow in the CloverDX data integration tool.
-
Automate Qualaroo Data Replication to Couchbase
Use CData Sync to Customize and automate Qualaroo data replication to Couchbase.
-
Deploy the ADO.NET Provider for HubSpot on an SSRS Report Server
Connect to HubSpot 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.
-
Factorial Reporting in OBIEE with the Factorial JDBC Driver
Deploy the Factorial JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for Greenhouse in Microsoft Power Query
You can use the CData Greenhouse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Greenhouse data into Microsoft Power Query.
-
Connect to Xero Data from AWS Glue
Use CData Connect AI to gain access to live Xero data from your AWS Glue jobs.
-
Operational Reporting on EnterpriseDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote EnterpriseDB data.
-
Visualize Elorus Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Elorus data.
-
Integrate Live Mailjet Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Mailjet data and integrate live Mailjet data into apps built in Microsoft Power Apps.
-
Connect to Facebook Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Facebook data using standard SQL.
-
Automated Continuous GitLab Replication to Amazon S3
Use CData Sync for automated, continuous, customizable GitLab replication to Amazon S3.
-
Import Bitly Data Using Azure Data Factory
Use CData Connect AI to connect to Bitly Data from Azure Data Factory and import live Bitly data.
-
Integrate Flowlu Data in Pentaho Data Integration
Build ETL pipelines based on Flowlu data in the Pentaho Data Integration tool.
-
Replicate Basecamp Data from PowerShell
Write a quick PowerShell script to query Basecamp data. Use connectivity to the live data to replicate Basecamp data to SQL Server.
-
How to Connect DBeaver to Oracle HCM Cloud via a JDBC Driver
Manage Oracle HCM Cloud data with visual tools in DBeaver like the query browser.
-
Connect to SparkPost Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SparkPost and the SQL Gateway to access SparkPost data from Google Apps Script.
-
Integrating LangChain with SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SQL Analysis Services data within automated workflows.
-
Integrate with WooCommerce Data in JReport Designer
Create charts and reports based on WooCommerce data in JReport Designer.
-
Build Automated Workflows with Live Basecamp Data in Workato
Use CData Connect AI to connect to live Basecamp data and build automated workflows in Workato.
-
How to Work with Beeminder Data in AWS Glue Jobs Using JDBC
Connect to Beeminder from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import and Visualize Nuclia Data in Power View
Create data visualizations based on Nuclia data in Excel.
-
Import Real-Time DB2 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use DB2 data in ColdFusion.
-
Analyze SAP Ariba Source Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Ariba Source data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to integrate Exa with Apache Airflow
Access and process Exa data in Apache Airflow using the CData JDBC Driver.
-
How to work with Dotmailer Data in Apache Spark using SQL
Access and process Dotmailer Data in Apache Spark using the CData Software JDBC Driver.
-
Build Raisers Edge NXT Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Raisers Edge NXT data and build visualizations in Tableau.
-
Use the CData Software ODBC Driver for Zoho Books in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoho Books data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoho Books.
-
Build SurveyMonkey-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SurveyMonkey Data and create custom apps in Bubble.
-
Build Freshteam-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Freshteam data without replication.
-
Integrating Cursor with Sage 200 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.
-
Create Azure Synapse-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Synapse Data from OutSystems and build custom enterprise apps using live Azure Synapse data.
-
Connect to EmailOctopus Data in RazorSQL
Connect to EmailOctopus from wizards and query EmailOctopus data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Zoho Projects Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Vertica.
-
Validate GetResponse Data with QuerySurge
Access and validate GetResponse data in QuerySurge using the CData JDBC Driver.
-
DataBind Controls to Qualaroo Data in Delphi
DataBind to Qualaroo data in Delphi with standard data access components and controls.
-
Replicate Multiple Aha! Accounts via the CData Sync CLI
Replicate multiple Aha! accounts to one or many databases.
-
Integrate Open WebUI with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Hive data from within the chat interface.
-
Build Apps with Live Splunk Data Using the Low-Code Development Platform of Mendix
Connect Splunk data with Mendix to build apps using the CData JDBC Driver for Splunk.
-
Connecting Pipedream with Act CRM 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 Act CRM data in real time.
-
Connect to Zendesk Data in RazorSQL
Connect to Zendesk from wizards and query Zendesk data from the GUI in the RazorSQL database management tool.
-
Integrate Dify with Live IBM Informix Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live IBM Informix data.
-
Analyze Lakebase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Lakebase data in Microsoft R Open.
-
Write a Simple Go Application to work with ConvertAPI Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ConvertAPI data.
-
Stream Toggl Data into Apache Kafka Topics
Access and stream Toggl data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build MVC Applications with Connectivity to Chargebee Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Chargebee from an ASP.NET MVC application.
-
Automated Continuous Cloudflare Replication to Vertica
Use CData Sync for automated, continuous, customizable Cloudflare replication to Vertica.
-
Analyze Webflow Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Webflow data in Microsoft R Open.
-
Validate Pinterest Data with QuerySurge
Access and validate Pinterest data in QuerySurge using the CData JDBC Driver.
-
Create Contentful Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Contentful data access from reports, embedded analytics, and more.
-
Connect to SendGrid from Asprova with CData Software ODBC Driver for SendGrid
This article shows how to connect faster to SendGrid data from Asprova.
-
Connect to BigQuery Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for BigQuery and the Script function in FileMaker Pro to connect to BigQuery and work with BigQuery data in your FileMaker application.
-
Query Parallel Data as a MySQL Database in Node.js
Execute MySQL queries against Parallel data from Node.js.
-
Build Act-On Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Act-On data and build visualizations in Tableau Cloud.
-
Getting Started with the CData Connect AI Python SDK for Mailjet
Install the CData Connect AI Python SDK to read live Mailjet data with standard DB-API 2.0 Python code.
-
Connect to PostgreSQL Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PostgreSQL data in the Denodo Virtual DataPort Administrator.
-
How to publish and share Phoenix Data dashboards with Tableau Server
The CData ODBC driver for Phoenix enables you integrate Phoenix data into Tableau dashboards.
-
Build Salesforce Data 360-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce Data 360 Data and create custom apps in Bubble.
-
Connect to and Query Wave Financial Data in QlikView over ODBC
Create data visualizations with Wave Financial data in QlikView.
-
Use Agno to Talk to Your Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Jumpseller data for you.
-
How to load Recurly data into Elasticsearch via Logstash
Introducing a simple method to load Recurly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate Multiple SendInBlue Accounts via the CData Sync CLI
Replicate multiple SendInBlue accounts to one or many databases.
-
Create PayPal Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PayPal data access from reports, embedded analytics, and more.
-
Integrate Theia IDE with Live Apify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Apify data from within the development environment.
-
Access Live Supabase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Supabase data from your Excel spreadsheets.
-
Build Semantic Layer Views for Workday Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Workday data.
-
Visualize Live Klaviyo Data in the Power BI Service
Use CData Connect AI to connect to live Klaviyo data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with Freshdesk Data in DBxtra
Create dynamic dashboards and perform analytics based on Freshdesk data in DBxtra.
-
How to Connect the Power BI Service to CockroachDB: Complete Guide
Connect to the CData Software Power BI Connector for CockroachDB from PowerBI.com to provide real-time CockroachDB data across the organization.
-
Integrate Theia IDE with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Jira data from within the development environment.
-
Replicate Multiple MailerLite Accounts
Replicate multiple MailerLite accounts to one or many databases.
-
Build Visualizations of Azure DevOps Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure DevOps data in Birst.
-
Trigger Act CRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Act CRM with standard wizards in Logic Apps.
-
Integrating SingleStore Data in Talend Cloud Data Management Platform
Connect SingleStore Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SingleStore.
-
Automated Continuous Microsoft Planner Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to PostgreSQL.
-
Stream Reply.io Data into Apache Kafka Topics
Access and stream Reply.io data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Natively Connect to LeadDesk Data in PHP
The CData ODBC driver for LeadDesk enables you to create PHP applications with connectivity to LeadDesk data. Leverage the native support for ODBC in PHP.
-
Query Live Databricks 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 Databricks data through a conversational interface.
-
Connect to Confluence from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Confluence data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Cosmos DB Replication to Databricks
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Databricks.
-
Getting Started with the CData Python Connector for Azure Analysis Services
Learn to install and license the CData Python Connector and configure a connection to live Azure Analysis Services data.
-
Create Beeminder Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Beeminder data access from reports, embedded analytics, and more.