Skip to main content
Skip table of contents

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):

SQL
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 => ''
);;

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.