To add an SQL database by entering information directly into OPTIONS.ini (instead of using the Add Database dialog—see Adding a Database), add a line of text of the following form:

You must supply all fields. Use “-” for fields that do not have a value.

Following is an example:

In the example above, the databaseName is myDatabase, and both useClientCredentials and runQueriesConcurrently are false. All other fields are not specified.

For JDBC databases jdbcUrl and jdbcClassName must be set.

See also Generating encrypted passwords for SQL data sources.