Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Documentation Updates
• Conventions

What's New in Oracle Identity Manager Connector for Database Application Tables?

• Software Updates
• Documentation-Specific Updates

1 About the Connector

• 1.1 Certified Components
• 1.2 Certified Languages
• 1.3 Supported Data Types
• 1.4 Features of the Connector
  • 1.4.1 Connector Architecture
  • 1.4.2 Target Resource Reconciliation
  • 1.4.3 Provisioning
  • 1.4.4 Trusted Source Reconciliation
• 1.5 Roadmap for Deploying and Using the Connector

2 Tasks to Be Performed Before You Create the Connector

• 2.1 Configuring Oracle Identity Manager
  • 2.1.1 Enabling Logging
    • 2.1.1.1 Enabling Logging on Oracle Identity Manager Release 9.1.0.x
    • 2.1.1.2 Enabling Logging on Oracle Identity Manager Release 11.1.1
  • 2.1.2 Adding New User-Defined Fields for the OIM User
  • 2.1.3 Using Lookup Definitions
  • 2.1.4 Copying the JDBC Drivers
  • 2.1.5 Exchanging Account Status Data with the Target System
    • 2.1.5.1 Configuring Account Status Reconciliation
    • 2.1.5.2 Configuring Account Status Provisioning
  • 2.1.6 Copying the Provider Files
• 2.2 Configuring the Target System
  • 2.2.1 Using Read-Only Views
  • 2.2.2 Ensuring That There Are No Target System Columns Named ID
  • 2.2.3 Configuring IBM DB2/UDB Running on IBM z/OS
  • 2.2.4 Configuring Oracle Database
• 2.3 Configuring Secure Communication Between the Target System and Oracle Identity Manager
  • 2.3.1 Configuring Secure Communication Between IBM DB2/UDB and Oracle Identity Manager
  • 2.3.2 Configuring Secure Communication Between Microsoft SQL Server and Oracle Identity Manager
  • 2.3.3 Configuring Secure Communication Between MySQL and Oracle Identity Manager
  • 2.3.4 Configuring Secure Communication Between Oracle Database and Oracle Identity Manager
    • 2.3.4.1 Configuring Data Encryption and Integrity in Oracle Database
    • 2.3.4.2 Configuring SSL Communication in Oracle Database
  • 2.3.5 Configuring Secure Communication Between Sybase Adaptive Server Enterprise and Oracle Identity Manager

3 Creating the Connector

• 3.1 Limited Reconciliation
• 3.2 Determining Values for the Database URL and Connection Properties Parameters
  • 3.2.1 Database URL and Connection Properties for IBM DB2/UDB
  • 3.2.2 Database URL and Connection Properties for Microsoft SQL Server
  • 3.2.3 Database URL and Connection Properties for MySQL
  • 3.2.4 Database URL and Connection Properties for Oracle Database
    • 3.2.4.1 Only Data Encryption and Integrity Is Configured
    • 3.2.4.2 Only SSL Communication Is Configured
    • 3.2.4.3 Both Data Encryption and Integrity and SSL Communication Are Configured
    • 3.2.4.4 Database URL and Connection Properties for Oracle RAC
  • 3.2.5 Database URL and Connection Properties for Sybase Adaptive Server Enterprise
• 3.3 Modifying Field Lengths of the Provider Parameters
• 3.4 Creating the Connector
  • 3.4.1 Step 1: Provide Basic Information Page
  • 3.4.2 Step 2: Specify Parameter Values Page
  • 3.4.3 Step 3: Modify Connector Configuration Page
  • 3.4.4 Step 4: Verify Connector Form Names Page
  • 3.4.5 Step 5: Verify Connector Information Page
  • 3.4.6 Modifying the Default Action Rules
  • 3.4.7 Configuring Reconciliation
  • 3.4.8 Configuring Provisioning
• 3.5 Performing Connector Operations

4 Known Issues

A An Example of the Procedure to Create Connectors

• A.1 Sample Scenario
  • A.1.1 Sample Target System to Be Configured As a Target Resource
  • A.1.2 Sample Target System to Be Configured As a Trusted Source
• A.2 Tasks to Be Performed Before You Create the Connector
• A.3 Configuring the Target System As a Target Resource
• A.4 Configuring the Target System As a Trusted Source

B Screenshots of the Step 3: Modify Connector Configuration Page

• B.1 Using the Data Type List and Required Check Box
• B.2 Specifying a Literal Value As Input for a Field
• B.3 Encrypting the Storage and Display of Field Values
• B.4 Configuring Account Status Reconciliation: Step 1
• B.5 Configuring Account Status Reconciliation: Step 2
• B.6 Summary of Changes That You See After Configuring Target Resource Reconciliation
• B.7 Summary of Changes That You See After Configuring Trusted Source Reconciliation

Index