CData Software Knowledge Base

Create Adobe Analytics Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

How to Build an ETL App for Bullhorn CRM in Python with CData

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

How to connect to FTP in DBVisualizer

Integrate FTP Servers with visual data analysis tools and data connection wizards in DBVisualizer

Access Live Asana in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Asana into the statistical analysis tools available in SAS JMP. This article shows how to use Asana in the Graph Builder and Query Builder.

Use the CData Software JDBC Driver for SAP BusinessObjects BI in MicroStrategy Desktop

Connect to SAP BusinessObjects BI in MicroStrategy Desktop using the CData Software JDBC Driver for SAP BusinessObjects BI.

Load HarperDB to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HarperDB to a database.

Connect to IBM Informix as a Linked Server via SQL Gateway

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

Automate Excel Online Replication to Azure Synapse

Use CData Sync to customize and automate Microsoft Excel Online replication to Azure Synapse.

Integrate Slack into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Slack and integrate live Slack into your Power Automate tasks.

Analyze NetSuite in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze NetSuite CRM & ERP in Microsoft R Open.

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

Connect to Google Sheets 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.

Analyze Impala in Infragistics Reveal

Use the CData API Server to create an OData API on top of Apache Impala and visualize live Apache Impala in Ingragistics Reveal.

Automated Continuous SurveyMonkey Replication to Local Delimited Files

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

Automated Continuous Sugar CRM Replication to Vertica

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

Configure the CData JDBC Driver for Cassandra in a Connection Pool in Tomcat

Connect to Apache Cassandra from a connection pool in Tomcat.

Connect to GMO MakeShop from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live GMO MakeShop from Filemaker Pro on Mac.

Use the CData Software ODBC Driver for QuickBooks Time in MicroStrategy Desktop

Connect to QuickBooks Time in MicroStrategy Desktop using the CData Software ODBC Driver for QuickBooks Time.

Query FHIR in ColdFusion

Write standard ColdFusion data access code to connect to FHIR.

Analyze Sugar CRM in Cognos Analytics

Use CData Connect Cloud to connect to Sugar CRM from Cognos Analytics and analyze live Sugar CRM.

Access Live Microsoft Project in Excel 365 Online (Excel for the web)

Connect to Microsoft Project from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Visualize Zoho Books in TIBCO Spotfire through ADO.NET

Integrate Zoho Books into dashboards in TIBCO Spotfire.

Import Real-Time Active Directory via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Active Directory in ColdFusion.

How to connect PolyBase to Box

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

Enable the Reckon JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Reckon.

Create Dynamic Presto Grids Using the Infragistics XamDataGrid

Learn how you can connect Presto to Infragistics XamDataGrid to build dynamic grids.

Configure the CData JDBC Driver for HCL Domino in a Connection Pool in Tomcat

Connect to HCL Domino from a connection pool in Tomcat.

Automated Continuous Todoist Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Todoist replication to Microsoft Access.

Build BCart Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live BCart and build visualizations in Tableau Cloud.

Build a PostgreSQL Interface for Twilio using the CData JDBC Driver

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

How to create an RPA flow for Couchbase in UiPath Studio

Use the Couchbase ODBC Driver to create workflows that access real-time Couchbase without any coding.

Trigger Tableau CRM Analytics IFTTT Flows in Azure App Service

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

Work with CouchDB in FoxPro

Load Apache CouchDB into a FoxPro database. This article includes full code and a walk-through of the process.

Connect to PostgreSQL in Jaspersoft Studio

Execute SQL to remote PostgreSQL in Jaspersoft Studio.

How to Connect to & Open Highrise in Microsoft Excel

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

Natively Connect to Vault CRM in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Veeva Vault & Vault CRM. Leverage the native support for ODBC in PHP.

How to connect to HarperDB from Spring Boot

Connect to HarperDB in a Spring Boot Application using CData JDBC HarperDB Driver

Model, Search, and Visualize Live OData Services in ThoughtSpot

Use CData Connect Cloud to connect to live OData for modeling, searching, and visualizing.

Access Live Backlog in Excel 365 Online (Excel for the web)

Connect to Backlog from Excel 365 Online (Excel for the web) with CData Connect Cloud.

How to Seamlessly Import Aha Data into IBM SPSS Modeler

Integrate Aha data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

Working with SAP HANA XS Advanced in LINQPad

Execute LINQ queries to SAP HANA XS Advanced in LINQPad.

How to Visualize DocuSign Data in Python with pandas

Use pandas and other modules to analyze and visualize live DocuSign in Python.

Create Google Search-Connected Business Apps in AppSheet

Connect to Google Search Results via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Google Search.

Use the CData Software JDBC Driver for Spark in MicroStrategy Desktop

Connect to Apache Spark SQL in MicroStrategy Desktop using the CData Software JDBC Driver for Spark.

Connect to MailChimp from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for MailChimp to connect to MailChimp and execute queries in PowerBuilder.

Use the CData Software ODBC Driver for Google Campaign Manager 360 in MicroStrategy Desktop

Connect to Google Campaign Manager 360 in MicroStrategy Desktop using the CData Software ODBC Driver for Google Campaign Manager 360.

How to Connect to Live Paylocity in n8n Workflows and Agents (via CData Connect Cloud)

Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Paylocity for you.

DataBind Controls to SAP Ariba Source in Delphi

DataBind to SAP Ariba Source in Delphi with standard data access components and controls.

A PostgreSQL Interface for Adobe Target (MySQL Remoting via JDBC)

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

Configure the CData JDBC Driver for Dynamics CRM in a Connection Pool in Tomcat

Connect to Microsoft Dynamics CRM from a connection pool in Tomcat.

CData Software - Knowledge Base

Recent Articles