[19387] in s-news-athena
[S] SPlus-Oracle - summary
daemon@ATHENA.MIT.EDU (Rita Ghosh)
Mon Oct 4 04:37:28 1999
Date: Mon, 4 Oct 1999 10:25:52 +0200 (MET DST)
From: Rita Ghosh <ghosh@wsl.ch>
Message-Id: <199910040825.KAA07632@wsl.ch>
To: s-news@wubios.wustl.edu
Cc: ghosh@wsl.ch
A few weeks ago, I asked about SPLUS-Oracle interaction.
I received several responses.
It turns out that the possibilities include installing the ODBC driver
when one is working with Splus for windows (Nick Ellis (also see Rose
O'Connor), Howard Brill, Jens Oehlschlaegel-Akiyoshi, Cheryl Howard),
going via SAS (Anona Thorne), HTML based work (Amara Graps) and direct
import of Oracle data by SPlus 5.1 for UNIX (Mette Langaas).
Huge thanks to all of you for sending me so much detailed information
in such a short time.
Best regards
Sucharita Ghosh
rita.ghosh@wsl.ch
The messages are forwarded below.
-------------
From: "Ellis, Nick (Marine, Cleveland)" <Nick.Ellis@cmis.csiro.au>
At our site we have an Oracle database on a Solaris machine. I have an
ODBC driver installed on my Windows NT machine. I can query the database
through the ODBC driver. The ODBC driver can be used from various
applications like MS Access and Splus. From Splus (4.5 for Windows) you
click on File | Import Data... | From ODBC connection. Ask an administrator
to set up the ODBC driver for you.
Nick Ellis
CSIRO Marine Research mailto:Nick.Ellis@marine.csiro.au
PO Box 120 ph +61 (07) 3826 7260
Cleveland QLD 4163 fax +61 (07) 3826 7222
Australia http://www.marine.csiro.au
-------------
From: Rosemary O'Connor [mailto:rosemary.oconnor@marine.csiro.au]
(confirming the response of Nick Ellis)
The only problem is that with SPlus it is not dynamic. ie a copy of the
data is imported, changes are not reflected in the database. Also if
the database tables change a new copy needs to be imported.
Rosemary O'Connor
Data Manager
Cleveland Laboratories
CSIRO Division of Marine Research
Phone: (07) 3826 7298
Fax : (07) 3826 7222
Email: Rosemary.O'Connor@marine.csiro.au
--------------
From: Howard Brill <HBrill@MonroePlan.com>
I've done this using SYBASE SQL ANYWHERE via the ODBC driver in S-PLUS
4.5 on a PC. The same technique should work with Oracle. You can submit
a SQL statement through S-PLUS's ODBC import dialog.
-------------
From: "Cheryl Howard" <cherylghoward@hotmail.com>
The best way to get Oracle data into S-Plus is to use the ODBC interface.
In S-Plus under the file menu, select Import Data> From ODBC Connection... In the dialog box you can use a SQL query to pull only a portion of the
database into S-Plus. In order to do this, you need to have the Oracle
ODBC driver installed. The drivers can be found on your Oracle CD.
Cheryl G. Howard, D.Sc.
cherylghoward@hotmail.com
----------------------------
From: anona@hivnet.ubc.ca
The only way I've done this is to go from oracle to Sas, where I do some
preliminary work, and then from Sas to Splus. If you need further details,
let me know. Perhaps by now, someone has given you information about
a more direct route.
Anona Thorne
Canadian HIV Trials Network
Vancouver, B.C.
-------------
From: Amara Graps <Amara.Graps@mpi-hd.mpg.de>
(Already published on the SNEWS)
-------------
From: "Dr. Jens Oehlschlaegel-Akiyoshi" <oehl@geocities.com>
the S+for windows (from version 4.0) allows ODBC-Access, which in turn
would allow accessing Oracle.
Dr. Jens Oehlschlaegel-Akiyoshi
Psychologist/Statistician (Ph.D.)
Microsoft Certified Systems Engineer (MCSE)
oehl@geocities.com http://www.geocities.com/Tokyo/Bay/5663/
-------------
From: Mette Langaas <Mette.Langaas@nr.no>
I have checked this out for Splus=SPlus 5.1 for UNIX. It seems that data
can be imported into S-Plus from oracle (I managed to do that) but
S-Plus kan not export data to oracle. Therefore I ended up by using
ascii files for import and export Splus-oracle.
If you are interested in details on how to import data from oracle into
S-Plus 5.1 UNIX I can send you an example -- but let me know if you are
interested as soon as possible (I'm starting on my maternal leave Oct
7).
Mette Langaas
Mette.Langaas@nr.no
http://www.nr.no/~mette
(I will inform the list, if I hear from Mette again. But possibly, she is
already on leave and all the best to her.... ).
-------------
-----------------------------------------------------------------------
This message was distributed by s-news@wubios.wustl.edu. To unsubscribe
send e-mail to s-news-request@wubios.wustl.edu with the BODY of the
message: unsubscribe s-news
