Connecting to Amazon MWS via SQL

You can use SQL to connect to Amazon in the Data Virtuality Studio or the Code Editor in the Web UI.

Pre-requisites

You need the ClientID, ClientSecret, MWSAuthToken, SellerID.

How to Connect

Run the following statements in the Data Virtuality Studio or the Web UI (remember to enter your credentials):

SQL

CALL SYSADMIN.createConnection (
    name => 'AmazonMWS_src'
    ,jbossCLITemplateName => 'ws'
    ,connectionOrResourceAdapterProperties => 'EndPoint=<https://mws.amazonservices.de,ClientId=<AWS> Access Key ID>,ClientSecret=<Secret Key>'
);;

CALL SYSADMIN.createDataSource (
    name => 'AmazonMWS_src'
    ,translator => 'AmazonMWS'
    ,modelProperties => 'MWSAuthToken=<MWSAuthToken>,SellerID=<Seller ID>,reportingTimestampFormat="MMM dd, yyyy hh:mm:ss a z",reportingTimestampFormatRegex="^[A-Za-z]{3} [0-2]{1}[0-9]{1}, [0-9]{4} ?([0-1]{1})[0-9]{1}:[0-5]{1}[0-9]{1}:[0-5]{1}[0-9]{1}",reportingTimestampFormatDefault="MMM dd, yyyy hh:mm:ss a z",reportingEncoding=ISO-8859-1,reportDelimiter=tab,noFailCancelledReports=true,dataSeek=false,skipSalesTaxCollected=false,checkEmptyReports=false,cleanupMethod=DELETE'
    ,translatorProperties => ''
);;