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 ??
Regarding parameterisation in DRS stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
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)
Moreover in 8x there is this beautiful parameter set which takes care of bundling the parameters you regularly use.
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#
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
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.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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Thanks for this tip Craig :D
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>