Date:         Thu, 27 Jul 2000 16:14:44 -0400
Reply-To:     "Alan H. McArdle" <amcardle@OIRP.UMASS.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Alan H. McArdle" <amcardle@OIRP.UMASS.EDU>
Subject:      Re: SAS, Peoplesoft and ODBC
Comments: To: SAS-L@LISTSERV.VT.EDU
In-Reply-To:  <5823BD992D67D3119F630008C7CF50FC02CC9AA0@skylark.mail.ukans.edu>
Content-type: text/plain; charset=iso-8859-1

Ryan and everyone else,

We are running Peoplesoft on an Oracle 8 system. However, our project staff
are extremely reluctant to allow any access to Peoplesoft other than through
PS security. SQR access is restricted to project staff only (and not all of
them) because of the real damage to the system that an unwary user can do.

All the uses of SAS with Peoplesoft that I've seen so far make use of
intermediate tables moved to another platform like Ryan describes. However,
I'm interested in more direct ways both because I keep finding new things in
SAS 8 and because I'm working with project staff to try to create reporting
files within Peoplesoft. We already have one for limited use but I can't get
at it directly. Hence my questions about ODBC and stored procedures.

Alan McArdle, Institutional Research
University of Massachusetts Amherst

> -----Original Message-----
> From: Cherland, Ryan [mailto:irrmc@ukans.edu]
> Sent: Thursday, July 27, 2000 10:51 am
> To: 'Alan H. McArdle'
> Cc: SAS-L@LISTSERV.VT.EDU
> Subject: RE: SAS, Peoplesoft and ODBC
>
>
> Alan,
>
> What database is PeopleSoft running under at UMass? At KU we are
> running PS
> on Oracle so I can only speak to that. Here we just do direct
> extracts from
> PeopleSoft using SAS/Access to Oracle. To do this, it did require our TS
> people to create a Read-Only Oracle role so that I had access
> outside of the
> PeopleSoft middle layer of security (if you can run an SQR or can use
> SQLPlus, you would have the direct access needed).
>
> We are currently extracting nightly data from our HR/Pay, Financials, and
> some aspects of Student from PeopleSoft (we have applicant/admission data,
> but will not be enrolling students until a year or so). These nightly
> extracts on done on a Unix server with Unix SAS (Sun Solaris), then our
> office does SAS/Connect sessions from SAS for Windows to access the data
> stores from our desktops. These nightly extracts also support
> KU's Web-based
> Intranet information system that uses SAS/IntrNet products to
> deliver ad hoc
> management-style reports. We also use SAS for Windows and its
> SAS/Access for
> Oracle to directly tap into the 'live' version of PeopleSoft when
> analytical
> needs call for extremely current data or data that we do not have
> as part of
> our nightly extracts.
>
> Let me know if you have any other questions or want any more detail.
>
> --------------------------------------------------
> Ryan Cherland               email: irrmc@ukans.edu
> Director                    phone:  (785) 864-4412
>   Univ Management Info        fax:  (785) 864-5324
> Associate Director
>   Office of Institutional Research & Planning
> University of Kansas
> P.O. Box 505
> Lawrence, KS 66044-0505
>
>
> Alan H. McArdle, Associate Director Analytic Studies
> Office of Institutional Research
> University of Massachusetts Amherst
> Amherst, MA 01003
> Voice: 413-545-5149    Fax: 413-545-3010
>