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. Download   Getting Started with SSIS If you are new with SSIS and ZappySys SSIS PowerPack then check below links to get started. How to get started with SSIS and SSIS PowerPack. it covers how to install necessary tools to design/debug SSIS Packages, deploy to SSIS catalog and last Schedule SSIS Package to run using SQL Agent. It will also cover how to secure SSIS package and Parameterize values (e.g. Password, Hostname, etc). SSIS API Source Help File SSIS API Destination Help File	See also Connect Amazon MWS (Marketplace Web Service) in SQL Server Connect Amazon MWS (Marketplace Web Service) in Power BI Connect Amazon MWS (Marketplace Web Service) in SSRS Connect Amazon MWS (Marketplace Web Service) in Informatica Connect Amazon MWS (Marketplace Web Service) in MS Access Connect Amazon MWS (Marketplace Web Service) in MS Excel Connect Amazon MWS (Marketplace Web Service) in SSAS Connect Amazon MWS (Marketplace Web Service) in C# Connect Amazon MWS (Marketplace Web Service) in Python Connect Amazon MWS (Marketplace Web Service) in JAVA Connect Amazon MWS (Marketplace Web Service) in ODBC
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.
   

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.

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.
   

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.

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)