Configuration Guide › Sample Identity Manager Environment › How to Configure the NeteAuto Sample with Organization Support › Configure a Relational Database

Configure a Relational Database

Perform the following procedure to configure a relational database.

To configure a relational database

1. Create a database instance named NeteAuto.
2. Create a user named neteautoadmin with the password test. Grant neteautoadmin rights (such as public and db_owner rights) to NeteAuto by editing the properties of the user.

   Note: The neteautoadmin must have at least select, insert, update and delete permissions for all the tables created by the .sql script for creating the NeteAuto database, and must be able to execute all of the stored procedures, if any, defined in these scripts.

3. While editing the user’s properties, make NeteAuto the default database for neteautoadmin.
4. Run the following scripts in the order in which they are listed:
   • db_type-rdbuserdirectory.sql—Configures the tables for the NeteAuto sample, and creates the user entries
   • ims_db_type_rdb.sql—Configures support for organizations

     db_type

     Defines the mssql or oracle depending on the type of database that you are configuring.

   These script files are located in the admin_tools\samples\NeteAutoRDB\Organization folder. In this example, admin_tools refers to the Administrative Tools, which are installed in the following default locations:

   • Windows: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools
   • UNIX: /opt/CA/IdentityManager/IAM_Suite/Identity_Manager/tools
5. Define a JDBC data source named neteautoDS that points to the NeteAuto database.

   The procedure for configuring a data source depends on the type of application server where CA Identity Manager is installed. The section How to Create a JDBC Data Source includes application server-specific instructions for creating a JDBC data source.