This chapter provides an overview of the updates made to the software and documentation for release 11.1.1.8.0 of the Database User Management connector.
Note:
Release 11.1.1.8.0 of the connector comes after release 11.1.1.6.0. Release number 11.1.1.7.0 has not been used.
The updates discussed in this chapter are divided into the following categories:
These include updates made to the connector software.
Documentation-Specific Updates
These include major changes made to the connector documentation. These changes are not related to software updates.
The following sections discuss software updates:
The following are issues resolved in release 11.1.1.8.0:
Bug Number | Issue | Resolution |
---|---|---|
16476930 16476913 16476900 16476884 16474781 |
The Entitlement, AccountName, and AccountID properties of fields on the process form for all target systems supported by this connector were not tagged. The "Entitlement" property of child form attributes was not set to The "AccountName" property of a process form field that represented the login ID of an account in the target system was not set to The "AccountID" property of a process form field that represented the immutable GUID of the account (if one exists) was not set to true. This prevented integrating Oracle Identity Manager with Oracle Identity Analytics. |
This issue has been resolved. The Entitlement, AccountName, and AccountID properties of fields on the process form have been tagged. In other words, the values of the Entitlement, AccountName, and AccountID properties have been set to |
16491431 |
The following issue was observed if you are using MySQL as the target system: The Revoke Privilege provisioning task had a dependency on the Add Privilege provisioning task. As a result, if you granted multiple privileges to a user and one of the Add Privilege tasks did not complete successfully, then none of the assigned privileges were revoked. In addition, the Revoke Privilege task remained in the "Waiting" state. |
This issue has been resolved. |
15955807 |
The connector failed to update password in UpdateApiOp with MySQL database. In addition, no errors were reported. |
This issue has been resolved. The connector updates the password in UpdateApiOp with MySQL database. |
16085209 |
The following exception was encountered when you ran the connector test: DBUM Connector Test Fails JRF Portability Layer exception |
This issue has been resolved. |
15919151 |
The connector failed in SearchApiOp with MySQL database running on UNIX computer. This failure was due to table names being case sensitive in UNIX MySQL. |
This issue has been resolved. |
15895008 |
Changing the password of a user account in Sybase resulted in the failure of a stored procedure. |
This issue has been resolved. |
The following is a software update in release 11.1.1.6.0:
From this release onward, the connector supports the following additional databases:
MySQL
See Using and Extending the Connector for MySQL for more information.
DB2
See Using and Extending the Connector for DB2 for more information.
Sybase
See Using and Extending the Connector for Sybase for more information.
The following are the software updates in release 11.1.1.5.0:
The Identity Connector Framework (ICF) is a component that provides basic provisioning, reconciliation, and other functions that all Oracle Identity Manager and Oracle Waveset connectors require.
The Oracle Identity Manager Connector for Database User Management is an ICF-based connector. The ICF uses classpath isolation, which allows the Database User Management connector to co-exist with legacy versions of the connector.
For more information about the ICF, see Understanding the Identity Connector Framework in Oracle Fusion Middleware Developing and Customizing Applications for Oracle Identity Manager.
From this release onward, all connector operations such as provisioning, reconciliation, and search, are performed by running SQL scripts stored in connector bundle.
In the previous release, reconciliation scripts were present in the filesystem and changes were expected for converting from full to incremental reconciliation.
From this release onwards, the script execution is more intelligent. It dynamically switches to incremental mode after first execution. In addition, no changes are required on script for limited reconciliation. They can all be managed from scheduled jobs.
Removing script loading from filesystem also reduces file synchronization issues in cluster deployment scenarios.
See Connector Architecture for more information about the connector bundle.
From this release onward, connection pooling is supported. Oracle Identity Manager connectors can use these connections to communicate with target systems. See Connection Pooling for more information about connection pooling.
This release of the connector supports running the connector remotely using ICF remote connector server. See Installing the Connector on the Connector Server in the connector guide for more information.
This release of the connector supports multiple instances and multiple versions of target system. You can deploy a single connector bundle on Oracle Identity Manager and create multiple IT resources for multiple instances and multiple versions of a target system. Then, you can use Oracle Identity Manager to manage accounts on these target systems.
See the following sections in the connector guide for more information:
From this release onward, you can run pre/post action scripts on a computer where the DBUM connector is deployed. These scripts can be of type SQL/StoredProc/Groovy. You can configure the scripts to run before or after the create, update, or delete an account provisioning operations. See the following sections for more information:
You can configure transformation of data, such as process form field data or any other object, that is brought into Oracle Identity Manager during reconciliation. In addition, you can configure validation of data that is brought into or sent from Oracle Identity Manager during reconciliation and provisioning. See the following sections for more information:
Configuring Transformation of Data During User Reconciliation for Oracle Database
Configuring Validation of Data During Reconciliation and Provisioning for Oracle Database
Configuring Transformation of Data During User Reconciliation for MSSQL
Configuring Validation of Data During Reconciliation and Provisioning for MSSQL
From this release onward, you can specify a list of accounts that must be excluded from reconciliation and provisioning operations. Accounts whose user IDs you specify in the exclusion list are not affected by reconciliation and provisioning operations.
See the following sections in the connector guide for more information:
From this release onward, the connector artifacts are provided OOB for trusted reconciliation. The incremental reconciliation is more simplified as user does not need to change queries file anymore to switch to incremental mode.
The release 11.1.1.5.0 supports incremental and limited reconciliation for the MSSQL database. See Reconciliation from MSSQL for more information.
The connector supports JDBC Based Database Customization against your target system. You can configure the connector to support the JDBC-based database by performing the required instructions. See Configuring the Connector for a JDBC-Based Database for more information about required instructions.
The following sections discuss documentation-specific updates:
The following is a documentation-specific update in revision "14" of release 11.1.1.8.0:
The description for reservedWordsList and unsupportedChars Code Keys have been modified in using-and-extending-connector-oracle-database.htm#GUID-3DF68A98-2CCE-4570-A4E0-DC227D757361__GUID-F4F10AC5-A530-4097-BA25-975DBBC98735.
The following is a documentation-specific update in revision "13" of release 11.1.1.8.0:
The "Oracle Identity Governance or Oracle Identity Manager" row of connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF has been updated to include support for Oracle Identity Governance 12c (12.2.1.4.0).
The following is a documentation-specific update in revision "12" of release 11.1.1.8.0:
Information specific to Oracle Identity Manager 11g Release 2 PS3 (11.1.2.3.0) has been modified in Usage Recommendation to include the phrase "any later BP in this release track".
The following are documentation-specific update in revision "11" of release 11.1.1.8.0:
The "Target systems" row of connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF has been modified to include support for Microsoft SQL server 2016.
Creating a Target System User Account for Connector Operations has been added.
All the cross-references to the related Oracle Identity Manager guides have been updated with cross-references to the specific sections of those guides.
Appendix A, "Configuring Requests for Database User Management Connector" has been added.
The "Related Documents" section in Preface has been updated.
The following are documentation-specific updates in revision "10" of release 11.1.1.8.0:
The "Connector Server" row has been added to connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF.
The "JDK" row of connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF has been renamed to "Connector Server JDK".
Postcloning Configuration for User Accounts has been added.
The following are documentation-specific updates in revision "9" of release 11.1.1.8.0:
The "Oracle Identity Manager" row of connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF has been updated.
The "Target systems" row of connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF has been updated.
Information specific to Oracle Identity Manager 11g Release 2 PS3 (11.1.2.3.0) has been added to Usage Recommendation.
The "Groovy" sample value has been removed from Step 3 of the following sections:
The following changes have been made for the addition of information specific to Database ID:
The "Call UPDATE_DBID(usrid, dbid)" procedure has been added to the list of stored procedures that are used in the provisioning queries in Target System Attributes and Queries.
Information specific to "UPDATE_DBID" query has been added to the information in the "Provisioning.queries" file in Configuring the Queries.
The sample screenshot of the updated process task has been modified in Adding Process Tasks, Assigning Adapters, and Mapping Adapter Variables.
Information specific to the update task for the Database ID field has been added at the end of Adding Attributes for Reconciliation.
A "Note" with information specific to lookup queries has been added at the beginning of the following sections:
The following are documentation-specific updates in revision "8" of release 11.1.1.8.0:
Oracle Database 12c and Microsoft SQL Server 2012 have been added to the "Target Systems" row of connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF.
Information about Oracle 12c has been added to the "JDBC URL" row of deploying-connector.htm#GUID-B5E9AAC7-6784-4708-BE79-6ADFA89C82FA__BABCDCEH.
Information about Microsoft SQL Server 2012 has been added to Configuring the Connector to Support Multiple Versions of the Target System.
Information about limited reconciliation has been modified in the following sections:
The following are documentation-specific updates in revision "7" of release 11.1.1.8.0:
Information about making changes to the form designer was added to Postupgrade Steps.
Information was updated under bug number 16713445 in Known Issues and Workarounds.
Information about exclusion lists has been modified in the following sections:
Information about including the jrf.jar, jrf-api.jar, and jrf-client.jar files for Oracle Identity Manager release 11.1.2.x has been added as step 2 in the following sections:
The name of the "Known Issues" chapter has been changed to "Known Issues and Workarounds." In addition, Known Issues and Workarounds has been restructured.
The following are documentation-specific updates in revision "6" of release 11.1.1.8.0:
The "Oracle Identity Manager" row in connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF has been modified.
A note has been added in the "Files in the xml directory" row of deploying-connector.htm#GUID-1ABFAF93-C729-4768-BC5F-0001938E98D8__BGBDBABG.
The following sections have been added:
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.x
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.x
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.x
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.x
Performing Provisioning Operations in Oracle Identity Manager Release 11.1.2.x
Instructions specific to Oracle Identity Manager release 11.1.2.x have been added in the following sections:
Issues tracked by bug numbers 16713445 and 16482139 have been added to Known Issues and Workarounds.
Bug 14260504 has been removed from Known Issues and Workarounds as it is not an issue.
The following is the documentation-specific update in revision "4" of release 11.1.1.6.0:
In connector.htm#GUID-C2D995F1-879C-4568-A002-394B33262D5B__BABEJCJF:
the patch numbers for Oracle Identity Manager have been replaced with 14163597 and 13897038.
Exadata V2 target system has been included.