Overview

Aperture is an application that provides a configuration data store for data center infrastructure. It's a primary source of practically undiscoverable physical metadata about configuration items:

• racks
• data center spaces/rooms
• UPS/HVAC equipment
• physical servers
• network devices
• cards

Most of this data is in the "VISTA" database underneath Aperture. This data can be imported and transformed into ServiceNow using MID Server (on Yale premises proxy)

VISTA Database Views

For the purposes of this integration, DC Operations is working with Avocent via a professional services contract to provide and maintain views for exposing configuration data to ServiceNow. At first this will be a one-way (SN read-only) integration, so Aperture will remain the canonical source of information, while SN will be used to plan & detect changes under the rubric of ITIL Change & Configuration management.

Servers

• APERDB (prod)
• APERDB-T (test)

Credentials

(TBD - SQL server is currently configured to accept DB auth as well as Windows auth, will probably set up a DB-specific account)

Views

Here's an overview of how the views are related: