Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: real time importing to Oracle.

Re: real time importing to Oracle.

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 1 Nov 2004 14:30:41 -0500
Message-ID: <>

"jim" <> wrote in message
| 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 Mon Nov 01 2004 - 13:30:41 CST

Original text of this message