· Mar 12, 2020

How to populate and then then query a staging table in a Business Service


Newbie Question.

I have a Staging table i want to populate by running a Stored Procedure  and then query the same table with some sort of SQL inbound Adapter.

is this possible or do i need to create a separate service for this? 



Discussion (1)2
Log in or sign up to continue

Hi Yakov

First, I wouldn't implement this kind of logic in a business service.  I would have a business service that immediately passes a message to a business operation and then perform these functions there (or possibly in business operations).   Services should not be long-running which building and querying a staging table seems like it might take some time.