4.1.3 Assigning User-Specific Data Source Login Credentials
You can allow different users to connect to the data source with user-specific login credentials. To configure user-specific login credentials, follow the steps below:
1. If a static username and password has been set for the data source, remove the static username and password.

2. Configure an SSO request filter to inject the following properties into the user Principal object:
a. Username Parameter Name: _Db_User_{Datasource Name}
b. Password Parameter Name: _Db_Password_{Datasource Name}
See Session-Based Single Sign-On in Integration for information on how to create a request filter.
All queries executed by a user on the data source will then utilize the assigned user-specific login credentials.
For example, the following request filter code assigns the login credentials for a particular user on a JDBC data source named 'Orders':
String username = lookupDatabaseUser(principal);
String password = lookupDatabasePassword(principal);
principal.setParameter("_Db_User_Orders", username);
principal.setParameter("_Db_Password_Orders", password);
In this example, you would need to create the lookupDatabaseUser() and lookupDatabasePassword() methods as part of the SSO Filter.
| << 4.1.2 Parameterizing the Data Source | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.1.4 Adding Additional Connections >> |