Files and encrypted parameters

MAT · Post by **MAT** » Tue Mar 11, 2003 8:44 am

Hi,
Using a file to store parameters for my jobs, I would like to store in the file encrypted passwords the way DataStage does it. Obviously for reading and writing them after. Is it possible?

I know someone said once he had isolated DataStage encryption function? Does anyone know more about it?

Thanks

MAT

ksoderlund · Post by **ksoderlund** » Tue Mar 11, 2003 9:51 am

MAT,

When a user manually enters text as a password in DataStage, the encryption translation takes place on the client side. This functionality resides in a DLL and to the best of my knowledge has not been made available via a command-line interface. Although the server must be able to translate (decrypt) the encrypted text, I am not aware of any type of text-encryption functionality that is offered from the server.

Sorry, I know this is not what you were looking to hear.

Regards,

Kevin Soderlund
DCS-Strategies

MAT · Post by **MAT** » Tue Mar 11, 2003 9:59 am

Thanks Kev...it may not be what I wanted to hear but it confirms what I was thinking [:(].

I guess I'll ask the folks from Ascential about what can be done about it. The team and especially the client does not like the idea of having server passwords in plain text on UNIX and it is something I need to be able to configure outside of my jobs.

Regards

MAT

ray.wurlod · Post by **ray.wurlod** » Wed Mar 12, 2003 11:25 am

The approach I normally advocate to my clients is not to store the password parameter, but to make any encrypted parameters parameters of the top-level control job, which propagates them down the job hierarchy in a totally secure fashion.
In a production environment, when passwords change, the new default values can be entered via the Job > Set Defaults option in the Director client.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

csimms · Post by **csimms** » Thu Mar 13, 2003 3:21 pm

MAT,

I too have had a similar requirement in a project that I did some time back. Do you have an email address to which I can send a more detailed and direct response?

Chris Simms

mihai · Post by **mihai** » Thu Mar 27, 2003 5:42 am

Here's a wacky idea...

If all you need is the encrypted text, schedule the job and look at the scheduler window - you should see the encrypted password, and you can then type that into your parameter file.

If you still need the 'elegant' solution, please let me know.

Kind regards,
Mihai

_________________________
desk direct:+441908448571