I want to implement a CER solution, we already have CCM 4.1(3) and we have a legacy PBX that will be slowly left out.
We have an Oracle database that serves for all our telecommunications data needs, billing, inventory, etc. All the data is updated through every step, from the client that asks for a change to the technician that makes the x-connect.
Actually, when a 911 call is made, the information is taken from that Oracle database(calling number, name), processed on a Linux server: it interrogates the legacy PBX to know which port is physically attached to that number. If a DN is on multiple physical location, it interrogates the PBX again to know which port is active/off-hook, then forwards the physical location, name, number of the caller to our security service.
The Linux server that hosts the 911 application extracts a copy of the Oracle db so that if the Oracle server goes down, 911 calls can always be treated, even if the info is not fully accurate during the downtime of the real db.
My question is : how do I make the CER database interact with our Oracle database ? I don't want to duplicate all the information that is already there and accurate. In fact, the only reason we need CER is that we want to be notified if users move their phones and of course, we want to make sure that the info for the 911 call will be accurate as for the physical location of the caller. Actually, the info is 100% accurate for a legacy phone, but not if the call is from an IP phone because users have started to move them.