CData Software Knowledge Base

Excel Spreadsheet Automation on Basecamp with the QUERY Formula

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

Use Dash to Build to Web Apps on IBM Informix

Create Python applications that use pandas and Dash to build IBM Informix-connected web apps.

Query Act CRM through ODBC in Node.js

Use node-odbc to execute SQL queries against Act CRM from Node.js.

Replicate Greenplum to Multiple Databases

Replicate Pivotal GreenPlum to disparate databases with a point-and-click configuration.

Connect to Zoho Creator in RunMyProcess through Connect AI

Use CData Connect AI to create on OData API for Zoho Creator and connect to Zoho Creator in Akorbi Digital RunMyProcess.

Integrate Google

Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon Redshift within intelligent workflows.

Integrating Claude Code with Google Ads via CData Connect AI

Leverage CData Connect AI to enable Claude Code to securely access and act on Google Ads within assisted coding and automated development workflows.

Connect Tableau CRM Analytics to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Tableau CRM Analytics using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

How to load Reckon Accounts Hosted data into Elasticsearch via Logstash

Introducing a simple method to load Reckon Accounts Hosted data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

Connect to Cassandra from HeidiSQL

Use CData Connect AI to connect to and query live Apache Cassandra from HeidiSQL.

Access Live Azure Synapse in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live Azure Synapse from your Excel spreadsheets.

Getting Started with the CData SSIS Components for Facebook Ads

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

How to connect SharePoint with Acumatica through external lists

Provide Acumatica ERP to SharePoint users as an external list.

Use Claude to Talk to Your Active Directory via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Active Directory for you.

Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy Web

Connect to Azure Cosmos DB in MicroStrategy Web using the CData Software JDBC Driver for Cosmos DB.

Prepare, Blend, and Analyze YouTube Analytics in Alteryx Designer (ODBC)

Build workflows to access live YouTube Analytics for self-service data analytics.

Connect to and Visualize Live Salesforce Pardot in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce Pardot.

Automated Continuous Parquet Replication to Azure SQL Database

Use CData Sync for automated, continuous, customizable Parquet replication to Azure SQL Database.

Integrate Live Oracle HCM Cloud into Amazon SageMaker Canvas with RDS

Use CData Connect AI to connect to Oracle HCM Cloud from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle HCM Cloud.

Facebook Ads Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Facebook Ads through CData Connect AI using different applications and tools.

Choosing the Best Method to Connect Blackbaud FE NXT to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Blackbaud FE NXT from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

How to Import Data from SAP Hybris C4C into Google Sheets

Import SAP Hybris C4C into a Google spreadsheet that is automatically refreshed.

Automated Continuous Tableau CRM Analytics Replication to Vertica

Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to Vertica.

DataBind Controls to Microsoft Project in Delphi

DataBind to Microsoft Project in Delphi with standard data access components and controls.

Integrate Excel with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Excel with External Services.

CData Software - Knowledge Base

Recent Articles