Building the Connection URL
Use the connection URL to supply connection information to the data store that you are accessing. The following is the format of the connection URL for the Simba Salesforce JDBC Connector:
jdbc:salesforce://localhost;[Property1]=[Value];
[Property2]=[Value];...
Be aware of the following about the connection URL format:
- [Property] and [Value] are any one of the other connection properties supported by the connector and the value for that property. For a list of the properties available in the connector, see Connector Configuration Options.
- If you are connecting to a sandbox system, you must set the
Endpoint
property to the sandbox URL. For more information, see Endpoint. - The
localhost
value must be included, but it is not used in establishing a connection to Salesforce.com.
For example, to connect to Salesforce.com and authenticate the connection using a user name and password, you would use the following connection URL:
jdbc:salesforce://localhost;UID=simba;PWD=simba
Important:
Do not duplicate properties in the connection URL.
You can also use a Properties
object to set properties. For examples, see Using OAuth, Using Single Sign-On, and Using User Name And Password.