Near Real-Time
Posted: Fri Jan 15, 2010 8:35 am
Hi,
I have requirement to design a datastage job to load POS transaction data in datawarehouse near real-time. Source system will send a message and my job should be able to read the message (xml) and load in respective tables.
Once data loaded in DW successfully then message can be deleted from the queue, in case of load failure message should be available to re-read.
At this point I am not sure what type to message application will be used.
My questions are:
1. Can I use WebSphere_MQ_Connector to read message when
messaging application is not IBM WebSphere MQ (MQ Series).
2. Do we need to install anything message related (Client etc.) in
datastage server.
3. Any suggetions and tips from your experience for similar
requirement.
I have been reading Dsxchange posting and other Pdfs, I found all are pointing to IBM WebSphere MQ (MQ Series) related.
I really appreciate your time and valuable inputs.
Thanks.
I have requirement to design a datastage job to load POS transaction data in datawarehouse near real-time. Source system will send a message and my job should be able to read the message (xml) and load in respective tables.
Once data loaded in DW successfully then message can be deleted from the queue, in case of load failure message should be available to re-read.
At this point I am not sure what type to message application will be used.
My questions are:
1. Can I use WebSphere_MQ_Connector to read message when
messaging application is not IBM WebSphere MQ (MQ Series).
2. Do we need to install anything message related (Client etc.) in
datastage server.
3. Any suggetions and tips from your experience for similar
requirement.
I have been reading Dsxchange posting and other Pdfs, I found all are pointing to IBM WebSphere MQ (MQ Series) related.
I really appreciate your time and valuable inputs.
Thanks.