I have an Amazon MWS account & I need to query their db periodically. I was told that open source ETL software (like CloverETL) are the best way to do this. I don’t have direct access to their db. It connects through an API through XML and it reads C#, Java & PHP, but that’s as much as I know. Is there a tutorial or a premade package that I can begin with? I’m not sure where to start.
Hi Sergio,
You can use CloverETL to communicate with the Amazon MWS API.
The principle of the communication with Amazon MWS API can be divided into three steps:
- build the URL request string, in which you pass parameters to the Amazon API,
- make HTTP call with this request string,
- read and parse XML response from the Amazon MWS API.
In the CloverETL you can use HTTP Connector component to make HTTP request and XML Extract component to extract data from the XML response. I prepared for you sample graph which demonstrates simple call of Amazon API. It is only simple request to the API URL without any parameter, because I haven’t Amazon MWS account.
For more information about parsing XML, please see the documentation:
http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/xmlextract.html