CData Software Knowledge Base

Visualize Live SAP Ariba Source of Power BI Report Builder in Power BI Service

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

Automated Continuous Amazon Marketplace Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Apache Kafka.

Visualize FTP from Tableau

Use the Tableau Desktop business intelligence tool to connect to FTP Servers.

Automated Continuous SQL Server Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable SQL Server replication to Apache Kafka.

Access Live SAS xpt in SAS JMP via ODBC

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

Automate SendGrid Replication to Couchbase

Use CData Sync to Customize and automate SendGrid replication to Couchbase.

Creating Azure Synapse-Connected Applications in Unqork

You can use CData Connect Cloud to feed Azure Synapse to Unqork and build custom business apps.

Analyze HBase in Infragistics Reveal

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

How to Build an ETL App for Access in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Access in Python with petl.

Connect to Azure Analysis Services from AWS Glue

Use CData Connect Cloud to gain access to live Azure Analysis Services from your AWS Glue jobs.

How to publish and share Facebook Ads dashboards with Tableau Server

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

Create Dynamic MongoDB Grids Using the Infragistics XamDataGrid

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

Connect to Google Drive as an External Source in Dremio

Use the CData JDBC Driver to connect to Google Drive as an External Source in Dremio.

Access Live Asana in TIBCO Data Virtualization

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

Connect to Azure Synapse in DBeaver

Use the CData ODBC Driver to connect to Azure Synapse in DBeaver.

Connect to IBM Informix in Aqua Data Studio

Access IBM Informix from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Analyze Act CRM in R via JDBC

Use standard R functions and the development environment of your choice to analyze Act CRM with the CData JDBC Driver for Act CRM.

How to connect PolyBase to Zoho Inventory

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

Integrate OneNote in Pentaho Data Integration

Build ETL pipelines based on Microsoft OneNote in the Pentaho Data Integration tool.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for LDAP

Provide connectivity to LDAP through an SAP BusinessObjects universe.

How to integrate Metabase with Microsoft Planner

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

Connect to DocuSign in Google Apps Script via SQL Gateway

Use the ODBC Driver for DocuSign and the SQL Gateway to access DocuSign from Google Apps Script.

How to connect to Aha from Google Apps Script

Use CData Software Connect Server to access Aha! in Google Apps Script.

Build a PostgreSQL Interface for Avro using the CData JDBC Driver

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

Build Semantic Layer Views for Microsoft Planner in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Planner.

Add Phoenix to Informatica Enterprise Data Catalog

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

Create Wave Financial-Connected Nintex Workflows

Use CData Software Connect Server to connect to Wave Financial from Nintex Workflow Cloud and build custom workflows using live Wave Financial.

Automated Continuous Azure DevOps Replication to IBM DB2

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

Bridge MariaDB Connectivity with Apache NiFi

Access and process MariaDB in Apache NiFi using the CData JDBC Driver.

Automated Continuous SingleStore Replication to Snowflake

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

Connect to Shippo from PowerBuilder via JDBC

This article demonstrates how to access Shippo from PowerBuilder using the Shippo JDBC Driver.

Connect to WooCommerce in DBArtisan

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

Automated Continuous Avalara AvaTax Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to AlloyDB.

Analyze Zoho Inventory in Looker

Use CData Connect Cloud to connect to Zoho Inventory from Looker and build custom apps using live Zoho Inventory.

Process & Analyze Dropbox in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Dropbox .

Access Dropbox from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Dropbox from HeidiSQL.

Access Live SuiteCRM in Coginiti Pro

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

Automated Continuous Bullhorn CRM Replication to SQL Server

Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to SQL Server.

Query SAP HANA XS Advanced in ColdFusion

Write standard ColdFusion data access code to connect to SAP HANA XS Advanced.

Access Live Presto in Excel (Desktop) through Connect Spreadsheets

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

Connect to FTP in the Denodo Platform

Use CData driver technologies to create a virtual data source for FTP Servers in the Denodo Virtual DataPort Administrator.

Using AngularJS to Build Dynamic Web Pages with Salesforce Pardot

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

Integrate Access with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Access with External Services.

Using AngularJS to Build Dynamic Web Pages with Printful

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

How to work with SendGrid in Apache Spark using SQL

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

Access Live Microsoft Planner in Excel (Desktop) through Connect Spreadsheets

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

Query Epicor Kinetic in ColdFusion

Write standard ColdFusion data access code to connect to Epicor Kinetic.

Visualize Cosmos DB in TIBCO Spotfire through ODBC

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

Creating SAP Hybris C4C-Connected Applications in Unqork

You can use CData Connect Cloud to feed SAP Hybris C4C to Unqork and build custom business apps.

Build Sage Intacct-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Sage Intacct and create custom apps in Mendix.

Connect to OneNote in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for OneNote and connect to Microsoft OneNote in Akorbi Digital RunMyProcess.

Connect to Drip in RunMyProcess through Connect Server

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

Create Informatica Mappings From/To a JDBC Data Source for Azure Data Lake Storage

Create Azure Data Lake Storage data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Import CockroachDB Using Azure Data Factory

Use CData Connect Cloud to connect to CockroachDB from Azure Data Factory and import live CockroachDB.

Build a PostgreSQL Interface for Okta using the CData JDBC Driver

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

Build Amazon Marketplace-Connected Apps in Choreo

Use CData Connect Cloud to connect to Amazon Marketplace from Choreo and build custom apps using live Amazon Marketplace.

Build Shippo Visualizations in Tableau Cloud

Use CData Software Connect Server to create a virtual SQL Server Database for Shippo and build visualizations in Tableau Cloud.

Connect to Spark in NetBeans

Connect to Apache Spark SQL in NetBeans with the data source configuration wizard.

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

Connect to Asana from a connection pool in Tomcat.

Build Apps with Live Microsoft SharePoint in Adalo using CData Connect Cloud

Use CData Connect Cloud to integrate live Microsoft SharePoint into the Adalo platform and build custom mobile and web applications with real-time Microsoft SharePoint.

How to connect to SAP HANA XS Advanced from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for SAP HANA XS Advanced and work with SAP HANA XS Advanced in Microsoft Excel on Mac OS X.

Connect to Oracle HCM Cloud as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle HCM Cloud.

Import Real-Time Microsoft OneDrive via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Microsoft OneDrive in ColdFusion.

Build Charts with HarperDB in Clear Analytics

Create dynamic charts and perform analytics based on HarperDB in Clear Analytics.

Working with Microsoft OneDrive in LINQPad

Execute LINQ queries to Microsoft OneDrive in LINQPad.

Import and Visualize Teradata in Power View

Create data visualizations based on Teradata in Excel.

Build Data Flows from SAP Ariba Procurement to SQL Server using SSIS

Easily back up SAP Ariba Procurement to SQL Server using the SSIS components for SAP Ariba Procurement.

Visualize WooCommerce in TIBCO Spotfire through ADO.NET

Integrate WooCommerce into dashboards in TIBCO Spotfire.

Automated Continuous Klaviyo Replication to SingleStore

Use CData Sync for automated, continuous, customizable Klaviyo replication to SingleStore.

Prepare, Blend, and Analyze Facebook Ads in Alteryx Designer (Connect Cloud)

Build workflows to access live Facebook Ads for self-service data analytics.

Query Sage 200 as a SQL Server Database in Node.js

Execute SQL Server queries against Sage 200 from Node.js.

How to import Amazon S3 into Apache Solr

Use the CData Software JDBC Driver for Amazon S3 in Data Import Handler and create an automated import of Amazon S3 to Apache Solr Enterprise Search platform.

Create Reckon-Connected Applications in Appsmith

Connect to Reckon via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Reckon.

Connect to Sage Cloud Accounting in the Denodo Platform

Use CData driver technologies to create a virtual data source for Sage Business Cloud Accounting in the Denodo Virtual DataPort Administrator.

Build Data Flows from SQL Server to Zoho Inventory through SSIS

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

Process & Analyze CockroachDB in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live CockroachDB .

Use the CData Software ODBC Driver for Amazon Marketplace in MicroStrategy Web

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

Automated Continuous HubSpot Replication to Local Delimited Files

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

Use the CData Software ODBC Driver for YouTube Analytics in MicroStrategy

Connect to YouTube Analytics in MicroStrategy Developer using the CData Software ODBC Driver for YouTube Analytics.

Access Live Microsoft Planner in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Microsoft Planner from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

How to Work with Workday in AWS Glue Jobs Using JDBC

Connect to Workday from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Automated Continuous Zoom Replication to Local Delimited Files

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

Access Outreach.io in PHP through Connect Server

Connect to Outreach.io through the standard SQL Server libraries in PHP.

Replicate Avalara AvaTax to Multiple Databases

Replicate Avalara AvaTax to disparate databases with a point-and-click configuration.

Stream Amazon S3 into Apache Kafka Topics

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

Create Data Visualizations in Cognos BI with Square

Access Square as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Automate ServiceNow Replication to Azure Data Lake

Use CData Sync to customize and automate ServiceNow replication to Azure Data Lake.

Use JayDeBeApi to access Google Spanner in Python

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

Replicate Multiple Workday Accounts

Replicate multiple Workday accounts to one or many databases.

Choosing the Best Method to Connect Sage 200 to SQL Server: 5 Options Explained

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

CData Software - Knowledge Base

Recent Articles