Configuration Guides › Policy Server Configuration Guide › Administrative User Interface Management › SiteMinder Administrators › How to Configure an External Administrator Store › Deploy a JDBC Data Source

Deploy a JDBC Data Source

If you are configuring a connection to a relational database, the Administrative UI requires a JDBC data source to communicate with the administrator store. A utility is required to create the data source. If you installed the Administrative UI using the stand-alone option, the smjdbcsetup utility is provided for you.

Note: If you installed the Administrative UI to an existing application server, see your vendor-specific documentation for information about deploying a JDBC data source. If you are deploying a data source to WebSphere, be sure that the JNDI name, under the datasource properties, is prefixed with the following:

jdbc/

Example: If the datasource name is abc, then the JNDI name is jdbc/abc.

To deploy a data source using the smjdbcsetup utility

1. Log into the Administrative UI host system.
2. (UNIX) Stop the SOA Security Manager Administrative UI service.

   Note: For more information about stopping the service, see the Policy Server Installation Guide.

3. Navigate to administrative_ui_home\CA\SiteMinder\adminui\bin.

   administrative_ui_home

   Specifies the Administrative UI installation path.

4. Run one of the following commands:
   • (Windows)

     smjdbcsetup.bat
     

     Important! Before running a SOA Security Manager utility or executable on Windows Server 2008, open the command line window with administrator permissions. Open the command line window this way, even if your account has administrator privileges. For more information, see the release notes for your SOA Security Manager component.

   • (UNIX)

     smjdbcsetup.sh
     

   The utility prompts you for a unique identifier. The utility appends the identifier to the data source.

5. Type a value and press Enter.

   The utility prompts you for a database driver type. The driver types are prefixed with a number.

6. Type a number to select a driver type and press Enter.

   The utility prompts you for the name of the database host system.

7. Type the database host name and press Enter.

   The utility prompts you for the port on which the database is listening.

8. Type the database port and press Enter.
   • If you are configuring a connection to Microsoft SQL Server, the utility prompts you for the database name.
   • If you are configuring a connection to Oracle, the utility prompts you for the service name.
9. Type the database name or the service name and press Enter.

   The utility prompts you for the database user account name.

10. Type the database user account name and press Enter.

    Note: This user account must have read/write permissions to the database.

    The utility prompts you for the password of the database user.

11. Type the password and press Enter.

    The connection details appear.

12. Review the details and do one of the following:
    • To configure and deploy the data source, type y and press Enter.

      The utility deploys the data source to admin_ui_home\CA\SiteMinder\adminui\server\default\deploy and prompts you to restart the SOA Security Manager Administrative UI service.

      admin_ui_home

      Specifies the Administrative UI installation path.

      Note: Restarting the SOA Security Manager Administrative UI service is required before you can use the data source to create the connection.

    • To cancel the deployment, type n and press Enter.
13. Do one of the following:
    • To start the service automatically, do one of the following:
      • (Windows) Type y and press Enter.
      • (UNIX) You must manually start the service. For more information about starting the service, see the Policy Server Installation Guide.
    • To start the service manually, type n and press Enter.

    The data source is configured and the utility exits.