Create a connection for PeopleSoft

Create a PeopleSoft connection as follows:

  1. Select the application to be extracted from the drop-down list.
  2. Select the required Insight from the drop-down list. Insights must be installed first on the IRC Portable Data Extractor before they can be viewed in the drop-down list.
  3. Provide the connection information to be used by the adapter. Unless the connection information is correct, connection creation will fail and an error message will be displayed.
  4. Click Next to save your changes and go to the next screen.
    The connection parameters for PeopleSoft are as follows:
    FIELD DESCRIPTION
    Connection Name

    Provide a user-defined connection name.

    Provider

    Select the provider depending on the back end database

    Server

    Provide the name of the server.

    DataSource

    Provide the name of the DataSource. Data Source is the database name if Provider is SQL whereas if the Provider is Oracle the database name is TNS Alias.

    Base Language of PeopleSoft

    Select the base language of PeopleSoft for which we are creating a database. The base language is the language of the PeopleSoft ERP database installed at the server end.

    Connection Language

    Select the connection language. Data is extracted in the selected language.