How to integrate Shopify using SSIS

Integrate SSIS and Shopify
Integrate SSIS and Shopify

Learn how to quickly and efficiently connect Shopify with SSIS for smooth data access.

Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required. You can do it all using the high-performance Shopify Connector for SSIS. We'll walk you through the entire setup.

Ready to dive in? Download the product to jump right in, or follow the step-by-step guide below to see how it works.

Video Tutorial

This video covers the following topics and more, so please watch carefully. After watching the video, follow the steps outlined in this article:

  • How to download and install the required PowerPack for Shopify integration in SSIS
  • How to configure the connection for Shopify
  • Features of the ZappySys API Source (Authentication / Query Language / Examples / Driver UI)
  • How to use the Shopify in SSIS

Prerequisites

Before we begin, make sure the following prerequisites are met:

  1. SSIS designer installed. Sometimes it is referred as BIDS or SSDT (download it from Microsoft).
  2. Basic knowledge of SSIS package development using Microsoft SQL Server Integration Services.
  3. SSIS PowerPack is installed (if you are new to SSIS PowerPack, then get started!).

Read data from Shopify in SSIS (Export data)

In this section we will learn how to configure and use Shopify Connector in API Source to extract data from Shopify.

  1. Begin with opening Visual Studio and Create a New Project.

  2. Select Integration Service Project and in new project window set the appropriate name and location for project. And click OK.

    In the new SSIS project screen you will find the following:

    • SSIS ToolBox on left side bar
    • Solution Explorer and Property Window on right bar
    • Control flow, data flow, event Handlers, Package Explorer in tab windows
    • Connection Manager Window in the bottom
    SSIS Project Screen
    Note: If you don't see ZappySys SSIS PowerPack Task or Components in SSIS Toolbox, please refer to this help link.

  3. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox. Double click on the Data Flow Task to see Data Flow designer.

    SSIS Data Flow Task - Drag and Drop

  4. From the SSIS toolbox drag and API Source (Predefined Templates) on the data flow designer surface, and double click on it to edit it:

    SSIS API Source (Predefined Templates) - Drag and Drop

  5. Select New Connection to create a new connection:

    API Source - New Connection

  6. Use a preinstalled Shopify Connector from Popular Connector List or press Search Online radio button to download Shopify Connector. Once downloaded simply use it in the configuration:

    Shopify
    Shopify Connector Selection

  7. Now it's time to configure authentication. Firstly, configure authentication settings in Shopify service and then proceed by configuring API Connection Manager. Start by expanding an authentication type:

    Admin Access Token (Custom App)

    Shopify authentication

    Method: Admin API Access Token (Recommended for Single-Store Connections)

    This method uses a permanent Admin API Access Token generated from a "Custom App" within your Shopify Admin. This is the simplest way to connect if you are only integrating with your own store.

    Quick Setup Summary:

    • Log in to your Shopify Admin and click Settings (the gear icon in the bottom left).
    • Select Apps from the left-side settings menu.
    • Click the Develop apps button at the top right of the page.
    • Open your app (or create a new one) and configure the necessary Admin API access scopes.
    • Click Install app. Once installed, navigate to the API credentials tab.

    Important: Your Admin API access token (shpat_xxx) is only revealed once. Please copy and store it securely immediately after clicking "Reveal token once."

    Note: If you are using the Shopify Dev Dashboard (via a Partner Account), you must use the OAuth Authorization Code Grant method, as those apps do not issue permanent 'shpat' tokens.

    Video Tutorial: How to Get Admin API Access Token in Shopify?

    Part 1: Create and Configure the Shopify App

    1. Visit https://accounts.shopify.com and log into your Shopify store account.
    2. After logging in, select the store you wish to connect to.
    3. Select Settings (gear icon in the lower-left corner) to launch the Settings screen.
    4. On the left menu panel, select Apps. (Note: Sales channels are now managed in a separate menu item).
    5. On the Apps page, select Develop apps (near the top right of the screen).
      Note: If this is your first time accessing this section, you may need to click "Allow custom app development" to proceed.
    6. On the App development screen, select Create an app.
    7. Give the app a name (e.g., "ZappySys Connector"), select the appropriate developer from the drop-down, and select Create app.
    8. Click Configure Admin API scopes.
    9. In the Admin API access scopes screen, select the checkboxes based on which features you plan to use:
      • For Customers: read_customers, write_customers
      • For Orders: read_orders, write_orders
      • For Products: read_products, write_products
      • For Inventory: read_inventory, write_inventory
      • For Locations: read_locations
      • For Payouts/Analytics: read_all_orders or read_analytics

      Important: If you select fewer scopes than required, some connector features will not work. To ensure full functionality, select both read and write permissions for the resources you need to access.

    10. After selecting your scopes, click Save at the top or bottom of the page.
    11. Install the app by clicking the Install app button (upper-right corner). If prompted, confirm by selecting Install.

    Part 2: Get Admin API Access Token

    1. Once the app is installed, you will be taken to the API credentials tab.
    2. Look for the Admin API access token section. Select Reveal token once to show the token (it starts with shpat_).

    3. IMPORTANT: Copy and save this token immediately in a secure location. You cannot view it again after leaving this page.

      Reveal Token Screenshot

      Note: You may also see an API Key or Secret Key in this section; these are not required for this specific authentication method. Use only the Admin API access token.

    Part 3: Configure the ZappySys Connector

    1. Open the ZappySys connector configuration screen.
    2. Enter Subdomain: Enter the unique subdomain of your Shopify store into the Subdomain parameter textbox.

      How to find your Subdomain:

      If you use a custom domain (e.g., www.my-store.com), you must still use your internal Shopify subdomain:

      • Method 1 (Admin URL): While logged into Shopify, check your browser address bar.
        • If the URL is admin.shopify.com/store/my-unique-slug, your subdomain is my-unique-slug.
        • If the URL is my-unique-slug.myshopify.com/admin, your subdomain is my-unique-slug.
      • Method 2 (Domains Setting): Go to Settings > Domains. Look for the "Primary domain for the online store" or the fallback domain ending in .myshopify.com. The part before the dots is your subdomain.
    3. Enter Access Token: Paste the shpat_xxx token you saved in Step 14 into the Admin API Access Token textbox.
      Tip: Click the ellipses (...) button inside the textbox to open a larger dialog for easier pasting.
    4. Click Test Connection to verify the settings.
    5. If the test is successful, click OK to save the configuration.
    API Connection Manager configuration

    Just perform these simple steps to finish authentication configuration:

    1. Set Authentication Type to Admin Access Token (Custom App) [Http]
    2. Optional step. Modify API Base URL if needed (in most cases default will work).
    3. Fill in all the required parameters and set optional parameters if needed.
    4. Finally, hit OK button:
    Shopify
    Admin Access Token (Custom App) [Http]
    https://[$Subdomain$].myshopify.com/admin/api/2025-01
    Required Parameters
    Sub-domain Fill-in the parameter...
    Admin API Access Token Fill-in the parameter...
    Optional Parameters
    RetryMode RetryWhenStatusCodeMatch
    RetryStatusCodeList 429
    RetryCountMax 5
    RetryMultiplyWaitTime True
    ZappySys Http Connection

    OAuth Authorization Code Grant (3-legged) - RECOMMENDED

    Shopify authentication

    Authenticate using OAuth 2.0 Authorization Code Flow (3-legged). Use this for apps built in the Dev Dashboard (https://dev.shopify.com). This is the primary OAuth flow supported for public apps and apps created in the Dev Dashboard.

    Method: OAuth Authorization Code Grant (3-Legged)

    This method is for apps built in the Shopify Dev Dashboard. Use this if you are a Partner or developer building a multi-store integration.

    Note: If you are connecting to your own single store, the Admin Access Token method is significantly simpler. Use this OAuth method only if your integration specifically requires a Client ID and Secret.

    Part 1: Create and Configure App in Dev Dashboard

    1. Log in to the Shopify Dev Dashboard using your Partner account.
    2. Click Apps in the left menu, then click Create app.
    3. Select Start from Dev Dashboard (manual setup) and give your app a name.
    4. Step 1: Configure Scopes and URLs via "Versions"
      • Click the Versions tab at the top of the app screen.
      • Click Create version (or edit the Draft).
      • In the URLs section, enter https://zappysys.com/oauth into Allowed redirection URL(s).
      • Select your Admin API scopes based on which features you plan to use:
        • For Customers: read_customers, write_customers
        • For Orders: read_orders, write_orders
        • For Products: read_products, write_products
        • For Inventory: read_inventory, write_inventory
        • For Locations: read_locations
        • For Payouts/Analytics: read_all_orders or read_analytics

        Important: If you select fewer scopes than required, some connector features will not work. To ensure full functionality, select both read and write permissions for the resources you need to access.

      • Click Release (top right). Note: Settings only become active once a version is Released.
    5. Step 2: Set Distribution Method
      • Click Distribution in the left-side menu.
      • Select Custom Distribution.
      • Enter your Shopify store URL (e.g., your-store.myshopify.com) and click Generate link.
      • Action Required: Copy the generated install link, open it in your browser, and follow the prompts to install/unlock the app for your store. You must complete this step before testing the connection in ZappySys.

    Part 2: Get Client Credentials

    1. Click on Settings in the left-side navigation of your app.
    2. In the Client credentials section, copy the Client ID and Client Secret (click the eye icon to reveal).

    Part 3: Configure the ZappySys Connector

    1. Open the ZappySys connector and select OAuth Authorization Code Grant (3-legged).
    2. Subdomain: Enter your store handle (the part before .myshopify.com).
    3. Client ID / Secret: Paste the credentials from Steps 6 and 7.
    4. Redirect URI: Enter https://zappysys.com/oauth.
    5. Click Test Connection. You will be prompted to authorize the app in your browser.

    Note on Tokens: Successful authorization generates an "Offline" Access Token (starting with shpca_). This token does not expire and does not require a refresh token.

    Troubleshooting: If you see "App no longer available," ensure you have completed the Distribution step and followed the Install Link in Step 5 to unlock the app for your store.

    API Connection Manager configuration

    Just perform these simple steps to finish authentication configuration:

    1. Set Authentication Type to OAuth Authorization Code Grant (3-legged) - RECOMMENDED [OAuth]
    2. Optional step. Modify API Base URL if needed (in most cases default will work).
    3. Fill in all the required parameters and set optional parameters if needed.
    4. Press Generate Token button to generate the tokens.
    5. Finally, hit OK button:
    Shopify
    OAuth Authorization Code Grant (3-legged) - RECOMMENDED [OAuth]
    https://[$Subdomain$].myshopify.com/admin/api/2025-01
    Required Parameters
    Redirect URI (***Must match App Settings***) Fill-in the parameter...
    ZappySys OAuth Connection

  8. Select the desired endpoint, change/pass the properties values, and click on Preview Data button to make the API call.

    API Source - Shopify
    Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.
    API Source - Select Endpoint

  9. That's it! We are done! Just in a few clicks we configured the call to Shopify using Shopify Connector.

    You can load the source data into your desired destination using the Upsert Destination , which supports SQL Server, PostgreSQL, and Amazon Redshift. We also offer other destinations such as CSV , Excel , Azure Table , Salesforce , and more . You can check out our SSIS PowerPack Tasks and components for more options. (*loaded in Trash Destination)

    Execute Package - Reading data from Shopify and load into target

Write data to Shopify using SSIS (Import data)

In this section we will learn how to configure and use Shopify Connector in the API Destination to write data to Shopify.

Video tutorial

This video covers following and more so watch carefully. After watching this video follow the steps described in this article.

  • How to download SSIS PowerPack for Shopify integration in SSIS
  • How to configure connection for Shopify
  • How to write or lookup data to Shopify
  • Features about SSIS API Destination
  • Using Shopify Connector in SSIS

Step-by-step instructions

In upper section we learned how to read data, now in this section we will learn how to configure Shopify in the API Source to POST data to the Shopify.

  1. Begin with opening Visual Studio and Create a New Project.

  2. Select Integration Service Project and in new project window set the appropriate name and location for project. And click OK.

    In the new SSIS project screen you will find the following:

    • SSIS ToolBox on left side bar
    • Solution Explorer and Property Window on right bar
    • Control flow, data flow, event Handlers, Package Explorer in tab windows
    • Connection Manager Window in the bottom
    SSIS Project Screen
    Note: If you don't see ZappySys SSIS PowerPack Task or Components in SSIS Toolbox, please refer to this help link.

  3. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox. Double click on the Data Flow Task to see Data Flow designer.

    SSIS Data Flow Task - Drag and Drop

  4. Read the data from the source, using any desired source component. You can even make an API call using the ZappySys JSON/XML/API Source and read data from there. In this example, we will use an OLE DB Source component to read real-time data from a SQL Server database.

  5. From the SSIS Toolbox drag and drop API Destination (Predefined Templates) on the Data Flow Designer surface and connect source component with it, and double click to edit it.
    SSIS API Destination (Predefined Templates) - Drag and Drop

  6. Select New Connection to create a new connection:

    API Destination - Shopify
    Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.
    API Destination - Shopify

  7. To configure the Shopify connector, choose one of the following methods:

    • Choose from Popular Connector List: Select a pre-installed service directly from the dropdown menu.
    • Search Online: Use this to find and download a new connector file to your computer.
    • Use Saved/Downloaded File: Once the file is downloaded, browse your local drive to load it into the configuration.

    After that, just click Continue >>:

    Shopify
    API Destination -

  8. Proceed with selecting the desired Authentication Type. Then select API Base URL (in most cases default one is the right one). Finally, fill in all the required parameters and set optional parameters if needed. You may press a link Steps to Configure which will help set certain parameters. More info is available in Authentication section.

    Admin Access Token (Custom App)

    Shopify authentication

    Method: Admin API Access Token (Recommended for Single-Store Connections)

    This method uses a permanent Admin API Access Token generated from a "Custom App" within your Shopify Admin. This is the simplest way to connect if you are only integrating with your own store.

    Quick Setup Summary:

    • Log in to your Shopify Admin and click Settings (the gear icon in the bottom left).
    • Select Apps from the left-side settings menu.
    • Click the Develop apps button at the top right of the page.
    • Open your app (or create a new one) and configure the necessary Admin API access scopes.
    • Click Install app. Once installed, navigate to the API credentials tab.

    Important: Your Admin API access token (shpat_xxx) is only revealed once. Please copy and store it securely immediately after clicking "Reveal token once."

    Note: If you are using the Shopify Dev Dashboard (via a Partner Account), you must use the OAuth Authorization Code Grant method, as those apps do not issue permanent 'shpat' tokens.

    Video Tutorial: How to Get Admin API Access Token in Shopify?

    Part 1: Create and Configure the Shopify App

    1. Visit https://accounts.shopify.com and log into your Shopify store account.
    2. After logging in, select the store you wish to connect to.
    3. Select Settings (gear icon in the lower-left corner) to launch the Settings screen.
    4. On the left menu panel, select Apps. (Note: Sales channels are now managed in a separate menu item).
    5. On the Apps page, select Develop apps (near the top right of the screen).
      Note: If this is your first time accessing this section, you may need to click "Allow custom app development" to proceed.
    6. On the App development screen, select Create an app.
    7. Give the app a name (e.g., "ZappySys Connector"), select the appropriate developer from the drop-down, and select Create app.
    8. Click Configure Admin API scopes.
    9. In the Admin API access scopes screen, select the checkboxes based on which features you plan to use:
      • For Customers: read_customers, write_customers
      • For Orders: read_orders, write_orders
      • For Products: read_products, write_products
      • For Inventory: read_inventory, write_inventory
      • For Locations: read_locations
      • For Payouts/Analytics: read_all_orders or read_analytics

      Important: If you select fewer scopes than required, some connector features will not work. To ensure full functionality, select both read and write permissions for the resources you need to access.

    10. After selecting your scopes, click Save at the top or bottom of the page.
    11. Install the app by clicking the Install app button (upper-right corner). If prompted, confirm by selecting Install.

    Part 2: Get Admin API Access Token

    1. Once the app is installed, you will be taken to the API credentials tab.
    2. Look for the Admin API access token section. Select Reveal token once to show the token (it starts with shpat_).

    3. IMPORTANT: Copy and save this token immediately in a secure location. You cannot view it again after leaving this page.

      Reveal Token Screenshot

      Note: You may also see an API Key or Secret Key in this section; these are not required for this specific authentication method. Use only the Admin API access token.

    Part 3: Configure the ZappySys Connector

    1. Open the ZappySys connector configuration screen.
    2. Enter Subdomain: Enter the unique subdomain of your Shopify store into the Subdomain parameter textbox.

      How to find your Subdomain:

      If you use a custom domain (e.g., www.my-store.com), you must still use your internal Shopify subdomain:

      • Method 1 (Admin URL): While logged into Shopify, check your browser address bar.
        • If the URL is admin.shopify.com/store/my-unique-slug, your subdomain is my-unique-slug.
        • If the URL is my-unique-slug.myshopify.com/admin, your subdomain is my-unique-slug.
      • Method 2 (Domains Setting): Go to Settings > Domains. Look for the "Primary domain for the online store" or the fallback domain ending in .myshopify.com. The part before the dots is your subdomain.
    3. Enter Access Token: Paste the shpat_xxx token you saved in Step 14 into the Admin API Access Token textbox.
      Tip: Click the ellipses (...) button inside the textbox to open a larger dialog for easier pasting.
    4. Click Test Connection to verify the settings.
    5. If the test is successful, click OK to save the configuration.
    API Connection Manager configuration

    Just perform these simple steps to finish authentication configuration:

    1. Set Authentication Type to Admin Access Token (Custom App) [Http]
    2. Optional step. Modify API Base URL if needed (in most cases default will work).
    3. Fill in all the required parameters and set optional parameters if needed.
    4. Finally, hit OK button:
    Shopify
    Admin Access Token (Custom App) [Http]
    https://[$Subdomain$].myshopify.com/admin/api/2025-01
    Required Parameters
    Sub-domain Fill-in the parameter...
    Admin API Access Token Fill-in the parameter...
    Optional Parameters
    RetryMode RetryWhenStatusCodeMatch
    RetryStatusCodeList 429
    RetryCountMax 5
    RetryMultiplyWaitTime True
    ZappySys Http Connection

    OAuth Authorization Code Grant (3-legged) - RECOMMENDED

    Shopify authentication

    Authenticate using OAuth 2.0 Authorization Code Flow (3-legged). Use this for apps built in the Dev Dashboard (https://dev.shopify.com). This is the primary OAuth flow supported for public apps and apps created in the Dev Dashboard.

    Method: OAuth Authorization Code Grant (3-Legged)

    This method is for apps built in the Shopify Dev Dashboard. Use this if you are a Partner or developer building a multi-store integration.

    Note: If you are connecting to your own single store, the Admin Access Token method is significantly simpler. Use this OAuth method only if your integration specifically requires a Client ID and Secret.

    Part 1: Create and Configure App in Dev Dashboard

    1. Log in to the Shopify Dev Dashboard using your Partner account.
    2. Click Apps in the left menu, then click Create app.
    3. Select Start from Dev Dashboard (manual setup) and give your app a name.
    4. Step 1: Configure Scopes and URLs via "Versions"
      • Click the Versions tab at the top of the app screen.
      • Click Create version (or edit the Draft).
      • In the URLs section, enter https://zappysys.com/oauth into Allowed redirection URL(s).
      • Select your Admin API scopes based on which features you plan to use:
        • For Customers: read_customers, write_customers
        • For Orders: read_orders, write_orders
        • For Products: read_products, write_products
        • For Inventory: read_inventory, write_inventory
        • For Locations: read_locations
        • For Payouts/Analytics: read_all_orders or read_analytics

        Important: If you select fewer scopes than required, some connector features will not work. To ensure full functionality, select both read and write permissions for the resources you need to access.

      • Click Release (top right). Note: Settings only become active once a version is Released.
    5. Step 2: Set Distribution Method
      • Click Distribution in the left-side menu.
      • Select Custom Distribution.
      • Enter your Shopify store URL (e.g., your-store.myshopify.com) and click Generate link.
      • Action Required: Copy the generated install link, open it in your browser, and follow the prompts to install/unlock the app for your store. You must complete this step before testing the connection in ZappySys.

    Part 2: Get Client Credentials

    1. Click on Settings in the left-side navigation of your app.
    2. In the Client credentials section, copy the Client ID and Client Secret (click the eye icon to reveal).

    Part 3: Configure the ZappySys Connector

    1. Open the ZappySys connector and select OAuth Authorization Code Grant (3-legged).
    2. Subdomain: Enter your store handle (the part before .myshopify.com).
    3. Client ID / Secret: Paste the credentials from Steps 6 and 7.
    4. Redirect URI: Enter https://zappysys.com/oauth.
    5. Click Test Connection. You will be prompted to authorize the app in your browser.

    Note on Tokens: Successful authorization generates an "Offline" Access Token (starting with shpca_). This token does not expire and does not require a refresh token.

    Troubleshooting: If you see "App no longer available," ensure you have completed the Distribution step and followed the Install Link in Step 5 to unlock the app for your store.

    API Connection Manager configuration

    Just perform these simple steps to finish authentication configuration:

    1. Set Authentication Type to OAuth Authorization Code Grant (3-legged) - RECOMMENDED [OAuth]
    2. Optional step. Modify API Base URL if needed (in most cases default will work).
    3. Fill in all the required parameters and set optional parameters if needed.
    4. Press Generate Token button to generate the tokens.
    5. Finally, hit OK button:
    Shopify
    OAuth Authorization Code Grant (3-legged) - RECOMMENDED [OAuth]
    https://[$Subdomain$].myshopify.com/admin/api/2025-01
    Required Parameters
    Redirect URI (***Must match App Settings***) Fill-in the parameter...
    ZappySys OAuth Connection

  9. Select the desired endpoint, change/pass the properties values, and go to the Mappings tab to map the columns.

    API Destination - Shopify
    Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.
    API Destination - Shopify

  10. Finally, map the desired columns:

    API Destination - Shopify
    Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.
    API Destination - Shopify

  11. That's it; we successfully configured the POST API Call. In a few clicks we configured the Shopify API call using ZappySys Shopify Connector

    Execute Package

Load Shopify data into SQL Server using Upsert Destination (Insert or Update)

Once you configured the data source, you can load Shopify data into SQL Server using Upsert Destination.

Upsert Destination can merge or synchronize source data with the target table. It supports Microsoft SQL Server, PostgreSQL, and Redshift databases as targets. Upsert Destination also supports very fast bulk upsert operation along with bulk delete.

Upsert operation - a database operation which performs INSERT or UPDATE SQL commands based on record's existence condition in the target table. It inserts records that don't have matching records in the target table or updates them, if they do, by matching them by key columns.

Upsert Destination supports INSERT, UPDATE, and DELETE operations, so it is similar to SQL Server's MERGE command, except it can be used directly in SSIS package.

  1. From the SSIS Toolbox drag-and-drop Upsert Destination component onto the Data Flow designer background.

  2. Connect your SSIS source component to Upsert Destination.

  3. Double-click on Upsert Destination component to open configuration window.

  4. Start by selecting the Action from the list.

  5. Next, select the desired target connection or create one by clicking <New [provider] Connection> menu item from the Target Connection dropdown.

  6. Then select a table from the Target Table list or click New button to create a new table based on the source columns.

  7. Continue by checking Insert and Update options according to your scenario (e.g. if Update option is unchecked, no updates will be made).

  8. Finally, click Map All button to map all columns and then select the Key columns to match the columns on:

    Configure SSIS Upsert Destination component to merge data with SQL Server, PostgreSQL, or Redshift table

  9. Click OK to save the configuration.

  10. Run the package and Shopify data will be merged with the target table in SQL Server, PostgreSQL, or Redshift:

    Execute Package - Reading data from API Source and load into target

  11. Done!

Deploy and schedule SSIS package

After you are done creating SSIS package, most likely, you want to deploy it to SQL Server Catalog and run it periodically. Just follow the instructions in this article:

Running SSIS package in Azure Data Factory (ADF)

To use SSIS PowerPack in ADF, you must first prepare Azure-SSIS Integration Runtime. Follow this link for detailed instructions:

Supported Shopify Connector actions

Got a specific use case in mind? We've mapped out exactly how to perform a variety of essential Shopify operations directly in SSIS, so you don't have to figure out the setup from scratch. Check out the step-by-step guides below:

Conclusion

In this article we showed you how to connect to Shopify in SSIS and integrate data without writing complex code — all of this was powered by Shopify Connector.

Download SSIS PowerPack now or ping us via chat if you have any questions or are looking for a specific feature (you can also reach out to us by submitting a ticket):

Download Chat

Explore SSIS connectors

All
Big Data & NoSQL
Database
CRM & ERP
Marketing
Collaboration
Cloud Storage
Reporting
Commerce
API & Files

More Shopify integrations

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications