Oracle
- Universal Importer for Confluence
- Kim Landis (Unlicensed)
- Phillip Hanegan
Connecting to Oracle
EmpowerID includes an Oracle connector that allows organizations to bring the user data (user accounts, profiles and roles) in their Oracle system to EmpowerID, where it can be managed and synchronized with data in any connected back-end user directories. When EmpowerID inventories Oracle, it creates an account in the EmpowerID Identity Warehouse for each Oracle user, a group for each Oracle profile, and an EmpowerID Business Role for each Oracle role.
The Oracle connector allows organizations to bring the user data in their Oracle system to EmpowerID, where you can manage and synchronize it with data in any connected back-end user directories. Once connected, you can manage this data from EmpowerID in the following ways:
- Provision new users
- Edit user attributes
- Delete users
This topic demonstrates how to connect EmpowerID to Oracle.
Before configuring EmpowerID to manage the account store, determine whether you want EmpowerID to provision Person objects from the user records it discovers in the account store. If so, answer the following questions before turning on inventory.
- When do you want EmpowerID to provision Person objects for those user accounts? At inventory or at a later point in time?
- If inventory provisioning is desired, in what Business Role and Location should those Person objects be placed?
- How many user accounts can one Person have in the account store?
- If people can have more that one user account in the account store, do you want EmpowerID to attempt to automatically join any user accounts meeting the conditions of your Join rules to an existing Person during inventory?
For a greater discussion of these points within the context of connecting EmpowerID to an account store, see Active Directory.
To create an account store for Oracle via the web site
- In the Navigation Sidebar, expand Admin, then Applications and Directories, and click Account Stores and Systems.
- Click the Actions tab, and then click the Create Account Store action.
- Search for and select Oracle Users from the list of system types and click Submit.
On the Oracle Settings page that appears, enter settings to connect to your Oracle instance to allow EmpowerID to discover and connect to it.
- In the Name field, enter a name for the account store.
- In the User Name field, enter the user name of an Oracle administrator.
- In the Password field, enter the Oracle admin's password.
- In the Server field, enter the FQDN or IP address of the Oracle system's server.
- In the Database field, enter the name of the Oracle database.
Click Submit.
- The Account Store and associated Resource System are created and appear in both the web application and in the Management Console.
To edit account store settings on the web
- In the Navigation Sidebar, expand Admin, then Applications and Directories, and click Account Stores and Systems.
- On the Account Stores tab, search for the account store you just created and click the link to go to its details page.
- On the Account Store Details page, click the Edit button or the name of the account store.
In the edit view of the page, you can edit values in any of the enabled fields on several tabs as detailed in the tables below. Do not enable inventory until the end.
If you do not want all of the users and groups found during inventory to go in the same location in EmpowerID, we recommend Mapping EmpowerID Locations to External Locations before enabling inventory.
When you have finished editing, click Save.
Clicking the Save button on any of the tabs saves any changed settings on all of the tabs, so there is no need to save it after each tab.
Settings Tab
General section
Setting | Description |
---|---|
Option 1 Specify an Account Proxy | Click Edit to change the Domain (Server), User Name, and Password that was entered when the account store was created. |
Option 2 Select a Vaulted Credential as Account Proxy | Click the drop-down arrow to select a vaulted credential to use as the account proxy. |
Inventoried Directory Server | Click the drop-down arrow to select from any connected Oracle servers. |
Authentication and Password Settings section
Setting | Description |
---|---|
Password Manager Policy for Accounts without Person | Select a password manager policy to use for the account. If not selected, it uses the Default Password Manager Policy. |
Provisioning Settings section
Setting | Description |
---|---|
Allow Attribute Flow | Toggle to allow attribute changes to flow between EmpowerID and the account store. |
Allow Provisioning (By RET) | Toggle to allow EmpowerID to create users in the system that were created in EmpowerID. |
Allow Deprovisioning (By RET) | Toggle to allow EmpowerID to delete users in the system that were deleted in EmpowerID. |
Default User Creation Path | Select an external location in which to create users when they are provisioned in EmpowerID. |
Default Group Creation Path | Select an external location in which to create groups when they are created in EmpowerID. |
Max Accounts per Person | Enter the maximum number of user accounts from this domain that an EmpowerID Person can have linked to them. This prevents the possibility of a runaway error caused by a wrongly configured Join rule. We recommended setting this value to 1 unless users commonly have multiple accounts and you want them to be joined to the same person. |
Default Person Business Role | Select a default Business Role to assign provisioned people if none is specified. |
Default Person Location | Select a default Location to assign provisioned people if none is specified. |
Special Use Settings section
Setting | Description |
---|---|
RBAC Assign Group Members On First Inventory | This setting only pertains to Active Directory account stores. |
Automatically Join Account to a Person On Inventory (Skip Account Inbox) | Toggle to allow EmpowerID to join newly discovered accounts to people during the inventory process if they meet the Join Rule as specified by the Custom_Account_InventoryInboxJoinBulk SQL stored procedure. |
Automatically Create a Person On Inventory (Skip Account Inbox) | Toggle to allow EmpowerID to provision EmpowerID people for new accounts discovered during the inventory process if they meet the Provision Rule specified by the Custom_Account_InventoryInboxGetAccountsToProvision SQL stored procedure. |
Show in Tree | Toggle to show the account store in the Locations tree. |
Queue Password Changes on Failure | Toggle to have EmpowerID send password changes to the Account Password Reset Inbox only when the change fails. |
Use Secure LDAPS Binding | Toggle to bind accounts with encryption. |
Naming Fields section
Setting | Description |
---|---|
Application ID | If the account store is a one-to-one match with a Tracking Only application, enter the Application Resource GUID of the application. (This value is supplied automatically if you select the Create a New Account Directory option when creating a Tracking Only application.) |
Tenant ID | Enter the Tenant ID, if supplied by the connection account. (AWS uses this.) |
Inventory Tab
The Inventory tab is where you set scheduling and enable EmpowerID to take inventory of the external system. If you do not want all of the users and groups found during inventory to go in the same location in EmpowerID, we recommend Mapping EmpowerID Locations to External Locations before enabling inventory.
Setting | Description |
---|---|
Inventory Enabled | Select this after everything is set up to your liking to allow EmpowerID to inventory the system. The Inventory Job must be enabled for inventory to occur. |
Inventory Schedule Interval: Start | Set the date on which to begin inventorying the system. By default, this is set to the creation date of the account store. |
Inventory Schedule Interval: End | Set the date on which to stop inventorying the system. By default, this is set to ten years after the creation date of the account store, but since Run Indefinitely is selected by default, this value is ignored unless you clear that checkbox. |
Inventory Schedule Interval: (units) | Select the units for the interval at which to run inventory. By default, this is set to 10 minutes.
|
Run Indefinitely | Select to allow inventory to run indefinitely, ignoring the End date. |
Interval: (number) | Set the number of units for the interval at which to run inventory. By default, this is set to 10 minutes. |
Inventory Next Compilation Time | If you do not want to wait for the next regularly scheduled inventory run, specify the time and date to run it next. |
Inventory Batch Size | Specify the number of records to process in each batch, to avoid hanging up your system when large numbers of records are processed. By default, this is set to 1,000 records. |
Membership Tab
Group membership reconciliation is enabled by default to run every ten minutes, indefinitely.
Setting | Description |
---|---|
Enable Group Membership Reconciliation | Select to allow EmpowerID to reconcile group membership with the system. This is enabled by default. |
Membership Schedule Interval: Start | Set the date on which to begin reconciling group membership with the system. By default, this is set to the creation date of the account store. |
Membership Schedule Interval: End | Set the date on which to stop reconciling group membership with the system. By default, this is set to ten years after the creation date of the account store, but since Run Indefinitely is selected by default, this value is ignored unless you clear that checkbox. |
Membership Schedule Interval: (units) | Select the units for the interval at which to run inventory. By default, this is set to 10 minutes.
|
Run Indefinitely | Select to allow group membership reconciliation to run indefinitely, ignoring the End date. |
Interval: (number) | Set the number of units for the interval at which to run rights inventory. By default, this is set to 10 minutes. |
Projection Tab
The Projection tab is where you set scheduling and enable EmpowerID to sync resource role group membership with the account store.
Setting | Description |
---|---|
Resource Role Group Membership Projection Enabled | Select to allow EmpowerID to dynamically manage the membership of the organization's groups, adding and removing users to and from groups based on policy-based assignment rules. This is disabled by default. |
Rights Inventory Schedule Interval: Start | Set the date on which to begin projection. By default, this is set to the creation date of the account store. |
Rights Inventory Schedule Interval: End | Set the date on which to stop projection. By default, this is set to ten years after the creation date of the account store, but since Run Indefinitely is selected by default, this value is ignored unless you clear that checkbox. |
Rights Inventory Schedule Interval: (units) | Select the units for the interval at which to run projection. By default, this is set to 10 minutes.
|
Run Indefinitely | Select to allow projection to run indefinitely, ignoring the End date. |
Interval: (number) | Set the number of units for the interval at which to run projection. By default, this is set to 10 minutes. |
Inventory Next Compilation Time | If you do not want to wait for the next regularly scheduled projection run, specify the time and date to run it next. |
Rights Inventory Tab
The Rights Inventory tab is where you set scheduling and enable EmpowerID to take inventory of rights in the native system.
Setting | Description |
---|---|
Rights Inventory Is Enabled | Select to allow EmpowerID to inventory native rights in the system. This is disabled by default. |
Rights Inventory Schedule Interval: Start | Set the date on which to begin inventorying rights in the system. By default, this is set to the creation date of the account store. |
Rights Inventory Schedule Interval: End | Set the date on which to stop inventorying rights in the system. By default, this is set to ten years after the creation date of the account store, but since Run Indefinitely is selected by default, this value is ignored unless you clear that checkbox. |
Rights Inventory Schedule Interval: (units) | Select the units for the interval at which to run rights inventory. By default, this is set to 10 minutes.
|
Run Indefinitely | Select to allow rights inventory to run indefinitely, ignoring the End date. |
Interval: (number) | Set the number of units for the interval at which to run rights inventory. By default, this is set to 10 minutes. |
Inventory Next Compilation Time | If you do not want to wait for the next regularly scheduled rights inventory run, specify the time and date to run it next. |
Enforcement Tab
Setting | Description |
---|---|
Resource Role Group Rights Enforcement Enabled | Select to allow EmpowerID to determine who should have access to what in Exchange based on their assignments to Access Levels in EmpowerID and to enforce it using domain local groups (Resource Role Groups). |
Enforcement Type | Select to specify how EmpowerID is to enforce rights in native systems.
|
Schedule: Start | Set the date on which to begin enforcement. By default, this is set to the creation date of the account store. |
Schedule: End | Set the date on which to stop enforcement. By default, this is set to ten years after the creation date of the account store, but since Run Indefinitely is selected by default, this value is ignored unless you clear that checkbox. |
Interval: (units) | Select the units for the interval at which to run enforcement. By default, this is set to 10 minutes.
|
Run Indefinitely | Select to allow enforcement to run indefinitely, ignoring the End date. |
Interval: (number) | Set the number of units for the interval at which to run enforcement. By default, this is set to 10 minutes. |
Enforcement Frequency | Set the re-enforcement frequency in minutes. |