Overview

Microsoft SQL Server is used to provide top level monitoring of the Hybris Integration Process (HIP). Database tables are used to track each instance of HIP. Recording each time the process is run, recording start and end times along with other useful information.

Database

The Mercury database contains the objects required to facilitate the monitoring process and support any reporting\analysis requirements.

Schemas

Monitoring

Contains objects related to the capturing transfer history, recording each instance of HIP being run.

Tables

Monitoring.History

Historic record, each time HIP is run a row is created in this table. HistoryId is created each time HIPS is run, this uniquely identifies each instance of the process.

Monitoring.Process

HIP is comprised of many processes transfer particular files or files within a folder. ProcessId uniquely identifies a process. The table contains useful information relating to each process.

Views

Stored Procedures

Monitoring.InsertHistory

Executed at the start of each instance of HIP. The stored procedure is called from PowerShell by the FileTransferFunctions script. Returns an OUTPUT parameter which contains the HistoryId. The HistoryId is subsequently used in the PowerShell script.

Monitoring.UpdateHistory

Executed at the end of each instance of HIP. The procedure updates the relevant row in the Monitoring.History table by using the HistoryId.