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:
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.
These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.
$DBUM-11.1.1.6.0/test/thirdparty
Name | Description | Sample or Default Value |
---|---|---|
Other Data |
||
Action |
Enter the type of operation that you want to test:
|
CONNECT |
ObjectType |
Oracle supports only one user type |
USER |
Log Level |
Enter one of the following values:
|
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:
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 |
OIM_HOME/DBUM-11.1.1.6.0/test/scripts
For UNIX:
DBUMProvisioningTester.sh
For Microsoft Windows:
DBUMProvisioningTester.bat
Perform the following steps to run the test utility for MSSQL:
OIM_HOME/DBUM-11.1.1.6.0/test/thirdparty
These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.
java -cp "../lib/*:../thirdparty/*" oracle.iam.connectors.dbum.testutil.prov.ProvisioningUtility ../config/mssqlconfig.properties ../../bundle/org.identityconnectors.dbum-1.0.1116.jar
Name | Description | Sample or Default Value |
---|---|---|
Other Data |
||
Action |
Enter the type of operation that you want to test:
|
CONNECT |
ObjectType |
MSSQL supports two user types: USER and USERLOGIN |
USERLOGIN |
Log Level |
Enter one of the following values:
|
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:
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 |
OIM_HOME/DBUM-11.1.1.6.0/test/scripts
For UNIX:
DBUMProvisioningTester.sh
For Microsoft Windows:
DBUMProvisioningTester.bat
Perform the following steps to run the test utility for MySQL:
OIM_HOME/DBUM-11.1.1.6.0/test/thirdparty
These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.
java -cp "../lib/*:../thirdparty/*" oracle.iam.connectors.dbum.testutil.prov.ProvisioningUtility ../config/mysqlconfig.properties ../../bundle/org.identityconnectors.dbum-1.0.1116.jar
Name | Description | Sample or Default Value |
---|---|---|
Other Data |
||
Action |
Enter the type of operation that you want to test:
|
CONNECT |
ObjectType |
MySQL supports only one user type. Do not modify this entry. |
USER |
Log Level |
Enter one of the following values:
|
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 |
OIM_HOME/DBUM-11.1.1.6.0/test/scripts
For UNIX:
DBUMProvisioningTester.sh
For Microsoft Windows:
DBUMProvisioningTester.bat
Perform the following steps to run the test utility for DB2:
OIM_HOME/DBUM-11.1.1.6.0/test/thirdparty
These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.
java -cp "../lib/*:../thirdparty/*" oracle.iam.connectors.dbum.testutil.prov.ProvisioningUtility ../config/db2config.properties ../../bundle/org.identityconnectors.dbum-1.0.1116.jar
Name | Description | Sample or Default Value |
---|---|---|
Other Data |
||
Action |
Enter the type of operation that you want to test:
|
CONNECT |
ObjectType |
DB2 supports two user types: USER and GROUP |
USER |
Log Level |
Enter one of the following values:
|
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 |
OIM_HOME/DBUM-11.1.1.6.0/test/scripts
For UNIX:
DBUMProvisioningTester.sh
For Microsoft Windows:
DBUMProvisioningTester.bat
Perform the following steps to run the test utility for Sybase:
OIM_HOME/DBUM-11.1.1.6.0/test/thirdparty
These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.
java -cp "../lib/*:../thirdparty/*" oracle.iam.connectors.dbum.testutil.prov.ProvisioningUtility ../config/sybaseconfig.properties ../../bundle/org.identityconnectors.dbum-1.0.1116.jar
Name | Description | Sample or Default Value |
---|---|---|
Other Data |
||
Action |
Enter the type of operation that you want to test:
|
CONNECT |
ObjectType |
Sybase supports two user types: USER and USERLOGIN |
USERLOGIN |
Log Level |
Enter one of the following values:
|
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 |
OIM_HOME/DBUM-11.1.1.6.0/test/scripts
For UNIX:
DBUMProvisioningTester.sh
For Microsoft Windows:
DBUMProvisioningTester.bat