Encrypt column
Description
This activity reads the data and encrypts the columns specified by the user in the user-defined modes. The encryption can be either one-way or two-way, depending on the configuration.
Input
Data Only
Output
Transformed Data
Configuration Fields
- Encryption type Specifies the type of encryption, either one-way or two-way.
- Algorithm Defines the algorithm for one-way encryption (enabled only when encryption type is one-way).
- Column names Specifies the names of the columns to encrypt.
- Password The encryption key for symmetric encryption (enabled only when encryption type is two-way).
Sample Input 1
| h1 | h2 | h3 |
|---|---|---|
| data1 | value1 | info1 |
| data2 | value2 | info2 |
| data3 | value3 | info3 |
Sample Configuration
Sample Output 2 (as per the configuration)
| h1 | h2 | h3 |
|---|---|---|
| 3b9d9b8d-6d93-4648-b33a-2c6f773789a7 | 9b1b5c9a-bc5e-4a99-b38d-d9c34cf7cfd6 | info1 |
| 33d3bff6-e469-46f7-9d7c-4bc12d5d59a1 | 7b77f40b-9375-479d-bdf7-dcc95f07b99c | info2 |
| b3c3e828-2cb7-4de9-bf1c-62aef6fffa97 | 6729f1d8-3781-4315-8fe1-8b042708f25e | info3 |
Sample Input 2
| h1 | h2 | h3 |
|---|---|---|
| data1 | value1 | info1 |
| data2 | value2 | info2 |
| data3 | value3 | info3 |
Sample Output 2 (Encrypted using SHA)(one-way)
| h1 | h2 | h3 |
|---|---|---|
| 6d97a6b8b9899b0a59b6e85b993b22a8ac94608 | e59b4d1a83149cdad8379a35de8f4a4a853a4cc8 | info1 |
| f62b083e8f63d69a91e16f0db11b19589f2fcf1 | 548f56b831617f4f8df5e705b2b76e8d8c4b03b9 | info2 |
| f78c6d99b6e04d0c5397423fb4cd58f79f228d2 | 2d72c30ecedc493139de2bc57290ed40f763ada | info3 |