13 Setting Up Security for Informatica

This section contains the following topics:

• Setting Up User Accounts

• Creating an Informatica Remote Location and Connection

You need to set up the following user accounts to integrate Oracle LSH with Informatica:

Setting Up User Accounts

You need the following accounts to integrate Informatica with Oracle LSH:

• Informatica Administrator Account

• Accounts for Each Oracle LSH Definer

Informatica Administrator Account

You must create an Informatica administrator account with the name LSHAdmin. This Informatica administrative user owns all the security groups and workflows created in association with Oracle LSH.

See the appropriate Informatica documentation for instructions on setting up user accounts in Informatica.

Note:

The administrator account name must be exactly LSHAdmin, including upper- and lowercase as written.

Accounts for Each Oracle LSH Definer

To work with Informatica, each Oracle LSH Definer needs the following user accounts:

• An Oracle LSH application user account and a corresponding Oracle LSH database user account. See "Setting Up User Accounts"and "Creating Database Accounts".

• An Informatica user account with the same username as the Oracle LSH application user account. See the appropriate Informatica documentation for instructions on setting up user accounts in Informatica.

  You must create Informatica user accounts with all uppercase letters for use with Oracle LSH (except for the LSHAdmin account).

  This is because Oracle LSH application and database user accounts are maintained in Oracle FND, which stores user names in uppercase though it accepts mixed case at login. In Informatica, user names are case sensitive. When a Definer launches Informatica from Oracle LSH, the system performs a security check that matches the user's Informatica and Oracle LSH user names. If the Informatica user name is not in uppercase, the security check fails and the Definer cannot launch Informatica.

  Note:

  The LSHAdmin account is not an FND account and must be entered in upper- and lowercase as shown.

Creating an Informatica Remote Location and Connection

This section contains the following topics:

• Creating the Informatica Remote Location in Oracle LSH

• Creating the Informatica Remote Connection in Oracle LSH

You must store the Informatica administrative user LSHAdmin in Oracle LSH as a Remote Connection. See Chapter 5, "Registering Locations and Connections" for details on Oracle LSH Remote Connections.

Creating the Informatica Remote Location in Oracle LSH

To create the Remote Location in Oracle LSH, do the following:

1. Click the Remote Location subtab under the Administration tab. The Maintain Remote Locations screen opens.

2. Click Add Remote Location. The Create Remote Location screen appears.

3. Enter values in the following fields:

   Note:

   Enter the values exactly as specified below, else the Oracle LSH Informatica Program will not run.

   • Name. Enter INFORMATICAADMIN

   • DBLINK Prefix. Enter INFORMATICAADMIN.

   • Connect String. Enter INFORMATICAADMIN.

   • Adapter. Select Informatica.

4. In the Classification section, select the following for both the definition and the instance:

   • Subtype. Select a subtype according to your company's policies.

   • Classification Values. Specify classifications according to your company's policies, to enable users to search for the Remote Location by classification. For instructions, see "Classifying Objects and Outputs" in the Oracle Life Sciences Data Hub Application Developer's Guide.

5. Click Apply to save your work. The system opens the main screen for the new Remote Location.

   You can change the security and classifications of the Remote Location through the items in the Actions drop-down list. By default, the Remote Location inherits the user group assignments of the Adapter Area.

Creating the Informatica Remote Connection in Oracle LSH

To create the Remote Connection in Oracle LSH, do the following:

1. In the main screen for the Remote Location INFORMATICAADMIN click Create Connection. The Create Connection screen opens.

2. Enter values in the following fields:

   Note:

   Enter the values exactly as specified below, else the Oracle LSH Informatica Program will not run.

   • Name. Enter LSHADMIN.

   • User Name. Enter LSHAdmin.

   • Password. Enter the password for the Informatica LSHAdmin user.

   • Connection Type. Select Shared.

   • Remote Location. The system populates the field with the name of the Remote Location.

3. In the Classification section, select the following for both the definition and the instance:

   • Subtype. Select a subtype according to your company's policies.

   • Classification Values. Specify classifications according to your company's policies, to enable users to search for the Connection by classification. For instructions, see "Classifying Objects and Outputs" in the Oracle Life Sciences Data Hub Application Developer's Guide.

4. Click Apply to save your work. The system displays the main screen for the new Connection.