Multiple database Users Configurations in Connection Pool

General
, , , ,
1

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 ??

2

@SadhubuggaP16918930 Please can you clarify your question and provide some examples.

3

@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

4

@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.

:full_moon: Changes in prConfig.xml file for Dual User Setup

:full_moon: [Preparing to configure an Apache Tomcat application server > Configuring Tomcat](http://Preparing to configure an Apache Tomcat application server > Configuring Tomcat)

:full_moon: 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.