Oracle Identity Manager: Provisioning to a Database Table
Provisioning a User to a Database Table
More information in the Provisioning a User to a Database Table tutorial.
Create or configure the database table
1.Creating the table
You can work with a already configured table or you can create your table of user data as follows:
CREATE TABLE "XLADM"."USER_DATA"
( "USER_ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"FIRSTNAME" VARCHAR2(20 BYTE),
"LASTNAME" VARCHAR2(20 BYTE),
"ORGANIZATION" VARCHAR2(20 BYTE),
"PASSWORD" VARCHAR2(20 BYTE),
"EMAIL" VARCHAR2(20 BYTE),
"COMPANY" VARCHAR2(20 BYTE),
CONSTRAINT "USER_DATA_PK" PRIMARY KEY ("USER_ID")
) ;
Install the Connector
1. Download the Database Application Table Connector 9.1.0.3
from Oracle Identity Manager Connectors or download the Database Application Table Connector 9.1.0.0 from the tutorial zip.
2. Copy the unzipped folder DBAT_9103 to \ConnectorDefaultDirectory
D:\Oracle\xellerate\ConnectorDefaultDirectory\DBAT_9103
3. Installing the Connector
Deployment Management > Install Connector
Select DatabaseApplicationTables 9.1.0.3.0
Load
Continue
Create the GTC Connector
1. Generic Technology connector > Create.
2. Provide basic information:
Name: A name for the connector
Provisioning: Provision information into the resource.
Transport Provider: The method used to transfer the record contained in the flat file into Oracle identity Manager.
Format Provider: The method used to parse the record fetched by the transport provider and convert this data into a structure to be stored in Oracle Identity Manager.
Ex:
Name: DB App Users Provisioning: yes Transport Provider: Database Application Tables Provisioning Format Provider: Database Application Tables Provisioning
3. Specify Parameter values for the connector
Runtime Parameters: These parameters are input variables of the selected transport and format providers. A runtime parameter represents a value not constrained by the design of the providers.
Database Driver: JDBC driver class
Database URL: JDBC URL for the target database. Value: jdbc:oracle:thin:@host_IP:1521:Database_Name
Database User ID: Database user ID (as sysdba) on the target database.
Database Password: Password of the DBA login that is used to create users.
Connection Properties
Ex (Oracle Database)
Database Drive: oracle.jdbc.driver.OracleDriver Database URL: jdbc:oracle:thin:@localhost:1521:XELL Database User: xladm Database Password: Password1 Connection Properties:
Parent Table/View Name: USER_DATA
4. For this connector, all data fields and mappings are correct
5. Verify Connector Form Names
DBAPPS
Assign the Resource to the user
1. Select the user
Users > Manage > Search
2. Select the Resource Profile and click Provision New Resource
3. Select the Resource
DB APPS USERS_GTC
