Shopify

Connect your data from Shopify to the Ascend platform.

The Shopify connection utilizes a JDBC driver from CData. For more information on how this connection reads in data, see CData's documentation.

Prerequisites

  • Shopify account access

Connection Properties

The following table describes the fields available when creating a new Shopify connection. Create a connection using the information below and these step-by-step instructions.

FieldRequiredDescription
Access TypeRequiredThe type of connection is Read-Only for Shopify.
Connection NameRequiredInput your desired name.
Shop URLRequiredthe URL of your shop. Ex. ascendio-2193.myshopify.com.

Credential Properties

The following table describes the fields available when creating a new Shopify credential.

Field NameRequiredDescription
Auth TypeRequiredThe authorization type to use
Access Token (Auth Type = Admin API)RequiredAdmin API Access Token to use
User (Auth Type = Basic)RequiredThe Shopify user to connect with.
Password (Auth Type = Basic)RequiredThe Shopify password to connect with

Read Connector Properties

The following table describes the fields available when creating a new Shopify read connector.

Field NameRequiredDescription
NameRequiredProvide a name for your connector. We recommend using lowercase with underscores in place of spaces.
DescriptionOptionalDescribes the connector. We recommend providing a description if you are ingesting information from the same source multiple times for different reasons.
Table NameRequiredName of the table being ingested. Enter in the table name or select Browse and Select Data to locate the table.
Replication StrategyOptionalFull Resync, Filter by column range, or Incremental column name. See Database Reading Strategies for more information.
Schema NameOptionalIf using a specific schema configuration, provide a name.
Filter ExpressionOptionalDefine a filter expression to be applied when querying the source table, utilized within the WHERE clause in SQL