Configuration Guide › Sample CA IdentityMinder 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.

Follow these steps:

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: To create a NeteAuto database, neteautoadmin role must have at least minimum (select, insert, update, and delete) permissions for all the tables that are created by.sql script. Also, neteautoadmin must be able to execute all of the stored procedures, if any, defined in these scripts.

3. When you edit user 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 Microsoft SQL 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 IdentityMinder is installed. The section How to Create a JDBC Data Source includes application server-specific instructions for creating a JDBC data source.