CData Software Knowledge Base

Connecting Agentforce with Excel Online via CData Connect AI MCP Server

Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft Excel Online for you.

LINQ to QuickBooks

LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData Data Providers for ADO.NET. This example uses LINQ to access information from the QuickBooks Data Provider.

Connect to SAP SuccessFactors in DBeaver

Use the CData ODBC Driver to connect to SAP SuccessFactors in DBeaver.

Creating Odoo-Connected Applications in Unqork

You can use CData Connect AI to feed Odoo ERP to Unqork and build custom business apps.

Manage MailChimp in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for MailChimp.

Analyze Google Campaign Manager 360 in Infragistics Reveal

Use CData Connect AI to create on OData API on top of Google Campaign Manager 360 and visualize live Google Campaign Manager 360 in Infragistics Reveal.

Build TigerGraph-Connected ETL Processes in Google Data Fusion

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

How to connect to Amazon Marketplace with Squirrel SQL client

Connect to Amazon Marketplace and execute queries in the Squirrel SQL Client.

Create Data Visualizations in Cognos BI with CSV

Access CSV/TSV Files as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Connect SAS Data Sets to IBM WebSphere Using the CData JDBC Driver

Use the CData JDBC Driver to connect SAS Data Sets with IBM WebSphere for seamless data integration and connectivity.

Replicate Multiple JSON Accounts via the CData Sync CLI

Replicate multiple JSON accounts to one or many databases.

How to connect PolyBase to Greenhouse

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

Connect to Power BI XMLA as a SQL Server Linked Server

Use CData Connect AI to create a linked server for live Power BI XMLA.

Create a Data Access Object for SFTP using JDBI

A brief overview of creating a SQL Object API for SFTP in JDBI.

Replicate Avro from PowerShell

Write a quick PowerShell script to query Apache Avro. Use connectivity to the live data to replicate Apache Avro to SQL Server.

Create Data Visualizations in Cognos BI with Salesforce Marketing

Access Salesforce Marketing Cloud as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

How to connect to SAS xpt from Spring Boot

Connect to SAS xpt in a Spring Boot Application using CData JDBC SAS xpt Driver

SQL Access to Analytical Data APIs

Use SQL to read from analytical data (multi-dimensional) APIs.

DataBind Controls to Odoo in C++Builder

DataBind to Odoo ERP in C++Builder with standard components and controls.

Access Twitter from MySQL in PHP

Connect to Twitter through the standard MySQL libraries in PHP.

Create Informatica Mappings From/To an ODBC Data Source for Amazon Marketplace

Create an ODBC connection to Amazon Marketplace in Informatica and browse and transfer Amazon Marketplace.

How to import Calendly into Apache Solr

Use the CData Software JDBC Driver for Calendly in Data Import Handler and create an automated import of Calendly to Apache Solr Enterprise Search platform.

Analyze MySQL in SAP Analytics Cloud

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

Getting Started with the CData SSIS Components for Microsoft Exchange

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

Using the CData Software ODBC Driver for Salesforce Pardot in PyCharm

Connect to Salesforce Pardot as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce Pardot.

Establish a Live Connection with Jira Assets using Tableau Bridge

The CData ODBC Driver for Jira Assets enables you to integrate live Jira Assets into Tableau Cloud dashboards using the Tableau Bridge.

How to connect Amazon QuickSight to Monday.com

Create a connection to Monday.com in CData Connect AI and insert Monday.com into Amazon QuickSight SPICE to build interactive dashboards.

Connect to Monday.com through External Services in Salesforce

Use CData Connect AI to securely connect Salesforce External Services with Monday.com using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

Access EventBrite as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Eventbrite from your Oracle system.

Build Oracle Financials Cloud-Connected Apps in Bubble

Use CData Connect AI to create an OData feed for Oracle Financials Cloud and create custom apps in Bubble.

Manage HubSpot in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for HubSpot.

Bidirectional Access to Access from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Access in Filemaker Pro for Mac or Windows.

How to Connect to Live FHIR 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 FHIR for you.

Consume Smartsheet OData Feeds in SAP Lumira

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

Connect to Act CRM from a Connection Pool in Jetty

The Act CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Act CRM from Web apps in Jetty.

Getting Started with the CData Python Connector for Greenplum

Learn to install and license the CData Python Connector

Deploy the ADO.NET Provider for SAP on an SSRS Report Server

Connect to SAP ERP/NetWeaver 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.

Build Charts with Pipedrive in Clear Analytics

Create dynamic charts and perform analytics based on Pipedrive in Clear Analytics.

Integrate Avro in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Avro from Informatica Cloud.

How to Connect to Live DocuSign from OpenAI Python Applications (via CData Connect AI)

Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your DocuSign through natural language.

CData Software - Knowledge Base

Recent Articles