Connecting to Amazon Ads 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 EndPoint, ClientId, ClientSecret, RefreshToken.

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 => 'amazon_ads_src'
    ,jbossCLITemplateName => 'ws'
    ,connectionOrResourceAdapterProperties => 'EndPoint=<https://advertising-api.amazon.com/v2,ClientId=<Client> ID>,ClientSecret=<Client Secret>,RefreshToken=<Refresh Token>'
);;

CALL SYSADMIN.createDataSource (
    name => 'amazon_ads_src'
    ,translator => 'amazon_ads'
    ,modelProperties => 'multitenancy_tablename=<multitenancy_tablename>,cleanupMethod=DELETE,accountType=Seller,traces=false'
    ,translatorProperties => ''
);;