Configuring ODBC Driver for Shopify

Windows DSN Configuration

After installing the driver, create a DSN for Shopify in the ODBC Data Source Administrator.

1. Open the ODBC Data Source Administrator.
   • Type ODBC Data Sources in the Windows search box and choose the application that matches the bitness of the third-party application (32-bit or 64-bit). You can also open ODBC Data Sources from Control Panel > Administrative Tools. Note that before Windows 8, the icon was named Data Sources (ODBC).
   • Alternatively, you can run C:\Windows\SysWOW64\odbcad32.exe to create a 32-bit DSN or C:\Windows\System32\odbcad32.exe to create a 64-bit DSN.
2. Select the User DSN or System DSN tab. Most applications work with both types, yet some applications require a specific type of DSN.
3. Click Add. The Create New Data Source dialog will appear.
4. Select Devart ODBC Driver for Shopify and click Finish. The driver setup dialog will open.
5. In Data Source Name, enter a name for your data source.
6. Optional: In Description, type a short description of the data source.
7. In API Version, select the version of the Shopify API used by the driver.
   • Ver1: Uses the legacy API implementation. Select this option if you need compatibility with existing queries or integrations.
   • Ver2: Uses the updated API implementation. This version provides better compatibility with newer Shopify features.
8. In Authentication, choose the method for connecting to Shopify.
   • AccessToken: Select this option if you already have a Shopify access token (for example, from a private or custom app).
     Fill in the Store and Access Token fields.

   

   • CustomApp: Select this option if you are using a Shopify custom app with API credentials (API key, API secret, etc.) and need a more advanced or configurable authentication setup.
     Fill in the Store, Client ID, and Client Secret fields. To learn how to generate values for Client ID and Client Secret, see Getting Parameters for Custom App Authentication.
     Click Sign in to Shopify, then log in to Shopify using your email address or passkey.

   

9. You can test the connectivity by clicking Test Connection.
10. Click OK to save the DSN.

See Also

Connection String Parameters