Shopify Integration Guides and Tutorials

Prepare, Blend, and Analyze Shopify in Alteryx Designer (ODBC)

Alteryx Designer

Work with Live Shopify Data in Alteryx Designer (Connect Cloud)

Amazon QuickSight

Build Interactive Dashboards from Shopify Data in Amazon QuickSight

Amazon SageMaker

Integrate Live Shopify data into Amazon SageMaker Canvas

Aqua Data Studio

Connect to Shopify in Aqua Data Studio

AWS Databricks

Process & Analyze Shopify Data in Databricks (AWS)

Azure Analysis Services

Model Shopify Data Using Azure Analysis Services

Birst

Build Visualizations of Shopify in Birst

BIRT

Design BIRT Reports on Shopify

Clear Analytics

Build Charts with Shopify in Clear Analytics

Cognos Analytics (On-Prem)

Analyze Shopify Data in Cognos Analytics

DBxtra

Build Dashboards with Shopify in DBxtra

Domo

Create Datasets from Shopify in Domo Workbench

Dundas BI

Build Dashboards with Shopify in Dundas BI

Excel (on Mac OS)

Work with Shopify Data in MS Excel on Mac OS X

FineReport

Feed Shopify into FineReport

Google Sheets

Access Live Shopify Data in Google Sheets

IBM Cognos BI

Create Data Visualizations in Cognos BI with Shopify

Infragistics Reveal

Analyze Shopify Data in Infragistics Reval

JasperServer

Create Shopify Reports on JasperReports Server

Jaspersoft BI Suite

Connect to Shopify in Jaspersoft Studio

JReport Designer

Integrate with Shopify in JReport Designer

Klipfolio

Create Shopify-Connected Visualizations in Klipfolio

KNIME

Enable the Shopify JDBC Driver in KNIME

LINQPad

Working with Shopify in LINQPad

Looker

Analyze Shopify Data in Looker

Looker Studio

Create Reports from Shopify Data in Looker Studio

Metabase

Create Interactive Shopify-Connected Metabase Dashboards

Microsoft Excel

Access Live Shopify Data in Excel Desktop

Microsoft Excel for the Web

Access Live Shopify Data in Excel for the Web

Microsoft SSAS

Build an OLAP Cube in SSAS from Shopify

MicroStrategy

Connect to Live Shopify Data in MicroStrategy through Connect Cloud

MicroStrategy

Use the CData JDBC Driver for Shopify in MicroStrategy

Microstrategy Desktop

Use the CData JDBC Driver for Shopify in MicroStrategy Desktop

Microstrategy Web

Use the CData JDBC Driver for Shopify in MicroStrategy Web

Mode Analytics

Create Shopify-Connected Visualizations in Mode

OBIEE

Shopify Reporting in OBIEE with the Shopify JDBC Driver

pandas

Use pandas to Visualize Shopify in Python

Pentaho Report Designer

Integrate Shopify in the Pentaho Report Designer

Power BI Desktop

Power BI

Author Power BI Reports on Real-Time Shopify

Power BI Service

Visualize Live Shopify Data in the Power BI Service

Power Pivot

Access Shopify Data in Microsoft Power Pivot

Power Query

Access Shopify Data in Microsoft Power Query

Qlik Cloud

Create Apps from Shopify Data in Qlik Sense Cloud

QlikView

Connect to and Query Shopify in QlikView over ODBC

Analyze Shopify in R (JDBC)

Analyze Shopify in R (ODBC)

RapidMiner

Connect to Shopify in RapidMiner

Redash

Build Shopify-Connected Dashboards in Redash

SAP Analytics Cloud

Analyze Shopify Data in SAP Analytics Cloud

SAP Business Objects

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

SAP Crystal Reports

Publish Reports with Shopify in Crystal Reports

SAS

Use the CData ODBC Driver for Shopify in SAS for Real-Time Reporting and Analytics

SAS JMP

Use the CData ODBC Driver for Shopify in SAS JMP

SAS Viya

Analyze Live Shopify Data in SAS Viya

Sisense

Visualize Live Shopify in Sisense

Spago BI

Connect to Shopify in SpagoBI

Tableau

Visualize Shopify in Tableau Desktop

Tableau Cloud

Build Shopify Visualizations in Tableau Cloud

Tableau Server

Tableau

Publish Shopify-Connected Dashboards in Tableau Server

TIBCO Spotfire

Visualize Shopify in TIBCO Spotfire through ADO.NET

TIBCO Spotfire

Visualize Shopify Data in TIBCO Spotfire

TIBCO Spotfire Server

Operational Reporting on Shopify from Spotfire Server

Visio

Link Visio Shapes to Shopify

Zoho Analytics

Create Shopify-Connected Dashboards in Zoho Analytics

Product	Technology	Article Title
Airbyte	Connect Cloud	Connect to Shopify Data in Airbyte ELT Pipelines
Amazon Redshift	CData Sync	Automated Continuous Shopify Replication to Amazon Redshift
Amazon S3	CData Sync	Automated Continuous Shopify Replication to Amazon S3
Apache Airflow	JDBC	Bridge Shopify Connectivity with Apache Airflow
Apache Camel	JDBC	Integrate with Shopify using Apache Camel
Apache Cassandra	CData Sync	Automated Continuous Shopify Replication to Apache Cassandra
Apache Kafka	CData Sync	Automated Continuous Shopify Replication to Apache Kafka
Apache NiFi	JDBC	Bridge Shopify Connectivity with Apache NiFi
Apache NiFi Batch Operations	JDBC	Perform Batch Operations with Shopify Data in Apache NiFi
AWS Glue	Connect Cloud	Build ETL Jobs with Shopify Data in AWS Glue Jobs
Azure Data Factory	Connect Cloud	Import Shopify Data Using Azure Data Factory
Azure Data Lake	CData Sync	Automated Continuous Shopify Replication to Azure Data Lake
Azure Synapse	CData Sync	Automated Continuous Shopify Replication to Azure Synapse
BIML	SSIS	Use Biml to Build SSIS Tasks to Replicate Shopify to SQL Server
CloverDX	JDBC	Connect to Shopify in CloverDX (formerly CloverETL)
Couchbase	CData Sync	Automated Continuous Shopify Replication to Couchbase
CSV	CData Sync	Automated Continuous Shopify Replication to Local Delimited Files
Databricks	CData Sync	Automated Continuous Shopify Replication to Databricks
FoxPro	ODBC	Work with Shopify in FoxPro
Google AlloyDB	CData Sync	Automated Continuous Shopify Replication to Google AlloyDB
Google BigQuery	CData Sync	Automated Continuous Shopify Replication to Google BigQuery
Google Cloud SQL	CData Sync	Automated Continuous Shopify Replication to Google Cloud SQL
Google Data Fusion	JDBC	Build Shopify-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce Connect	CData Sync	Replicate Shopify for Use in Salesforce Connect
HULFT Integrate	JDBC	Connect to Shopify in HULFT Integrate
IBM DB2	CData Sync	Automated Continuous Shopify Replication to IBM DB2
Informatica Cloud	JDBC	Integrate Shopify in Your Informatica Cloud Instance
Informatica PowerCenter	JDBC	Create Informatica Mappings From/To a JDBC Data Source for Shopify
Jaspersoft ETL	JDBC	Connect to Shopify in Jaspersoft Studio
Microsoft Access	CData Sync	Automated Continuous Shopify Replication to Microsoft Access
Microsoft Azure Tables	CData Sync	Automated Continuous Shopify Replication to Azure SQL
Microsoft Excel	Excel	Transfer Data from Excel to Shopify
Microsoft Power Automate	Connect Cloud	Build Shopify-Connected Automated Tasks with Power Automate (Desktop)
MongoDB	CData Sync	Automated Continuous Shopify Replication to MongoDB
MySQL	CData Sync	Automated Continuous Shopify Replication to MySQL
Oracle Data Integrator	JDBC	ETL Shopify in Oracle Data Integrator
Oracle Database	CData Sync	Automated Continuous Shopify Replication to Oracle
petl	Python	Extract, Transform, and Load Shopify in Python
PostgreSQL	CData Sync	Automated Continuous Shopify Replication to PostgreSQL
Replicate to MySQL	PowerShell	Replicate Shopify to MySQL with PowerShell
SAP HANA	CData Sync	Automated Continuous Shopify Replication to SAP HANA
SingleStore	CData Sync	Automated Continuous Shopify Replication to SingleStore
SnapLogic	JDBC	Integrate Shopify with External Services using SnapLogic
Snowflake	CData Sync	Automated Continuous Shopify Replication to Snowflake
SQL Server	CData Sync	Automated Continuous Shopify Replication to SQL Server
SQL Server Linked Server	Connect Cloud	Connect to Shopify Data as a SQL Server Linked Server
SQLite	CData Sync	Automated Continuous Shopify Replication to SQLite
Talend	JDBC	Connect to Shopify and Transfer Data in Talend
UiPath Studio	ODBC	Create an RPA Flow that Connects to Shopify in UiPath Studio
Vertica	CData Sync	Automated Continuous Shopify Replication to a Vertica Database

Product

Technology

Article Title

Airbyte

Connect to Shopify Data in Airbyte ELT Pipelines

Amazon Redshift

Automated Continuous Shopify Replication to Amazon Redshift

Amazon S3

Automated Continuous Shopify Replication to Amazon S3

Apache Airflow

Bridge Shopify Connectivity with Apache Airflow

Apache Camel

Integrate with Shopify using Apache Camel

Apache Cassandra

Automated Continuous Shopify Replication to Apache Cassandra

Apache Kafka

Automated Continuous Shopify Replication to Apache Kafka

Apache NiFi

Bridge Shopify Connectivity with Apache NiFi

Apache NiFi Batch Operations

Perform Batch Operations with Shopify Data in Apache NiFi

AWS Glue

Build ETL Jobs with Shopify Data in AWS Glue Jobs

Azure Data Factory

Import Shopify Data Using Azure Data Factory

Azure Data Lake

Automated Continuous Shopify Replication to Azure Data Lake

Azure Synapse

Automated Continuous Shopify Replication to Azure Synapse

BIML

SSIS

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

CloverDX

Connect to Shopify in CloverDX (formerly CloverETL)

Couchbase

Automated Continuous Shopify Replication to Couchbase

CSV

Automated Continuous Shopify Replication to Local Delimited Files

Databricks

Automated Continuous Shopify Replication to Databricks

FoxPro

Work with Shopify in FoxPro

Google AlloyDB

Automated Continuous Shopify Replication to Google AlloyDB

Google BigQuery

Automated Continuous Shopify Replication to Google BigQuery

Google Cloud SQL

Automated Continuous Shopify Replication to Google Cloud SQL

Google Data Fusion

Build Shopify-Connected ETL Processes in Google Data Fusion

Heroku / Salesforce Connect

Replicate Shopify for Use in Salesforce Connect

HULFT Integrate

Connect to Shopify in HULFT Integrate

IBM DB2

Automated Continuous Shopify Replication to IBM DB2

Informatica Cloud

Integrate Shopify in Your Informatica Cloud Instance

Informatica PowerCenter

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

Jaspersoft ETL

Connect to Shopify in Jaspersoft Studio

Microsoft Access

Automated Continuous Shopify Replication to Microsoft Access

Microsoft Azure Tables

Automated Continuous Shopify Replication to Azure SQL

Microsoft Excel

Excel

Transfer Data from Excel to Shopify

Microsoft Power Automate

Build Shopify-Connected Automated Tasks with Power Automate (Desktop)

MongoDB

Automated Continuous Shopify Replication to MongoDB

MySQL

Automated Continuous Shopify Replication to MySQL

Oracle Data Integrator

ETL Shopify in Oracle Data Integrator

Oracle Database

Automated Continuous Shopify Replication to Oracle

petl

Extract, Transform, and Load Shopify in Python

PostgreSQL

Automated Continuous Shopify Replication to PostgreSQL

Replicate to MySQL

PowerShell

Replicate Shopify to MySQL with PowerShell

SAP HANA

Automated Continuous Shopify Replication to SAP HANA

SingleStore

Automated Continuous Shopify Replication to SingleStore

SnapLogic

Integrate Shopify with External Services using SnapLogic

Snowflake

Automated Continuous Shopify Replication to Snowflake

SQL Server

Automated Continuous Shopify Replication to SQL Server

SQL Server Linked Server

Connect to Shopify Data as a SQL Server Linked Server

SQLite

Automated Continuous Shopify Replication to SQLite

Talend

Connect to Shopify and Transfer Data in Talend

UiPath Studio

Create an RPA Flow that Connects to Shopify in UiPath Studio

Vertica

Automated Continuous Shopify Replication to a Vertica Database

Product	Technology	Article Title
Access Linked Tables	ODBC	Update Shopify with a Microsoft Access Linked Table
APOS Live Data Gateway	JDBC	Build Semantic Layer Views for Shopify (JDBC)
APOS Live Data Gateway	Connect Cloud	Build Semantic Layer Views for Shopify Data (Connect Cloud)
Denodo	JDBC	Create A Data Source for Shopify in Denodo Platform
Dremio	JDBC	Connect to Shopify as an External Source in Dremio
MySQL Federated Tables	ODBC	Connect to Shopify as Federated Tables in MySQL
Oracle Database	ODBC	Access Shopify as a Remote Oracle Database
PostgreSQL FDW	JDBC	A PostgreSQL Interface for Shopify
Salesforce Connect	Connect Cloud	Edit and Search Shopify External Objects in Salesforce Connect
SQL Server Linked Servers	ODBC	Connect to Shopify as a Linked Server
SQL Server PolyBase	Connect Cloud	Connect to Shopify Data using PolyBase with Connect Cloud
SQL Server PolyBase	ODBC	Connect to Shopify as an External Data Source using PolyBase
TIBCO Data Virtualization	TIBCO DV	Access Live Shopify Data in TIBCO Data Virtualization

Product

Technology

Article Title

Access Linked Tables

Update Shopify with a Microsoft Access Linked Table

APOS Live Data Gateway

Build Semantic Layer Views for Shopify (JDBC)

APOS Live Data Gateway

Build Semantic Layer Views for Shopify Data (Connect Cloud)

Denodo

Create A Data Source for Shopify in Denodo Platform

Dremio

Connect to Shopify as an External Source in Dremio

MySQL Federated Tables

Connect to Shopify as Federated Tables in MySQL

Oracle Database

Access Shopify as a Remote Oracle Database

PostgreSQL FDW

A PostgreSQL Interface for Shopify

Salesforce Connect

Edit and Search Shopify External Objects in Salesforce Connect

SQL Server Linked Servers

Connect to Shopify as a Linked Server

SQL Server PolyBase

Connect to Shopify Data using PolyBase with Connect Cloud

SQL Server PolyBase

Connect to Shopify as an External Data Source using PolyBase

TIBCO Data Virtualization

TIBCO DV

Access Live Shopify Data in TIBCO Data Virtualization

Product	Technology	Article Title
.NET Charts	ADO.NET	DataBind Charts to Shopify
.NET QueryBuilder	ODBC	Rapidly Develop Shopify-Driven Apps with Active Query Builder
Angular JS	Connect Server	Using AngularJS to Build Dynamic Web Pages with Shopify
Apache Spark	JDBC	Work with Shopify in Apache Spark Using SQL
AppSheet	Connect Cloud	Create Shopify-Connected Business Apps in AppSheet
Bubble.io	Connect Cloud	Build Shopify-Connected Apps in Bubble
C++Builder	ODBC	DataBind Controls to Shopify Data in C++Builder
Choreo	Connect Cloud	Build Custom Apps on Shopify Data in Choreo
ColdFusion	JDBC	Query Shopify in ColdFusion Using JDBC
ColdFusion	ODBC	Query Shopify in ColdFusion Using ODBC
Dash	Python	Use Dash & Python to Build Web Apps on Shopify
Delphi	ODBC	DataBind Controls to Shopify Data in Delphi
DevExpress	ADO.NET	DataBind Shopify to the DevExpress Data Grid
EF - Code First	ADO.NET	Access Shopify with Entity Framework 6
EF - LINQ	ADO.NET	LINQ to Shopify
EF - MVC	ADO.NET	Build MVC Applications with Connectivity to Shopify
Filemaker Pro	ODBC	Bidirectional Access to Shopify from FileMaker Pro
Filemaker Pro (on Mac)	JDBC	Bidirectional Access to Shopify from FileMaker Pro (on Mac)
Go	ODBC	Write a Simple Go Application to work with Shopify on Linux
Google Apps Script	Connect Cloud	Connect to Shopify Data in Google Apps Script
Hibernate	JDBC	Object-Relational Mapping (ORM) with Shopify Entities in Java
IntelliJ	JDBC	Connect to Shopify in IntelliJ
JBoss	JDBC	Connect to Shopify from a Connection Pool in JBoss
JDBI	JDBC	Create a Data Access Object for Shopify using JDBI
JRuby	JDBC	Connect to Shopify in JRuby
Mendix	Connect Cloud	Build Shopify-Connected Apps in Mendix
Microsoft Power Apps	Connect Cloud	Integrate Live Shopify Data into Custom Business Apps Built in Power Apps
NodeJS	Connect Cloud	Query Shopify Data in Node.js (via Connect Cloud)
NodeJS	ODBC	Query Shopify through ODBC in Node.js
OutSystems	Connect Cloud	Create Shopify-Connected Enterprise Applications in OutSystems
PHP	Connect Server	Access Shopify in PHP through Connect Server
PHP	ODBC	Natively Connect to Shopify in PHP
PowerBuilder	ADO.NET	Connect to Shopify from PowerBuilder
PowerShell	PowerShell	Pipe Shopify to CSV in PowerShell
PyCharm	ODBC	Using the CData ODBC Driver for Shopify in PyCharm
Python	ODBC	Connect to Shopify in Python on Linux/UNIX
React	Connect Server	Build Dynamic React Apps with Shopify Data
Ruby	ODBC	Connect to Shopify in Ruby
RunMyProcess	Connect Cloud	Connect to Shopify Data in RunMyProcess
RunMyProcess DSEC	JDBC	Connect to Shopify in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5	Connect Server	Integrate Real-Time Access to Shopify in SAPUI5 MVC Apps
Servoy	JDBC	Build Shopify-Connected Apps in Servoy
Spring Boot	JDBC	Access Live Shopify Data in Spring Boot Apps
SQLAlchemy	Python	Use SQLAlchemy ORMs to Access Shopify in Python
Tomcat	JDBC	Configure the CData JDBC Driver for Shopify in a Connection Pool in Tomcat
Unqork	Connect Cloud	Create Shopify-Connected Applications in Unqork
VCL App (RAD Studio)	ODBC	Build a Simple VCL Application for Shopify
WebLogic	JDBC	Connect to Shopify from a Connection Pool in WebLogic

Product

Technology

Article Title

.NET Charts

DataBind Charts to Shopify

.NET QueryBuilder

Rapidly Develop Shopify-Driven Apps with Active Query Builder

Angular JS

Using AngularJS to Build Dynamic Web Pages with Shopify

Apache Spark

Work with Shopify in Apache Spark Using SQL

AppSheet

Create Shopify-Connected Business Apps in AppSheet

Bubble.io

Build Shopify-Connected Apps in Bubble

C++Builder

DataBind Controls to Shopify Data in C++Builder

Choreo

Build Custom Apps on Shopify Data in Choreo

ColdFusion

Query Shopify in ColdFusion Using JDBC

ColdFusion

Query Shopify in ColdFusion Using ODBC

Dash

Use Dash & Python to Build Web Apps on Shopify

Delphi

DataBind Controls to Shopify Data in Delphi

DevExpress

DataBind Shopify to the DevExpress Data Grid

EF - Code First

Access Shopify with Entity Framework 6

EF - LINQ

LINQ to Shopify

EF - MVC

Build MVC Applications with Connectivity to Shopify

Filemaker Pro

Bidirectional Access to Shopify from FileMaker Pro

Filemaker Pro (on Mac)

Bidirectional Access to Shopify from FileMaker Pro (on Mac)

Write a Simple Go Application to work with Shopify on Linux

Google Apps Script

Connect to Shopify Data in Google Apps Script

Hibernate

Object-Relational Mapping (ORM) with Shopify Entities in Java

IntelliJ

Connect to Shopify in IntelliJ

JBoss

Connect to Shopify from a Connection Pool in JBoss

JDBI

Create a Data Access Object for Shopify using JDBI

JRuby

Connect to Shopify in JRuby

Mendix

Build Shopify-Connected Apps in Mendix

Microsoft Power Apps

Integrate Live Shopify Data into Custom Business Apps Built in Power Apps

NodeJS

Query Shopify Data in Node.js (via Connect Cloud)

NodeJS

Query Shopify through ODBC in Node.js

OutSystems

Create Shopify-Connected Enterprise Applications in OutSystems

PHP

Access Shopify in PHP through Connect Server

PHP

Natively Connect to Shopify in PHP

PowerBuilder

Connect to Shopify from PowerBuilder

PowerShell

Pipe Shopify to CSV in PowerShell

PyCharm

Using the CData ODBC Driver for Shopify in PyCharm

Python

Connect to Shopify in Python on Linux/UNIX

React

Build Dynamic React Apps with Shopify Data

Ruby

Connect to Shopify in Ruby

RunMyProcess

Connect to Shopify Data in RunMyProcess

RunMyProcess DSEC

Connect to Shopify in DigitalSuite Studio through RunMyProcess DSEC

SAP UI5

Integrate Real-Time Access to Shopify in SAPUI5 MVC Apps

Servoy

Build Shopify-Connected Apps in Servoy

Spring Boot

Access Live Shopify Data in Spring Boot Apps

SQLAlchemy

Use SQLAlchemy ORMs to Access Shopify in Python

Tomcat

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

Unqork

Create Shopify-Connected Applications in Unqork

VCL App (RAD Studio)

Build a Simple VCL Application for Shopify

WebLogic

Connect to Shopify from a Connection Pool in WebLogic

Product	Technology	Article Title
Apache Solr	JDBC	Import Shopify Data into Apache Solr
DB Artisan	JDBC	Manage Shopify in DBArtisan as a JDBC Source
DB Artisan	ODBC	Connect to Shopify in DBArtisan
DBeaver	JDBC	Connect to Shopify in DBeaver
DbVisualizer	JDBC	Connect to Shopify in DBVisualizer
Informatica Enterprise Data Catalog	JDBC	Add Shopify to Informatica Enterprise Data Catalog
MySQL Workbench	Connect Server	Query Shopify Data in MySQL Workbench (Connect Server)
MySQL Workbench	ODBC	Query Shopify in MySQL Workbench (ODBC)
QuerySurge	JDBC	Validate Shopify Data with QuerySurge
RazorSQL	JDBC	Connect to Shopify in RazorSQL
SQuirreL	JDBC	Connect to Shopify in Squirrel SQL Client

Product

Technology

Article Title

Apache Solr

Import Shopify Data into Apache Solr

DB Artisan

Manage Shopify in DBArtisan as a JDBC Source

DB Artisan

Connect to Shopify in DBArtisan

DBeaver

Connect to Shopify in DBeaver

DbVisualizer

Connect to Shopify in DBVisualizer

Informatica Enterprise Data Catalog

Add Shopify to Informatica Enterprise Data Catalog

MySQL Workbench

Query Shopify Data in MySQL Workbench (Connect Server)

MySQL Workbench

Query Shopify in MySQL Workbench (ODBC)

QuerySurge

Validate Shopify Data with QuerySurge

RazorSQL

Connect to Shopify in RazorSQL

SQuirreL

Connect to Shopify in Squirrel SQL Client

Product	Technology	Article Title
MuleSoft Anypoint	JDBC	Access Shopify in Anypoint Using SQL
Nintex Workflow Cloud	Connect Cloud	Build Shopify-Connected Workflows in Nintex
Power Automate	Connect Cloud	Integrate Shopify Data into Power Automate Automated Tasks
SSIS Export	SSIS	Export Data from SQL Server to Shopify through SSIS
SSIS Import	SSIS	Import Shopify Data into SQL Server using SSIS
SSIS Lookup	SSIS	Insert New or Update Existing Shopify Records from SQL Server

Product

Technology

Article Title

MuleSoft Anypoint

Access Shopify in Anypoint Using SQL

Nintex Workflow Cloud

Build Shopify-Connected Workflows in Nintex

Power Automate