Configure a Connection Profile

From the CData ribbon, click Get Data and select From eBay Analytics connection/s to launch the CData Query window. To setup a new connection, you will have to click the New eBay Analytics Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to eBay Analytics

You can establish a connection and authenticate to the eBay Analytics only via the OAuth 2 authentication method. The eBay Analytics API requires an access token created with the authorization code grant flow to authorize the requests.

Authenticating to eBay Analytics

eBay Analytics supports OAuth authentication only. AuthScheme must be set to OAuth in all OAuth flows.

Desktop Applications

You must create a custom OAuth application to authenticate via a desktop application. See Creating a Custom OAuth App for more information.

Get and Refresh the OAuth Access Token

After setting the following, you are ready to connect:

• OAuthClientId: Set this to the App Id(client Id) assigned when you registered your application.
• OAuthClientSecret: Set this to the Cert Id (client secret) assigned when you registered your application.
• RuName: Set this to the Redirect URL name of the OAuth application in the 'Application access' section.
• CallbackURL (Optional): Set this to a local Redirect URL (ex. http://localhost:33333) in case your OAuth application's auth accepted URL is set to https://oauth.cdata.com/oauth/ or to the actual one in case you are using another redirect URL.
• (Optional) UseSandbox: Set this to True if you are connecting to the Sandbox environment

When you connect, the add-in opens eBay Analytics's OAuth endpoint in your default browser. Log in and grant permissions to the application.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to eBay Analytics you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

• Querying Data: Use the data selection wizard to pull data into a spreadsheet. You can also configure scheduled data refresh here.
• Using the Excel Add-In: Find other ways to interact with eBay Analytics data, such as using the available CData Excel Functions.