CData Software Knowledge Base

Automated Continuous Asana Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Asana replication to Apache Cassandra.

Query Bing Ads in MySQL Workbench

Create a virtual MySQL database for Bing Ads in CData Software Connect (or Connect Server) and work with live Bing Ads in MySQL Workbench.

Connect to Dynamics 365 Business Central in NetBeans

Connect to Dynamics 365 Business Central in NetBeans with the data source configuration wizard.

Query AlloyDB through ODBC in Node.js

Use node-odbc to execute SQL queries against Google AlloyDB from Node.js.

Connect to Okta in DBArtisan

Use wizards in DBArtisan to configure Okta as a data source.

Back Up Google Sheets to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Sheets. In this article, we will employ an SSIS workflow to populate a database with Google Sheets data.

Load Pipedrive to a Database Using Embulk

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

Visualize IBM Cloud Object Storage in TIBCO Spotfire through OData

Integrate IBM Cloud Object Storage into dashboards in TIBCO Spotfire.

Build Automated Workflows with Live Acumatica in Workato

Use CData Connect Cloud to connect to live Acumatica ERP and build automated workflows in Workato.

Connect to Snowflake in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Connect to Sage 300 from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Sage 300 using standard SQL.

Feed SAP HANA into FineReport

How to set SAP HANA as a JDBC data source in FineReport.

DataBind Controls to Sage 50 UK in C++Builder

DataBind to Sage 50 UK in C++Builder with standard components and controls.

Integrate SAP SuccessFactors in Pentaho Data Integration

Build ETL pipelines based on SAP SuccessFactors in the Pentaho Data Integration tool.

Automated Continuous Bullhorn CRM Replication to Microsoft Access

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

Import HBase into Microsoft Power Query

The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Apache HBase. In this article, you will use the OData format to import Apache HBase into Microsoft Power Query.

Build SAP Netweaver Gateway-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to SAP Netweaver Gateway and build web apps with connectivity to live SAP Netweaver Gateway.

Replicate Pipedrive to Multiple Databases via the CData Sync CLI

Replicate Pipedrive to disparate databases with a single configuration.

Connect to eBay in Jaspersoft Studio

Execute SQL to remote eBay in Jaspersoft Studio.

PowerShell Scripting to Replicate Snapchat Ads to MySQL

Write a simple PowerShell script to replicate Snapchat Ads to a MySQL database.

Connect to DocuSign in DBeaver

Use the CData ODBC Driver to connect to DocuSign in DBeaver.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle HCM Cloud

Provide connectivity to Oracle HCM Cloud through an SAP BusinessObjects universe.

Use JayDeBeApi to access BigCommerce in Python

Use standard Python scripting and the development environment of your choice to access live BigCommerce.

Visualize Smartsheet in Tableau

The CData ODBC driver for Smartsheet enables you integrate Smartsheet into Tableau dashboards.

Parquet Reporting in OBIEE with the Parquet JDBC Driver

Deploy the Parquet JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Build Xero-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live Xero Accounting and build Xero-connected web apps with Axios.

Access Azure Synapse as a Remote Oracle Database

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

Add Twitter Ads to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Twitter Ads with the Informatica Enterprise Data Catalog to classify and organize data.

Use the CData Software ODBC Driver for Twitter Ads in MicroStrategy Desktop

Connect to Twitter Ads in MicroStrategy Desktop using the CData Software ODBC Driver for Twitter Ads.

Use the CData Software ODBC Driver for Klipfolio in MicroStrategy Web

Connect to Klipfolio in MicroStrategy Web using the CData Software ODBC Driver for Klipfolio.

Google Campaign Manager 360 Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Campaign Manager 360 through CData Connect Cloud using different applications and tools.

How to work with Acumatica in Apache Spark using SQL

Access and process Acumatica in Apache Spark using the CData Software JDBC Driver.

Connect to HDFS in SpagoBI

Create reports featuring live Apache HDFS in SpagoBI Studio. Host HDFS reports on SpagoBI Server.

Access Live IBM Informix in AWS Lambda (with IntelliJ IDEA)

Connect to live IBM Informix in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

How to work with SAP HANA in Apache Spark using SQL

Access and process SAP HANA in Apache Spark using the CData Software JDBC Driver.

Build Visualizations of Live Sybase in Power BI (through CData Connect)

Use CData Connect to create a virtual database for Sybase and build custom reports in Power BI.

Model Sage Intacct Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Sage Intacct, enabling the direct import of real-time Sage Intacct.

Connect to Spark in Jaspersoft Studio

Execute SQL to remote Apache Spark SQL in Jaspersoft Studio.

Integrate Live MarkLogic into Custom Business Apps Built in Power Apps

Use CData Software Connect Server to create a virtual SQL Server Database for MarkLogic and integrate live MarkLogic into apps built in Microsoft Power Apps.

How to create Visio diagrams from Pipedrive

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

Connect to Oracle HCM Cloud from PowerBuilder via ODBC

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

Seamlessly Bring Zoho Projects into Retool Using CData Connect Cloud

Integrate Zoho Projects data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

Access Presto from MySQL in PHP

Connect to Presto through the standard MySQL libraries in PHP.

Create Apps from Square in Qlik Sense Cloud

Use CData Connect Cloud to connect to Square and build apps from live Square in Qlik Sense Cloud.

Create Act CRM-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Act CRM from Klipfolio and build custom visualizations using live Act CRM.

Connect to Live MariaDB in PostGresSQL Interface through CData Connect Cloud

Create a live connection to MariaDB in CData Connect Cloud and connect to your MariaDB from PostgreSQL.

Automate ConstantContact Replication to Azure Synapse

Use CData Sync to customize and automate ConstantContact replication to Azure Synapse.

DataBind Controls to eBay in C++Builder

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

Connect to IBM Cloud Object Storage from a Connection Pool in JBoss

Integrate IBM Cloud Object Storage into Java servlets: Use the Management Console in JBoss to install the IBM Cloud Object Storage JDBC Driver.

How to connect to MYOB AccountRight from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for MYOB AccountRight and work with MYOB AccountRight in Microsoft Excel on Mac OS X.

How to integrate Metabase with Paylocity

Use CData Connect Cloud to connect to live Paylocity and create an interactive dashboard in Metabase from Paylocity.

Query Databricks in MySQL Workbench

Create a virtual MySQL database for Databricks in CData Software Connect (or Connect Server) and work with live Databricks in MySQL Workbench.

CData Software - Knowledge Base

Recent Articles