Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Configure Policy, Key, Logging, or Session Stores › Configure an ODBC Database as a Policy Store

Configure an ODBC Database as a Policy Store

To configure an ODBC database as a policy store

1. Start the Policy Server Management Console.

   Important! If you are accessing this graphical user interface on Windows Server 2008, open the shortcut with Administrator permissions, even if you are logged into the system as an Administrator. For more information, see the release notes for your SiteMinder component.

2. Select the Data tab to move it to the front.
3. In the Storage drop-down list, select ODBC.
4. In the Database drop-down list, select Policy Store.
5. In the Data Source Information field, enter the name of the data source.
   • For Windows systems, this name must correspond to the name you entered in the Data Source field of the ODBC Oracle Wire Protocol Driver Setup dialog box, when you created your Oracle data source or to the name you entered in the Data Source field of the ODBC SQL Server Wire Protocol Driver Setup dialog box when you created your SQL data source.
   • For UNIX systems, the value you enter must match the first line of the data source entry in the system_odbc.ini file when you created your SQL server data sources or your Oracle data sources. This file is located in $NETE_PS_ROOT/db. For example, the first line of the default entry in the system_odbc.ini file is [SiteMinder Data Source], so you would enter SiteMinder Data Source in the Data Source Name field. If you modified the entry in the system_odbc.ini file, you would enter that value in the Data Source Information field.

   Note: When entering the data source name, do not include the brackets.

6. In the User Name and Password fields, enter the username and password of the database account that has full access rights to the Oracle or SQL Server database instance.
7. In the Confirm Password field, re-enter the password.
8. Specify the maximum number of database connections allocated to SiteMinder. For best performance, retain the default of 25 connections.
9. (Optional) Click Test Connection to make sure the connection works.
10. Click Apply to save the settings.
11. Click the Status tab.
12. Stop and restart the Policy Server.

More Information:

Create an Oracle Data Source on Windows Systems

Create an Oracle Data Source on UNIX Systems

Create a SQL Server Data Source on Windows Systems

Create a SQL Server Data Sources on UNIX Systems