I was wondering if anyone had tried to run a Hyperion report or job from a DataStage job or Sequencer. DataStage and Hyperion are installed on two separate Windows servers.
Sorry if I left out important details, I have never tried it before and have no idea how to go about it.
Anything you can script, DataStage can 'launch'. Two primary ways: from a Sequence job the Execute Command stage would do the trick, or it could be done before/after a Server job using ExecDOS or ExecSH.
Curious though, what role would DataStage play here? Other than the launcher, that is?
-craig
"You can never have too many knives" -- Logan Nine Fingers
Thanks for the idea! I forgot about ExecDOS. I could string a BAT file together to do the work and launch it from a job.
For this particular task, the role of DataStage would just be a scheduler or launcher. We use Cybermation to run all our Sequencers. So our Business Analysts want DataStage to run their Hyperion reports that will have dependencies on certain DataStage jobs.
Your next question would then be, why can't you just use Cybermation to run Hyperion reports? Good question! I will ask to see if this a possibility.
kenstorm wrote:Your next question would then be, why can't you just use Cybermation to run Hyperion reports? Good question! I will ask to see if this a possibility.
Exactly right, that would have been the next question!
-craig
"You can never have too many knives" -- Logan Nine Fingers