Introduction

Users of the Aeros LIVE system may want to archive the results of the reporting system, warehouse them for distribution to other systems, or override the outputs. Aeros CONNECT offers users the ability to run projection reports and output them to a data warehouse.     

Prerequisites

To warehouse Aeros LIVE projection data, we will need:

• An Aeros Live installation, of at least version 1.47.11.0 or greater

• A designated data warehouse database with certain tables and procedures (described below)

• CONNECT permissions for creating and scheduling automated processes

• An installed CONNECT Scheduler Service, if we wish to schedule execution of warehouse batches. 

Configuration

Warehousing projections is an update to the Data Warehouse 1.0 Database, so we'll need a version of that which includes the "Process", "Process_Batch" and "Process_Message" tables. The Process table will need a new record of Process_Key 5, and like other import types before it we will use the Process_Start column to identify the first week-ending date that we will calculate batches for. 

Open