CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code with Act-On Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Act-On within assisted coding and automated development workflows.
-
Build ClickUp-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ClickUp and build web apps with connectivity to live ClickUp.
-
How to Connect to Live SAP Fieldglass 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 SAP Fieldglass for you.
-
Visualize Live GitLab Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live GitLab using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Trigger QuickBooks Online IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for QuickBooks Online with standard wizards in Logic Apps.
-
Integrating Boomi Agentstudio with IBM Informix Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to IBM Informix, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Back Up QuickBooks Online to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for QuickBooks Online. In this article, we will employ an SSIS workflow to populate a database with QuickBooks Online data.
-
Connect to Hacker News Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Hacker News.
-
Integrating Cursor CLI with Autopilot 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.
-
Oracle SCM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle SCM through CData Connect AI using different applications and tools.
-
Consume MailChimp OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MailChimp feeds that reflect any changes in SAP Lumira.
-
Connect to Dynamics 365 in SpagoBI
Create reports featuring live Microsoft Dynamics 365 in SpagoBI Studio. Host Dynamics 365 reports on SpagoBI Server.
-
Build Microsoft Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Ads Data and create custom apps in Mendix.
-
Bidirectional Access to SAP HANA Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP HANA in Filemaker Pro for Mac or Windows.
-
DataBind Controls to Mocean Data in C++Builder
DataBind to Mocean in C++Builder with standard components and controls.
-
How to connect SharePoint with SuiteCRM Data through external lists
Provide SuiteCRM to SharePoint users as an external list.
-
Automated Continuous WooCommerce Replication to SQL Server
Use CData Sync for automated, continuous, customizable WooCommerce replication to SQL Server.
-
Stream Google Translate Data into Apache Kafka Topics
Access and stream Google Translate in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Dropbox-Connected Business Apps in AppSheet
Connect to Dropbox Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Dropbox.
-
Build Microsoft Ads-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Ads.
-
Build SQL Analysis Services Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SQL Analysis Services and build visualizations in Tableau.
-
Replicate Marketo Data in Heroku for Use in Salesforce Connect
Replicate Marketo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Informatica Mappings From/To an ODBC Data Source for Bugsnag
Create an ODBC connection to Bugsnag in Informatica and browse and transfer Bugsnag.
-
DataBind Controls to BigQuery Data in C++Builder
DataBind to Google BigQuery in C++Builder with standard components and controls.
-
Establish a Live Connection with IBM Informix Data using Tableau Bridge
The CData ODBC Driver for IBM Informix enables you to integrate live IBM Informix into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software ODBC Driver for Snowflake in MicroStrategy Web
Connect to Snowflake in MicroStrategy Web using the CData Software ODBC Driver for Snowflake.
-
Access Live Datadog Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Datadog into the statistical analysis tools available in SAS JMP. This article shows how to use Datadog in the Graph Builder and Query Builder.
-
Connect to MongoDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MongoDB as an External Source in Dremio.
-
How to Build an ETL App for WooCommerce Data in Python with CData
Create ETL applications and real-time data pipelines for WooCommerce in Python with petl.
-
Load OData Services to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load OData to a database.
-
Connect to Adobe Target Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Target and the Script function in FileMaker Pro to connect to Adobe Target and work with Adobe Target in your FileMaker application.
-
Create Epicor Kinetic-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Epicor Kinetic Data from Klipfolio and build custom visualizations using live Epicor Kinetic.
-
Query CapsuleCRM Data as a MySQL Database in Node.js
Execute MySQL queries against CapsuleCRM from Node.js.
-
Connect to Highrise Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Highrise Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Moving Data from Coinbase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Coinbase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SpaceX Data in RazorSQL
Connect to SpaceX from wizards and query SpaceX from the GUI in the RazorSQL database management tool.
-
Automated Continuous Active Directory Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Active Directory replication to Amazon S3.
-
Create Azure Synapse-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Synapse Data from Klipfolio and build custom visualizations using live Azure Synapse.
-
Write a Simple Go Application to work with Amazon DynamoDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon DynamoDB.
-
Deploy the ADO.NET Provider for Paymo on an SSRS Report Server
Connect to Paymo 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.
-
Connect to Vercel Data in JRuby
Create a simple JRuby app with access to live Vercel.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zendesk
Provide connectivity to Zendesk through an SAP BusinessObjects universe.
-
Migrating data from SAP Business Warehouse to Snowflake using CData SSIS Components.
Easily push SAP Business Warehouse to Snowflake using the CData SSIS Tasks for SAP Business Warehouse and Snowflake.
-
Integrate XML Data in the Pentaho Report Designer
Publish reports based on XML Files in the Pentaho BI tool.
-
Integrate with Live Google Drive Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Drive from the MuleSoft Anypoint Platform to integrate live Google Drive into custom reports and dashboards.
-
Use Databricks Agent Bricks to Talk to Your Jira Assets Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Jira Assets for you.
-
Automated Continuous Aha! Replication to MySQL
Use CData Sync for automated, continuous, customizable Aha! replication to MySQL.
-
Consume QuickBooks Time OData Feeds in SAP Lumira
Use the API Server to create data visualizations on QuickBooks Time feeds that reflect any changes in SAP Lumira.
-
Use Databricks Agent Bricks to Talk to Your MySQL Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your MySQL for you.
-
How to Work with SAP Hybris C4C Data in ETL Validator JDBC
Connect to SAP Hybris C4C from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Access Live ZohoPeople Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZohoPeople enables you to integrate ZohoPeople into workflows built using Microsoft Power Automate Desktop.
-
Import Salesforce CRM Analytics Data Using Azure Data Factory
Use CData Connect AI to connect to Salesforce CRM Analytics Data from Azure Data Factory and import live Salesforce CRM Analytics.
-
View Reports on Real-Time Everhour Data in Power BI Report Server
Use the CData ODBC Driver for Everhour to visualize Everhour in Power BI Desktop and then publish them to Power BI Report Server.
-
A PostgreSQL Interface for Databricks Data (MySQL Remoting via JDBC)
Use the Remoting features of the Databricks JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live MailChimp 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 MailChimp for you.
-
Build Visualizations of Paymo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Paymo in Birst.
-
Rapidly Develop Dynamics CRM-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 CRM.
-
Integrate Goose with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live BigCommerce from within the local AI agent.
-
Query, Visualize, and Share live EnterpriseDB Data in Redash
Use CData Connect AI to connect to live EnterpriseDB in Redash for querying, visualizing, and sharing.
-
Use Claude to Talk to Your Oracle Service Cloud 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 Oracle Service Cloud for you.
-
Integrating Codex CLI with Autopilot 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 an SAP BusinessObjects Universe on the CData JDBC Driver for TigerGraph
Provide connectivity to TigerGraph through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Mocean in MicroStrategy Web
Connect to Mocean in MicroStrategy Web using the CData Software JDBC Driver for Mocean.
-
A PostgreSQL Interface for Accelo Data using the CData ODBC Driver
Use the SQL Gateway and Accelo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Neo4J Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Neo4J and visualize live Neo4J in Infragistics Reveal.
-
How to Visualize ShipStation Data in Python with pandas
Use pandas and other modules to analyze and visualize live ShipStation in Python.
-
Easily Integrate ZohoMarketingHub Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoMarketingHub in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build an OLAP Cube in SSAS from Humanity Data
Establish a connection to Humanity data from SQL Server Analysis Services, and use the Humanity Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build a Simple VCL Application for Neo4J Data
How to build a simple VCL Application to view Neo4J in RAD Studio using the CData ODBC Driver for Neo4J.
-
Use the CData Software JDBC Driver for ChargeOver in MicroStrategy
Connect to ChargeOver in MicroStrategy Developer using the CData Software JDBC Driver for ChargeOver.
-
How to Connect Flowise AI Agents to Live Dropbox Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Dropbox without replication.
-
Build Amazon Marketplace-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Amazon Marketplace.
-
How to Connect to Live Greenhouse Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Greenhouse for you.
-
Integrating Kiro CLI with Salesforce Pardot 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.
-
Publish Zoho Projects-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho Projects.
-
Build Blackbaud FE NXT-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Blackbaud FE NXT Data and create custom apps in Mendix.
-
Connect Shopify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Shopify using the CData Python MCP Server.
-
How to Query Live Box Data in Claude Desktop
Connect to and query live Box Data in Claude Desktop using CData MCP Server.
-
Use Biml to Build SSIS Tasks to Replicate Omnisend Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Omnisend to SQL Server.
-
Automated Continuous SendGrid Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SendGrid replication to delimited files (CSV/TSV).
-
Feed Google Calendar Data into FineReport
How to set Google Calendar as a JDBC data source in FineReport.
-
Use Agno to Talk to Your SingleStore 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 SingleStore for you.
-
Extend Google Sheets with OneNote Data
Make calls to OneNote from Google Apps Script via the API Server.
-
Use CData Connect AI to Access SAP Business One Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Business One in the Power Pivot business intelligence tool.
-
How to integrate BigCommerce with Apache Airflow
Access and process BigCommerce in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Odoo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Odoo ERP.
-
Integrating GitHub Copilot CLI with Sybase 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 xBase Data in Jaspersoft Studio
Execute SQL to remote xBase in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Pinecone
Provide connectivity to Pinecone through an SAP BusinessObjects universe.
-
Build MVC Applications with Connectivity to Stripe Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Stripe from an ASP.NET MVC application.
-
Automate SAP Concur Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Concur replication to Azure Synapse.
-
Connect to Square 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 Square.
-
Create Apps from WordPress Data in Qlik Sense Cloud
Use CData Connect AI to connect to WordPress Data and build apps from live WordPress in Qlik Sense Cloud.
-
How to connect and process Dotmailer from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Dotmailer.
-
Analyze Salesforce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce & Force.com and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Import Shopify Data Using Azure Data Factory
Use CData Connect AI to connect to Shopify Data from Azure Data Factory and import live Shopify.
-
Model Kintone Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Kintone, enabling the direct import of real-time Kintone.
-
Analyze Active Directory Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Active Directory and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Access Outreach.io Data Using Entity Framework
This article shows how to access Outreach.io using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to SAP ByDesign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Business ByDesign using standard SQL.