Configuring Authentication

To access Eloqua data stores, you must authenticate the connection by providing either your user name and password or a valid OAuth 2.0 access token. You can also provide your Eloqua application information so that the connector retrieves and uses the corresponding OAuth 2.0 access token.

For detailed configuration instructions, see the following sections:

Using Your User Name and Password

You can authenticate your connection by providing your Eloqua user name and password in the connection URL.

To authenticate using your user name and password:

  • Connect to the server using a connection URL written in the following format:

    • jdbc:eloqua://localhost;Host=[InstanceURL];Auth_Type=Basic Authentication;UID=[YourUserName];PWD=[YourPassword];

    The variables are defined as follows:

  • [InstanceURL] is URL of the Eloqua instance that you are connecting to. Typically, the instance URL uses the following format: https://secure.[machineID].eloqua.com.
  • [YourUserName] is the site name and user name that you use to access Eloqua, written in this format: [SiteName]\\[UserName].
  • [YourPassword] is the password corresponding to your user name.

For example:

jdbc:eloqua://localhost;Host=secure.server01.eloqua.com;Auth_Type=Basic Authentication;UID=SimpleSiteName\\jsmith;
PWD=123456;

Using an Access Token

If you already have a valid OAuth 2.0 access token, you can authenticate your connection by providing the token in the connection URL.

By default, access tokens expire after some time. You can configure the connector to automatically retrieve a new access token upon expiry so that your authentication settings remain valid for all subsequent connections. To do this, include your Eloqua application information and the corresponding refresh token along with the access token.

To authenticate using an access token:

  • Connect to the server using a connection URL written in the following format:

    • jdbc:eloqua://localhost;Host=[InstanceURL];Auth_Type=Access Token;Auth_AccessToken=[YourAcccessToken];

    The variables are defined as follows:

  • [InstanceURL] is URL of the Eloqua instance that you are connecting to. Typically, the instance URL uses the following format: https://secure.[machineID].eloqua.com.
  • [YourAccessToken] is your access token for authenticating to Eloqua.

For example:

jdbc:eloqua://localhost;Host=secure.server01.eloqua.com;Auth_Type=Access Token;Auth_AccessToken=kP9PcyQ7prK2LwUMZMpFQ4R+5VE;

To authenticate using an access token that refreshes automatically:

  • Connect to the server using a connection URL written in the following format:

    • jdbc:eloqua://localhost;Host=[InstanceURL];Auth_Type=OAuth 2.0;Auth_AccessToken=[YourAcccessToken];Auth_BaseRedirectUri=[RedirectURL];Auth_Client_ID=[YourClientID];Auth_Client_Secret=[YourClientSecret];Auth_RefreshToken=[YourRefreshToken];

    The variables are defined as follows:

  • [InstanceURL] is URL of the Eloqua instance that you are connecting to. Typically, the instance URL uses the following format: https://secure.[machineID].eloqua.com.
  • [RedirectURI] is the redirect URL associated with your Eloqua application.
  • [YourAccessToken] is your access token for authenticating to Eloqua.
  • [YourClientID] is the client ID associated with your Eloqua application.
  • [YourClientSecret] is the client secret associated with your Eloqua application.
  • [YourRefreshToken] is the refresh token associated with your Eloqua application.

For example:

jdbc:eloqua://localhost;Host=example.eloqua.com;Auth_Type=OAuth 2.0;Auth_AccessToken=kP9PcyQ7prK2LwUMZMpFQ4R+5VE;Auth_BaseRedirectUri=eloqua.domain1.com;Auth_Client_ID=f145kn9Pcyq9pr4lvumdapfl4rive;Auth_Client_Secret=45kn9Pcyq9pr4lvu123pfl4r57;Auth_RefreshToken=GdOj8Yis6TVQdQJ1WzM01z75;

Using Your Eloqua Application Information

If you do not already have a valid access token, you can configure the connector to retrieve and use one based on your Eloqua application information. To do this, provide the client ID, client secret, and redirect URL associated with your Eloqua application in the connection URL.

To authenticate using your Eloqua application information:

  • Connect to the server using a connection URL written in the following format:

    • jdbc:eloqua://localhost;Host=[InstanceURL];Auth_Type=OAuth 2.0;Auth_BaseRedirectUri=[RedirectURL];Auth_Client_ID=[YourClientID];Auth_Client_Secret=[YourClientSecret];

    The variables are defined as follows:

  • [InstanceURL] is URL of the Eloqua instance that you are connecting to. Typically, the instance URL uses the following format: https://secure.[machineID].eloqua.com.
  • [RedirectURI] is the redirect URL associated with your Eloqua application.
  • [YourClientID] is the client ID associated with your Eloqua application.
  • [YourClientSecret] is the client secret associated with your Eloqua application.

For example:

jdbc:eloqua://localhost;Host=example.eloqua.com;Auth_Type=OAuth 2.0;Auth_BaseRedirectUri=eloqua.domain1.com;Auth_Client_ID=f145kn9Pcyq9pr4lvumdapfl4rive;Auth_Client_Secret=45kn9Pcyq9pr4lvu123pfl4r57;

Related topics