Date: Fri, 8 Sep 2000 17:09:29 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "David L. Cassell" <Cassell.David@EPAMAIL.EPA.GOV>
Subject: Re: sas Access to lotus notes (odbc) set-up
Content-type: text/plain; charset=us-ascii
Jeff Lesueur wrote:
> anyone experienced in setting up sas Access to lotus notes ? i've
I can't say that I'm *experienced* here, but I can tell you a couple things.
Lotus Notes is accessible via either ODBC or OLE. If you need to go the
ODBC route, there used to be NotesSQL drivers on the Lotus website which
would do the job. I don't know if they're still there [and free].
> installed sas access (odbc) on a unix platform, the Notes database
> is on an NT platform.
Of course. It's *always* on an NT server.
> lotus is saying that additional
> required on both the unix platform as well as the NT platform (and they
> want $$$ for this software).
Of course!!! If you have SAS on a unix box, I think you'll have to go with
the ODBC route. And if you cannot get the NotesSQL drivers from their
website and you have to use ODBC, there will be no alternative but to buy
from them the drivers. Sorry.
It is probably easier to go the OLE route. [It might be possible to do it via
too.] You could try accessing the Notes databases using OLE in a programming
language such as Visual Basic, Java, or Perl, then transferring [in an
way] the information over to the unix box for SAS processing.
In Perl the OLE route is as easy as 1-2-3 [sorry about the pun :-] :
my $session = Win32::OLE::new->('Notes.NotesSession') or die "Doggone Lotus
Of course there's more needed to open the desired database, get the view you
iterate over all the documents in the view, etc. But you can get there via OLE
it may be cheaper - even if it is less direct. You'll have to decide on
David Cassell, OAO Corp. Cassell.David@epa.gov
Senior computing specialist