It is currently 14 Dec 2017 7:19


Post new topic  Reply to topic  [ 4 posts ] 
Author Message
 Post subject: DataStage with Control-M
PostPosted: 24 Apr 2011 2:43 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Aug 2010 12:00
Posts: 53
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


Top
   
 Post subject:
PostPosted: 25 Apr 2011 10:10 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Nov 2007 12:00
Posts: 76
Location: Hyderabad
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 .


Top
   
 Post subject:
PostPosted: 07 Jun 2011 3:08 
Offline
Nouveau
Nouveau
User avatar

Joined: 07 Oct 2010 12:00
Posts: 8
Hi, sharas,

We currently execute several DataStage jobs via Control-M on an ETL platform (AIX 5).

Basicly, we invoke the Datastage job via command line with a "Command"-like job.

The return codes are programmed by whoever is developing the DataStage process and Control-M detects them fine.


Top
   
PostPosted: 15 Apr 2016 4:43 
Offline
Nouveau
Nouveau
User avatar

Joined: 25 May 2009 12:00
Posts: 151
Location: Bangalore
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.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 4 posts ] 

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved