Announcement

Collapse
No announcement yet.

MySQL with AES_DECRYPT in DB reader

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL with AES_DECRYPT in DB reader

    Hi,

    I am using MySQL to store the transformed HL7 XML message. Since the messages we plan to capture are production data, we need to encrypt them. Thus, I need to use AES_DECRYPT function to decode the encrypted messages.

    The problem is the SQL statement in the DB reader of the channel.

    Only msgid show up as variable; not HL7XML. Please advise the possible solution for this.

    SELECT msgid,AES_DECRYPT(HL7XML,'123&#039 FROM inbound where sendstatus = 'N' and interface = 'Affinity' and buildnum = '111' order by msgid limit 1;

    Thank you very much,

    Charles

  • #2
    Re: MySQL with AES_DECRYPT in DB reader


    SELECT msgid,AES_DECRYPT(HL7XML,'123&#039 as HL7XML FROM inbound where sendstatus = 'N' and interface = 'Affinity' and buildnum = '111' order by msgid limit 1;

    Comment

    Working...
    X