CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for Mocean With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mocean data using
-
Integrate with Freshdesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshdesk to a JSON file on disk.
-
How to Query Live Zoho Books Data in Claude Desktop
Connect to and query live Zoho Books Data in Claude Desktop using CData MCP Server.
-
Integrate Theia IDE with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to connect and process CapsuleCRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CapsuleCRM.
-
Excel Spreadsheet Automation on Pushbullet Data with the QUERY Formula
Pull data from Pushbullet, automate spreadsheets, and more with the QUERY formula.
-
Use Manus AI to Talk to Your Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Slack.
-
Replicate Salesforce Marketing Data to Multiple Databases via the CData Sync CLI
Replicate Salesforce Marketing Cloud to disparate databases with a single configuration.
-
Connect to Live ShipStation Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ShipStation in CData Connect AI and connect to your ShipStation from PostgreSQL.
-
Connect and Visualize Live Epicor Kinetic Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Epicor Kinetic into the Databricks platform and create visualization dashboards with real-time Epicor Kinetic.
-
Integrating Claude Code CLI with Zoho Creator 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.
-
Integrating Cursor CLI with ChargeOver 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.
-
Consume Teamwork OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Teamwork feeds that reflect any changes in SAP Lumira.
-
Establish a Live Connection with Freshservice Data using Tableau Bridge
The CData ODBC Driver for Freshservice enables you to integrate live Freshservice into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to VWO Data from Spring Boot
Connect to VWO in a Spring Boot Application using the CData API Driver for JDBC
-
Process & Analyze Codat Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Codat Data.
-
Connect to Pinterest Data in CloverDX (formerly CloverETL)
Transfer Pinterest using the visual workflow in the CloverDX data integration tool.
-
Build Data Flows from LionDesk to SQL Server using SSIS
Easily back up LionDesk to SQL Server using the SSIS components for LionDesk.
-
Query MarkLogic Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MarkLogic entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for RabbitMQ from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for RabbitMQ to connect to RabbitMQ from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring RabbitMQ in Excel.
-
Publish JSON-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live JSON.
-
Publish Reports with ShipStation Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ShipStation.
-
Connect to PingOne Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PingOne using standard SQL.
-
Create a Data Access Object for Klipfolio Data using JDBI
A brief overview of creating a SQL Object API for Klipfolio in JDBI.
-
Model, Search, and Visualize Live Gong Data in ThoughtSpot
Use CData Connect AI to connect to live Gong for modeling, searching, and visualizing.
-
Integrating Claude Code with Exact Online Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Exact Online within assisted coding and automated development workflows.
-
How to Easily Query Blackbaud FE NXT Data in OpenOffice Base
Connect to Blackbaud FE NXT data in OpenOffice Base using the CData ODBC Driver for Blackbaud FE NXT and generate reports with live data insights.
-
Model Google Ad Manager Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Ad Manager, enabling the direct import of real-time Google Ad Manager.
-
Connecting Pipedream with Raisers Edge NXT 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 Raisers Edge NXT data in real time.
-
Design BIRT Reports on CircleCI Data
Provide current CircleCI to your embedded analytics.
-
Automated Continuous Humanity Replication to Vertica
Use CData Sync for automated, continuous, customizable Humanity replication to Vertica.
-
Connect to Moosend from a Connection Pool in WebLogic
Use the CData JDBC Driver for Moosend to connect to Moosend from Web applications running on WebLogic.
-
Connect to Demio Data from a Connection Pool in Jetty
The Demio JDBC Driver supports connection pooling: This article shows how to connect faster to Demio from Web apps in Jetty.
-
Connect to OneNote 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 Microsoft OneNote.
-
Use the CData SSIS Components to Insert New or Update Existing WooCommerce Records from SQL Server
Easily push SQL Server data to WooCommerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into WooCommerce or update existing records with data from a SQL Server database.
-
Build Semantic Layer Views for Datadog Data in APOS Live Data Gateway
Use the CData Connector for Datadog in APOS Live Data Gateway to build Semantic Layer Views for Datadog.
-
Migrating data from Freshteam to Databricks using CData SSIS Components.
Easily push Freshteam to Databricks using the CData SSIS Tasks for Freshteam and Databricks.
-
Automate Google Forms Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Forms replication to Azure Data Lake.
-
How to Connect to Live Oracle Eloqua Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Oracle Eloqua for you.
-
Use Claude to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP Ariba Source for you.
-
Build BenchmarkEmail-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live BenchmarkEmail Data in GitHub Copilot to assist with building BenchmarkEmail-powered applications.
-
Automated Continuous Box Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Box replication to Apache Cassandra.
-
Use the CData API Server to Access Freshdesk Data in Microsoft PowerPivot
Use the CData API Server to connect to live Freshdesk in the Power Pivot business intelligence tool.
-
Getting Started with the CData Power BI Connector for Google Calendar
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Calendars.
-
Integrate Live MongoDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to connect SharePoint with Authorize.Net Data through external lists
Provide Authorize.Net to SharePoint users as an external list.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apache Phoenix using the Model Context Protocol.
-
Connect to Dynamics CRM Data in HULFT Integrate
Connect to Dynamics CRM as a JDBC data source in HULFT Integrate
-
Create SSAS Tabular Models from Parquet Data
How to build a SQL Server Analysis Service Tabular Model from Apache Parquet using CData drivers.
-
Edit and Search External Act-On Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Act-On to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Act-On Data objects that you can access from apps and the dashboard.
-
How to connect to Instagram Data from IntelliJ
Integrate connectivity to Instagram with wizards in IntelliJ.
-
Create Datasets from Perplexity in Domo Workbench and Build Visualizations of Perplexity Data in Domo
Use the CData Software ODBC Driver for Perplexity to create datasets from Perplexity in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for Salesloft in MicroStrategy
Connect to Salesloft in MicroStrategy Developer using the CData Software ODBC Driver for Salesloft.
-
Automate Tasks in Power Automate Using the CData API Server
Automate YouTube Analytics actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Use the CData Software JDBC Driver for Office 365 in MicroStrategy Web
Connect to Microsoft Office 365 in MicroStrategy Web using the CData Software JDBC Driver for Office 365.
-
Build Voice Agents in ElevenLabs with access to Live SendGrid Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SendGrid.
-
Feed Front Data into FineReport
How to set Front as a JDBC data source in FineReport.
-
How to connect to Google Directory Data with Squirrel SQL client
Connect to Google Directory and execute queries in the Squirrel SQL Client.
-
Create Reports with Mailgun Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mailgun.
-
Viewing Active Directory Data in RAD Studio Data Explorer
How to view Active Directory in RAD Studio Data Explorer using the CData ODBC Driver for Active Directory.
-
Write a Simple Go Application to work with Okta Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Okta.
-
Access Live MessageBird Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MessageBird in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Epicor Kinetic
Provide connectivity to Epicor Kinetic through an SAP BusinessObjects universe.
-
Connect to Real-Time CampaignMonitor Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use CampaignMonitor in Power Apps.
-
Analyze HelloSign Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HelloSign with the CData JDBC Driver for HelloSign.
-
Integrating Codex CLI with Placid 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.
-
Visualize Perigon Data in TIBCO Spotfire through OData
Integrate Perigon into dashboards in TIBCO Spotfire.
-
Build MVC Applications with Connectivity to Parallel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Parallel from an ASP.NET MVC application.
-
Connecting Moonlit Workflow with Cvent 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 Cvent in real time.
-
Replicate Multiple WooCommerce Accounts via the CData Sync CLI
Replicate multiple WooCommerce accounts to one or many databases.
-
Process & Analyze TaxJar Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live TaxJar Data.
-
Integrating Codex CLI with Azure Table Storage 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 the CData Software ODBC Driver for OpenWeatherMap in SAS for Real-Time Reporting and Analytics
Connect to real-time OpenWeatherMap in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for OpenWeatherMap.
-
Access Apollo 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 Apollo.
-
SAP BusinessObjects BI Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP BusinessObjects BI through CData Connect AI using different applications and tools.
-
Easily Integrate Google Search Results in Lazarus Pascal IDE
Learn how to easily integrate live Google Search in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Model, Search, and Visualize Live SQL Analysis Services Data in ThoughtSpot
Use CData Connect AI to connect to live SQL Analysis Services for modeling, searching, and visualizing.
-
How to Create Power BI Visual Reports with Real-Time Paymo Data
Use CData Power BI Connectors to visualize Paymo in Power BI.
-
How to work with Mouseflow Data in Apache Spark using SQL
Access and process Mouseflow Data in Apache Spark using the CData Software JDBC Driver.
-
Query Amazon DynamoDB Data in ColdFusion
Write standard ColdFusion data access code to connect to Amazon DynamoDB.
-
Access Live ServiceNow Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live ServiceNow data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous Front Replication to SingleStore
Use CData Sync for automated, continuous, customizable Front replication to SingleStore.
-
Access Live Redshift Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amazon Redshift into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon Redshift in the Graph Builder and Query Builder.
-
Getting Started with the CData JDBC Driver for Nuclia
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Nuclia.
-
Query Codat Data as a MySQL Database in Node.js
Execute MySQL queries against Codat from Node.js.
-
Automated Continuous SendInBlue Replication to SingleStore
Use CData Sync for automated, continuous, customizable SendInBlue replication to SingleStore.
-
Connect to Dynamics 365 Business Central from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Dynamics 365 Business Central, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Helpscout Data Replication to Teradata
Use CData Sync to Customize and automate Helpscout replication to Teradata.
-
Use Azure AI Foundry to Talk to Your DB2 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 IBM DB2 for you.
-
Excel Spreadsheet Automation on JobNimbus Data with the QUERY Formula
Pull data from JobNimbus, automate spreadsheets, and more with the QUERY formula.
-
Create Data Visualizations Based On Xero Data in Mode
Use CData Connect AI to connect to Xero Data from Mode and build visualizations using live
-
Automated Continuous Float Replication to Snowflake
Use CData Sync for automated, continuous, customizable Float replication to Snowflake.
-
How to Build an ETL App for Google Spanner Data in Python with CData
Create ETL applications and real-time data pipelines for Google Spanner in Python with petl.
-
Connect to SharePoint Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft SharePoint in DBeaver.
-
Create Data Visualizations Based On Avalara AvaTax Data in Mode
Use CData Connect AI to connect to Avalara AvaTax Data from Mode and build visualizations using live
-
Getting Started with the CData JDBC Driver for Paymo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Paymo.
-
Build Gong-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Gong Data in GitHub Copilot to assist with building Gong-powered applications.
-
Connect to Microsoft Planner Data in RapidMiner
Integrate Microsoft Planner with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating GitHub Copilot CLI with Retently 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.
-
Connect to FreshBooks Data in Aqua Data Studio
Access FreshBooks from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.