We are looking to build a scenario where certain job function will extract information every interval of time from several systems and then send it to a couple of custom tables within a single DB. From there PPM will explode the data and will automatically create PPM requests as the registers are added to one of the custom tables.
What is the best approach to fulfill the automatic PPM request creation?.
It's a good idea to create those custom tables inside the PPM DB and then use another trigger or job function within PPM DB to create requests? (all of this information is suposed to become useful request data)
Do you have any suggestions for us to start looking up as guidance to fulfill this request?.
I think WebServices is more oriented to integrations with external systems, besides it need more effort to get it done.
I'll follow the option A (Open Interface) to create the requests and then keep updating each one of them by an oracle procedure (including the flushing). The procedure will be executed via workflow step, letting a parallel step that will be looping every 24 hours. This loop will execute the procedure.
I only have one more doubt. There's any way to automatize the run of Request Import Report?