13 Setting Up Security for Informatica

You need to set up user accounts and create a Remote Location and Remote Connection in Informatica.

This section contains the following topics:

• Setting Up User Accounts
  You need to create an Informatica administrator account and accounts for each Oracle LSH definer to integrate Informatica with Oracle Life Sciences Data Hub.
• Creating an Informatica Remote Location and Connection
  You must store the Informatica administrative user LSHAdmin in Oracle Life Sciences Data Hub as a Remote Connection.

Setting Up User Accounts

You need to create an Informatica administrator account and accounts for each Oracle LSH definer to integrate Informatica with Oracle Life Sciences Data Hub.

This section contains the following topics:

• Informatica Administrator Account
  You must create an Informatica administrator account with the name LSHAdmin.
• Accounts for Each Oracle LSH Definer
  To work with Informatica, each Oracle LSH Definer needs an Oracle LSH application user account and a corresponding data base account and an Informatica user account that matches Oracle LSH application user account.

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 an Oracle LSH application user account and a corresponding data base account and an Informatica user account that matches Oracle LSH application user account.

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.

For more details on the Oracle Life Sciences Data Hub application user account and a corresponding Oracle LSH database user account, see Setting Up User Accountsand Creating Database Accounts. For more details on setting up accounts in Informatica, see the appropriate Informatica documentation.

Creating an Informatica Remote Location and Connection

You must store the Informatica administrative user LSHAdmin in Oracle Life Sciences Data Hub as a Remote Connection.

Note:

For details on registering the Informatica locations and connections, see Registering Locations and Connections.

This section contains the following topics:

• Creating the Informatica Remote Location in Oracle LSH
  To use Informatica with Oracle LSH, you need to create the Remote Location in Oracle LSH.
• Creating the Informatica Remote Connection in Oracle LSH
  To use Informatica with Oracle LSH, you need to create the Remote Connection in Oracle LSH.

Creating the Informatica Remote Location in Oracle LSH

To use Informatica with Oracle LSH, you need to create the Remote Location in Oracle LSH.

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 use Informatica with Oracle LSH, you need to create the Remote Connection in Oracle LSH.

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.