Create a connection for PeopleSoft
Create a PeopleSoft connection as follows:
- Select the application to be extracted from the drop-down list.
- 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.
- 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.
-
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.