CData Software Knowledge Base

Build Act-On Visualizations in Tableau Desktop

Use CData Connect AI to connect to live Act-On and build visualizations in Tableau.

How to Connect to & Open LinkedIn Ads in Microsoft Excel

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

Integrate with Azure Active Directory using Apache Camel2

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

Analyze Dropbox in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Dropbox and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

How to pipe Xero to CSV in PowerShell

Use standard PowerShell cmdlets to access Xero tables.

Connect to ConstantContact from a Connection Pool in JBoss

Integrate ConstantContact into Java servlets: Use the Management Console in JBoss to install the ConstantContact JDBC Driver.

Automated Continuous Dynamics 365 Replication to Snowflake

Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Snowflake.

Integrate OData Services in the Pentaho Report Designer

Publish reports based on OData in the Pentaho BI tool.

Connecting GenSpark with Trello 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.

Build Agents in Relevance AI with Access to Live Azure DevOps via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure DevOps within intelligent agent workflows.

Build Agents in Relevance AI with Access to Live OneNote via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft OneNote within intelligent agent workflows.

Import Real-Time Sugar CRM via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Sugar CRM in ColdFusion.

How to Use a Microsoft Access Database to Update Twilio in Real Time

Update Twilio data by creating a linked table in Microsoft Access with the CData Twilio ODBC Driver.

Visualize Live SAP BusinessObjects BI in Power BI (via CData Connect AI)

Use the CData Power BI Connector and CData Connect AI to integrate live SAP BusinessObjects BI into custom reports in Power BI.

Use the CData Software ODBC Driver for Jira Service Management in MicroStrategy Web

Connect to Atlassian Jira Service Management in MicroStrategy Web using the CData Software ODBC Driver for Jira Service Management.

Build Odoo-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Odoo ERP.

Build a PostgreSQL Interface for Zoom using the CData JDBC Driver

Use the Remoting features of the Zoom JDBC Driver to create a PostgreSQL entry-point for data access.

Connect to SingleStore from PowerBuilder via JDBC

This article demonstrates how to access SingleStore from PowerBuilder using the SingleStore JDBC Driver.

How to connect to Sage 300 from Spring Boot

Connect to Sage 300 in a Spring Boot Application using CData JDBC Sage 300 Driver

Connect to Microsoft Exchange in Aqua Data Studio

Access Microsoft Exchange from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to pipe xBase to CSV in PowerShell

Use standard PowerShell cmdlets to access xBase tables.

Automate Klipfolio Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Klipfolio from PowerShell? This article demonstrates how to utilize the Klipfolio Cmdlets for tasks like connecting to Klipfolio, automating operations, downloading data, and more.

How to connect SharePoint with Azure Table through external lists

Provide Azure Table Storage to SharePoint users as an external list.

Automated Continuous ADP Replication to Oracle

Use CData Sync for automated, continuous, customizable ADP replication to Oracle.

How to Build an ETL App for Okta in Python with CData

Create ETL applications and real-time data pipelines for Okta in Python with petl.

How to create Visio diagrams from Kintone

Automatically update Kintone with the changes you make to Visio master shapes.

Connecting Mastra with AlloyDB 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 data across 300+ enterprise sources no replication required.

Excel Spreadsheet Automation on OneNote with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Excel Spreadsheet Automation on SendGrid with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Build Agents in Relevance AI with Access to Live SAP HANA via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP HANA within intelligent agent workflows.

Prepare, Blend, and Analyze AlloyDB in Alteryx Designer (Connect AI)

Build workflows to access live Google AlloyDB for self-service data analytics.

ETL Drift in Oracle Data Integrator

This article shows how to transfer Drift into a data warehouse using Oracle Data Integrator.

Natively Connect to SAP Business One in PHP

The CData ODBC driver for SAP Business One enables you to create PHP applications with connectivity to SAP Business One. Leverage the native support for ODBC in PHP.

Access Live Google Analytics in Excel (Desktop) via Connect AI

Use CData Connect AI to gain access to live Google Analytics from your Excel spreadsheets.

Connect to Gmail from Asprova with CData Software ODBC Driver for Gmail

This article shows how to connect faster to Gmail data from Asprova.

Use Biml to Build SSIS Tasks to Replicate Amazon Athena to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon Athena to SQL Server.

How to connect PolyBase to Access

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Access.

CData Software - Knowledge Base

Recent Articles