Configuration Parameters

This section contains the information that IdentityIQ uses to connect and interact with the application. Each application type requires different information to create and maintain a connection.

Note
Attributes marked with (*) sign are the mandatory attributes.

The PeopleSoft HCM Database connector uses the following connection attributes:

JDBC Connection Settings

The URL to connect to the database.

The user to connect to the host of the database.

The password associated with the specified user.

The Java JDBC class to use for the connection.

Is used to provide a SQL statement that provides a criteria to fetch the record of a person from the PeopleSoft HRMS underlying tables. This query is used during aggregation.

Default: Query is provided to fetch the personal record that also includes the email and phone from the PeopleSoft HRMS system.

Note
If SQL Query has the where clause with "?", then you must specify the ORDER BY clause to aggregate all records correctly.

The getObjectSQL query will be similar to SQL query, however will fetch details of only one Person record at a time. It is recommended for this query to be updated when the SQL Query is updated.

Is used to provide a SQL statement that provides a criteria to fetch the record of a Job from the PeopleSoft HRMS underlying tables.

Select the Exclude Inactive Persons checkbox to exclude inactive persons from aggregation.

The rule that is called for each row returned by the database after the SQL has been executed. The rule uses ResultSet and builds a Map out of it to be consumed by IdentityIQ.

PeopleSoft Credentials

The PeopleSoft server host.

The Jolt port (Jolt Server Listener Port) on which the PeopleSoft Server is listening. Default: 9000

To determine the JOLT Server Listener (JSL) port of the application server, check the JOLTListener section in the psappsrv.cfg file. The file is located in <PS_CFG_HOME>\appserv\<DOMAIN_NAME>, where:

PS_CFG_HOME

Is the location of the configuration file of the PeopleSoft Server.

DOMAIN_NAME

Is the name of the domain to be administered.

The administrator user of the PeopleSoft server.

The password for the administrator user.

Determines if the domain connection password is configured.

The password is required if the Domain Connection Password Enabled attribute is selected.

Library Configuration

The location of the jar files required for communicating with the server. For example:

Relative:

\lib-connectors\PSFT\<jars>

OR

Absolute:

C:\Temp\PSFT\<jars>)

  • SailPoint recommends saving the required jars belonging to the same People Tool version at the same location.

  • If the user wants to use the \WEB-INF\lib-connectors location to save the jars, then they must create a new folder under \WEB-INF\lib-connectors and save the jars location.

  • If the path of both the jars must be specified, then the path of each jar must be added on a new line.

    For example:

    Absolute Path

     

    Relative Path

  • If the jar path is specified in Application Libraries then the jars must not be placed in the WEB-INF/lib folder.