Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: real time importing to Oracle.

From: jim <jim_at_freethought.demon.co.uk>
Date: Tue, 02 Nov 2004 19:42:28 +0000
Message-ID: <4187E324.6040307@freethought.demon.co.uk>


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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US