Get Latest Updates directly delivered in your Email

Differences Between Two-tier and Three-Tier Connection on PeopleTools Development Environment


For two-tier connections Involves connecting directly to the database. A two-tier connection requires connectivity software to be installed and configured on the workstation. A two-tier connection is required for many upgrade and installation tasks.


Two-tier Connection via App Designer

PeopleSoft Data Mover runs in two-tier mode only.


Involves connecting to the database through the application server. A three-tier connection requires no connectivity software to be installed on the workstation. In a three-tier connection, the application server maintains the connection to the database for transmitting SQL statements between the application server and the database. Only lightweight Tuxedo messages are sent between the workstation and the application server.


Related Article you might like:
Difference Between PeopleTools Operator ID , Connect ID and Access ID
Read File Using SQR and Insert data into Table PeopleSoft

Leave a Reply

Your email address will not be published. Required fields are marked *

Write your code inside of code or pre tag

<code> your code resides here </code>