Hi @vinaybethi - Have your tried exploring workflows ? You can potentially use features like external trigger to invoke any custom bit like calling the IDN workflow from an external powershell then have the workflow orchestrate based on the inputs received. Would suggest reading it here to know details - Triggers - SailPoint Identity Services
hi @vinaybethi, When you say you want to connect to Database at which event do you want to connect and do these operations.
Some suggestions I can think of would be.
create a source with that database
provision the access like if the user is requesting for an access + run the query
Once the provisioning is completed trigger the email via workflow using provisioning completed trigger.
Hi Vinay,
Are you talking about connecting to IdentityNow database or any other database?
If you want to query IdentityNow best is use Workflow. From the Workflow Schedule it and then have a HTT Post to search the data in IdentityNow and once done take the output and send it to user via Email action.
If you want to connect external database then best is use powershell to do that.