How to use XML stages to handle real time data transform?

olgc · Post by **olgc** » Thu Dec 01, 2005 8:27 am

Hi there,

Under ReaL Time in the Datastage Designer, there are three stages: XMP_INPUT, XML_TRANSFORMER and XML_OUTPUT. How are these stages used to handle real time data transform? Does the source operation system generate XML file with its operations as the source XML File? Or messaging service do this? Why that's the case?

Thanks,

chulett · Post by **chulett** » Thu Dec 01, 2005 9:06 am

They become truly 'real time' when you use them in an SOA enabled job published as a Web Service. Yes, that means you have to purchase the SOA Edition, so the category is a bit of a misnomer out of the box.

olgc · Post by **olgc** » Thu Dec 01, 2005 3:01 pm

But how SOA works? Subscribe and inform? Or event-driven? Does this mean to modify the operational applications to generate events?

chulett · Post by **chulett** » Thu Dec 01, 2005 3:27 pm

Best to post questions like that over in the SOA forum. As I said, it allows you to publish a job as a Web Service with a choice of different bindings - SOAP over HTTP, JMS and EJB from what I recall.

olgc · Post by **olgc** » Fri Dec 16, 2005 3:22 pm

Can Datastage handle the real time like Sunopsis?
It is said that using Sunopsis, It first journize the source table, which means tracking the source data change. Then the job is set to only use the data that has changed. The job itself is developed as usual. In this approach, it makes real time ETL a piece of cake. No jargon SOA.