Connecting to eBay via SQL
You can use SQL to connect to eBay in the CData Virtuality Studio or the Code Editor in the Web UI.
Pre-requisites
You need the ClientId, ClientSecret, RefreshToken, etc.
How to Connect
Run the following statements in the CData Virtuality Studio or the Web UI (remember to enter your credentials):
CALL SYSADMIN.createConnection (
name => 'ebay_src'
,jbossCLITemplateName => 'ws'
,connectionOrResourceAdapterProperties => 'ClientId=<ClientId>,EndPoint=https://<api.sandbox or api>.ebay.com,SecurityType=OAuth2,redirectUri=<redirectUri>,ClientSecret=<ClientSecret>,RefreshToken=<RefreshToken>'
);;
CALL SYSADMIN.createDataSource (
name => 'ebay_src'
,translator => 'ebay'
,modelProperties => 'cleanupMethod=<cleanupMethod>,marketplaceId=EBAY_US'
,translatorProperties => ''
);;