Date: Thu, 13 Mar 2003 14:46:33 -0600
Reply-To: Daniel Sharp <dmsharp@MATCMADISON.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Daniel Sharp <dmsharp@MATCMADISON.EDU>
Subject: Re: DATABASE
Content-Type: text/plain; charset=US-ASCII
I discussed this with the sas folks before buying 8.2, and Peoplesoft
does sit on top of a RDMS. The word from SAS was that SAS/access can
read the data using the correct database interface, but that
SAS/ACCESS-Peoplesoft is faster, having been optimized for Peoplesoft.
We are running PS on MS Sql Server, rather than Oracle. I've heard that
Oracle environment is not supported as well by PS as SQL Server.
However, We (folks not in IT) do not, nor will we ever query the
transaction database directly, since that drags the system to a
standstill and it's complicated. We are in the process of purchasing a
product to build us a slightly flattened data warehouse (from 7000+
tables to around 150) which we will query. We are running the Student
Administration, Financial, and HR modules.
Regards,
Dan Sharp
>>> Dianne Rhodes <RHODESD1@WESTAT.COM> 03/13/03 01:40PM >>>
>yh266515 <yh266515@YAHOO.COM> [a common name] wrote:
>> My company will soon switch the financial software to Peoplesoft.
>> Currently my dept is using SAS to access financial info.
>from the flat
>> file for our reports. Soon, we will have relation database
>instead of
>> flat file.
>>
>> My concern is will SAS be able to read data from database. Or do we
>> need to write a program to dump data from database to flat
>file so we
>> can use SAS. Most of the times, the query will not meet our
>reporting
>> need.
>
>If you have SAS 8.2, you can buy SAS/Access to Peoplesoft and get the
>data sets directly. That should solve your problem, even though it
>won't
>help your budget.
>
Even worse, it is my understanding that Peoplesoft sits on top of an
RDBMS,
usually the much maligned Oracle.
So I'd check with your systems people before buying anything.
Dianne Louise Rhodes
Sr. Systems Analyst
Westat
| 
