Data Warehouse, Data Marts, & Application Manager (AppMan) Information
Overview
The Analytics - Enablement, Shared-Services, and Platform (ESP) team manages data in the Data Warehouse and the Repository that is used to support state and USF operational reporting.
Data Warehouse
Data Warehouse is a collection of tables, views, snapshots, and other objects designed for the purpose of state and operational reporting. Information on the main objects in the Data Warehouse can be obtained in the document Data Warehouse Tables and Views Available to Users.
Some tables and views related to the main tables are not included in the above documentation. Detailed information on these and other Data Warehouse tables and views is available in the MetaMart.
Data Warehouse application, forms, and documentation:
Data Warehouse Tables and Views Available to Users (available to DWHOUSE users based DAL security)
Request Data Warehouse access (Note: to log in and request a Data Warehouse account, you must use a computer with a USF IP address and use your NetID).
Standards for Development and Documentation
Read about standards for Data Warehouse database tables and views and, Applications Manager (AppWorx) process and job documentation, and repository usage.
Data Marts Applications
Data marts provide access to subject-oriented data in a data warehouse environment, such as student admissions data or data reported to the Board of Governors.
Security privileges are required to access data in USF data marts. Privileges could be one of, or any combination of, the security privileges listed below:
USF Net ID and password
Security privileges granted to a specific mart and/or specific pages within that mart (these privileges are usually granted manually)
Security privileges granted to a specific group, such as a data steward group
Data Marts Page
Data Marts Page contains links to the data marts listed below. To bookmark the Data Marts Page, use the URL https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=103:1, not the URL generated when you follow it in your web browser. Your web browser will add a session ID that is only good for that one browser session.
MetaMart
The MetaMart is an interactive tool that allows business and technical users to easily locate information about USF enterprise business systems metadata. To bookmark the MetaMart, use the link https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1, not the URL generated when you follow it in your web browser. Your web browser will add a session ID that is valid only for that single browser session.
Hub Mart
Hub Mart provides access to the data collected for BOG reporting and Operational uses. This application also provides functionality needed to upload data to select tables and functionality to give data steward groups access to select views. To bookmark the Hub Mart, use the URL https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=110:1, not the URL generated when you follow it in your web browser. Your web browser will add a session ID that is valid only for that single browser session.
Doc Mart
Doc Mart provides access to documentation on the data extracted and stored for the BOG file submission. This includes information on data sources and identifies which USF data element meets which SUDS data element. To bookmark the Doc Mart, use the URL https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=123:1, not the URL generated when you follow it in your web browser. Your web browser will add a session ID that is only good for that one browser session.
Application Manager (AppWorx)
Applications Manager is an administrative systems automation tool that Banner users, with the appropriate privileges, can run and schedule processes.
AppWorx Documentation System (requires login)
Applications Manager (requires login)
Production instance (AMPROD) installation
Production instance (AMPROD) client
Report Documentation
IT Analytics, SVC4010, Contact Us