9 Testing the Connector

After you deploy the connector, you must test it to ensure that it functions as expected.

You can use the testing utility to identify the cause of problems associated with connecting to the target system and performing basic operations on the target system.

While running the testing utility, the testing utility reads the connectivity information from the IT Resource, lookup definitions from Oracle Identity Manager, and process form data is read from the config.properties file. While running the testing utility, you must ensure that the connector should be deployed and Oracle Identity Manager should be running.

This chapter includes the following procedures:

9.1 Running the Test Utility for the Oracle Database

Perform the following steps to run the test utility for Oracle:

Note:

The testing utility might not work for IBM WebSphere Application Server and Oracle WebLogic Server.

  1. Set the JAVA_HOME to use JDK1.6, that is the classpath should have the entry to JDK 1.6.
  2. If you are using Oracle Identity Manager release 11.1.2.x or later, then include the jrf.jar, jrf-api.jar, and jrf-client.jar files to the classpath.

    These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.

  3. Copy the third party jar (ojdbc5.jar) in the following directory:

    $DBUM-11.1.1.6.0/test/thirdparty

  4. Update OIM_HOME/DBUM-11.1.1.6.0/test/config/oracleconfig.properties using the values specified in the following table. This file is located in the directory.
    Name Description Sample or Default Value

    Other Data

    		    

    Action

    Enter the type of operation that you want to test:

    • CONNECT: To connect to the target system

    • CREATE: To create a user in the target system, that is, provisioning

    • DELETE: To delete the user from the target system

    • ENABLE: To enable the user in the target system

    • DISABLE: To disable the user in the target system

    • ADDROLE: To add/grant role to the user

    • DELETEROLE: To delete/revoke role of the user

    • ADDPRIVILEGE: To grant privilege to the user

    • DELETEPRIVILEGE: To delete privilege to the user

    • UPDATEPASSWORD: To update the password

    CONNECT

    ObjectType

    Oracle supports only one user type

    USER

    Log Level

    Enter one of the following values:

    • OFF

    • INFO

    • FINE

    FINE

    OIM Login Data

    		    

    Security Auth Login Config File

    Security Auth Login Config File

    OIM_HOME/server/config/authwl.conf

    OIM Connection URL

    Enter the Oracle Identity Manager connection URL.

    t3://OIM_HOST:PORT

    Context Factory

    Enter the name of the context factory.

    weblogic.jndi.WLInitialContextFactory

    OIM Admin User

    Enter the name of the Oracle Identity Manager user.

    xelsysadm

    Database IT Resource Name

    		    

    IT Resource Name

    Enter the name of the IT resource from which connectivity information must be read.

    Oracle DB

    Process Form Fields and Query Code Keys

    		    

    UserID

    Enter the ID of the user to be provisioned/created.

    Note: UserID to be deleted or updated or enable/disable should be already existing on the target.

    TestUser

    __NAME__

    Enter the name of the user to be provisioned. This attribute will be used only while provisioning.

    TestUser

    __PASSWORD__

    Enter the password of the user to be provisioned.

    mypassw0r1

    authType

    Enter one of the following authentication types:

    • PASSWORD

    • GLOBAL

    • EXTERNAL

    Note: This is a mandatory field.

    PASSWORD

    globalDN

    Enter the Global DN of the user. Provide the value for this attribute only when the authentication type is GLOBAL.

    Global DN

    tablespace

    Default Tablespace

    tablespace

    defaultQuota

    Default Tablespace Quota (in MB).

    defaultQuota

    profile

    Profile Name

    profile

    tempTableSpace

    Temporary Tablespace

    tempTableSpace

    Roles to be added/deleted

    		    

    roles~DBRole~__NAME__

    Enter the roler name.

    CONNECT

    roles~DBRole~adminOption

    Enter the role with admin option.

    Note: leave this attribute blank if you do not want to grant admin option.

    WITH ADMIN OPTION

    Privilege to be added/deleted

    		    

    privileges~DBPrivilege~__NAME__

    Enter the privilege name.

    ALTER ANY ASSEMBLY

    privileges~DBPrivilege~adminOption

    Enter the privelege with admin option.

    WITH ADMIN OPTION
  5. After you specify values in the oracleconfig.properties file, run the test utility from the following location:

    OIM_HOME/DBUM-11.1.1.6.0/test/scripts

    For UNIX:

    DBUMProvisioningTester.sh

    For Microsoft Windows:

    DBUMProvisioningTester.bat
  6. Enter Oracle Identity Manager Administrator's Password on the console when prompted. A message confirming the successful completion of running the utility is displayed.

9.2 Running the Test Utility for the MSSQL Database

Perform the following steps to run the test utility for MSSQL:

  1. Drop the third party jar (sqljdbc4.jar) in the following directory:

    OIM_HOME/DBUM-11.1.1.6.0/test/thirdparty

  2. If you are using Oracle Identity Manager release 11.1.2.x or later, then include the jrf.jar, jrf-api.jar, and jrf-client.jar files to the classpath.

    These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.

  3. Update OIM_HOME/DBUM-11.1.1.6.0/test/scripts/DBUMProvisioningTester.sh and replace oracleconfig.properties with mssqlconfig.properties in the first argument: 
    java -cp "../lib/*:../thirdparty/*"
oracle.iam.connectors.dbum.testutil.prov.ProvisioningUtility
../config/mssqlconfig.properties
../../bundle/org.identityconnectors.dbum-1.0.1116.jar
  4. Update OIM_HOME/DBUM-11.1.1.6.0/test/config/mssqlconfig.properties with the required information.
    Name Description Sample or Default Value

    Other Data

    		    

    Action

    Enter the type of operation that you want to test:

    • CONNECT: To connect to the target system

    • CREATE: To create a user in the target system, that is, provisioning

    • DELETE: To delete the user from the target system

    • ENABLE: To enable the user in the target system. This operation is supported for the object type UserLogin only.

    • DISABLE: To disable the user in the target system. This operation is supported for the object type UserLogin only.

    • ADDROLE: To add/grant role to the user. This operation is supported for object type User.

    • DELETEROLE: To delete/revoke role of the user

    • UPDATEPASSWORD: To update the password. This operation is supported only for the object type UserLogin.

    CONNECT

    ObjectType

    MSSQL supports two user types: USER and USERLOGIN

    USERLOGIN

    Log Level

    Enter one of the following values:

    • OFF

    • INFO

    • FINE

    FINE

    OIM Login Data

    		    

    Security Auth Login Config File

    Security Auth Login Config File

    OIM_HOME/server/config/authwl.conf

    OIM Connection URL

    Enter the Oracle Identity Manager connection URL.

    t3://OIM_HOST:PORT

    Context Factory

    Enter the name of the context factory.

    weblogic.jndi.WLInitialContextFactory

    OIM Admin User

    Enter the name of the Oracle Identity Manager user.

    xelsysadm

    Database IT Resource Name

    		    

    IT Resource Name

    Enter the name of the IT resource from which connectivity information must be read.

    MSSQL DB

    Process Form Fields and Query Code Keys

    		    

    UserID

    Enter the ID of the user to be provisioned/created.

    Note: UserID to be deleted or updated or enable/disable should be already existing on the target.

    TestUser

    __NAME__

    Enter the name of the user to be provisioned. This attribute will be used only while provisioning.

    TestUser

    __PASSWORD__

    Enter the password of the user to be provisioned.

    mypassw0r1

    loginName

    Enter the login name of the user to be provisioned. This attribute will be used only while provisioning.

    TestUser

    authType

    Enter one of the following authentication types:

    • WINDOWS_AUTHENTICATION

    • SQL_SERVER_AUTHENTICATION

    Note: This is a mandatory field.

    SQL_SERVER_AUTHENTICATION

    defaultDatabase

    Default database, this is an optional attribute.

    defaultDatabase

    defaultLanguage

    Default language, this is an optional attribute.

    defaultLanguage

    Roles to be added/deleted

    		    

    roles~DBRole~__NAME__

    Enter the role name for the user.

    Role
  5. After you specify values in the mssqlconfig.properties file, run the test utility from the following location:

    OIM_HOME/DBUM-11.1.1.6.0/test/scripts

    For UNIX:

    DBUMProvisioningTester.sh

    For Microsoft Windows:

    DBUMProvisioningTester.bat
  6. Enter Oracle Identity Manager Administrator's Password on the console when prompted. A message confirming the successful completion of running the utility is displayed.

9.3 Running the Test Utility for MySQL

Perform the following steps to run the test utility for MySQL:

  1. Drop the third party jar (mysql-connector-java-5.1.20-bin.jar) in the following directory:

    OIM_HOME/DBUM-11.1.1.6.0/test/thirdparty

  2. If you are using Oracle Identity Manager release 11.1.2.x or later, then include the jrf.jar, jrf-api.jar, and jrf-client.jar files to the classpath.

    These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.

  3. Update OIM_HOME/DBUM-11.1.1.6.0/test/scripts/DBUMProvisioningTester.sh and replace oracleconfig.properties with mysqlconfig.properties in the first argument: 
    java -cp "../lib/*:../thirdparty/*"
oracle.iam.connectors.dbum.testutil.prov.ProvisioningUtility
../config/mysqlconfig.properties
../../bundle/org.identityconnectors.dbum-1.0.1116.jar
  4. Update OIM_HOME/DBUM-11.1.1.6.0/test/config/mysqlconfig.properties with the required information.
    Name Description Sample or Default Value

    Other Data

    		    

    Action

    Enter the type of operation that you want to test:

    • CONNECT: To connect to the target system.

    • CREATE: To create a user in the target system, that is, provisioning.

    • DELETE: To delete the user from the target system.

    • UPDATEPASSWORD: To update the password.

    CONNECT

    ObjectType

    MySQL supports only one user type. Do not modify this entry.

    USER

    Log Level

    Enter one of the following values:

    • OFF

    • INFO

    • FINE

    FINE

    OIM Login Data

    		    

    Security Auth Login Config File

    Security Auth Login Config File

    OIM_HOME/server/config/authwl.conf

    OIM Connection URL

    Enter the Oracle Identity Manager connection URL.

    t3://OIM_HOST:PORT

    Context Factory

    Enter the name of the context factory.

    weblogic.jndi.WLInitialContextFactory

    OIM Admin User

    Enter the name of the Oracle Identity Manager user.

    xelsysadm

    Database IT Resource Name

    		    

    IT Resource Name

    Enter the name of the IT resource from which connectivity information must be read.

    MySQL DB

    Process Form Fields and Query Code Keys

    		    

    UserID

    Enter the ID of the user to be provisioned/created.

    Note: UserID to be deleted or updated should be already existing on the target.

    TestUser

    __NAME__

    Enter the name of the user to be provisioned. This attribute will be used only while provisioning.

    TestUser

    __PASSWORD__

    Enter the password of the user to be provisioned.

    mypassw0r1
  5. After you specify values in the mssqlconfig.properties file, run the test utility from the following location:

    OIM_HOME/DBUM-11.1.1.6.0/test/scripts

    For UNIX:

    DBUMProvisioningTester.sh

    For Microsoft Windows:

    DBUMProvisioningTester.bat
  6. Enter Oracle Identity Manager Administrator's Password on the console when prompted. A message confirming the successful completion of running the utility is displayed.

9.4 Running the Test Utility for DB2

Perform the following steps to run the test utility for DB2:

  1. Drop the third party jar (db2jcc.jar) in the following directory:

    OIM_HOME/DBUM-11.1.1.6.0/test/thirdparty

  2. If you are using Oracle Identity Manager release 11.1.2.x or later, then include the jrf.jar, jrf-api.jar, and jrf-client.jar files to the classpath.

    These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.

  3. Update OIM_HOME/DBUM-11.1.1.6.0/test/scripts/DBUMProvisioningTester.sh and replace oracleconfig.properties with db2config.properties in the first argument: 
    java -cp "../lib/*:../thirdparty/*"
oracle.iam.connectors.dbum.testutil.prov.ProvisioningUtility
../config/db2config.properties
../../bundle/org.identityconnectors.dbum-1.0.1116.jar
  4. Update OIM_HOME/DBUM-11.1.1.6.0/test/config/db2config.properties with the required information.
    Name Description Sample or Default Value

    Other Data

    		    

    Action

    Enter the type of operation that you want to test:

    • CONNECT: To connect to the target system.

    • CREATE: To create a user in the target system, that is, provisioning.

    • DELETE: To delete the user from the target system.

    • ENABLE: To enable the user in the target system.

    • DISABLE: To disable the user in the target system.

    CONNECT

    ObjectType

    DB2 supports two user types: USER and GROUP

    USER

    Log Level

    Enter one of the following values:

    • OFF

    • INFO

    • FINE

    FINE

    OIM Login Data

    		    

    Security Auth Login Config File

    Security Auth Login Config File

    OIM_HOME/server/config/authwl.conf

    OIM Connection URL

    Enter the Oracle Identity Manager connection URL.

    t3://OIM_HOST:PORT

    Context Factory

    Enter the name of the context factory.

    weblogic.jndi.WLInitialContextFactory

    OIM Admin User

    Enter the name of the Oracle Identity Manager user.

    xelsysadm

    Database IT Resource Name

    		    

    IT Resource Name

    Enter the name of the IT resource from which connectivity information must be read.

    DB2

    Process Form Fields and Query Code Keys

    		    

    UserID

    Enter the ID of the user to be provisioned/created.

    Note: UserID to be deleted or updated or enable/disable should be already existing on the target.

    Dummy_Account

    __NAME__

    Enter the name of the user to be provisioned. This attribute will be used only while provisioning.

    Dummy_Account

    userType

    Enter the type of the user to be provisioned.

    USER
  5. After you specify values in the mssqlconfig.properties file, run the test utility from the following location:

    OIM_HOME/DBUM-11.1.1.6.0/test/scripts

    For UNIX:

    DBUMProvisioningTester.sh

    For Microsoft Windows:

    DBUMProvisioningTester.bat
  6. Enter Oracle Identity Manager Administrator's Password on the console when prompted. A message confirming the successful completion of running the utility is displayed.

9.5 Running the Test Utility for Sybase

Perform the following steps to run the test utility for Sybase:

  1. Drop the third party jar (jconn4.jar) in the following directory:

    OIM_HOME/DBUM-11.1.1.6.0/test/thirdparty

  2. If you are using Oracle Identity Manager release 11.1.2.x or later, then include the jrf.jar, jrf-api.jar, and jrf-client.jar files to the classpath.

    These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.

  3. Update OIM_HOME/DBUM-11.1.1.6.0/test/scripts/DBUMProvisioningTester.sh and replace oracleconfig.properties with sybaseconfig.properties in the first argument: 
    java -cp "../lib/*:../thirdparty/*"
oracle.iam.connectors.dbum.testutil.prov.ProvisioningUtility
../config/sybaseconfig.properties
../../bundle/org.identityconnectors.dbum-1.0.1116.jar
  4. Update OIM_HOME/DBUM-11.1.1.6.0/test/config/sybaseconfig.properties with the required information.
    Name Description Sample or Default Value

    Other Data

    		    

    Action

    Enter the type of operation that you want to test:

    • CONNECT: To connect to the target system.

    • CREATE: To create a user in the target system, that is, provisioning.

    • DELETE: To delete the user from the target system.

    • ENABLE: To enable the user in the target system. This operation is supported for the object type UserLogin only.

    • DISABLE: To disable the user in the target system. This operation is supported for the object type UserLogin only.

    • ADDROLE: To add/grant role to the user. This operation is supported for object type User.

    • DELETEROLE: To delete/revoke role of the user. This operation is supported for object type User.

    • UPDATEPASSWORD: To update the password. This operation is supported only for the object type UserLogin.

    CONNECT

    ObjectType

    Sybase supports two user types: USER and USERLOGIN

    USERLOGIN

    Log Level

    Enter one of the following values:

    • OFF

    • INFO

    • FINE

    FINE

    OIM Login Data

    		    

    Security Auth Login Config File

    Security Auth Login Config File

    OIM_HOME/server/config/authwl.conf

    OIM Connection URL

    Enter the Oracle Identity Manager connection URL.

    t3://OIM_HOST:PORT

    Context Factory

    Enter the name of the context factory.

    weblogic.jndi.WLInitialContextFactory

    OIM Admin User

    Enter the name of the Oracle Identity Manager user.

    xelsysadm

    Database IT Resource Name

    		    

    IT Resource Name

    Enter the name of the IT resource from which connectivity information must be read.

    Sybase DB

    Process Form Fields and Query Code Keys

    		    

    UserID

    Enter the ID of the user to be provisioned/created.

    Note: UserID to be deleted or updated or enable/disable should be already existing on the target.

    TestUser

    __NAME__

    Enter the name of the user to be provisioned. This attribute will be used only while provisioning.

    TestUser

    __PASSWORD__

    Enter the password of the user to be provisioned.

    mypassw0r1

    loginName

    Enter the login name of the user to be provisioned. This attribute will be used only while user creation.

    TestUser

    TestLogin

    databaseGroup

    Enter the database group. This attribute will be used only while user creation.

    databaseGroup

    defaultDatabase

    Default database, this is an optional attribute. This attribute will be used only for UserLogin.

    defaultDatabase

    defaultLanguage

    Default language, this is an optional attribute. This attribute will be used only for UserLogin.

    defaultLanguage

    fullName

    Enter full name of the user. This attribute will be used only for UserLogin.

    fullName

    Roles to be added/deleted

    		    

    roles~DBRole~__NAME__

    Enter the role name for the user.

    Role
  5. After you specify values in the mssqlconfig.properties file, run the test utility from the following location:

    OIM_HOME/DBUM-11.1.1.6.0/test/scripts

    For UNIX:

    DBUMProvisioningTester.sh

    For Microsoft Windows:

    DBUMProvisioningTester.bat
  6. Enter Oracle Identity Manager Administrator's Password on the console when prompted. A message confirming the successful completion of running the utility is displayed.