1. Configuring the Database Application Tables Application
  2. Defining and Upgrading the DBAT Connector

7 Defining and Upgrading the DBAT Connector

Define and upgrade the Database Application Tables connector using Oracle Identity System Administration.

7.1 Defining the Connector

Using Oracle Identity System Administration, you can define a customized or reconfigured connector. Defining a connector is equivalent to registering the connector with Oracle Identity Governance.

A connector is automatically defined when you install it by using the Install Connectors feature or when you upgrade it using the Upgrade Connectors feature. You must manually define a connector if:

  • You import the connector by using the Deployment Governance.
  • You customize or reconfigure the connector.
  • You upgrade Oracle Identity Governance.

The following events take place when you define a connector:

  • A record representing the connector is created in the Oracle Identity Governance database. If this record already exists, then it is updated.
  • The status of the newly defined connector is set to Active. In addition, the status of a previously installed release of the same connector is automatically set to Inactive.

See Defining Connectors With Oracle Identity Manager in Oracle Fusion Middleware Administering Oracle Identity Governance for detailed information about the procedure to define connectors.

7.2 Upgrading the Connector

If you have already deployed the 11.1.1.6.0 version of the DBAT connector, then you can upgrade the connector to version 12.2.1.3.0 by uploading the new connector JAR files to the Oracle Identity Governance database.

Note:

Before you perform the upgrade procedure:
  • Create a backup of the Oracle Identity Governance database. See the database documentation for information about creating a backup.
  • As a best practice, initially perform the upgrade procedure in a test environment.

The following topics describe the procedure to upgrade the connector:

Note:

See Upgrading Connectors in Oracle Fusion Middleware Administering Oracle Identity Governance for detailed information about upgrade steps.

7.2.1 Upgrade Steps

This is a summary of the procedure to upgrade the connector for both staging and production environments.

Depending on the environment in which you are upgrading the connector, perform one of the following steps:

  • Staging environment: Perform the upgrade procedure by using the wizard mode.

    Note:

    Do not upgrade IT resource type definition. In order to retain the default setting, you must map the IT resource definition to 'None'.
  • Production environment: Perform the upgrade procedure by using the silent mode.

7.2.2 Postupgrade Steps

Postupgrade steps involve uploading new connector JAR to Oracle Identity Governance database.

Perform the following steps:

  1. Delete the old Connector JARs. Run the Oracle Identity Governance Delete JARs ($ORACLE_HOME/bin/DeleteJars.sh) utility to delete the existing ICF bundle org.identityconnectors.databasetable-1.2.2.jar from the Oracle Identity Governance database.
    When you run the Delete JARs utility, you are prompted to enter the login credentials of the Oracle Identity Governance administrator, URL of the Oracle Identity Governance host computer, context factory value, type of JAR file being deleted, and the name of the JAR file to be removed. Specify 4 as the value of the JAR type.
  2. Upload the new connector JAR files. To do so:
    1. Run the Oracle Identity Governance Upload JARs ($ORACLE_HOME/bin/UploadJars.sh) utility to upload the connector JARs.
    2. Upload the org.identityconnectors.databasetable-12.3.0.jar bundle as an ICF Bundle. Run the Oracle Identity Governance Upload JARs utility to post the new ICF bundle org.identityconnectors.databasetable-12.3.0.jar file to the Oracle Identity Governance database.

      When you run the Upload JARs utility, you are prompted to enter the login credentials of the Oracle Identity Governance administrator, URL of the Oracle Identity Governance host computer, context factory value, type of JAR file being uploaded, and the location from which the JAR file is to be uploaded. Specify 4 as the value of the JAR type.

  3. Restart Oracle Identity Governance.
  4. If the connector is deployed on a connector server, then:
    1. Stop the connector server.
    2. Replace the existing bundle JAR file org.identityconnectors.databasetable-1.2.2.jar with the new bundle JAR file org.identityconnectors.databasetable-12.3.0.jar.
    3. Start the connector server.