Question
Virtusa private limited
IN
Last activity: 4 Dec 2023 13:16 EST
Multiple database Users Configurations in Connection Pool
HI All,
We have Configured Database connections with one User for different databases.
But we would like to use Multiple different users for Respective database.-> This we are facing issues We would like to Configure these in Context.xml and prconfig ??
Accepted Solution
Updated: 4 Dec 2023 13:16 EST
Pegasystems Inc.
GB
@SadhubuggaP16918930 we noticed that your post contained some proprietary information ( personal number ). That information has been removed from your post. Just a reminder that the Pega Support Center (PSC) is a public forum and we don't want to share any of your information publicly.
In Pega, you can connect to multiple databases using different user credentials. You need to define each database and its connectivity parameters in the context.xml file and prconfig.xml file under database/databases. Each database should have its own unique name. For example, for entries named database/databases/StagingDB, database/databases/ArchiveDB, and database/databases/ReadReplicaDB, you would enter StagingDB, ArchiveDB, and ReadReplicaDB respectively.
After defining these in the xml files, you need to create a database data instance in Pega for each database. Please remember to restart the server after making these changes.
🌕 Changes in prConfig.xml file for Dual User Setup
🌕 Preparing to configure an Apache Tomcat application server > Configuring Tomcat
@SadhubuggaP16918930 we noticed that your post contained some proprietary information ( personal number ). That information has been removed from your post. Just a reminder that the Pega Support Center (PSC) is a public forum and we don't want to share any of your information publicly.
In Pega, you can connect to multiple databases using different user credentials. You need to define each database and its connectivity parameters in the context.xml file and prconfig.xml file under database/databases. Each database should have its own unique name. For example, for entries named database/databases/StagingDB, database/databases/ArchiveDB, and database/databases/ReadReplicaDB, you would enter StagingDB, ArchiveDB, and ReadReplicaDB respectively.
After defining these in the xml files, you need to create a database data instance in Pega for each database. Please remember to restart the server after making these changes.
🌕 Changes in prConfig.xml file for Dual User Setup
🌕 Preparing to configure an Apache Tomcat application server > Configuring Tomcat
🌕 Creating database instances for prconfig references
If you get no further suggestions on this open forum then feel free to contact your Pega AE in order to arrange a consultancy visit to discuss your requirements.
Pegasystems Inc.
GB
@SadhubuggaP16918930 Please can you clarify your question and provide some examples.
Updated: 27 Nov 2023 4:33 EST
Virtusa private limited
IN
@MarijeSchillern HI Actually we are connecting to a DB from Pega application by making few changes in context.xml, with one user Credential only but it is not Allowing to connect with multiple users to multiple db's we have 3 db's -> Staging DB,->Archeive db and -> readreplica db so pega is allowing to configure only for one user, so this is the Query??
If not please call to my number: [moderator removed proprietary information] will connect in a screen share and explain the issue clearly.
thanks
Accepted Solution
Updated: 4 Dec 2023 13:16 EST
Pegasystems Inc.
GB
@SadhubuggaP16918930 we noticed that your post contained some proprietary information ( personal number ). That information has been removed from your post. Just a reminder that the Pega Support Center (PSC) is a public forum and we don't want to share any of your information publicly.
In Pega, you can connect to multiple databases using different user credentials. You need to define each database and its connectivity parameters in the context.xml file and prconfig.xml file under database/databases. Each database should have its own unique name. For example, for entries named database/databases/StagingDB, database/databases/ArchiveDB, and database/databases/ReadReplicaDB, you would enter StagingDB, ArchiveDB, and ReadReplicaDB respectively.
After defining these in the xml files, you need to create a database data instance in Pega for each database. Please remember to restart the server after making these changes.
🌕 Changes in prConfig.xml file for Dual User Setup
🌕 Preparing to configure an Apache Tomcat application server > Configuring Tomcat
@SadhubuggaP16918930 we noticed that your post contained some proprietary information ( personal number ). That information has been removed from your post. Just a reminder that the Pega Support Center (PSC) is a public forum and we don't want to share any of your information publicly.
In Pega, you can connect to multiple databases using different user credentials. You need to define each database and its connectivity parameters in the context.xml file and prconfig.xml file under database/databases. Each database should have its own unique name. For example, for entries named database/databases/StagingDB, database/databases/ArchiveDB, and database/databases/ReadReplicaDB, you would enter StagingDB, ArchiveDB, and ReadReplicaDB respectively.
After defining these in the xml files, you need to create a database data instance in Pega for each database. Please remember to restart the server after making these changes.
🌕 Changes in prConfig.xml file for Dual User Setup
🌕 Preparing to configure an Apache Tomcat application server > Configuring Tomcat
🌕 Creating database instances for prconfig references
If you get no further suggestions on this open forum then feel free to contact your Pega AE in order to arrange a consultancy visit to discuss your requirements.