1 / 13

Ulf Borjesson Evangeline Collado Linda Sullivan University of Central Florida

C ASE STUDY: Implementing and Administering SAS ® Enterprise Guide ® Across the Enterprise As a Solution for Data Access Security . Ulf Borjesson Evangeline Collado Linda Sullivan University of Central Florida. Session Highlights. Who We Are Security & Reporting Need Drivers

limei
Download Presentation

Ulf Borjesson Evangeline Collado Linda Sullivan University of Central Florida

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CASE STUDY:Implementing and Administering SAS® Enterprise Guide® Across the Enterprise As a Solution for Data Access Security Ulf Borjesson Evangeline Collado Linda Sullivan University of Central Florida

  2. Session Highlights • Who We Are • Security & Reporting Need Drivers • SAS Enterprise Guide as the Solution • Integrating Systems with Enterprise Guide • New Security Dimensions • Administration of Enterprise Guide • User Support

  3. University of Central Florida (UCF)

  4. Introduction to the EDS Office Enterprise Decision Support • Unit of Institutional Knowledge Management (IKM) • Data Integration Services • Business Intelligence & Information Portal • Enterprise Data Warehouse • Support Decision-making and Planning

  5. Security & Reporting Need Drivers • Aging hardware • Updates needed for reporting data mart (MS SQL Server) • Enhanced security policies • Operational system ad-hoc query tool change

  6. Integrating Systems with Enterprise Guide • SAS server & systems administration • Integrated Windows Authentication (IWA) • Metadata security groups & access control templates • Query & custom solution conversions • SAS Stored Processes • Enterprise Guide projects • ODBC data set extract conversions • Custom user applications • Data delivery options

  7. New Security Dimensions for EG • Integration with university MS Active Directory Domain Services • New security groups for access & function control • New business process for access requests • Multiple domain access • Windows service account, Windows authentication • Local library references

  8. Administration of Enterprise Guide Responses to significant increase of EG users • Creation of installation depot • Automating predefined option settings • EGOPTIONS.xml and ConfigurationV42.xml • MS Sharepoint site - maintenance schedule, tech info • Future development • Identify unit IT points of contact for Enterprise Guide issues • Enhance server performance monitoring

  9. Enterprise Guide User Support • Individual installation & initial orientation • Individual training by EDS development team • Hands-on workshops for new EG users • User reference documents: Enterprise Guide User’s Quick Start Guide Enterprise Guide Training Resources • EG User reference page within Information Portal • Support challenge: Widely varied user query skill sets

  10. Summary Enterprise Guide has proven to be: • Powerful • Flexible • Adaptable • Versatile • Secure THE SOLUTION OF CHOICE!

  11. Contact Information Ulf Borjesson Systems Administrator Email: Ulf.Borjesson@ucf.edu Phone: 407-882-1587 Evangeline (Angel) Collado Senior Database Programmer/Analyst Email: Evangeline.Collado@ucf.edu Phone: 407-823-4968 Dr. Linda Sullivan Director, Enterprise Decision Support Email: Linda.Sullivan@ucf.edu Phone: 407-823-6683 Website: www.iroffice.ucf.edu

More Related