All Forums Connectivity
td_admirer 36 posts Joined 07/12
09 Jan 2014
Masking Password on the JDBC connectivity from Hadoop to Teradata.

Hello Friends,
Can someone share some insights on how I can mask the password when I make a connection from Hadoop to Teradata using the JDBC drivers? I understand that the password can be entered in the Teradata export/import properties file, but if I need to establish connectivity to multiple Teradata systems from the same cluster, i would not be able to do so. The other way is to hardcode the password on the connectivity something like..
-url jdbc:teradata://TD_SYSTEM_NAME/Database=DB_NAME
-username USERNAME
-password  TEST$123
 
In the above how can I mask the password "TEST$123" from being visibile in the scripts or on the logs? Do we have something like a Password file paramter that I can use or do I have other options? Any help would be appreciated.
 
Thank you.

Raja_KT 1246 posts Joined 07/09
10 Jan 2014

Can you try , if your unix env supports ftppwd, then you can encrypt your password. Remember to echo it after implementing and store in a good place.

Cheers,

Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

td_admirer 36 posts Joined 07/12
10 Jan 2014

Thanks Raja. I unfortunately do not have FTPPWD utility installed on the gateway.
Any other suggestions? Sqoop has a password file option, but TDCH does not have one.

Raja_KT 1246 posts Joined 07/09
10 Jan 2014

Many years ago, we put login credentials in a file. We open the file before logon. Read the values at the program. Once logged on, we remove the file. That file is read with ugo[r-w-x]  only read permission for that user.  I don't think name-value pair of TD query band also will help here.
Just my thought.
Btw, I have seen many folks resorting to sqoop. Why not HIVE or PIG. I am curious.
Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

td_admirer 36 posts Joined 07/12
13 Jan 2014

I don't think any of them would work here.
TDCH has more features than Sqoop.

You must sign in to leave a comment.