Difference between revisions of "Allscripts HUB (aka Cloud)"
Steve.Stahr (talk | contribs) (Created page with "The Allscripts HUB, also known as the Cloud, is the enormous data repository that communicates to every Stimulus Set client's Event Bus Servers. Each night (or on a regular sched...") |
|||
(2 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
− | The Allscripts HUB, also known as the Cloud, is the enormous data repository that communicates to every Stimulus Set client's Event Bus Servers. Each night (or on a regular schedule), an ETL process pulls data from the organization's Works database, through the Event Bus Server and up to the Hub. | + | The Allscripts HUB, also known as the Cloud, is the enormous data repository that communicates to every Stimulus Set client's Event Bus Servers. Each night (or on a regular schedule), an ETL (Extract Transform Load) process pulls data from the organization's Works database, through the Event Bus Server and up to the Hub. |
=== Data Warehouse === | === Data Warehouse === | ||
Line 5: | Line 5: | ||
=== Data Mart === | === Data Mart === | ||
+ | The Data Warehouse communicates a more focused set of data to the '''Data Mart'''. When Stimulus Reports are requested, the Data Mart is the source of this data. Most filters are applied between the Data Warehouse and the Data Mart, like the [[Appointment Type Exclusion]]. The data in the Data Mart is updated daily, after the Data Warehouse has completed its ETL with the Event Bus Server. |
Latest revision as of 14:41, 2 April 2012
The Allscripts HUB, also known as the Cloud, is the enormous data repository that communicates to every Stimulus Set client's Event Bus Servers. Each night (or on a regular schedule), an ETL (Extract Transform Load) process pulls data from the organization's Works database, through the Event Bus Server and up to the Hub.
Data Warehouse
The raw data is housed in the Data Warehouse, partitioned by the Client's Account ID and other defining data elements.
Data Mart
The Data Warehouse communicates a more focused set of data to the Data Mart. When Stimulus Reports are requested, the Data Mart is the source of this data. Most filters are applied between the Data Warehouse and the Data Mart, like the Appointment Type Exclusion. The data in the Data Mart is updated daily, after the Data Warehouse has completed its ETL with the Event Bus Server.