Tuesday 7 June 2011

What is a Peoplesoft Connect ID ?

We will discuss what is a Peoplesoft connect id, where it is used , how to create connect id and permission required by connect id.

What is a PeopleSoft connect id?
PeopleSoft connect id is a very important peoplesoft database id which is required for initial connection to database in PeopleSoft. It replaces the old concept of having database userid for every peoplesoft user id. A connect Id is a valid user ID that, when used during sign in takes the place of Peoplesoft User Id.
Where is connect ID used?
As mentioned above, peoplesoft connect Id is used for initial authentication with peoplesoft database. We require connect Id whenever we need to configure application server, process scheduler and configure 2 tier client like peoplesoft application designer and data mover. If connect id is not mentioned correctly you will face error while starting application server,process scheduler server & will be unable to login in app designer or data mover.

Application Server: Connect Id is entered when choosing "Configure this domain" option for any application server domain using psadmin utility.
Connect Id can also be entered directly in application server configuration file psappsrv.cfg for the domain being configured. After making changes to psappsrv.cfg file , appserver needs to be configured again using psadmin so that psadmin picks up new settings as mentioned in "psappsrv.cfg" file.
Process Scheduler Server: Similar to application server configuration, connect id is used in process scheduler configuration as well. Connect Id can be entered in process scheduler configuration file "psprcs.cfg" as well.
2 tier client eg. PeopleSoft Application Designer, Data mover: As these 2 tier clients also connects with database so connect id is also required to be configured for these. To configure this we need to go to the configuration manager which can be accessed via installed peopletools workstation. Enter values of connect id and password on the startup tab of peoplesoft configuration manager.

If you don't specify connect id , system will assume that you are trying to access peoplesoft using 3 tier access. Learn how to setup 3 tier connection in peoplesoft.

Get our exclusive subscription-only PeopleSoft tips once per month!

How to create a connect Id?
While creating a new database, connect id is created using connect.sql script which is present in PS_HOME\scripts\nt\ folder. By default 'people' is connect id, although a new connect id can be created any time later.

What are the permissions required for connect id?
For initial connection with peoplesoft database, connect id needs to have read only access to three major peoplesoft tables i.e PSSTATUS, PSOPRDEFN and PSACCESSPRFL. Usually this access is also granted as part of database installation using grant.sql which is also present in PS_HOME. You can also grant access by running the below commands.
GRANT SELECT ON PSACCESSPRFL to people;
GRANT SELECT ON PSSTATUS to people;
GRANT SELECT ON PSOPRDEFN to people;


If you still have any questions, please leave some comments here or for quick response like our facebook page and ask your question there.

2 comments:

Unknown said...

GRANT SELECT ON PSSTATUS to people why we are assigning SELECT Previlige to people on PSSTATUS?

Unknown said...

is it not possible to particular application version compatible with the peopletools version


8.53 compatible application FSCM 9.2

HOW COULD WE KNOW THE FSCM9.2 compatible with the PT8.53 before login into DATA MOVER?

Get our exclusive subscription-only PeopleSoft tips once per month!

How was the blog? Help us in getting better