The connection URL takes the following form:

jdbc:datadirect:oraclesalescloud://base_url;User=user_id;
   Password=password[;property=value[;...]]
Note:
  • Connection property names are case-insensitive. For example, Password is the same as password.
  • For connection properties that support string values, use the following escape sequence to specify values containing leading or trailing spaces and curly brackets: {value}. For example: User={hello } or Password={{hello}}.

where:

base_url

specifies the base URL of the Oracle Sales Cloud site to which you are connecting, for example, mysite.custhelp.com. This value should not include an internet protocol such as http:// or https://.

user_id

specifies the user name that used to connect to the Oracle Sales Cloud instance.

password

specifies the password for the specified User.

property=value
specifies additional connection property settings.

The following is an example of a connection URL to an Oracle Sales Cloud instance.

jdbc:datadirect:oraclesalescloud://mysite.custhelp.com;User=123@abccorp.com;Password=secret