Documentation
  • The Fundamental
  • ACTIVE SYNC
    • Data Ingestion
      • Data Tracking
        • API Key Management
        • Generate Tracking ID
        • Install tracking with Tag Manager
        • Install Tracking from the Console
        • Tracking Method on Website
      • Datasource
        • MySQL
        • PostgreSQL
        • MongoDB
        • Microsoft SQL Server
        • Shopify
        • CSV
        • Google Sheets
    • Data Ingestion API
      • Data Lake
        • File upload
        • Tracking API
      • Data Warehouse
        • Batch upload
        • CSV upload
        • Tracking API
      • Data Schema Warehouse API
    • Data Integrations
      • Manage your API Key
      • Get Data using API
  • ROCKET.BI
    • Introduction
    • Data Warehouse
      • Data Management
      • Ad-hoc Query
        • Measure Schema
        • Calculated Field
      • Query Analysis
      • Relationship
    • Row-level Security
    • Dashboard
      • Dashboard Filter
      • Chart Control
        • Tab Control
        • Single Choice
        • Multiple Choice
        • Dropdown Control
        • Slicer Control
        • Date Control
        • Input Control
      • Manage Dashboard
        • Relationship
        • View and Share
        • Select Main Date Filter
        • Boost
        • Settings
        • Add Chart
        • Add Tab
        • Add Text
    • Chart Builder
      • Chart Types
        • Pie Chart
        • Column Chart
        • Bar Chart
        • Line Chart
        • Line Stock Chart
        • Pareto Chart
        • Bubble Chart
        • Scatter Chart
        • Map Chart
        • Area Chart
        • KPI Chart
        • Lollipop Chart
        • Parliament Chart
        • Funnel Chart
        • Pyramid Chart
        • Gauge Chart
        • Bullet Graph Chart
        • Heat Map Chart
        • Word Cloud Chart
        • Tree Map Chart
        • Stacked Column Chart
        • Stacked Bar Chart
        • Sankey Chart
        • Spider Web Chart
        • Wind Rose Chart
        • Histogram Chart
        • Bell Curve Chart
        • Table Chart
        • Pivot Table Chart
      • Chart Settings
        • Zoom
        • Inner chart filter
      • Chart Filters
        • Tab Filter
        • Single Choice
        • Multiple Choice
        • Dropdown Filter
        • Slicer Filter
        • Date Filter
        • Input Filter
      • Right-click Settings
        • Change date function
        • Drill down
        • Drill through
        • Use as a filter
    • SQL Query
      • Syntax
      • Functions
      • Aggregate Functions
      • Data Types
  • UNLOCK.CI
    • Unlock.CI
Powered by GitBook
On this page
  • 1. What is Shopify?
  • 2. Add Shopify Source
  • 3. Pull data from Shopify Data Source
  • 4. Demo
  1. ACTIVE SYNC
  2. Data Ingestion
  3. Datasource

Shopify

PreviousMicrosoft SQL ServerNextCSV

Last updated 1 year ago

1. What is Shopify?

Shopify is a cloud-based E-commerce platform suitable for all sizes of businesses. It provides an online solution to quickly build their own website to sell products without coding.

2. Add Shopify Source

1. Click Add Data Source

2. In the menu, select Shopify

3. Config information of Data Source

  • Display name: name of your Shopify source

  • Shop URL: input your Shopify store URL

  • Access token: input your Shopify access token

4. Test Connection

After inputting the Config information, click Test Connection to check whether your Shopify source connects successfully.

5. Click Add to add Data Source

Your Shopify will be displayed in the Data Sources with the information of the Owner, Type, Date Modified, and Action.

3. Pull data from Shopify Data Source

1. Click the Jobs tab then click Add Job

2. Config information for Job

  • Job name: name of your job

  • From Data Source: select your data source to add the job

  • From database: select one database suggested in the data source. If the database you need doesn’t appear on the list, please type exactly the database you want.

  • From table: select one table suggested in the database. If the table you need doesn’t appear on the list, please type exactly the table you want. Or you can choose to sync all tables.

  • Sync to data warehouse: This is the default option, your data will be stored in the data warehouse.

  • Create new database: choose one database suggested in the data source or you can create a new one.

  • Create new table: choose one table suggested in the database or you can create a new one (also when you create a new database).

  • Sync to data lake: your job will be organized in the data lake

  • Sync Mode: your mode to sync

  • Full sync: sync everything in the data source with the designated destination, data lake, data warehouse, or both

  • Incremental sync: transfers changed all record and catalog data since the last synchronization (full or incremental)

  • Scheduler type: choose the type you want to sync

  • Run only once: collect data once at the date and time you input

  • Recurring: set up the repeated sync using the time scheduler Frequency: select the time interval between the data sync

3. Click Add Job

4. Check your synced job: Synced Jobs will be displayed in Jobs with the information of their mode, status, date synced, and action. You can click Force Sync to sync manually to ensure you access the up-to-date data.

5. Click the Jobs History to see what jobs have been done in the system so far. You can track all the activities of the jobs, including the time, the number of occurrences, and how many columns each job has generated.

4. Demo

This is a demo of the entire process of adding Shopify Data Source.

We hope that the above instructions will be useful to you. Let's have a look at our other articles to learn more about adding other databases with Data Insider.