• State Verified Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 94 subscribers
  • Views 1901 views
  • Users 0 members are here
Options
Related

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

DV-BB
over 3 years ago

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.  

Parents
  • +1 over 3 years ago

    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.

Reply
  • +1 over 3 years ago

    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.

Children