Need help on Database connector

[ShantanuKumar]

We are migrating a Database App to Saviynt and the existing solution makes a select call with multiple column call to Database, manipulate the data and use it in provisioning process.

Below are some of the example:

select * from emp where empid='1234'

select fname,lname from emp where empid='1234'

select abc.NEXTVAL from dual.

I heard that if it doing select * then it won't be possible to achieve with OOTB DB connector. Could you please share some example for other 2 scenarios.  

[rushikeshvartak · Accepted solution]

You can ask application team to create stored procedure

[ShantanuKumar]

That is 1 of the solution which is being discussed but yet to be approved. I am also checking if there are other options from Saviynt side. 

I think if select * is used there is no other way than creating a stored procedure. But if there are only few columns or just reading the next value then it can be doable in Saviynt. Could you share some sample configuration for the same? 

[rushikeshvartak · Accepted solution]

You need to use stored procedure