Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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. 

  • No labels