Summary
Summary of ODS and SAS Data Access and Reporting at VCU
Environment
Ellucian Banner ODS (Operational Data Store) database and SAS environments
Solution
Data Access and Reporting implements and supports business intelligence and decision support technology.
- Banner Operational Data Store (ODS) provides secured access to Banner data transformed to facilitate reporting. The ODS has been customized with additional data and transformations to support Census activity, the PDB (Person Database), and other dashboards and reports.
- VCU Reporting Center, developed using SAS Enterprise Business Intelligence which includes the SAS Stored Process Portal (VCU Reporting Center), Enterprise Guide, Microsoft Office Integration and Metadata Management. The VPN/ZScaler must be used to log into the Reporting Center.
- SAS Visual Analytics, used to support the Research Dashboard, Finance Dashboards, Budget Model reporting, and other administrative reports and dashboards.
- Person Database provides a single row perspective of students, employees, affiliates and the VCU Health System. The Person Database provides data to systems such as Blackboard, Email, Parking, and Telecommunications.
- Data Extraction using the ODS to provide data to VCUCard, Recreational Sports, Student Health, STIX, eDirectory, University Libraries, and the Career Center
- VCUID Number System provides a unique identifier for students, employees, affiliates and the VCU Health System to reduce the use of Social Security Number.
- Banner Eprint provides access to static PDF reports secured by Banner security classes and value-based security.
- VCU Data Portal contains links to various Dashboards owned and maintained by many departments throughout the university. On this site, the Human Resources Dashboard, Principal Investigator Dashboard, Finance Dashboard and Research Financial Award Dashboard are maintained by our team (Business Intelligence Analytics in Administrative Systems)
- VCU ODS Cloud Instances Connection Details for use by ODS users granted direct access to the ODSP and ODST databases (via a tool like TOAD or Microsoft SQL Server). These connections are not needed for SAS EG.
- SAS Enterprise Guide Download
- IT Service Request - RamsCentral
- Access to ODS and VCU Reporting Center
Additional Information
NOTE: Do not contact these data owners for ODS data access requests. See How to get access to data in the ODS and VCU Reporting Center
Banner ODS Documentation:
ODS Business Concept Diagrams (Visual Guides to Sources of ODS Data)