How To Apply MD5 Encryption to an Oracle Source Column

Question

How can I apply MD5 encryption to a column in my Oracle source database and load data to a target?

Environment

• HVR 6
• Capture
• Source: Oracle

Answer

Define action ColumnProperties with the following parameters and values in the channel:

• Name: The name of the column in the source.
• CaptureExpression: Use the following expression:

  • CASE  
      WHEN {{hvr_col_name}} IS null THEN Null
      ELSE rawtohex(DBMS_OBFUSCATION_TOOLKIT.MD5 (INPUT => UTL_RAW.CAST_TO_RAW ({{hvr_col_name}})))
    END
    

• CaptureExpressionType=SQL_WHERE_ROW

After defining the above action, activate the channel with the Jobs option selected and monitor the results.