Difference between revisions of "How is the Stimulus Set ETL run?"
Jump to navigation
Jump to search
Steve.Stahr (talk | contribs) (→Answer) |
|||
| (One intermediate revision by the same user not shown) | |||
| 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? | ||
| + | |||
==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)]] | ||
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)