| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Encryption in ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| vanshulchawla_target |
 Posted: Tue Jun 01, 2010 3:42 am Post subject: Encryption in ESQL |
 |
|
Apprentice
Joined: 19 May 2010
Posts: 25
|
Hi,
I need to encrypt a user name and password in my flow.
Can we use ESQL for this or is there any existing algorithm we can use to encrypt it? |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Jun 01, 2010 4:30 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Are you sure you need to do this in your flow?
Are you sure you can't use security profiles to handle this for you?
Are you sure you really mean "encrypt" and not "encode" or "obfuscate"?
Have you reviewed the presupplied functions available with ESQL? Have you reviewed the mechanisms in ESQL to invoke functions available in other languages? have you determined that ESQL is the correct choice to perform this function in the first place? |
|
| Back to top |
|
|
| vanshulchawla_target |
| Posted: Wed Jun 02, 2010 7:18 am Post subject: |
|
|
Apprentice
Joined: 19 May 2010
Posts: 25
|
I can use java functions also.I searched at many sites but couldnt find static methods taking string as input and returning string.
I need to encrypt the username and password,store that in DB and in next flow, select the stuff from db and decrypt it.
Can you please provide me any code which can help....
Thanks |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Jun 02, 2010 7:59 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| vanshulchawla_target wrote: |
I can use java functions also.I searched at many sites but couldnt find static methods taking string as input and returning string.
I need to encrypt the username and password,store that in DB and in next flow, select the stuff from db and decrypt it.
Can you please provide me any code which can help....
Thanks |
You should probably look at Database encryption for this.
The DB will need a private/public key pair and if instructed correctly will do the encryption/decryption of the fields for you.
Talk to your DBA's about knowing how this works with different authorization/user profiles.
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
