Don’t Show Me the Money
Download
Report
Transcript Don’t Show Me the Money
Don’t Show Me the Money
About Pacific University
• Pacific University Oregon (Ory-gun)
– Founded in 1849 for Oregon Trail Orphans
– Small, private university with campuses in Forest
Grove, Hillsboro and Eugene, Oregon
– 4 Colleges; Arts & Sciences, Optometry,
Education, Health Professions
– 3,200 FTE, Undergraduate & Professional, split
50/50
– Colleague since 1993, ODS 2008, Recruiter 2011.
– Mascot is Boxer, a Chinese qilin (dog-dragon)
Add the GL Roles and GL Users tables to the ODS download
COLLEAGUE
Create the Security User Group that will use the schemas
MS SQL ADMIN
Inform the ODS Data Server that the User Group exists
ODS DATABASE
Create RSGL and Budget Schemas
ODS DATABASE
Create Views for the Schemas
ODS DATABASE
Connect Users to the ODBC
USERS
Connect Access Database to ODS via the ODBC
USERS