front-end to DataStage

DStageNewbie · Post by **DStageNewbie** » Tue Aug 25, 2009 7:07 am

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.

chulett · Post by **chulett** » Tue Aug 25, 2009 7:55 am

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.

kduke · Post by **kduke** » Tue Aug 25, 2009 9:20 am

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.

tjr · Post by **tjr** » Tue Aug 25, 2009 9:27 am

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>

eostic · Post by **eostic** » Tue Aug 25, 2009 1:02 pm

Use ISD or RTI and easily have a front end Web Services client application send up the Job parms!

Ernie