Talend community forum / User management in Talend

chesofai · 2012-06-12 11:12:42

Hi the community,

I want to deploy Talend as an ETL , i have already did the jobs for the processing. but my problem is that i want to manage users in Talend.

I want to secure it by forcing a user to connect to Talend(login+password) first before launching the JOB.

Is it possible? or is there another way to secure my jobs ?

thank you in advance

pedro · 2012-06-12 11:14:55

Hi

Sorry. For the user management feature, it's only supported by Talend Enterprise version.

Regards,
Pedro

chesofai · 2012-06-12 11:35:48

Thank you Pedro, so there is no way to secure my jobs ?
Even using specific components?

pedro · 2012-06-12 11:44:51

Hi

You might use tMsgBox as workaround.
tMsgBox
|
Run-if
|
Subjobs

tMsgBox: You'd better select 'Question' for 'Buttons' option.

Regards,
Pedro

Uploaded Images

avdbrink · 2012-06-12 12:01:01

Hi,

Nice solution here Pedro.

I would suggest hasuhing the password prior to storing it in hte context and use the same hash function (MD5?) before the comparison inside the "If" statement, but this would mean you'd have to import some additional libraries. The password will be stored in plain text inside the job (and on the file system) otherwise.

Regards,
Arno

chesofai · 2012-06-12 12:13:41

thank you pedro,

As said avdbrink, the password here will be in clear text to the user that will clic on the components properties.
Now how can i hash the password to make it crypted ??

chesofai · 2012-06-12 12:16:41

Pedro,

So can u confirm my understanding of your solution?

- Textbox component
- run-if link
- tjava component
- link ???
- jobs

thank you

pedro · 2012-06-13 04:09:25

Hi

I'm using TOS 5.1.0 now. You will see an option called 'Mask Answer' on tMsgBox, which is able to change the clear text into ***.

- tjava component
- link ???
- jobs
Use 'OnSubjobOK' here.

Regards,
Pedro

avdbrink · 2012-06-13 07:57:20

Hi,

Sure, using the "Mask Answer" option in the MsgBox will hide the password rfmo the user when entering, but when the user just opens the job and clicks the If condition row he/she will see the password.

I've used an MD5 library to hash values before. Found it on Talend exchange: http://www.talendforge.org/exchange/tos … hp?eid=137

You can than use a function like this:

Code:

MD5.getHashString("MyPassword");

First use this code in a dummy tJava to print it to the console (using System.out.print) then copy paste the hash value in the If condition.

Hope this helps.

Regards,
Arno

pedro · 2012-06-13 09:15:43

Hi Arno

Great! Thanks for your perfect solution.

Regards,
Pedro

chesofai · 2012-06-13 13:07:08

Hi avdbrink,

I followed your process and calculated the hashvalue 1st using a dummy java: it gave me "dc647eb65e6711e155375218212b3964" for "Password".

Then what is the process after? because when i tried to paste this hash value in the equals() funtion is gave me error

thank you

avdbrink · 2012-06-13 13:21:15

Hi,

You could use somthing like this for your If statement:

Code:

((String)globalMap.get("tMsgBox_1_RESULT")).equals("dc647eb65e6711e155375218212b3964")

What error did you get?

Regards,
Arno

chesofai · 2012-06-13 15:14:19

Hi arno,

I did as u said and when i execute the "IF" statement still false despite i am typing the right password as hashed by the MD5 function.

regards

avdbrink · 2012-06-13 16:09:38

Hi,

I'm very sorry, I wasn't paying attention.

The correct code should be:

Code:

MD5.getHashString((String)globalMap.get("tMsgBox_1_RESULT")).equals("dc647eb65e6711e155375218212b3964")

In the previous code the entered password will not be crypted and thus won't match the crypted version.

Regards,
Arno

chesofai · 2012-06-13 16:34:36

Super, Arno its working !

One more thing, is it possible to have more than 1 condition is IF link(case when there is more than 1 password) ?

The purpose is to have more than 1 user executing the job, so is it possible to have many passwords ? If yes how can i implement it?

Regards

avdbrink · 2012-06-13 16:45:55

Hi,

You could use a structure like this:

Code:

MD5.getHashString((String)globalMap.get("tMsgBox_1_RESULT")).equals("hash_of_1st_password") || MD5.getHashString((String)globalMap.get("tMsgBox_1_RESULT")).equals("hash_of_2nd_password") || MD5.getHashString((String)globalMap.get("tMsgBox_1_RESULT")).equals("hash_of_3rd_password")

and so on...

Another option would be to use some more extended functionality where you could use some database lookup to perform the check if the user entered a correct password, but that would be a completely different approach.

Regards,
Arno

Announcement

Unanswered posts

#1 2012-06-12 11:12:42

User management in Talend

#2 2012-06-12 11:14:55

Re: User management in Talend

#3 2012-06-12 11:35:48

Re: User management in Talend

#4 2012-06-12 11:44:51

Re: User management in Talend

#5 2012-06-12 12:01:01

Re: User management in Talend

#6 2012-06-12 12:13:41

Re: User management in Talend

#7 2012-06-12 12:16:41

Re: User management in Talend

#8 2012-06-13 04:09:25

Re: User management in Talend

#9 2012-06-13 07:57:20

Re: User management in Talend

Code:

#10 2012-06-13 09:15:43

Re: User management in Talend

#11 2012-06-13 13:07:08

Re: User management in Talend

#12 2012-06-13 13:21:15

Re: User management in Talend

Code:

#13 2012-06-13 15:14:19

Re: User management in Talend

#14 2012-06-13 16:09:38

Re: User management in Talend

Code:

#15 2012-06-13 16:34:36

Re: User management in Talend

#16 2012-06-13 16:45:55

Re: User management in Talend

Code:

Board footer