In order to install the Stuntbyte JDBC driver into your tool or application you will need:
Here is a sample JDBC URL. Make sure to use the correct domain for your instance. ie: "login.salesforce.com" for a Production or Developer instance, and "test.salesforce.com" for a Sandbox instance.
The URL also takes an optional "datatypes" parameter that controls how the various data types are displayed to the user. For example:
The supported values for the "datatypes" parameter are:
- api uses the datatypes as returned by the Salesforce API. This offers the richest range of data types, and is the default.
- ui uses the datatypes as they appear in the Salesforce UI. Ideal for users who are more comfortable at that level.
- sql92 uses SQL92 datatypes. Useful for tools that can't handle Salesforce datatypes, like Mogawai.
Note that "datatypes" can also be configured as a Property in the database connection, as well as part of the server URL.
This is the username you use to normally login to the desired Salesforce instance.
Stuntbyte software requires a licence. You can either include the licence as part of the password, or you can define it independently as an "extended property" in the JDBC connection.Licence in the password
If you decide to include the licence as part of the "password", then you should define the password as:
This password DOES include the literal values "licence(" and "sfdc(", so a sample password might look like this:
Licence as a separate property
If you decide to include the licence as part a separate property then you should define the password as:
<sfdc-password><sfdc-security-token>, for example:
... and then define a property named "licence" with the appropriate value.
Read more about obtaining a licence (including free ones) on the download page.