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

Question

Yakov Berger · Mar 12, 2020

Hi,

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?

Thanks

Discussion (1)2

Jenna Poindexter · Apr 15, 2020

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.

0 0

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

Social networks

InterSystems resources