Re: Difference between SAS CONNECT and ACCESS

My understanding is that CONNECT is about moving the sas processing from
the box you're in front of to a remote server someplace. We make good
use of it here to move our sas processing to the same machine where the
enormous datasets are stored. Rather than dragging the dsets over the
network to our client pcs, CONNECT sends just the bytes of our program
code to the server, and it runs there.

ACCESS is about enabling sas to address data sources that are not native
sas datasets.

HTH,

-Roy

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Shanks N
Sent: Friday, November 18, 2005 11:01 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Difference between SAS CONNECT and ACCESS


Hello,

I have a setup where there's an Oracle DB server and another box with
SAS. Both running Solaris. I u'stand I'd need ACCESS to connect to the
DB server but is CONNECT necessary?

Both are multi CPU boxes. The SAS sales guy I talked to, well, he
seemed even newer to SAS than me.

The SAS site says CoNNECT does distributed processing, has anyone ever
used it that way?

regards,
Shanks
--