Execute a SQL query in object browser and return data results automatically?

Question

Hello - we are currently using OneIM 8.1.3 and have a question regarding executing a SQL query automatically and exporting data results. As of right now, we use Object Browser to manually execute a SQL query that essentially runs a comparison between an HRIS import file and persons record, then returns the results within the window pane below. 
 Our question is, is there an easy way to automate this process? I'm presuming we would need to potentially create some form of process within Designer; however wanted to gauge whether there are any other possibilities at all. Thanks in advance for any guidance.

Christian Stevens · Accepted Answer

From my experience, OIM has ootb no special means for automated reconciliation, that is, only showing differences between data sources. 
 Creating a process in Designer that executes your SQL and logs the results to some file is probably your best bet. Create a schedule for the process and make sure the correct import file is present at the location given in your statement when it runs. 
 You could also send the results via e-mail in a following process step.

DV-BB · Answer

Thanks, Christian. I'll try going the process route in designer then and see if I'm able to create one successfully. Thanks again

Endpoint Privilege Management

Execute a SQL query in object browser and return data results automatically?

Top Replies