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

This chapter provides an overview of the updates made to the software and documentation for the Database Application Tables connector in release 11.1.1.6.0.

The updates discussed in this chapter are divided into the following categories:

Software Updates

The following section discusses software updates:

Software Updates in Release 11.1.1.6.0

The following are the software updates in release 11.1.1.6.0:

Support for Using the Connector with a Target System Containing Autoincrement Columns

You can create and use connector for a target system that has the primary key column defined with the autoincrement option.

See the following sections for more information about the configuring the connector for autoincrementing columns:

Additional Properties Related to Scripting Have Been Added

In the earlier release, the DBATConfiguration.groovy file contained the following script properties:

  • CreateScript

  • UpdateScript

  • DeleteScript

  • ExecuteQueryScript

This meant that you could configure the connector to use custom stored procedures or SQL statements for the Create User, Update User, Delete User provisioning operations, and custom SQL queries for user reconciliation.

In this release, in addition to the preceding properties, the following properties have been added:

  • SyncScript - Used for specifying custom stored procedures or SQL queries to perform incremental reconciliation.

  • lookupScript - Used for specifying custom stored procedures or SQL queries to perform lookup field synchronization.

  • addMultiValuedAttributeScript and removeMultiValuedAttributeScript - Used for specifying custom stored procedures or SQL statements to perform provisioning operations corresponding to adding and removing multivalued attributes.

See Table 2-1 for detailed information about each of these properties.

Software Updates in Release 11.1.1.5.0

This is the first release of the Oracle Identity Manager connector for Database Application Tables based on ICF architecture. Therefore, there are no software updates in this release.

Documentation-Specific Updates

The following sections discuss documentation-specific updates:

Documentation-Specific Updates in Release 11.1.1.6.0

The following documentation-specific update has been made in revision "14" of this guide:

The "Target systems" row of Table 1-1 has been updated to include support for Microsoft SQL Server 2016.

The following documentation-specific update has been made in revision "13" of this guide:

The "Oracle Identity Governance or Oracle Identity Manager" row of Table 1-1 has been updated to include support for Oracle Identity Governance 12c (12.2.1.4.0).

The following documentation-specific updates have been made in revision "12" of this guide:

The following documentation-specific update has been made in revision "11" of this guide:

The "Target Systems" row of Table 1-1 has been updated to include IBM DB2 version 11.x.

The following documentation-specific update has been made in revision "10" of this guide:

The following documentation-specific update has been made in revision "09" of this guide:

The "Oracle Identity Manager" row of Table 1-1 has been renamed as "Oracle Identity Governance or Oracle Identity Manager" and also updated for Oracle Identity Governance 12c (12.2.1.3.0) certification.

The following documentation-specific updates have been made in revision "08" of this guide:

The following documentation-specific updates have been made in revision "07" of this guide:

The following documentation-specific update has been made in revision "06" of this guide:

The "Target systems" and "JDBC Drivers" rows of Table 1-1 have been updated.

The following documentation-specific update has been made in revision "05" of this guide:

The "Oracle Identity Manager" row of Table 1-1 has been updated.

The following documentation-specific update has been made in revision "04" of this guide:

A "Note" has been added at the beginning of Extending the Functionality of the Database Application Tables Connector.

The following documentation-specific update has been made in revision "03" of this guide:

Major changes have been made in the structure of the guide. The objective of these changes is to synchronize the guide with the way the connector works and to improve the usability of information provided by the guide.

Documentation-Specific Updates in Release 11.1.1.5.0

The following are the documentation-specific updates in revision "02" of this guide:

  • Description of LOOKUP_FIELD_ID has been modified in Section 1.7.2, "Custom Lookup Definitions Synchronized with the Target System."

  • Section 1.7.1.5, "Lookup.RESOURCE.UM.ReconAttrMap.Defaults" has been modified.

  • The following sections have been added:

    • Section 2.2.2.2, "Configuring the DBATConfiguration.groovy File for a Target System with an Autoincrement Primary Key"

    • Section 2.3.1, "Configuring the Connector for a Target System with an Autoincrement Primary Key"