Difference between revisions of "How is the Stimulus Set ETL run?"
Jump to navigation
Jump to search
Steve.Stahr (talk | contribs) (→Answer) |
|||
Line 3: | Line 3: | ||
#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? | ||
+ | |||
==Answer== | ==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. | 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)]] | * A slightly more technical explanation: [[Allscripts HUB (aka Cloud)]] |
Revision as of 14:40, 21 February 2012
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)