Hi,
I have a request from our data warehouse people for implementing ETL process in Datastage on Control-M Tools ,
Has anyone done this before and have any ideas that they can share?
Is there a good practice way to do this?
Otherwise anyone have any ideas which classes to model things into?
I think should be integration between Data Stage Tools with Control-M Tools , but I cannot do this!
please advice
DataStage with Control-M
Hi,
There should be a command in datastage that triggers a job basing on the parameters we pass to it . basically it requires datastage admin user name, password and datastage job name and project name . datastage admin can develop a custom script to hardcode the constants and just pass the required parameters . Then, run that script from Control-M command line passing the parameters .It was implemented in out previous organization . I do not think there is Control-M module for datastage .
There should be a command in datastage that triggers a job basing on the parameters we pass to it . basically it requires datastage admin user name, password and datastage job name and project name . datastage admin can develop a custom script to hardcode the constants and just pass the required parameters . Then, run that script from Control-M command line passing the parameters .It was implemented in out previous organization . I do not think there is Control-M module for datastage .
Re: DataStage with Control-M
There is a Control Module available for InfoSphere® DataStage®
You can download it from the BMC website and install it on the Agent server where your datastage scripts exist.
You can download it from the BMC website and install it on the Agent server where your datastage scripts exist.