Developing Apama Applications > Building Dashboards > Using SQL Data > Specifying application options > Entering database information directory into OPTIONS.ini
Entering database information directory into OPTIONS.ini
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:
sqldb databaseName username password jdbcUrl jdbcClassName tableTypes useClientCredentials-boolean
runQueriesConcurrently-boolean
You must supply all fields. Use “-” for fields that do not have a value.
Following is an example:
sqldb myDatabase - - - - - false false
In the example above, the databaseName is myDatabase, and both useClientCredentials and runQueriesConcurrently are false. All other fields are not specified.
For ODBC databases, use “-” for jdbcUrl and jdbcClassName. For JDBC databases these fields must be set.
See also Generating encrypted passwords for SQL data sources.
Copyright © Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its Subsidiaries and or/its Affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.