Intermediate Database Connection

Nick Stoltzfus

At one point there was a connection point that would allow for an intermediate database connection whereby I would send the content of a BOD to a stored procedure and the SP would return the BOD back to the data flow.  It looks like that functionality is no longer available Infor OS Cloud.  Is there a work-around or alternative to this that would be best to use?

Kevin Heiman

A successful approach I have used is have your stored procedure, write the result to a table and then run another procedure to fetch that result, ie two database connections back to back.  Generate a correlation ID and pass to the first so that the write can be tagged with it, so that the fetch can request it specifically.

Other thoughts would be to write the result to an outbox table,  use inbox and outbox tables and have stored procedures / triggers on the inbox.

If you want a 'synchronous' experience, then the first one is probably what you want.