Regarding parameterisation in DRS stage

199542 · Post by **199542** » Sun Mar 30, 2008 9:08 pm

Hi ,
I have some 100 jobs designed .My database is oracle .But , I am using DRS stage instead of oracle enterprise stage because oracle enterprise stage is giving some sql loader error .
with DRS stage , all jobs are working fine . But , If the usernaame and password is getting changed i need to change all 100 jobs .Is there anyway to parameterise the username and password in DRS stage ??
I tried using DATA CONNECTION .But , I heard that it will get locked if one is running .I dont know whether i am viewing it in a right angle .Could someone suggest anything regarding this ??

chulett · Post by **chulett** » Sun Mar 30, 2008 10:46 pm

Not familiar with 8.x connectors yet, but you should always parameterize all of your connection information. A set of Job Parameters would do the trick.

199542 · Post by **199542** » Mon Mar 31, 2008 12:41 am

Thank you chulett for your response .But , In DRS Stage there is no provision for giving job parameters to username and password .Thats where entire problem came

199542 · Post by **199542** » Mon Mar 31, 2008 12:41 am

Thank you chulett for your response .But , In DRS Stage there is no provision for giving job parameters to username and password .Thats where entire problem came

Minhajuddin · Post by **Minhajuddin** » Mon Mar 31, 2008 5:26 am

You CAN use job parameters in the connection options in a DRS stage. The only thing is that you don't get a neat right click option to insert it.
You can use job parameters in the username or password by enclosing the job parameter in #(as in most of the stages)

Code: Select all

username: #job_param_user_name#

Moreover in 8x there is this beautiful parameter set which takes care of bundling the parameters you regularly use.

chulett · Post by **chulett** » Mon Mar 31, 2008 6:56 am

Minhajuddin wrote:You CAN use job parameters in the connection options in a DRS stage. The only thing is that you don't get a neat right click option to insert it.

Ah... not only can you use parameters practically everywhere just by typing them in by hand, you CAN get the 'neat right-click option to insert it' in any database stage... you just have to know how.

Right-click on the DRS (or pretty much any stage) and select 'Grid style'. If the option is there, that will get you the older interface to the stage. There you'll find there the 'Insert Job Parameter' option on the Properties page you can use so you don't have to do all that pesky typing.

I use that all the time, but only for that purpose. So, right-click grid style, click click paramater parameter, get out. Then switch back to the normal view for the rest of your work.

Minhajuddin · Post by **Minhajuddin** » Wed Apr 02, 2008 12:28 am

Thanks for this tip Craig :D

verify · Post by **verify** » Sun Apr 06, 2008 11:52 pm

Sorry for the late reply.....Chulett its working ...Thank you for your solution.Now i will mark this topic as resolved