Hello

What is the connection type is database under profile tab in configuration manager. why do we use database profile when we are already entering database name in sign in page of application designer.
In peoplebooks its saying that "if the databse used at sign in is not tied to specific profile, the default profile is used to supply required directory information." Please clarify me.

Good question. Answer to the question in one sentence, I don't see any major reason on why it should be required to have a separate radio button for "Database" for Connection Type as long as you configure your application server "Validate Signon with Database" = 0, which is default. This is the type of validation used for most of the RDBMS like oracle, Sybase, MS-SQL Server.

When you have your app server configured as 0, then you can notice when you select Database as the connection type option, the Machine Name or IP Address, Port Number and TUEXDO Connect string options gray out. This means, as long as you connect to the database directly bypassing Application server, you need not mention it here in the profile of the configuration file.

As long as you have the ODBC connection details or tnsnames details for oracle then you would be able to connect to the database using your PeopleSoft ID for app server or data mover and bootstrap mode in data mover.

This would be more useful and practiced mostly when you have DB2/MVS RDBMS which gives additional level of authorization. Then the Administrators usually create the configuration files and give the files to the developers/testers when they install People Tools in their workstations.

When you set Database Signon Validation as 1, then the PSAUTH server process additionally attempt to connect to the RDBMS using the PeopleSoft Operator is and password.

If you want to know the effects of this parameter, then try changing the "Database Signon Validation" parameter and check the connection in 2-tier and 3-tier. [Of course, not on the production environment]

Where can we set "Validate Signon with Database" = 0" in Configuration Manager.

It is not in the client configuration. It is in the application server configuration.

$PS_HOME/<appserver>/psconfig.cfg file contains a security setup like below, which can be modified:


[Security]
;================================================
; Security settings
;================================================
; Use the database for additional signon authentication.
; The default value is 0 (DB signon validation OFF).
Validate Signon with Database=0