Environment variables
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Environment variables
Hi all,
I would like to know , how can i make project environment variables encrypted like such as oracle password and use them as finally
job parameters. i mean project environment variable used as job parameters.
Can some one explain me clearly how to accomplish this.
Thank you all very much.
I would like to know , how can i make project environment variables encrypted like such as oracle password and use them as finally
job parameters. i mean project environment variable used as job parameters.
Can some one explain me clearly how to accomplish this.
Thank you all very much.
kollurianu,
the only way I see this working is if you write your own SetEncryptedEnv and GetEncryptedEnv functions that use some arbitrary algorithm to do this - the DataStage functions are not available to do this.
the only way I see this working is if you write your own SetEncryptedEnv and GetEncryptedEnv functions that use some arbitrary algorithm to do this - the DataStage functions are not available to do this.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Hi Arnd,
Are SetEncryptedEnv and GetEncryptedEnv are Unix functions to be used
to make them encrypted and use them in the datastage jobs(parameters
are encrypted using those functions) do we need to decrypt them with these functions and in datastage job.
Please explain me clearly.
My whole point is that i want to make production oracle password encrypted as datastage project environment variable and i should be able to use that as job parameter(project datastage environment variable)
Thank you
Are SetEncryptedEnv and GetEncryptedEnv are Unix functions to be used
to make them encrypted and use them in the datastage jobs(parameters
are encrypted using those functions) do we need to decrypt them with these functions and in datastage job.
Please explain me clearly.
My whole point is that i want to make production oracle password encrypted as datastage project environment variable and i should be able to use that as job parameter(project datastage environment variable)
Thank you
Hi,
My cheep solution is having a central job control that runs all jobs and hold encripted passwords for all DBs required.
any change of them means changing that job and promoting it indeed, but nothing else - no other job needs any change.
the mentioned job naturally also get the parameters list from a DB table and sets all parameters to the requested job to be run.
IHTH,
My cheep solution is having a central job control that runs all jobs and hold encripted passwords for all DBs required.
any change of them means changing that job and promoting it indeed, but nothing else - no other job needs any change.
the mentioned job naturally also get the parameters list from a DB table and sets all parameters to the requested job to be run.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Re: Environment variables
Have them read from read-only file (permission to read by PROD usr group)
- Sachin
- Sachin
kollurianu wrote:Hi all,
I would like to know , how can i make project environment variables encrypted like such as oracle password and use them as finally
job parameters. i mean project environment variable used as job parameters.
Can some one explain me clearly how to accomplish this.
Thank you all very much.
Another solution
Create a encrypted text file in some setup directory with user name and password separated by some character. Have the path of setup directory as environment variable in DataStage.
To get the password, you need to create a batch job which will execute Unix script to get the password and then pass the password to main job.
Dinesh
Create a encrypted text file in some setup directory with user name and password separated by some character. Have the path of setup directory as environment variable in DataStage.
To get the password, you need to create a batch job which will execute Unix script to get the password and then pass the password to main job.
Dinesh
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Version 7.1 and beyond supports the creation of an encrypted project level environment variable that is set by the Administrator tool and can be added to a project as an encrypted environment job parameter and used in a database stage. I think it's time to add a new FAQ! You need to set the value of the job parameter to $PROJDEF (you will need to type it twice as it is an encrypted field).
The only drawback is that "View Data" will not work with job parameters set to $PROJDEF.
The only drawback is that "View Data" will not work with job parameters set to $PROJDEF.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Vincent - wowie! Finding out about enhancements like that is just like Christmas
Thanks!
Thanks!
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA