CData Software Knowledge Base

Build ClickUp-Connected Dashboards in Redash

Use CData Software Connect Server to create a virtual SQL Server Database for ClickUp and build visualizations and dashbaords from ClickUp in Redash.

Validate Twitter with QuerySurge

Access and validate Twitter in QuerySurge using the CData JDBC Driver.

Use the CData Software JDBC Driver for Impala in MicroStrategy Web

Connect to Apache Impala in MicroStrategy Web using the CData Software JDBC Driver for Impala.

Replicate Avalara AvaTax to Multiple Databases via the CData Sync CLI

Replicate Avalara AvaTax to disparate databases with a single configuration.

How to Connect to & Open SAS xpt in Microsoft Excel

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

Create MarkLogic Dataflows on PowerBI.com

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

Access Couchbase from MySQL in Amazon QuickSight

Connect to Couchbase and build visualizations of Couchbase using a MySQL Connection in Amazon QuickSight.

Validate HubSpot with QuerySurge

Access and validate HubSpot in QuerySurge using the CData JDBC Driver.

Create IBM Cloud Object Storage-Connected Nintex Workflows

Use CData Software Connect Server to connect to IBM Cloud Object Storage from Nintex Workflow Cloud and build custom workflows using live IBM Cloud Object Storage.

Build Data Flows from SQL Server to BigCommerce through SSIS

Easily push SQL Server data to BigCommerce using the CData SSIS Tasks for BigCommerce.

Access Live Pinterest in SAS JMP via ODBC

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

Load ConstantContact to a Database Using Embulk

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

Connect to Twilio as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Twilio.

Automated Continuous GitHub Replication to Snowflake

Use CData Sync for automated, continuous, customizable GitHub replication to Snowflake.

Visualize Live Airtable of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Airtable using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

Access Slack in PHP through Connect Server

Connect to Slack through the standard SQL Server libraries in PHP.

Build Google Cloud Storage-Connected ETL Processes in Google Data Fusion

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

Operational Reporting on Oracle Financials Cloud from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Financials Cloud.

Automated Continuous Oracle SCM Replication to Apache Cassandra

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

Automated Continuous IBM Cloud Object Storage Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Amazon Redshift.

Visualize Shopify in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Shopify into TIBCO Spotfire.

Connect to EnterpriseDB in Ruby

Connect to EnterpriseDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to connect and process Adobe Analytics from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Analytics

Using the CData Software ODBC Driver for Wave Financial in PyCharm

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

Using AngularJS to Build Dynamic Web Pages with Invoiced

Use the CData Connect Server to create Invoiced OData feeds and build single-page applications with live Invoiced.

How to create QuickBooks Online federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for QuickBooks Online in MySQL .

Viewing Bing Search Results in RAD Studio Data Explorer

How to view Bing Search in RAD Studio Data Explorer using the CData ODBC Driver for Bing Search.

Connect to Excel in RunMyProcess through Connect Server

Use CData Connect Server to create an OData API for Excel and connect to Microsoft Excel in Akorbi Digital RunMyProcess.

Provide OData Services of Cosmos DB from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Azure Cosmos DB by developing a WCF Service Application.

Connect to Veeva Vault from a Connection Pool in JBoss

Integrate Veeva Vault & Vault CRM into Java servlets: Use the Management Console in JBoss to install the Veeva Vault JDBC Driver.

How to connect Amazon QuickSight to ShipStation

Create a connection to ShipStation in CData Connect Cloud and insert ShipStation into Amazon QuickSight SPICE to build interactive dashboards.

Analyze Live MYOB AccountRight in SAS Viya

Use CData Connect Cloud to connect to MYOB AccountRight from SAS Viya and deploy self-service analytics using live MYOB AccountRight.

Access Azure Analysis Services from MySQL in Amazon QuickSight

Connect to Azure Analysis Services and build visualizations of Azure Analysis Services using a MySQL Connection in Amazon QuickSight.

DataBind Charts to Asana

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Asana from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

Query Basecamp in DataGrip

Create a Data Source for Basecamp in DataGrip and use SQL to query live Basecamp.

How to integrate Reckon with Apache Airflow

Access and process Reckon in Apache Airflow using the CData JDBC Driver.

Creating BambooHR-Connected Applications in Unqork

You can use CData Connect to feed BambooHR to Unqork and build custom business apps.

Access Live Confluence in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Confluence to create a Atlassian Confluence source in TIBCO Data Virtualization Studio and gain access to live Atlassian Confluence from your TDV Server.

Query Zoho CRM as a MySQL Database in Node.js

Execute MySQL queries against Zoho CRM from Node.js.

Replicate MariaDB for Use in Salesforce Connect

Replicate MariaDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Replicate IBM Cloud Object Storage to Multiple Databases

Replicate IBM Cloud Object Storage to disparate databases with a point-and-click configuration.

Enable the Azure Data Lake Storage JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Azure Data Lake Storage.

How to use SQLAlchemy ORM to access Sybase in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sybase.

Connect to Yahoo! Ads from Crystal Reports

Use CData Connect Cloud to connect to and report on live Yahoo! Ads from Crystal Reports.

How to create an RPA flow for Epicor Kinetic in UiPath Studio

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

Access Live Salesforce Data Cloud in AWS Lambda

Connect to live Salesforce Data Cloud in AWS Lambda using the CData JDBC Driver.

Extract, Transform, and Load Outreach.io in Informatica PowerCenter

Create a simple Workflow for Outreach.io in Informatica PowerCenter.

Publish JotForm-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live JotForm.

Use Biml to Build SSIS Tasks to Replicate SendGrid to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendGrid to SQL Server.

How to publish and share SAP Fieldglass dashboards with Tableau Server

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

Create Reports with SharePoint Excel Services in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date SharePoint Excel Services.

Connect to Excel from a Connection Pool in Jetty

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

Integrate Oracle Sales in the Pentaho Report Designer

Publish reports based on Oracle Sales in the Pentaho BI tool.

Automated Continuous Reckon Accounts Hosted Replication to Snowflake

Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Snowflake.

Connect to Klaviyo from Blazor Apps

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

PowerShell Scripting to Replicate GitHub to MySQL

Write a simple PowerShell script to replicate GitHub to a MySQL database.

Connect to Zoho Books from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Books, and over 250 other data sources, right inside your Excel and Google spreadsheets!

Stream SAP SuccessFactors into Apache Kafka Topics

Access and stream SAP SuccessFactors in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Build a PostgreSQL Interface for YouTube Analytics using the CData JDBC Driver

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

Natively Connect to Paylocity in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Paylocity. Leverage the native support for ODBC in PHP.

Automated Continuous Azure Blob Storage Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Microsoft Access.

Create Data Visualizations Based On SAP SuccessFactors in Mode

Use CData Connect Cloud to connect to SAP SuccessFactors from Mode and build visualizations using live

Automated Continuous Salesforce Pardot Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to AlloyDB.

CData Software - Knowledge Base

Recent Articles