Go to main content
1/17
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's New in the Oracle Identity Manager Connector for Database User Management?
Software Updates
Software Updates in Release 11.1.1.8.0
Software Updates in Release 11.1.1.6.0
Support for MySQL, DB2, and Sybase Databases
Software Updates in Release 11.1.1.5.0
ICF Based Connector
Connector Bundle
Support for Connection Pooling
Support for Running the Connector Remotely Using ICF Remote Connector Server
Support for Multiple Instances and Multiple Versions of Target System
Support for Running Pre/Post Action Scripts
Support for Transformation and Validation
Support for Resource Exclusion Lists
Improved Trusted Reconciliation
Support for Incremental and Limited Reconciliation
Support for JDBC-Based Database Customization
Documentation-Specific Updates
Documentation-Specific Updates in Release 11.1.1.8.0
Documentation-Specific Updates in Release 11.1.1.6.0
Documentation-Specific Updates in Release 11.1.1.5.0
1
About the Connector
1.1
Introduction to the Database User Management Connector
1.2
Certified Components
1.3
Usage Recommendation
1.4
Certified Languages
1.5
Connector Architecture
1.6
Features of the Connector
1.6.1
Mapping Standard and Custom Attributes for Reconciliation and Provisioning
1.6.2
Predefined and Custom Reconciliation Queries
1.6.3
Predefined and Custom Provisioning Queries
1.6.4
Support for Creating Global and External Users In Oracle Database
1.6.5
Full and Incremental Reconciliation
1.6.6
Limited (Filtered) Reconciliation
1.6.7
Batched Reconciliation
1.6.8
Specifying Accounts to Be Excluded from Reconciliation and Provisioning Operations
1.6.9
Connection Pooling
1.6.10
Support for Connector Server
1.6.11
Support for Creating Connector Copies
1.6.12
Transformation and Validation of Account Data
1.6.13
Support for Reconciling Data About Deleted Entities
1.6.14
Separate Scheduled Jobs for Reconciliation of Users, Logins, and Deleted Login Entities
1.6.15
Support for SSL Communication Between the Target System and Oracle Identity Manager
1.6.16
Support for Managing Authorization to Oracle Database Vault Realms
1.6.17
Support for Configuring the Connector for Enterprise User Security
1.7
Roadmap for Deploying and Using the Connector
2
Deploying the Connector
2.1
Preinstallation
2.1.1
Files and Directories on the Installation Media
2.1.2
Preinstallation on Microsoft SQL Server
2.1.3
Creating a Target System User Account for Connector Operations
2.2
Installation
2.2.1
Understanding the Installation of the Connector
2.2.2
Installing the Connector in Oracle Identity Manager
2.2.3
Deploying the Connector Bundle in a Connector Server
2.2.3.1
Installing and Configuring the Connector Server
2.2.3.2
Running the Connector Server
2.2.3.3
Installing the Connector on the Connector Server
2.3
Postinstallation
2.3.1
Postinstallation on Oracle Identity Manager
2.3.1.1
Configuring the Target System As a Trusted Source
2.3.1.2
Changing to the Required Input Locale
2.3.1.3
Clearing Content Related to the Connector Resource Bundles from the Server Cache
2.3.1.4
Creating the Administrator Account on Oracle Database Vault
2.3.1.5
Setting up the Lookup Definition for Connection Pooling
2.3.1.6
Managing Logging for Oracle Identity Manager
2.3.1.6.1
Understanding Log Levels
2.3.1.6.2
Enabling Logging
2.3.1.7
Configuring Oracle Identity Manager Release 11.1.2 or Later
2.3.1.7.1
Creating and Activating a Sandbox
2.3.1.7.2
Creating a New UI Form
2.3.1.7.3
Creating an Application Instance
2.3.1.7.4
Publishing a Sandbox
2.3.1.7.5
Harvesting Entitlements and Sync Catalog
2.3.1.7.6
Updating an Existing Application Instance with a New Form
2.3.1.8
Localizing Field Labels in UI Forms for the Connector
2.3.2
Configuring the IT Resource for the Target System
2.3.3
Configuring the Connector to Support Multiple Versions of the Target System
2.3.4
Configuring the IT Resource for the Connector Server
2.3.5
Enabling Logging for Connector Server
2.4
Upgrading the Connector
2.4.1
Preupgrade Steps
2.4.2
Upgrade Steps
2.4.3
Postupgrade Steps
2.5
Postcloning Steps
2.5.1
Connector Objects
2.5.2
Postcloning Configuration for User Accounts
3
Using and Extending the Connector for MSSQL
3.1
Configuring Secure Communication Between MSSQL and Oracle Identity Manager
3.2
Guidelines on Determining Values for the JDBC URL and Connection Properties Parameters for MSSQL
3.3
Lookup Definitions for MSSQL
3.3.1
Lookup Definitions Synchronized with MSSQL
3.3.2
Lookup Definitions for Configurations for MSSQL
3.3.2.1
Lookup.DBUM.MSSQL.Configuration
3.3.2.2
Lookup.DBUM.MSSQL.Login.Configuration
3.3.2.3
Lookup.DBUM.MSSQL.UM.Configuration
3.3.2.4
Lookup.DBUM.MSSQL.Configuration.Trusted
3.3.2.5
Lookup.DBUM.MSSQL.UM.Configuration.Trusted
3.3.3
Lookup Definitions for Attribute Mappings for MSSQL Login Entity
3.3.3.1
Lookup.DBUM.MSSQL.Login.ProvAttrMap
3.3.3.2
Lookup.DBUM.MSSQL.Login.ReconAttrMap
3.3.3.3
Lookup.DBUM.MSSQL.Login.ReconDefaults
3.3.4
Lookup Definitions for Attribute Mappings for MSSQL User Entity
3.3.4.1
Lookup.DBUM.MSSQL.UM.ProvAttrMap
3.3.4.2
Lookup.DBUM.MSSQL.UM.ReconAttrMap
3.3.4.3
Lookup.DBUM.MSSQL.UM.ReconDefaults
3.3.4.4
Lookup.DBUM.MSSQL.UM.ReconDefaults.Trusted
3.3.4.5
Lookup.DBUM.MSSQL.UM.ReconAttrMap.Trusted
3.3.5
Lookup Definitions for Exclusion Lists for MSSQL
3.3.6
Lookup Definitions for Transformation of Data in MSSQL
3.3.7
Lookup Definition for Validation of Data in MSSQL
3.4
Scheduled Jobs for MSSQL
3.4.1
Scheduled Jobs for Lookup Field Synchronization for MSSQL
3.4.2
Attributes of the Scheduled Jobs for Reconciliation of MSSQL User and Login Entities
3.4.3
Attributes of the Scheduled Jobs for MSSQL Delete Operations
3.4.4
Configuring Scheduled Jobs for MSSQL
3.5
Reconciliation from MSSQL
3.5.1
Guidelines on Configuring Reconciliation from MSSQL
3.5.2
About the Reconciliation Process for MSSQL
3.5.3
About the Reconciliation Queries for MSSQL
3.5.4
Target System Columns Used in Reconciliation from MSSQL
3.5.5
Configuring the Target System As a Trusted Source
3.5.6
Reconciliation Rules for MSSQL
3.5.7
Viewing Reconciliation Rules for MSSQL
3.5.8
Reconciliation Action Rules for MSSQL
3.5.9
Viewing Reconciliation Action Rules for MSSQL
3.5.10
Performing Full Reconciliation from MSSQL
3.5.11
Performing Limited Reconciliation from MSSQL
3.5.12
Performing Incremental Reconciliation from MSSQL
3.6
Provisioning for MSSQL
3.6.1
Guidelines on Performing Provisioning Operations for MSSQL
3.6.2
Understanding the Provisioning Process for MSSQL
3.6.3
Configuring Direct Provisioning for MSSQL
3.6.4
Configuring Request-Based Provisioning for MSSQL
3.6.4.1
About Request Based Provisioning for MSSQL
3.6.4.2
Enabling Request-Based Provisioning
3.6.4.2.1
Approver's Role in Request-Based Provisioning for MSSQL
3.6.4.2.2
Importing MSSQL Request Datasets Using Deployment Manager
3.6.4.2.3
End User's Role in Request-Based Provisioning for MSSQL
3.6.4.2.4
Enabling the Auto Save Form Feature for MSSQL
3.6.4.2.5
Running the PurgeCache Utility for MSSQL
3.6.5
Switching Between Request-Based Provisioning and Direct Provisioning for MSSQL
3.6.5.1
Switching From Request-Based Provisioning to Direct Provisioning
3.6.5.2
Switching From Direct Provisioning to Request-Based Provisioning
3.6.6
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.
x
3.7
Extending the Connector for MSSQL
3.7.1
Modifying Predefined Queries or Creating New Queries for MSSQL
3.7.1.1
About the Queries for MSSQL
3.7.1.2
Syntax of Provisioning Queries for MSSQL
3.7.1.3
Syntax of Reconciliation Queries for MSSQL
3.7.1.4
Syntax of List of Values Queries for MSSQL
3.7.1.5
Guidelines for Configuring Search Queries Used in Reconciliation from MSSQL
3.7.2
Configuring Queries to Add Support for Custom Parameters and Lookup Fields for MSSQL
3.7.2.1
Updating a Query File for MSSQL
3.7.2.2
Configuring Oracle Identity Manager
3.7.3
About Configuring the Connector for Multiple Installations of MSSQL
3.7.4
About Configuring the Connector for Multiple Trusted Source Reconciliation from MSSQL
3.7.5
Configuring Validation of Data During Reconciliation and Provisioning for MSSQL
3.7.6
Configuring Transformation of Data During User Reconciliation for MSSQL
3.7.7
Configuring Resource Exclusion Lists for MSSQL
3.7.8
Setting Up Action Scripts for MSSQL
3.7.8.1
About Action Scripts for MSSQL
3.7.8.2
Configuring Action Scripts for MSSQL
4
Using and Extending the Connector for Oracle Database
4.1
Configuring Secure Communication Between Oracle Database and Oracle Identity Manager
4.1.1
Configuring Data Encryption and Integrity in Oracle Database
4.1.2
Configuring SSL Communication in Oracle Database
4.2
Determining Values for the JDBC URL and Connection Properties Parameters for Oracle Database
4.2.1
Only Data Encryption and Integrity Is Configured
4.2.2
Only SSL Communication Is Configured
4.2.3
Both Data Encryption and Integrity and SSL Communication Are Configured
4.3
Lookup Definitions Used During Connector Operations for Oracle Database
4.3.1
Lookup Definitions Synchronized with Oracle Database
4.3.2
Lookup Definitions for Configurations for Oracle Database
4.3.2.1
Lookup.DBUM.Oracle.Configuration
4.3.2.2
Lookup.DBUM.Oracle.UM.Configuration
4.3.2.3
Lookup.DBUM.Oracle.Configuration.Trusted
4.3.2.4
Lookup.DBUM.Oracle.UM.Configuration.Trusted
4.3.3
Lookup Definitions for Attribute Mappings for Oracle Database
4.3.3.1
Lookup.DBUM.Oracle.UM.ProvAttrMap
4.3.3.2
Lookup.DBUM.Oracle.UM.ReconAttrMap
4.3.3.3
Lookup.DBUM.Oracle.UM.ReconAttrMap.Trusted
4.3.3.4
Lookup.DBUM.Oracle.UM.ReconDefaults.Trusted
4.3.4
Lookup Definitions for Exclusion Lists for Oracle Database
4.3.5
Lookup Definitions for Transformation of Data in Oracle Database
4.3.6
Lookup Definition for Validation of Data in Oracle Database
4.4
Scheduled Jobs for Oracle Database
4.4.1
Scheduled Jobs for Lookup Field Synchronization for Oracle Database
4.4.2
Attributes of the Scheduled Jobs for Oracle Database
4.4.3
Configuring Scheduled Jobs for Oracle Database
4.5
Reconciliation from Oracle Database
4.5.1
Guidelines on Configuring Reconciliation for Oracle Database
4.5.2
About Reconciliation Process for Oracle Database
4.5.3
About Reconciliation Queries for Oracle Database
4.5.4
Target System Columns Used in Reconciliation from Oracle Database
4.5.5
Configuring the Target System As a Trusted Source
4.5.6
Reconciliation Rules for Oracle Database
4.5.7
Viewing Reconciliation Rules for Oracle Database
4.5.8
Reconciliation Action Rules for Oracle Database
4.5.9
Viewing Reconciliation Action Rules for Oracle Database
4.5.10
Performing Full Reconciliation from Oracle Database
4.5.11
Performing Limited Reconciliation from Oracle Database
4.5.12
Performing Batched Reconciliation from Oracle Database
4.5.13
Performing Incremental Reconciliation from Oracle Database
4.6
Provisioning for Oracle Database
4.6.1
Guidelines on Performing Provisioning Operations for Oracle Database
4.6.2
Understanding the Provisioning Process for Oracle Database
4.6.3
Configuring Direct Provisioning for Oracle Database
4.6.4
Configuring Request-Based Provisioning for Oracle Database
4.6.4.1
About Request-Based Provisioning for Oracle Database
4.6.4.2
Enabling Request-Based Provisioning
4.6.4.2.1
Approver's Role in Request-Based Provisioning
4.6.4.2.2
Importing Request Datasets Using Deployment Manager
4.6.4.2.3
End User's Role in Request-Based Provisioning
4.6.4.2.4
Enabling the Auto Save Form Feature
4.6.4.2.5
Running the PurgeCache Utility
4.6.5
Switching Between Request-Based Provisioning and Direct Provisioning for Oracle Database
4.6.5.1
Switching From Request-Based Provisioning to Direct Provisioning
4.6.5.2
Switching From Direct Provisioning to Request-Based Provisioning
4.6.6
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.
x
4.7
Extending the Connector for Oracle Database
4.7.1
Modifying the Predefined Queries or Creating New Queries
4.7.1.1
About the Queries for Oracle Database
4.7.1.2
Syntax of Provisioning Queries for Oracle Database
4.7.1.3
Syntax of Reconciliation Queries for Oracle Database
4.7.1.4
Syntax of List of Values Queries for Oracle Database
4.7.1.5
Guidelines for Configuring Search Queries Used in Reconciliation from Oracle DatabaseS
4.7.2
Configuring Queries to Add Support for Custom Parameters and Lookup Fields for Oracle Database
4.7.2.1
Updating the Query Files for Oracle Database
4.7.2.2
Configuring Oracle Identity Manager
4.7.3
About Configuring the Connector for Multiple Installations of Oracle Database
4.7.4
About Configuring the Connector for Multiple Trusted Source Reconciliation from Oracle Database
4.7.5
Configuring Validation of Data During Reconciliation and Provisioning for Oracle Database
4.7.6
Configuring Transformation of Data During User Reconciliation for Oracle Database
4.7.7
Configuring Resource Exclusion Lists for Oracle Database
4.7.8
Setting Up Action Scripts for Oracle Database
4.7.8.1
About Action Scripts for Oracle Database
4.7.8.2
Configuring Action Scripts for Oracle Database
5
Using and Extending the Connector for MySQL
5.1
Configuring Secure Communication Between MySQL and Oracle Identity Manager
5.2
Guidelines on Determining Values for the JDBC URL and Connection Properties Parameters for MySQL
5.3
Lookup Definitions for MySQL
5.3.1
Lookup Definitions Synchronized with MySQL
5.3.2
Lookup Definitions for Configurations for MySQL
5.3.2.1
Lookup.DBUM.MySQL.Configuration
5.3.2.2
Lookup.DBUM.MySQL.UM.Configuration
5.3.2.3
Lookup.DBUM.MySQL.Configuration.Trusted
5.3.2.4
Lookup.DBUM.MySQL.UM.Configuration.Trusted
5.3.3
Lookup Definitions for Attribute Mappings for MySQL
5.3.3.1
Lookup.DBUM.MySQL.UM.ProvAttrMap
5.3.3.2
Lookup.DBUM.MySQL.UM.ReconAttrMap
5.3.3.3
Lookup.DBUM.MySQL.UM.ReconAttrMap.Trusted
5.3.3.4
Lookup.DBUM.MySQL.UM.ReconDefaults.Trusted
5.3.4
Lookup Definitions for Exclusion Lists for MySQL
5.3.5
Lookup Definitions for Transformation of Data in MySQL
5.3.6
Lookup Definition for Validation of Data in MySQL
5.4
Scheduled Jobs for MySQL
5.4.1
Scheduled Job for Lookup Field Synchronization for MySQL
5.4.2
Attributes for Scheduled Jobs for MySQL
5.4.3
Configuring Scheduled Jobs for MySQL
5.5
Reconciliation from MySQL
5.5.1
Guidelines on Configuring Reconciliation for MySQL
5.5.2
About the Reconciliation Process for MySQL
5.5.3
Target System Columns Used in Reconciliation from MySQL
5.5.4
Configuring the Target System As a Trusted Source
5.5.5
Reconciliation Rules for MySQL
5.5.6
Viewing Reconciliation Rules for MySQL
5.5.7
Reconciliation Action Rules for MySQL
5.5.8
Viewing Reconciliation Action Rules for MySQL
5.5.9
Performing Full Reconciliation from MySQL
5.5.10
Performing Limited Reconciliation from MySQL
5.5.11
Performing Batched Reconciliation from MySQL
5.6
Provisioning for MySQL
5.6.1
Guidelines on Performing Provisioning Operations for MySQL
5.6.2
Understanding the Provisioning Process for MySQL
5.6.3
Configuring Direct Provisioning for MySQL
5.6.4
Configuring Request-Based Provisioning for MySQL
5.6.4.1
About Request Based Provisioning for MySQL
5.6.4.2
Enabling Request-Based Provisioning
5.6.4.2.1
Approver's Role in Request-Based Provisioning for MySQL
5.6.4.2.2
Importing MySQL Request Datasets Using Deployment Manager
5.6.4.2.3
End User's Role in Request-Based Provisioning for MySQL
5.6.4.2.4
Enabling the Auto Save Form Feature for MySQL
5.6.4.2.5
Running the PurgeCache Utility for MySQL
5.6.5
Switching Between Request-Based Provisioning and Direct Provisioning for MySQL
5.6.5.1
Switching From Request-Based Provisioning to Direct Provisioning
5.6.5.2
Switching From Direct Provisioning to Request-Based Provisioning
5.6.6
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.
x
5.7
Extending the Connector for MySQL
5.7.1
Modifying Predefined Queries or Creating New Queries for MySQL
5.7.1.1
About the Queries for MySQL Database
5.7.1.2
Syntax of Provisioning Queries for MySQL Database
5.7.1.3
Syntax of Reconciliation Queries for MySQL Database
5.7.1.4
Syntax of List of Values Queries for MySQL Database
5.7.2
Configuring Queries to Add Support for Custom Parameters and Lookup Fields for MySQL
5.7.2.1
Updating the Query Files for MySQL Database
5.7.2.2
Configuring Oracle Identity Manager
5.7.3
About Configuring the Connector for Multiple Installations of MySQL
5.7.4
About Configuring the Connector for Multiple Trusted Source Reconciliation from MySQL
5.7.5
Configuring Validation of Data During Reconciliation and Provisioning for MySQL
5.7.6
Configuring Transformation of Data During User Reconciliation for MySQL
5.7.7
Configuring Resource Exclusion Lists for MySQL
5.7.8
Setting Up Action Scripts for MySQL
5.7.8.1
About Action Scripts for MySQL
5.7.8.2
Configuring Action Scripts for MySQL
6
Using and Extending the Connector for DB2
6.1
Configuring Secure Communication Between DB2 and Oracle Identity Manager
6.2
Guidelines on Determining Values for the JDBC URL and Connection Properties Parameters for DB2
6.3
Lookup Definitions for DB2
6.3.1
Lookup Definitions Synchronized with DB2
6.3.2
Lookup Definitions for Configurations for DB2
6.3.2.1
Lookup.DBUM.DB2.Configuration
6.3.2.2
Lookup.DBUM.DB2.UM.Configuration
6.3.2.3
Lookup.DBUM.DB2.Configuration.Trusted
6.3.2.4
Lookup.DBUM.DB2.UM.Configuration.Trusted
6.3.3
Lookup Definitions for Attribute Mappings for DB2
6.3.3.1
Lookup.DBUM.DB2.UM.ProvAttrMap
6.3.3.2
Lookup.DBUM.DB2.UM.ReconAttrMap
6.3.3.3
Lookup.DBUM.DB2.UM.ReconAttrMap.Trusted
6.3.3.4
Lookup.DBUM.DB2.UM.ReconDefaults.Trusted
6.3.4
Lookup Definitions for Exclusion Lists for DB2
6.3.5
Lookup Definitions for Transformation of Data in DB2
6.3.6
Lookup Definition for Validation of Data in DB2
6.4
Scheduled Jobs for DB2
6.4.1
Scheduled Jobs for Lookup Field Synchronization for DB2
6.4.2
Attributes for Scheduled Jobs for DB2
6.4.3
Configuring Scheduled Jobs for DB2
6.5
Reconciliation from DB2
6.5.1
Guidelines on Configuring Reconciliation for DB2
6.5.2
About the Reconciliation Process for DB2
6.5.3
Target System Columns Used in Reconciliation from DB2
6.5.4
Configuring the Target System As a Trusted Source
6.5.5
Reconciliation Rules for DB2
6.5.6
Viewing Reconciliation Rules for DB2
6.5.7
Reconciliation Action Rules for DB2
6.5.8
Viewing Reconciliation Action Rules for DB2
6.5.9
Performing Full Reconciliation from DB2
6.5.10
Performing Limited Reconciliation from DB2
6.5.11
Performing Batched Reconciliation from DB2
6.6
Provisioning for DB2
6.6.1
Guidelines on Performing Provisioning Operations for DB2
6.6.2
Understanding the Provisioning Process for DB2
6.6.3
Configuring Direct Provisioning for DB2
6.6.4
Configuring Request-Based Provisioning for DB2
6.6.4.1
About Request Based Provisioning for DB2
6.6.4.2
Enabling Request-Based Provisioning
6.6.4.2.1
Approver's Role in Request-Based Provisioning for DB2
6.6.4.2.2
Importing DB2 Request Datasets Using Deployment Manager
6.6.4.2.3
End User's Role in Request-Based Provisioning for DB2
6.6.4.2.4
Enabling the Auto Save Form Feature for DB2
6.6.4.2.5
Running the PurgeCache Utility for DB2
6.6.5
Switching Between Request-Based Provisioning and Direct Provisioning for DB2
6.6.5.1
Switching From Request-Based Provisioning to Direct Provisioning
6.6.5.2
Switching From Direct Provisioning to Request-Based Provisioning
6.6.6
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.
x
6.7
Extending the Connector for DB2
6.7.1
Modifying Predefined Queries or Creating New Queries for DB2
6.7.1.1
About the Queries for DB2
6.7.1.2
Syntax of Provisioning Queries for DB2
6.7.1.3
Syntax of Reconciliation Queries for DB2
6.7.1.4
Syntax of List of Values Queries for DB2
6.7.2
Configuring Queries to Add Support for Custom Parameters and Lookup Fields for DB2
6.7.2.1
Updating the Query Files for DB2
6.7.2.2
Configuring Oracle Identity Manager
6.7.3
About Configuring the Connector for Multiple Installations of DB2
6.7.4
About Configuring the Connector for Multiple Trusted Source Reconciliation from DB2
6.7.5
Configuring Validation of Data During Reconciliation and Provisioning for DB2
6.7.6
Configuring Transformation of Data During User Reconciliation for DB2
6.7.7
Configuring Resource Exclusion Lists for DB2
6.7.8
Setting Up Action Scripts for DB2
6.7.8.1
About Action Scripts for DB2
6.7.8.2
Configuring Action Scripts for DB2
7
Using and Extending the Connector for Sybase
7.1
Configuring Secure Communication Between Sybase and Oracle Identity Manager
7.2
Guidelines on Determining Values for the JDBC URL and Connection Properties Parameters for Sybase
7.3
Lookup Definitions for Sybase
7.3.1
Lookup Definitions Synchronized with Sybase
7.3.2
Lookup Definitions for Configurations for Sybase
7.3.2.1
Lookup.DBUM.Sybase.Configuration
7.3.2.2
Lookup.DBUM.Sybase.Login.Configuration
7.3.2.3
Lookup.DBUM.Sybase.UM.Configuration
7.3.2.4
Lookup.DBUM.Sybase.Configuration.Trusted
7.3.2.5
Lookup.DBUM.Sybase.UM.Configuration.Trusted
7.3.3
Lookup Definitions for Attribute Mappings for Sybase Login Entity
7.3.3.1
Lookup.DBUM.Sybase.Login.ProvAttrMap
7.3.3.2
Lookup.DBUM.Sybase.Login.ReconAttrMap
7.3.3.3
Lookup.DBUM.Sybase.Login.ReconDefaults
7.3.4
Lookup Definitions for Attribute Mappings for Sybase User Entity
7.3.4.1
Lookup.DBUM.Sybase.UM.ProvAttrMap
7.3.4.2
Lookup.DBUM.Sybase.UM.ReconAttrMap
7.3.4.3
Lookup.DBUM.Sybase.UM.ReconDefaults
7.3.4.4
Lookup.DBUM.Sybase.UM.ReconDefaults.Trusted
7.3.4.5
Lookup.DBUM.Sybase.UM.ReconAttrMap.Trusted
7.3.5
Lookup Definition for Validation of Data in Sybase
7.3.6
Lookup Definitions for Transformation of Data in Sybase
7.3.7
Lookup Definitions for Exclusion Lists for Sybase
7.4
Scheduled Jobs for Sybase
7.4.1
Scheduled Jobs for Lookup Field Synchronization for Sybase
7.4.2
Attributes for Scheduled Jobs for Sybase
7.4.3
Configuring Scheduled Jobs for Sybase
7.5
Reconciliation from Sybase
7.5.1
About the Reconciliation Process for Sybase
7.5.2
Reconciliation Rules for Sybase
7.5.3
Viewing Reconciliation Rules for Sybase
7.5.4
Reconciliation Action Rules for Sybase
7.5.5
Viewing Reconciliation Action Rules for Sybase
7.5.6
Performing Full Reconciliation from Sybase
7.6
Provisioning for Sybase
7.6.1
Guidelines on Performing Provisioning Operations for Sybase
7.6.2
Understanding the Provisioning Process for Sybase
7.6.3
Configuring Direct Provisioning for Sybase
7.6.4
Configuring Request-Based Provisioning for Sybase
7.6.4.1
About Request Based Provisioning for Sybase
7.6.4.2
Enabling Request-Based Provisioning
7.6.4.2.1
Approver's Role in Request-Based Provisioning
7.6.4.2.2
Importing Request Datasets Using Deployment Manager
7.6.4.2.3
End User's Role in Request-Based Provisioning
7.6.4.2.4
Enabling the Auto Save Form Feature
7.6.4.2.5
Running the PurgeCache Utility
7.6.5
Switching Between Request-Based Provisioning and Direct Provisioning for Sybase
7.6.5.1
Switching From Request-Based Provisioning to Direct Provisioning
7.6.5.2
Switching From Direct Provisioning to Request-Based Provisioning
7.6.6
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.
x
7.7
Extending the Connector for Sybase
7.7.1
Modifying Predefined Queries or Creating New Queries for Sybase
7.7.1.1
About the Queries for Sybase
7.7.1.2
Syntax of Provisioning Queries for Sybase Database
7.7.1.3
Syntax of Reconciliation Queries for Sybase Database
7.7.1.4
Syntax of List of Values Queries for Sybase Database
7.7.2
Configuring Queries to Add Support for Custom Parameters and Lookup Fields for Sybase
7.7.2.1
Updating the Query Files for Sybase Database
7.7.2.2
Configuring Oracle Identity Manager
7.7.3
About Configuring the Connector for Multiple Installations of Sybase
7.7.4
About Configuring the Connector for Multiple Trusted Source Reconciliation from Sybase
7.7.5
Configuring Validation of Data During Reconciliation and Provisioning for Sybase
7.7.6
Configuring Transformation of Data During User Reconciliation for Sybase
7.7.7
Configuring Resource Exclusion Lists for Sybase
7.7.8
Setting Up Action Scripts for Sybase
7.7.8.1
About Action Scripts for Sybase
7.7.8.2
Configuring Action Scripts for Sybase
8
Configuring the Connector for a JDBC-Based Database
8.1
Target System Attributes and Queries
8.2
Configuring the Queries
8.3
Updating the Query Files to the Connector Bundle
8.4
Configuring the IT Resource
8.5
Configuring the Process Form
8.6
Configuring the Resource Object
8.7
Adding Process Tasks, Assigning Adapters, and Mapping Adapter Variables
8.8
Adding Attributes for Reconciliation
8.9
Configuring Lookup Definitions Used During Connector Operations
8.10
Configuring Scheduled Jobs
8.10.1
Configuring Scheduled Jobs for Lookup Field Synchronization
8.10.2
Configuring Scheduled Jobs for Reconciliation
8.11
Configuring Oracle Identity Manager for Request-Based Provisioning
8.12
Testing the Customized Connector
9
Testing the Connector
9.1
Running the Test Utility for the Oracle Database
9.2
Running the Test Utility for the MSSQL Database
9.3
Running the Test Utility for MySQL
9.4
Running the Test Utility for DB2
9.5
Running the Test Utility for Sybase
10
Known Issues and Workarounds
10.1
Connector Issues
10.1.1
Wild Card Expressions not Supported in Privileges for MySQL
10.2
Oracle Identity Manager Issues
10.2.1
Update of a Child Table does not Work as Expected
10.2.2
User Remains in Provisioned Status After a Trusted Delete Reconciliation Run
10.2.3
Target Reconciliation Does Not Revoke Roles and Privileges
10.2.4
The With Grant Option in Child Data Fails to Appear in Entitlement List
10.2.5
The Second Installation of the Connector Fails
10.3
Target System Issues
10.3.1
Creation of a JDBC Connection Results in an Indefinite Wait Time
10.3.2
Incremental Reconciliation Cannot Process Role Updateds in MSSQL
10.3.3
Relevant Error Log not Provided While Provisioning a Duplicate User
10.3.4
Provisioning of Privileges for the Schema not Supported for MySQL
A
Configuring Requests
A.1
Step 1: Creating a Request Dataset for the Resources
A.1.1
About Request Datasets
A.1.2
Default Request Datasets
A.1.3
Elements and Properties
A.1.3.1
The request-data-set Element
A.1.3.2
The DataSetValidator Element
A.1.3.3
The AttributeReference Element
A.1.3.3.1
Mandatory Properties
A.1.3.3.2
Optional Properties
A.1.3.3.3
The PrePopulationAdapter Element
A.1.3.3.4
The lookupValues Element
A.1.3.3.5
The lookupQuery Element
A.1.3.4
The Attribute Element
A.1.4
Sample Request Dataset
A.1.5
Child Data
A.1.6
Common Request Dataset
A.1.7
Configuring Localized Values for Request Datasets
A.1.7.1
Localization for Request Dataset Attributes
A.1.7.1.1
Request Dataset Attributes for Nongeneric Request Models
A.1.7.1.2
Request Dataset Attributes for Generic Request Models
A.1.7.1.3
Child Attributes
A.1.7.1.4
Predefined Values for Attributes
A.1.7.2
Localization of Column Names in LookupQuery for Dataset Attributes
A.2
Step 2: Uploading Request Datasets into MDS
A.3
Step 3: Creating SOA Composites Required for Approval
A.3.1
Using SOA Composites for Approval
A.3.2
Creating a SOA Composite
A.4
Step 4: Registering the SOA Composites in Oracle Identity Manager
A.5
Step 5: Defining Request Approvals
A.5.1
Approval Workflows
A.5.2
Approval Levels
A.5.2.1
Template-Level Approval
A.5.2.2
Request-Level Approval
A.5.2.3
Operation-Level Approval
A.5.3
Creating Approval Policies
A.6
Step 6: Creating Request Templates
A.6.1
About Request Templates
A.6.2
Creating a Request Template Based on the Create User Request Type
A.6.3
Creating a Request Template Based on the Provisioning Resource Request Type
A.7
Extending Request Management Operations
A.7.1
Running Custom Code Based on Request Status Change
A.7.2
Validating Request Data
A.7.3
Prepopulation of an Attribute Value During Request Creation
Scripting on this page enhances content navigation, but does not change the content in any way.