I am not very technical but I am in a critical project and seeking some guidance/help.
Basically we need to listen to a BUS where various systems will be publishing messages as and when changes take place. We then need to pickup the messages and load into the Oracle Database Raw schema.
The messages are in XML and the databse will be normalised and then denormalised into a Datawarehouse structure with possioble Datamarts or Rollup/summary tables.
I need to to what is the best method to pupolate the Oracle Database from the XML messages and these messages are event based and Realtime.