Two Portals One SignOn: Gateway to University Reporting

1
Two Portals One Sign-On Gateway to University
Reporting

2
University of Central Florida (UCF)
3
Two Portals One Sign-On Gateway to University
Reporting

• Vision
• Implementation
• Our University Reporting Gateway

4
Strategic Plan

• Data Warehouse
• BI Analytic Tools
• Information Portal

5
Data Warehouse

• Historical census data
• Custom tables
• Data cleansing validation

6
BI Analytic Tool

• SAS BI Platform

7
Strategic Plan

• Data Warehouse
• BI Analytic Tools
• Information Portal

8
Portal Benefits

• Improved information delivery
• Access ease of use
• New program/report development
• Security conscious platform

9
Vision

• One Platform - IR Information Gateway
• Classic IR Web applications
• Reporting Database Service
• New Stored Processes
• Other reporting tools (Web Report Studio and OLAP
  cube)

10
IR Web Application
11
Reporting Data Service - RDS
12
Implementation of the Information Delivery Portal

• Single Sign-on
• Security Design and Implementation

13
UCFs Portal
14
Link to Pegasus Mine Information Portal
15
Information Portal
16
Single Sign-On Architecture
17
Secure Socket Layer Implementation

• Purchase SSL Certificate
• Install Certificate on Server
• Configure Tomcat server .xml File
• Configure SAS Web Applications for SSL

18
DW User Access Security PolicyPersonas (Roles)

• Administrators
• Information Enablers
• Stored Process Developers
• Report Authors
• Information Consumers

19
Business Line Security Personas

• Business Line Implementation Example
• College of Education
• EDUC Information Enablers
• EDUC Stored Process Developers
• EDUC Report Authors
• EDUC Information Consumers

20
MetaData Folder Structure

• Directory Tree Modifications
• ReportStudio
• Reports
• UCF
• Reports
• Maps
• Stored Processes
• EDUC
• Reports
• Maps
• Stored Processes

21
Security Access Enforced
22
Security Stored Processes

• Validated and Registered
• Stored for execution in specific folders

23
Information Portal
24
Information Portal
25
New Program Development

• Admissions Profile
• Enrollment Profile
• Retention Profile

26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
(No Transcript)
36
(No Transcript)
37
(No Transcript)
38
(No Transcript)
39
(No Transcript)
40
(No Transcript)
41
(No Transcript)
42
(No Transcript)
43
Future Development

• Program productivity
• Course scheduling with admission
  projections
• Program Review

44
Contact Information

• Office of Institutional Research
• Email iroffice_at_mail.ucf.edu
• Web http//www.iroffice.ucf.edu
• Phone [phone]
• Maureen H. Murray mamurray_at_mail.ucf.edu