Execute DS job using Web services

rajeev_prabhuat · Post by **rajeev_prabhuat** » Wed May 20, 2009 10:47 am

Hi,

We have a requirement from client to execute some Datastage job using web services. So please let me know what all are the ways that we can get this accomplished.

Regards
Rajeev Prabhu

ray.wurlod · Post by **ray.wurlod** » Wed May 20, 2009 12:25 pm

Do you mean to invoke the DataStage job from a Web service, or to expose the DataStage job AS a Web service?

rsiem · Post by **rsiem** » Wed May 20, 2009 1:08 pm

Uh, just write a web service that'll execute dsjob shell command with the correct parameters.

Not that big of a deal really...

ray.wurlod · Post by **ray.wurlod** » Wed May 20, 2009 4:21 pm

The easiest is probably just to use the dsjob command line interface. The question then arises about providing data to, and retrieving data from, the job. You have a number of choices here including file system files, message queues, named pipes and so on.

eostic · Post by **eostic** » Wed May 20, 2009 7:44 pm

...but ISD, assuming it is licensed, would be more elegant!

This is where a Job is published as a Web Service (can be any normal Job) and the Job Parameters become the input to that Web Service......it's the simplest and least exciting pattern for ISD, but very do-able.

Ernie

rajeev_prabhuat · Post by **rajeev_prabhuat** » Mon May 25, 2009 11:13 am

ray.wurlod wrote:Do you mean to invoke the DataStage job from a Web service, or to expose the DataStage job AS a Web service? ...

Yes Ray it is to invoke Datastage job from web services i.e. call a job while a page is submitted in web. Currently I am writing a bat file which will call dsjob command and execute the job. Is there a better way of doing/achieving it.