HTTP Post from DataStage
Posted: Sun Oct 07, 2007 11:28 pm
We are in process of designing a new ETL process here. Our requirement is to extract messages from MQ and post it to destination URL by making an HTTP post. The extract job will be scheduled and the job should pick up all the messages in the queue in one go and then do the data transformation and do the data posting. In this regard I have the below queries
1. Can we do an HTTP post from Data stage?
2. Consider the scenario where we have 10 messages to be posted using HTTP and the HTTP post job fails after sending 4th message.
a. What will happen to the remaining messages pending to be sent out?
b. What will happen to the ones that are already sent out?
3. Consider the scenario where the 4th message failed in transformation job. Can we continue with the rest of the messages discarding the one that is failed?
1. Can we do an HTTP post from Data stage?
2. Consider the scenario where we have 10 messages to be posted using HTTP and the HTTP post job fails after sending 4th message.
a. What will happen to the remaining messages pending to be sent out?
b. What will happen to the ones that are already sent out?
3. Consider the scenario where the 4th message failed in transformation job. Can we continue with the rest of the messages discarding the one that is failed?