Difference between revisions of "How is the Stimulus Set ETL run?"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
(Created page with "==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 Al...")
 
Line 6: Line 6:
 
==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.
 +
 +
 +
[[Allscripts HUB (aka Cloud)]]

Revision as of 03:10, 19 November 2011

Question

Regarding the Stimulus Set ETL:

  1. Is it an SSIS package?
  2. 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.


Allscripts HUB (aka Cloud)