Page 1 of 1
front-end to DataStage
Posted: Tue Aug 25, 2009 7:07 am
by DStageNewbie
Has anyone built a front-end app to DataStage? An app that would let a user enter job parms and submit the job without having to actually sign on to ds.
Posted: Tue Aug 25, 2009 7:55 am
by chulett
I haven't personally, but sure, there are posts here discussing that. The API is published and generally involves using the 'dsjob' function from the command line. The actual code for dsjob is published as well, so some people have coded closer 'to the metal' as well, from what I recall.
A search for "VB" or "Visual Basic" may turn some up, IIRC.
Check the
Command Line Interface chapter in the
Server Job Developer's Guide pdf.
Posted: Tue Aug 25, 2009 9:20 am
by kduke
If you have defaults on your job parameters then you do not need to fill them in. There are several who have put parameter values in text files and filled in the values using shell scripts. This is not a simple task.
Posted: Tue Aug 25, 2009 9:27 am
by tjr
You do not need to fill the values using shell scripts if you leverage the new parameter sets. at run-time just specify the parameter set value file name. the parsing of the value file and setting the parameters will be done by datastage automatically then. the value file layout is pretty simple, having a line for each parameter of the parameter set, like this:
<param1>=<value1>
..
<paramN>=<valueN>
Posted: Tue Aug 25, 2009 1:02 pm
by eostic
Use ISD or RTI and easily have a front end Web Services client application send up the Job parms!
Ernie