Building the Connection URL

Use the connection URL to supply connection information to the data store that you are accessing. The examples below show the format of the connection URL for the Simba Oracle Eloqua JDBC Connector:

jdbc:eloqua://localhost;Host=[InstanceURL];Auth_Type=[AuthenticationMethod];[Property1]=[Value];[Property2]=[Value];...

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.
[AuthenticationMethod] is the authentication method used to connect to the Eloqua instance.
[Property] is any one of the other connection properties supported by the connector. At minimum, you must set the properties that provide your credentials for authentication.

For information about configuring authentication, see Configuring Authentication. For a list of the properties available in the connector, see Connector Configuration Options.

For example, to connect to Eloqua and authenticate the connection using your Eloqua user name and password, you would use the following connection URL:

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

Important:

Do not duplicate properties in the connection URL.