SSIS Amazon MWS (Marketplace Web Service) Connector

Amazon MWS (Marketplace Web Service) Connector can be used to integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.
You can use this connector to integrate REST API data inside SSIS, SQL Server or any BI / Reporting Apps / Programming languages which supports ODBC Driver Interface.


Help File    View All Tasks    Buy

Step-By-Step: How to read from Amazon MWS (Marketplace Web Service) in SSIS (Export data)

In this section we will learn how to configure Amazon MWS (Marketplace Web Service) in the API Source to extract data from the Amazon MWS (Marketplace Web Service).

  1. Download and Install ZappySys SSIS PowerPack.

  2. Once you finished first step, Open Visual Studio and Create New SSIS Package Project.

  3. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.
    SSIS Data Flow Task - Drag and Drop

  4. Double click on the DataFlow task to see DataFlow designer surface.

  5. From the SSIS toolbox drag and drop API Source (Predefined Templates) on the dataflow designer surface, and Double click on it to edit it. SSIS API Source (Predefined Templates) - Drag and Drop

  6. This connection can be configured using two ways. Use Default App (Created by ZappySys) OR Use Custom App created by you. To use minimum settings you can start with ZappySys created App.

  7. Just select the desired Authentication Type and replace the [$PlaceHolder$] with the desired required value and click on Ok

  8. Select the desired endpoint change/pass the properties values and click on preview to make the API call.

    API Soure - Amazon MWS (Marketplace Web Service)
    Amazon MWS (Marketplace Web Service) Connector can be used to integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.

  9. That's it we are done. In few clicks we configured the Amazon MWS (Marketplace Web Service) API call using ZappySys Amazon MWS (Marketplace Web Service) Connector

Step-By-Step: How to write to Amazon MWS (Marketplace Web Service) in SSIS (Import data)

In upper section we learn how to read data, now in this section we will learn how to configure Amazon MWS (Marketplace Web Service) in the API Source to Post data to the Amazon MWS (Marketplace Web Service).

  1. Firstly, You need to Download and Install SSIS ZappySys PowerPack.

  2. Once you finished first step, Open Visual Studio and Create New SSIS Package Project.

  3. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.
    SSIS Data Flow Task - Drag and Drop

  4. Double click on the DataFlow task to see DataFlow designer surface.

  5. Read the data from the source using desired component.

  6. From the SSIS toolbox drag and drop API Destination (Predefined Templates) on the dataflow designer surface and connect source with it, and Double click to edit it. SSIS API Destination (Predefined Templates) - Drag and Drop

  7. This connection can be configured using two ways. Use Default App (Created by ZappySys) OR Use Custom App created by you. To use minimum settings you can start with ZappySys created App.

  8. Just select the desired Authentication Type and replace the [$PlaceHolder$] with the desired required value and click on Ok

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

    API Destination - Amazon MWS (Marketplace Web Service)
    Amazon MWS (Marketplace Web Service) Connector can be used to integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.

  10. Map the the desired columns

    API Destination - Amazon MWS (Marketplace Web Service)
    Amazon MWS (Marketplace Web Service) Connector can be used to integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.

  11. That's it we successfully configured the POST API Call. In few clicks we configured the Amazon MWS (Marketplace Web Service) API call using ZappySys Amazon MWS (Marketplace Web Service)