AnsweredAssumed Answered

Sending data from Oracle DB in Response

Question asked by Dariusz.Piotrak on Mar 3, 2016
Latest reply on Mar 7, 2016 by Ujwol Shrestha



We want to perform a custom SQL query (stored procedure would be even better) on Oracle DB and return result (string) as a response.


After successfull authentication and authorisation performed against AD User Store we need to send extra data in the response that is stored in the Oracle DB.

The data in Oracle is not related to user schema - just a reference data about the Group that we want to provide to the Web application.


I've looked at DN attribute, however this seems to require User Store, and Oracle Database is not a user store and doesn't have such schema. Active Response doesn't seem correct as creating database connection for every request is expensive and a bad practise.


Any ideas would be appreciated.


Best Regards