Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Natively Connect to Google Contacts in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Google Contacts. Leverage the native support for ODBC in PHP.
Replicate Multiple CSV Accounts via the CData Sync CLI

Replicate multiple CSV accounts to one or many databases.
Query, Visualize, and Share live Oracle Service Cloud in Redash

Use CData Connect AI to connect to live Oracle Service Cloud in Redash for querying, visualizing, and sharing.
How to create TigerGraph federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for TigerGraph in MySQL .
Automated Continuous MYOB AccountRight Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Google Cloud SQL.
How to Connect to Live Google Sheets from Gemini CLI (via CData Connect AI)

Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Sheets for you.
Connecting GenSpark with GraphQL 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.
Publish Crystal Reports on Azure Data Lake Storage

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Data Lake Storage.
Visualize Live Google Cloud Storage of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Google Cloud Storage using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
Connect Box to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Box using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
How to connect to SAP Concur from IntelliJ

Integrate connectivity to SAP Concur with wizards in IntelliJ.
Connect to MailChimp from PowerBuilder via JDBC

This article demonstrates how to access MailChimp from PowerBuilder using the MailChimp JDBC Driver.
How to Connect to & Open Zoho Books in Microsoft Excel

This article uses the CData ODBC driver for Zoho Books to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
Shippo Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Shippo facts in real time.
Use the CData Software JDBC Driver for HCL Domino in MicroStrategy

Connect to HCL Domino in MicroStrategy Developer using the CData Software JDBC Driver for HCL Domino.
Build Visualizations of Google Campaign Manager 360 in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Campaign Manager 360 in Birst.
Use the CData SSIS Components to Insert New or Update Existing WooCommerce Records from SQL Server

Easily push SQL Server data to WooCommerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into WooCommerce or update existing records with data from a SQL Server database.
Connect to Harvest from a Connection Pool in Jetty

The Harvest JDBC Driver supports connection pooling: This article shows how to connect faster to Harvest from Web apps in Jetty.
Connect to Reckon Accounts Hosted in ACL Analytics

Connect to Reckon Accounts Hosted via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Reckon Accounts Hosted.
Getting Started with the CData ODBC Driver for Presto

Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Presto.
Replicate Multiple NetSuite Accounts via the CData Sync CLI

Replicate multiple NetSuite accounts to one or many databases.
Consume MarkLogic OData Feeds in SAP Lumira

Use the API Server to create data visualizations on MarkLogic feeds that reflect any changes in SAP Lumira.
Query Paylocity as a SQL Server Database in Node.js

Execute SQL Server queries against Paylocity from Node.js.
Query Authorize.Net in DataGrip

Create a Data Source for Authorize.Net in DataGrip and use SQL to query live Authorize.Net.
Create Greenplum Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Greenplum data access from reports, embedded analytics, and more.
How to Connect to Live BigCommerce in Mistral AI Workflows

Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live BigCommerce without replication.
Rapidly Develop Excel-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
Connect to YouTube Analytics from PowerBuilder via JDBC

This article demonstrates how to access YouTube Analytics from PowerBuilder using the YouTube Analytics JDBC Driver.
Publish Reports with Oracle SCM in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Oracle SCM.
Connect to Google Data Catalog Using the Script Function in Claris FileMaker Pro