Developing Apama Applications > Building Dashboards > Using SQL Data > Specifying application options > Entering database information directory into OPTIONS.ini > Generating encrypted passwords for SQL data sources
Generating encrypted passwords for SQL data sources
If you are adding an SQL data source by entering information directly into OPTIONS.ini (see Entering database information directory into OPTIONS.ini), and you specify a username and password, use the dashboard_management utility in order to generate an encrypted version of the password. Use the encrypted version in the sqldb line of OPTIONS.ini.
Commands of the following form yield the encrypted string as output:
dashboard_management -e | --encryptString password
Following is an example:
dashboard_management -e sunshine
This yields the following output:
0134901351013440134901338013390134401335
Following is a sample sqldb line that includes the encrypted password shown above:
sqldb test2 username 0134901351013440134901338013390134401335 - - - true false
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.