Re: SQL and ILS systems

[Mark Dahl <mdahl@cocc.edu>]

I think this Oracle option sounds like a step in the right direction.

An interim step in an III system is to pull the data you want out of the 
system on a regular basis using Expect scripts and the create lists 
function (which now has a nice comma-delimited option), and then reload it 
into an SQL database, which can then be queried with web forms via PHP, 
cgi, etc.

I'm working on a postgresql database containing information from our order 
and bib records.  It allows faculty book selectors to get on the web and 
search by their name or fund code to see what they've ordered.

The best part is that it all comes together with free tools: Linux, Expect, 
perl, PHP, postgresql.

Mark Dahl



At 08:36 AM 8/11/00 -0700, you wrote:
>A fairly new option from Innovative allows you
>to migrate the underlying database to Oracle.
>This is not cheap unless you have a site license
>to Oracle, and there is a charge from Innovative
>to do this also. But it is a major step for them
>in opening up the system, potentially allowing a
>variety of read only and even read-write access
>(if you are confident enough to try it). I thought
>I had heard this was an option with Sirsi at one time
>also.
>
>John Rutherford
>Central Conn State Univ.

Mark Dahl
Systems & Technical Services Librarian
Central Oregon Community College
2600 NW College Way
Bend, OR 97701
voice (541)-383-7783
fax (541)-383-7507
mdahl@cocc.edu