Question

4
Replies
246
Views
X
BrianR9472 Member since 2018 7 posts
Appriss
Posted: 11 months ago
Last activity: 11 months ago
Solved

How to set a values for a connection to an external Oracle database connection

My application is working with an external Oracle database as it's SOR. We have defined the connection to this database in a Database rule, using a JDBC Connection Pool. The connection string defines a user created specifically for our Pega application for the connection. So, any connections that are made made from the pool appear to be from this user.

We now have an auditing requirement to know the identity of the logged in user that executed the CRUD operations that we do to this database. There is a way to do this by calling a procedure when the connection is initiated according to this article: https://oracle-base.com/articles/misc/dbms_session

We have very few Connect-SQL rules defined in our app, and are instead using the Data classes that map to the external database. Does Pega provide any hooks or options into the connection process on call this stored procedure to set the client information for the connection? This seems like this would be needed by people who deal with connection pools and auditing for an external database.

Regards,

Brian

Data Integration
Share this page LinkedIn