Installation Guides › Policy Server Installation Guide › Configuring SOA Security Manager Data Stores in a Relational Database › Configure Oracle Data Stores › How to Store Key Information in Oracle › Point the Policy Server to Database

Point the Policy Server to Database

You point the Policy Server to the database so the Policy Server can read and store key information.

To point the Policy Server to the data store

1. Open the Policy Server Management Console, and click the Data tab.

   Database settings appear.

2. Select ODBC from the Storage list.

   ODBC settings appear.

3. Select Key Store from the Database list and clear the Use Policy Store database check box.

   Data source settings become active.

4. Enter the name of the data source in the Data Source Information field.
   • (Windows) this entry must match the name you entered in the Data Source Name field when you created the data source.
   • (UNIX) this entry must match the first line of the data source entry in the system_odbc.ini file. By default, the first line in the file is [SOA Security Manager Data Sources]. If you modified the first entry, be sure that you enter the correct value.
5. Enter and confirm the user name and password of the database account that has full access rights to the database instance in the respective fields.
6. Specify the maximum number of database connections allocated to SOA Security Manager.

   Note: We recommend retaining the default for best performance.

7. Click Apply.

   The settings are saved.

8. Click Test Connection.

   SiteMinder returns a confirmation that the Policy Server can access the data store.

9. Click OK.

   The Policy Server is configured to use the database as a key store