How is the Stimulus Set ETL run?
Question
Regarding the Stimulus Set ETL:
- Is it an SSIS package?
- If not, what is it and where does it run from?
Answer
The SSIS packages execute from a server on the Allscripts network. Allscripts pulls the data from their central location to keep the footprint of the ETLs to a minimum on the source system. On the source server, SELECT statement will be seen running within SQL Server, but that is all.
- A slightly more technical explanation: Allscripts HUB (aka Cloud)