Date:         Mon, 27 Oct 2003 18:57:16 -0500
Reply-To:     "F. J. Kelley" <jkelley@UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "F. J. Kelley" <jkelley@UGA.EDU>
Subject:      Re: using sas to get data from remote oracle database
Content-Type: text/plain; charset=us-ascii

I would have said the ODBC method would be fine, but
recently  I was told some DB folks are concerned re the
security of this method.  Whether this is legitimate (or they
just don't understand why anyone wouldn't want to use the
Oracle client), I cannot say.


---- Original message ----
>Date: Mon, 27 Oct 2003 16:28:19 -0700
>From: William Kossack <kossackw@NJC.ORG>
>Subject: using sas to get data from remote oracle database
>To: SAS-L@LISTSERV.UGA.EDU
>
>We have a project that is ramping up that involves
connecting to an
>oracle database in europe.
>
>Assuming we get a connection to the database what would be
our best
>options for getting the data.  I'm hoping to avoid using
sqlplus to dump
>the data to a flat file (an approach I've had to use in the
past).  Much
>will depend on what kind of connection we are given to the
remote
>system.
>
>We have SAS access to oracle but not a license for oracle
itself.
>
>Can the oracle odbc driver be downloaded and used to create
an odbc
>connection or should I stick to the SAS access to oracle?