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.