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 userLSHAdmin
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 nameLSHAdmin
. - 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.
Parent topic: Setting Up Security for Informatica
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 exactlyLSHAdmin
, including upper- and lowercase as written.
Parent topic: Setting Up User Accounts
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.
Parent topic: Setting Up User Accounts
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.
Parent topic: Setting Up Security for Informatica
Creating the Informatica Remote Location in Oracle LSH
To use Informatica with Oracle LSH, you need to create the Remote Location in Oracle LSH.
Parent topic: Creating an Informatica Remote Location and Connection
Creating the Informatica Remote Connection in Oracle LSH
To use Informatica with Oracle LSH, you need to create the Remote Connection in Oracle LSH.
Parent topic: Creating an Informatica Remote Location and Connection