Difference between revisions of "How is the Stimulus Set ETL run?"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
==Question== | ==Question== | ||
− | Regarding the Stimulus Set ETL: | + | Regarding the Stimulus Set ETL (Extract Transform Load): |
#Is it an SSIS package? | #Is it an SSIS package? | ||
#If not, what is it and where does it run from? | #If not, what is it and where does it run from? |
Latest revision as of 14:42, 2 April 2012
Question
Regarding the Stimulus Set ETL (Extract Transform Load):
- 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)