CData Software Knowledge Base

Analyze Live Amazon Marketplace in SAS Viya

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

Connect to Acumatica 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 Acumatica ERP.

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

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

Visualize Live Tally in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Tally ERP.

Automated Continuous Facebook Ads Replication to Databricks

Use CData Sync for automated, continuous, customizable Facebook Ads replication to Databricks.

Access Azure Data Lake Storage as a Remote Oracle Database

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

How to Import Data from CSV into Google Sheets

Import CSV/TSV Files into a Google spreadsheet that is automatically refreshed.

How to Visualize SAP SuccessFactors Data in Python with pandas

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

Import and Visualize Google Cloud Storage in Power View

Create data visualizations based on Google Cloud Storage in Excel.

Migrating data from Redshift to Databricks using CData SSIS Components.

Easily push Amazon Redshift to Databricks using the CData SSIS Tasks for Redshift and Databricks.

Build Automated Amazon Marketplace-Connected Workflows in Zapier

Use CData Connect Cloud to connect to live Amazon Marketplace and build automated workflows in Zapier.

Trigger Dynamics 365 IFTTT Flows in Azure App Service

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

Create Yahoo! Japan Data Solution-Connected Business Apps in AppSheet

Connect to Yahoo! Japan Data Solution via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Yahoo! Japan Data Solution.

How to create HCL Domino federated tables in MySQL

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

Connect to Google Campaign Manager 360 from a Connection Pool in Jetty

The Google Campaign Manager 360 JDBC Driver supports connection pooling: This article shows how to connect faster to Google Campaign Manager 360 from Web apps in Jetty.

How to Work with CSV in ETL Validator JDBC

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

Automated Continuous Facebook Ads Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Facebook Ads replication to AlloyDB.

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

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

Import SingleStore into Microsoft Power Query

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

Work with Vault CRM in FoxPro

Load Veeva Vault & Vault CRM into a FoxPro database. This article includes full code and a walk-through of the process.

Create MySQL-Connected Dashboards in Grafana

Connect to MySQL via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to MySQL.

Connect to Twilio as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Twilio.

Build EventBrite-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Eventbrite and build web apps with connectivity to live Eventbrite.

Build Pipelines with Live GitHub in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to GitHub from Google Cloud Data Fusion, enabling the integration of live GitHub into the building and management of effective data pipelines.

Use the CData API Server to Access Oracle HCM Cloud in Microsoft PowerPivot

Use the CData API Server to connect to live Oracle HCM Cloud in the Power Pivot business intelligence tool.

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

Connect to JSON 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.

Use the CData Software ODBC Driver for Google Ads in SAS for Real-Time Reporting and Analytics

Connect to real-time Google Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Ads.

Connect to Live Facebook in MicroStrategy through CData Connect Cloud

Create a live connection to Facebook in CData Connect Cloud and connect to your Facebook from MicroStrategy.

Integrate with ADP in SnapLogic

Use CData Connect Cloud to connect to and integrate with live ADP in SnapLogic.

How to Seamlessly Import Hive Data into IBM SPSS Modeler

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

Connect to SharePoint in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Microsoft SharePoint in Airbyte.

Create Apps from Databricks in Qlik Sense Cloud

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

Automated Continuous Xero Replication to Vertica

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

Easily Integrate Zoho CRM in Lazarus Pascal IDE

Learn how to easily integrate live Zoho CRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

Access Live Acumatica Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live Acumatica data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

Visualize Klipfolio in Sisense

Create an ElastiCube in Sisense app with access to Klipfolio.

Build a Simple VCL Application for Cassandra

How to build a simple VCL Application to view Apache Cassandra in RAD Studio using the CData ODBC Driver for Cassandra.

Connect to JSON Services in Aqua Data Studio

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

Extend Google Sheets with YouTube Analytics

Make calls to the API Server from Google Apps Script.

Connect to XML as an External Source in Dremio

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

Back Up Kintone to SQL Server through SSIS

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

Build Zoho Creator-Connected Dashboards Using Zoho Analytics

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

Integrate Avalara AvaTax in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Avalara AvaTax from Informatica Cloud.

Create Datasets from CouchDB in Domo Workbench and Build Visualizations of CouchDB in Domo

Use the CData Software ODBC Driver for CouchDB to create datasets from Apache CouchDB in Domo Workbench and then build visualizations in the Domo service.

Access Live Amazon Athena in SAS JMP via ODBC

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

Connect to Raisers Edge NXT in ACL Analytics

Connect to Raisers Edge NXT via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Raisers Edge NXT.

CData Software - Knowledge Base

Recent Articles