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: jim <>
Date: Tue, 02 Nov 2004 19:42:28 +0000
Message-ID: <>

Thanks for the reply. I will see see if I can get the volumetrics and get back to you.

Mark C. Stock wrote:
> "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 Tue Nov 02 2004 - 13:42:28 CST

Original text of this message