Datamart user password encryption in ETl files

[SorinM]

Hello,

It is written that ETL Runtime has a password encryption option for cfguser passowrd and also for datamart user password.
Can somebody tell me hot to encrypt this? It is like for config server, to run etl application with -p parameter?

Thank you!

[Kubig]

There is no reason for encrypt etl.properties file. This file is necessary only during the deployment and first start-up.

[Fra]

[quote author=Kubig link=topic=7715.msg33366#msg33366 date=1363275410]
There is no reason for encrypt etl.properties file. This file is necessary only during the deployment and first start-up.
[/quote]
Not true. etl.properties file is used during runtime.

On top of that, I think the question was around the *password* encryption of the cfguser, not the file encryption.

SorinM, were you referring to the CfgUserPasswordEncrypted option? If you were, you can encrypt your password by using the gutils.jar utility included in the Data Mart package, as far as I recall.

Fra

[cavagnaro]

I though the same Fra, but found one deployment where the properties files were empty (no config done) and ETL was working fine....I was surprised too...seems ETL uses CfgServer now to get those options from the DAP

[Fra]

I know, that is a bit of a grey area, however, the CCAnalyzer command lines usually indicate a -conf option that points to the etl.properties file; not sure what it happens when that is not configured..

Fra

[cavagnaro]

Yes I know that, that was my understanding too. But I found this deployment and works...I will have to do a lab to be able to understand it more correctly but so far seems properties files are no longer needed unless running from bat files.

[Timur Karimov]

[quote author=cavagnaro link=topic=7715.msg33371#msg33371 date=1363285266]
...unless running from bat files.
[/quote]
Exactly

[Kubig]

Yes, as I wrote this file is no longer need (I think from 7.0+) for running properly. rather is better have file empty or with "dummy" values, because if anyone,who does not know about that,can start ETL backend script (purge, createdb,..) and re-write existing data,I know that is a unlikely scenario, but never say never :-)

[SorinM]

Thanks all for answers!

I was talking about the cfguser and also DBA user in etl.properties. I will make a test with dummy passwords after finishing the upgrade to see it's ok

[GMG]

Hi,

Which ETL version you are using, I remember 7.6XX has a bug, it wouldn’t Encrypt the password


--
Gaurav Gupta

[SorinM]

Hello,

Yes, I am 7.6

[GMG]

Tell me the exact Version.

mean while try to use lower version... like 7.5XXX.....  Tomorrow I will check and tell you the stable version. 


--
Gaurav Gupta