Databases

Settings - Databases

Sentinel interacts with the PeopleSoft database using an ODBC or JDBC connection. It can simultaneously support multiple PeopleSoft Pillars (HR, FS, CS) and PeopleTools versions.

The application does not create or modify tables within a PeopleSoft environment. Transaction history and audit reports are stored in the Sentinel database.

Security changes made in Sentinel and PeopleSoft are automatically synced after they occur. To differentiate between PeopleSoft and Sentinel updates, each update from Sentinel is prefixed by SNT_(User ID) in the PeopleSoft database.

Account Requirements

A database account is required for proper functionality, and installation cannot be completed without the database account credentials.

  • A separate database account is required for each PeopleSoft Environment.

    *The client is solely responsible for creating and maintaining their account credentials.

Add A Database Connection
  1. Navigate to Settings - Databases.

  2. Click 'Add,' located at the top right.

  3. Input the following database account credentials and connection information:

  4. Click 'Test Connection.'

    • If successful, click 'Create.'

    • If an error occurs, verify there is connectivity between the Sentinel server and the PeopleSoft database server.

After a new database is added to Sentinel, the initial build process must be manually run for the database to be accessible. *The process runs automatically after the initial build.

Database Info is used to configure the Environment Name, PeopleSoft Shortcut Link, and Write Access Settings.

  • Environment Name - The name of the environment as it is displayed to users.

  • PeopleSoft Environment URL - Creates a shortcut link to the PeopleSoft application.

  • Lock Environment - Disables all Sentinel updates & makes environment 'Read-Only.'

  • Deactivate - Stops the database connection and can be removed from Sentinel.

Last updated