Re: real time importing to Oracle.

To add to Mark's suggestion, you may also consider an external program kicked off by a cron job that periodically looks at the file, then posts updates to the database. I've been poking into Perl on my current project and it seems to handle things like that pretty nicely - but there's certainly many other ways to get this job done.

Craig

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<3I6dna4osZyGEhvcRVn-vQ_at_comcast.com>...
> "jim" <jim_at_freethought.demon.co.uk> wrote in message
> news:41868B97.20206_at_freethought.demon.co.uk...
> | Can anyone help with this as I am not familiar with Oracle. One of my
> | students wishes to develop a system to run under UNIX that will have the
> | functionality he has outlined below:
> |
> | It is a PBX phone system which when someone rings in it writes the
> | details of number calling and which person/dept routing to a file. I
> | need some how to have a program waiting till the file is updated to grab
> | the new entry and turn it into format appropriate for oracle so i can
> | run a trigger on it to bring up the callers details.
> |
> | So far as I can see he wants some type of TSR to monitor the PBX file
> | for activity and when detected this will trigger an import to ORACLE.
> | I do not yet know in what format the PBX stores data other than it has a
> | DAT extension. However, if there is anyone has any ideas please help.
> | Jim
> |
>
> if the process that writes the PBX file can't be modified to connect to
> oracle (instead of the PBX file), consider using oracle's EXTERNAL TABLE
> feature to make the PBX file look like a table to oracle, otherwise you need
> a UNIX daemon process to do as you described (what do you teach?)
>
> however, lots of questions, issues remain...
> - IFAK a TSR is a DOS-thingy, in UNIX you're looking at a daemon process
> - what process writes the PBX file? can it connect directly to the database
> (ODBC, ADO, or otherwise)
> - how long does the data stay in the PBX file? how big does it get? how does
> it get cleaned out?
> - what is the volume (frequency) of calls?
>
> ++ mcs
Received on Tue Nov 02 2004 - 20:10:37 CST