A lot depends upon your shop. If you have a middleware infrastructure (MQ Series, MSMQ), why not use that? The obvious answer is use the Oracle message broker with a trigger. Or simply do a bulk copy on a batch basis. Why make things complicated? A more progressive answer is wrap both systems as Web Services using XML and SOAP. IBM and SUN provide free tools for this development. Information is available from a variety of sources, including http://www.soapware.org/bdg. Our software, TierBroker, has been designed to wrap legacy data warehouses in SOAP API's without resorting to bulky Java or C# programming.
Dig Deeper on Topics Archive
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.