Enterprise Data: Architectural Diagram of Current Environment

The following image is a simplified drawing of the architecture of enterprise data at the University of Minnesota.

enterprise data pdf click to download

Click image to download larger pdf

 

Text description of image:

This simplified overview shows the current environment of the enterprise data and analytics service.
There are four primary areas of the drawing: Data Sources, ETL (Extract Transform Load), Data Warehouses, Reporting and Analytics

On the left, some of the various data sources at the University are shown. PeopleSoft is shown feeding into PSSNAP (a peoplesoft clone). There are two other source systems displayed.

The Data Sources are shown as feeding into four different areas:
    €¢    Tertiary Systems, which are labeled "custom, unit support"
    €¢    Microsoft SSIS ETL (Windows) €” In the ETL section of the drawing
    €¢    Informatica PowerCenter ETL (Linux) €” In the ETL section of the drawing
    €¢    UM Reports Framework (Windows) €” In the Reporting and Analytics section of the drawing

In the ETL section, there are two servers €” Microsoft SSIS ETL and Informatica PowerCenter ETL.
These two servers are connected to the three databases in the Data Warehouse section.

The Data Warehouse section contains three databases:
    €¢    UM Reports Database oit gold (Microsoft SQL)
    €¢    Enterprise Data Warehouse edwprd (Oracle)
    €¢    Legacy Data Warehouse dweprd (Oracle)

The Reporting and Analytics section contains three servers:
    €¢    UM Reports Framework (Windows)
    €¢    UM Analytics Oracle BI (Linux)
    €¢    Web Query Tool (Windows)

The UM Reports Framework and the UM Analytics Oracle BI are shown feeding into MyU Reporting Center.

The last section contains the End User/Consumer or Analyst. This box points towards both MyU and the Web Query Tool and the "SQL Developer, Toad for Oracle" box.