Configuring Authentication

The Simba Oracle Eloqua ODBC Connector can use either basic user name and password authentication or the OAuth 2.0 protocol for authentication and authorization.

Configuring Basic Authentication

To use basic authentication, set the authentication method to Basic.

To configure basic authentication:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select Basic.
  3. In the User field, type the site name and user name that you use to access Eloqua, written in this format: [SiteName]\[UserName].
  4. In the Password field, type the password associated with your Eloqua user name.
  5. To save your settings and close the DSN Setup dialog box, click OK.

Configuring Authentication With an Access Token

If you already have a valid access token, specify it in your DSN so that the connector can use it to authenticate the connection.

To configure authentication using an access token:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select Access Token.
  3. In the Access Token field, type your access token.
  4. To save your settings and close the DSN Setup dialog box, click OK.

Configuring Authentication With Your Eloqua Credentials

You can configure the connector to retrieve and use an access token based on your Eloqua credentials.

To configure authentication using your Eloqua credentials:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select OAuth_2.0.
  3. In the Client ID field, type the consumer key associated with the Eloqua application.
  4. In the Client Secret field, type the client secret.
  5. In the Redirect URI field, type the redirect URL associated with your Eloqua application.
  6. Click Get Access Token.
  7. A web browser opens. In the web browser, log in to your Eloqua account with your Eloqua user name and password, and click Allow to allow the connector to access your Eloqua data store.
  8. In the DSN setup dialog box, confirm that the Access Token and Refresh Token fields are populated. Then, close the browser window.
  9. To save your settings and close the DSN Setup dialog box, click OK.