4 Testing Connector Functionality

You can use the testing utility to directly use the connector for identifying the cause of problems associated with connecting to the target system server and performing basic operations on the target system.

To use the testing utility:

1. Copy the files in the test/config directory on the installation media to the OIM_HOME/xellerate/XLIntegrations/DatabaseAccess/config directory.

   Copy the files in the test/scripts directory on the installation media to the OIM_HOME/xellerate/XLIntegrations/DatabaseAccess/scripts directory.

2. Open the following file:

   OIM_HOME/xellerate/XLIntegrations/DatabaseAccess/config/config.properties
   

3. Specify values for the attributes in this file. These attributes are described in the following table.

   Attribute	Description	Sample Value
   Action	Provisioning action to be performed by the testing utility	CONNECT CREATE_LOGIN DELETE_LOGIN CHANGE_PASSWORD DISABLE_USER
   Database_Driver	Database driver	com.microsoft.jdbc.sqlserver.SQLServerDriver
   Database_URL	Database URL	jdbc:microsoft:sqlserver://172.21.109.73:1433;DatabaseName=sales
   Database_User_ID	User ID for connecting to the database	jdoe
   Database_Name	Database name	sales
   Database_Type	Database type	MSSQL
   LocaleLanguage	Locale language of the target system	en
   LocaleCountry	Locale country of the target system	US
   Login	Login to be created	loginname
   Password	Password for the login	password
   FullName	Full name of the user associated with the login created	FullName
   DefDBSql	Default database for Microsoft SQL Server	MyDB
   Default_Language	Default language	En
   Authentication_Type	Authentication type for Microsoft SQL Server	SQL_SERVER_AUTHENTICATION This is the actual value.
   Tablespace	Any valid tablespace in Oracle Database	Mytablespace
   Datafile_size	Datafile size in Oracle Database	500
   Default_Role	Default role in Sybase
   DB2_Database	IBM DB2 UDB database name	DBApp
   DB2_User_Type	IBM DB2 UDB user type (Group/User)	Group
   Default_DB	Default database for IBM DB2 UDB	SYSTOOLS
   Role	Role	DBA
   Tablespace_Name	Valid tablespace name for IBM DB2 UDB	Systool
   Schema_Name	Valid schema name for IBM DB2 UDB	Systool
   Del_Login	Login name to be deleted	Dellogin
   New_Password	New password for changing password	Password
   Chg_Login	Login name of the user for whom changes are required	jdoe
   User_Type	New user type	User
   DIS_Login	Login to be disabled	DISLogin
   DIS_User_Type	User type of the login to be disabled (Group/User)	User

   
   

4. Run the testing utility file.

   • For Microsoft Windows, run the following file:

     OIM_HOME\xellerate\XLIntegrations\DatabaseAccess\scripts\DBAccess.bat
     

   • For UNIX, run the following file:

     OIM_HOME/xellerate/XLIntegrations/DatabaseAccess/scripts/DBAccess.sh
     

5. When you are prompted for a password, enter the password of the user account whose credentials you specify in the IT resource. See "IT Resources" for more information.

6. If the script runs without any error, then verify that the required provisioning action has been carried out on the target system.