In this blog we will see how we can connect our shopify store to SSIS using kingsway soft connector.
Step 1: Open your shopify store instance and note down your store name somewhere we will need that while creating a connection.
Step 2: Open Apps from the left hand side menu
Step 3: Scroll down to bottom and click on manage private apps
Step 4: Copy the API key generated in the API Key section. If now app is created create one by clicking on create new private app.
Step 5: Open SSIS and create new project. Download the kingsway soft connector from https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/download
Step 6: Once you have installed the connector in SSIS create connection in SSIS by selecting REST as source
Step 6: Select Shopify from the service dropdown
Step 7: Enter the shop name that you copied at the beginning. Select the API Key authentication mode
Step 8: Add your API key and password and test the connection. Check for spaces while copying the API key.
In this way you can connect your Shopify store to SSIS. Hope this helps