Configuring Authentication

You can authenticate your connection to Shopify by specifying an access token, or by providing your Shopify credentials so that the connector retrieves and uses the corresponding access token.

Configuring Authentication With an Access Token

If you already have a valid access token, specify it in your DSN so that the connector can use it to authenticate the connection.

Access tokens for Shopify do not expire. For information about revoking access tokens and protecting your Shopify data from unauthorized access, see "API Credential Rotation" in the Shopify API Reference: https://help.shopify.com/api/guides/authentication/api-credential-rotation.

To configure authentication using an access token:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select Access Token.
  3. In the Access Token field, type or paste your access token.
  4. To save your settings and close the DSN Setup dialog box, click OK.

Configuring Authentication With Your Shopify Credentials

You can configure the connector to retrieve and use an access token based on your Shopify credentials.

To configure authentication using your Shopify credentials:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select OAuth_2.0.
  3. In the Client ID field, type the API key associated with the Shopify application.
  4. In the Client Secret field, type the credential set associated with your Shopify application.
  5. In the Scope field, type a comma-separated list of OAuth scopes for the access token.

    6. For example:

    write_content,read_content

    For a list of the scopes that the connector supports, see https://help.shopify.com/en/api/getting-started/authentication/oauth/scopes.

  6. In the Redirect Uri field, type the redirect URL associated with your Shopify application.
  7. Click Get Access Token.

    8. A web browser opens. In the web browser, log in to your Shopify account with your Shopify email ID and password, and click Log in to allow the connector to access your Shopify data store.

  8. In the DSN setup dialog box, confirm that the Access Token field is populated. Then, close the browser window.
  9. To save your settings and close the DSN Setup dialog box, click OK.

Related topics