CData Software Knowledge Base

Trigger Access IFTTT Flows in Azure App Service

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

Replicate Microsoft OneLake for Use in Salesforce Connect

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

Automated Continuous Google Sheets Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Google Sheets replication to Amazon Redshift.

Office 365 Reporting in OBIEE with the Office 365 JDBC Driver

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

How to connect and process Active Directory from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Active Directory

Visualize CouchDB in Sisense

Create an ElastiCube in Sisense app with access to Apache CouchDB.

Create ActiveCampaign Dataflows on PowerBI.com

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

Analyze Avalara AvaTax in Cognos Analytics

Use CData Connect Cloud to connect to Avalara AvaTax from Cognos Analytics and analyze live Avalara AvaTax.

Connect to Bullhorn CRM in DBeaver

Use the CData ODBC Driver to connect to Bullhorn CRM in DBeaver.

Build Visualizations of Shopify in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Shopify in Birst.

Use the CData Software JDBC Driver for Snowflake in MicroStrategy Desktop

Connect to Snowflake in MicroStrategy Desktop using the CData Software JDBC Driver for Snowflake.

Publish Crystal Reports on WooCommerce

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date WooCommerce.

How to create Visio diagrams from SAP Ariba Source

Automatically update SAP Ariba Source with the changes you make to Visio master shapes.

Establish a Live Connection with SQL Server using Tableau Bridge

The CData ODBC Driver for SQL Server enables you to integrate live Microsoft SQL Server into Tableau Cloud dashboards using the Tableau Bridge.

Create Informatica Mappings From/To a JDBC Data Source for Access

Create Access data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Back Up Google Directory to SQL Server through SSIS

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

Replicate Active Directory to Multiple Databases

Replicate Active Directory to disparate databases with a point-and-click configuration.

Bridge PostgreSQL Connectivity with Apache NiFi

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

Amazon S3 Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Amazon S3 facts in real time.

How to work with Instagram in Apache Spark using SQL

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

Query QuickBooks Online through ODBC in Node.js

Use node-odbc to execute SQL queries against QuickBooks Online from Node.js.

Import and Visualize Microsoft Project in Power View

Create data visualizations based on Microsoft Project in Excel.

Access Phoenix as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Phoenix from your Oracle system.

How to Seamlessly Import Twilio Data into IBM SPSS Modeler

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

Connect to eBay in RazorSQL

Connect to eBay from wizards and query eBay from the GUI in the RazorSQL database management tool.

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

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

Access Spark in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Apache Spark SQL.

Access Wave Financial from MySQL in PHP

Connect to Wave Financial through the standard MySQL libraries in PHP.

Consume Drift OData Feeds in PowerBuilder

This article demonstrates how to consume Drift as OData feeds from PowerBuilder using the API Server.

How to connect PolyBase to Salesforce Pardot

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

Replicate Zoho Creator to Multiple Databases via the CData Sync CLI

Replicate Zoho Creator to disparate databases with a single configuration.

Create Google Ads-Connected Nintex Workflows

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

Enable the ShipStation JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with ShipStation.

Connect to Printful from a Connection Pool in JBoss

Integrate Printful into Java servlets: Use the Management Console in JBoss to install the Printful JDBC Driver.

Publish 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.

Use the CData Software JDBC Driver for Cassandra in MicroStrategy Web

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

Validate Square with QuerySurge

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

How to Connect to SAP Netweaver Gateway in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to SAP Netweaver Gateway. Leverage the pyodbc module for ODBC in Python.

Automate ShipStation Replication to Azure Data Lake

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

How to connect PolyBase to PingOne

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

Connect to Act CRM from Crystal Reports

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

Add SAP SuccessFactors to Informatica Enterprise Data Catalog

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

Visualize Oracle Eloqua in TIBCO Spotfire through ODBC

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

Extend Google Sheets with Amazon S3

Make calls to the API Server from Google Apps Script.

Create Data Visualizations Based On Oracle Service Cloud in Mode

Use CData Connect Cloud to connect to Oracle Service Cloud from Mode and build visualizations using live

Access Live Azure Analysis Services in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Azure Analysis Services from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

Access Live Outreach.io in SAS JMP via ODBC

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

Process & Analyze Drip in Databricks (AWS)

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

Connect to Printify in RazorSQL

Connect to Printify from wizards and query Printify from the GUI in the RazorSQL database management tool.

Access Live MYOB AccountRight in Excel (Desktop) via Connect Cloud

Use CData Connect Cloud to gain access to live MYOB AccountRight from your Excel spreadsheets.

ETL JDBC-ODBC Bridge in Oracle Data Integrator

This article shows how to transfer JDBC-ODBC Bridge into a data warehouse using Oracle Data Integrator.

Automated Continuous Sage Cloud Accounting Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to AlloyDB.

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

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

Use the CData Software JDBC Driver for Cvent in MicroStrategy Desktop

Connect to Cvent in MicroStrategy Desktop using the CData Software JDBC Driver for Cvent.

Creating Amazon DynamoDB-Connected Applications in Unqork

You can use CData Connect Cloud to feed Amazon DynamoDB to Unqork and build custom business apps.

Integrate with SAP HANA using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP HANA to a JSON file on disk.

ETL SAP in Oracle Data Integrator

This article shows how to transfer SAP ERP/NetWeaver into a data warehouse using Oracle Data Integrator.

Connect to Presto from a Connection Pool in JBoss

Integrate Presto into Java servlets: Use the Management Console in JBoss to install the Presto JDBC Driver.

Connect to PingOne in the Denodo Platform

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

Use the CData Software JDBC Driver for Azure Table in MicroStrategy

Connect to Azure Table Storage in MicroStrategy Developer using the CData Software JDBC Driver for Azure Table.

Analyze Quickbase with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Quickbase from Power Pivot. You will use the Table Import Wizard to load Quickbase. You can visually build the import query or use any SQL supported by the driver.

Use the CData Software ODBC Driver for Redis in MicroStrategy

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

Use the CData API Server in Microsoft Power BI

You can use the CData API Server to feed SAP Business ByDesign to Power BI dashboards. Simply drag and drop SAP Business ByDesign into data visuals on the Power BI canvas.

Create Data Visualizations Based On Hive in Mode

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

View Reports on Real-Time Excel Online in Power BI Report Server

Use the CData ODBC Driver for Excel Online to visualize Microsoft Excel Online in Power BI Desktop and then publish them to Power BI Report Server.

Invoiced Reporting in OBIEE with the Invoiced JDBC Driver

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

Visualize SAP Hybris C4C in Tableau

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

Publish Reports with xBase in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date xBase.

DataBind Controls to MongoDB in Delphi

DataBind to MongoDB in Delphi with standard data access components and controls.

Use Dash to Build to Web Apps on Adobe Commerce

Create Python applications that use pandas and Dash to build Adobe Commerce-connected web apps.

Automated Continuous Pinterest Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Pinterest replication to Google BigQuery.

Connect to Sage 300 as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage 300.

Excel Spreadsheet Automation on Sage 50 UK with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Build Automated Adobe Analytics-Connected Workflows in Zapier

Use CData Connect Cloud to connect to live Adobe Analytics and build automated workflows in Zapier.

Import Twitter Ads Using Azure Data Factory

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

Visualize Live Zendesk in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Zendesk into custom reports in Power BI.

How to load Google Search data into Elasticsearch via Logstash

Introducing a simple method to load Google Search data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

How to Query EnterpriseDB in MySQL Workbench

Execute MySQL queries against live EnterpriseDB from MySQL Workbench.

Natively Connect to Square in PHP

The CData ODBC driver for Square enables you to create PHP applications with connectivity to Square. Leverage the native support for ODBC in PHP.

Analyze Kafka in R via JDBC

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

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Books

Provide connectivity to Zoho Books through an SAP BusinessObjects universe.

Extend Google Sheets with Typeform

Make calls to the API Server from Google Apps Script.

Feed Shippo into FineReport

How to set Shippo as a JDBC data source in FineReport.

Connect to Twitter in NetBeans

Connect to Twitter in NetBeans with the data source configuration wizard.

Integrate with MariaDB in JReport Designer

Create charts and reports based on MariaDB in JReport Designer.

Automate Neo4J Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Neo4J from PowerShell? This article demonstrates how to utilize the Neo4J Cmdlets for tasks like connecting to Neo4J, automating operations, downloading data, and more.

Connect to SAS Data Sets in DBeaver

Use the CData ODBC Driver to connect to SAS Data Sets in DBeaver.

Analyze SQL Server with Power Pivot

This article walks you through the process of using the CData ODBC Driver for SQL Server from Power Pivot. You will use the Table Import Wizard to load Microsoft SQL Server. You can visually build the import query or use any SQL supported by the driver.

CData Software - Knowledge Base

Recent Articles