CData Software Knowledge Base

Consume Basecamp OData Feeds in SAP Lumira

Use the API Server to create data visualizations on Basecamp feeds that reflect any changes in SAP Lumira.

Use Azure AI Foundry to Talk to Your WooCommerce 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 WooCommerce for you.

Analyze Snowflake in SAP Analytics Cloud

Use CData Connect AI to create an OData API on top of Snowflake and visualize Snowflake in SAP Analytics Cloud.

Prepare, Blend, and Analyze Jira in Alteryx Designer (ODBC)

Build workflows to access live Atlassian Jira for self-service data analytics.

How to connect to Sage 200 in DBVisualizer

Integrate Sage 200 with visual data analysis tools and data connection wizards in DBVisualizer

Trigger Sugar CRM IFTTT Flows in Azure App Service

This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

How to Connect to & Open Outreach.io in Microsoft Excel

This article uses the CData ODBC driver for Outreach.io to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

How to Connect to Live Google Search Results from crewAI Agents (via CData Connect AI)

Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Search for you.

Integrate Real-Time Access to Calendly in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Calendly in real time.

Automated Continuous SAS xpt Replication to SQLite

Use CData Sync for automated, continuous, customizable SAS xpt replication to SQLite.

Connect to ShipStation in Ruby

Connect to ShipStation in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Create Confluence-Connected Visualizations in Klipfolio

Use CData Connect AI to connect to Confluence from Klipfolio and build custom visualizations using live Atlassian Confluence.

Automated Continuous Cloudant Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Cloudant replication to delimited files (CSV/TSV).

Build Dashboards with Adobe Commerce in Dundas BI

Create dynamic dashboards and perform analytics based on Adobe Commerce in Dundas BI.

Automated Continuous SAP HANA XS Advanced Replication to Azure SQL Database

Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Azure SQL Database.

Getting Started with the CData SSIS Components for Impala

Complete guide to installing, licensing, and connecting with the CData SSIS Components for Impala.

Connect to Drip as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Drip.

Build Automated Workflows with Live Cosmos DB in Workato

Use CData Connect AI to connect to live Azure Cosmos DB and build automated workflows in Workato.

Integrate with Databricks using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Databricks to a JSON file on disk.

Access Live Cassandra in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Apache Cassandra from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

How to pipe Google Ads to CSV in PowerShell

Use standard PowerShell cmdlets to access Google Ads tables.

Connecting GenSpark with Exact Online via CData Connect AI MCP Server

Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.

Automated Continuous Sage 300 Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon S3.

A PostgreSQL Interface for Certinia using the CData ODBC Driver

Use the SQL Gateway and Certinia ODBC Driver to create a PostgreSQL entry-point for data access.

Connect to Trello in RazorSQL

Connect to Trello from wizards and query Trello from the GUI in the RazorSQL database management tool.

CData Software - Knowledge Base

Recent Articles