CData Software Knowledge Base

Prepare, Blend, and Analyze Adobe Analytics in Alteryx Designer (Connect Cloud)

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

Bind Live Sybase IQ Data in Wijmo FlexGrid with CData API Server

With CData API Server, easily create OData endpoints for live Sybase IQ data

Integrate Google Calendar in Pentaho Data Integration

Build ETL pipelines based on Google Calendar in the Pentaho Data Integration tool.

Write a Simple Go Application to work with OData Services on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to OData.

Build Google Campaign Manager 360-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Google Campaign Manager 360 and create custom apps in Bubble.

A PostgreSQL Interface for Dynamics NAV using the CData ODBC Driver

Use the SQL Gateway and Dynamics NAV ODBC Driver to create a PostgreSQL entry-point for data access.

Access Live Spark in AWS Lambda

Connect to live Apache Spark SQL in AWS Lambda using the CData JDBC Driver.

How to Work with Dynamics 365 Business Central in ETL Validator JDBC

Connect to Dynamics 365 Business Central from ETL Validator jobs using the CData Software JDBC Driver.

A PostgreSQL Interface for SAP Hybris C4C using the CData ODBC Driver

Use the SQL Gateway and SAP Hybris C4C ODBC Driver to create a PostgreSQL entry-point for data access.

Connect to Greenplum in JRuby

Create a simple JRuby app with access to live Pivotal GreenPlum.

Replicate Oracle Sales to Multiple Databases

Replicate Oracle Sales to disparate databases with a point-and-click configuration.

Build eBay-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to eBay from Zoho Analytics and import live eBay.

Access Live Google Sheets in Coginiti Pro

Connect to and query live Google Sheets from the GUI in the Coginiti Pro: SQL Analytics Tool.

Migrating data from MailChimp to Snowflake using CData SSIS Components.

Easily push MailChimp to Snowflake using the CData SSIS Tasks for MailChimp and Snowflake.

Access Raisers Edge NXT from MySQL in Amazon QuickSight

Connect to Raisers Edge NXT and build visualizations of Raisers Edge NXT using a MySQL Connection in Amazon QuickSight.

Bridge Reckon Accounts Hosted Connectivity with Apache NiFi

Access and process Reckon Accounts Hosted in Apache NiFi using the CData JDBC Driver.

Connect to Oracle HCM Cloud 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 Oracle HCM Cloud.

Import and Visualize Workday in Power View

Create data visualizations based on Workday in Excel.

Connect to API from Crystal Reports

Use CData Connect Cloud to connect to and report on live API from Crystal Reports.

Creating Microsoft Teams-Connected Applications in Unqork

You can use CData Connect Cloud to feed Microsoft Teams to Unqork and build custom business apps.

Stream Printify into Apache Kafka Topics

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

How to connect PolyBase to Salesforce

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce & Force.com.

How to work with Highrise in Apache Spark using SQL

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

Analyze Live Facebook in SAS Viya

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

Work with Neo4J in FoxPro

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

How to Work with SAP Fieldglass in ETL Validator JDBC

Connect to SAP Fieldglass from ETL Validator jobs using the CData Software JDBC Driver.

Access Live Facebook in Excel (Desktop) through Connect Spreadsheets

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

Build a PostgreSQL Interface for SQL Server using the CData JDBC Driver

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

Connect Slack to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

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

Connect HubSpot to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

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

Visualize Live ConstantContact in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live ConstantContact.

Publish Outreach.io-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Outreach.io.

Build a PostgreSQL Interface for Parquet using the CData JDBC Driver

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

Analyze Bullhorn CRM in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Bullhorn CRM and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

Use CData Connect Cloud to Access SAP HANA in Microsoft Power Pivot

Use CData Connect Cloud to connect to live SAP HANA in the Power Pivot business intelligence tool.

Automated Continuous Google Directory Replication to Vertica

Use CData Sync for automated, continuous, customizable Google Directory replication to Vertica.

Import TaxJar into Microsoft Power Query

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

Create SSAS Tabular Models from Azure Data Catalog

How to build a SQL Server Analysis Service Tabular Model from Azure Data Catalog using CData drivers.

Connect to Google Calendar from Excel & GoogleSheets!

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

Visualize Pipedrive in Tableau

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

Import and Visualize Impala in Power View

Create data visualizations based on Apache Impala in Excel.

Access Live Neo4J in SAS JMP via ODBC

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

Build Automated LinkedIn Ads-Connected Workflows in Zapier

Use CData Connect Cloud to connect to live LinkedIn Ads and build automated workflows in Zapier.

Invoiced Reporting in OBIEE with the Invoiced JDBC Driver

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

How to Connect to & Open Snowflake in Microsoft Excel

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

Automated OneNote Replication to Teradata

Use CData Sync to Customize and automate Microsoft OneNote replication to Teradata.

Connect to Phoenix from a Connection Pool in WebLogic

Use the CData JDBC Driver for Phoenix to connect to Apache Phoenix from Web applications running on WebLogic.

Connect to Google Ads from Excel & GoogleSheets!

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

Query Sage 200 using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Sage 200 entities in PHP by modeling them as objects.

How to connect and process Sybase from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Sybase.

Build PCA Sales-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live PCA Sales.

Validate CSV with QuerySurge

Access and validate CSV/TSV Files in QuerySurge using the CData JDBC Driver.

Using the CData Software ODBC Driver for Sybase IQ in PyCharm

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

Automated Continuous Redis Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Redis replication to OneLake in Microsoft Fabric.

How to create an RPA flow for SAS xpt in UiPath Studio

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

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

Connect to Google BigQuery from a connection pool in Tomcat.

How to update Tableau CRM Analytics from Excel

This article explains how to transfer data from Excel to Tableau CRM Analytics using the Excel Add-In for Tableau CRM Analytics.

Create MariaDB-Connected Nintex Workflows

Use CData Connect Cloud to connect to MariaDB from Nintex Workflow Cloud and build custom workflows using live MariaDB.

Choosing the Best Method to Connect Exact Online to SQL Server: 5 Options Explained

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

Build an OLAP Cube in SSAS from Azure Table

Establish a connection to Azure Table Storage data from SQL Server Analysis Services, and use the Azure Table Data Provider to build OLAP cubes for use in analytics and reporting.

How to update Xero from Excel

This article explains how to transfer data from Excel to Xero using the Excel Add-In for Xero.

How to Query Act-On in MySQL Workbench

Execute MySQL queries against live Act-On from MySQL Workbench.

View Reports on Real-Time Oracle Eloqua in Power BI Report Server

Use the CData ODBC Driver for Oracle Eloqua to visualize Oracle Eloqua in Power BI Desktop and then publish them to Power BI Report Server.

CData SSIS Packages for Azure Data Factory

CData and Microsoft have partnered to make it easy to use CData SSIS Components within Azure Data Factory (ADF)

Build Workday-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Workday and create custom apps in Bubble.

Query ClickUp in ColdFusion

Write standard ColdFusion data access code to connect to ClickUp.

Automated Continuous MariaDB Replication to IBM DB2

Use CData Sync for automated, continuous, customizable MariaDB replication to IBM DB2.

CData Software - Knowledge Base

Recent Articles