Steps to create encryption job:
1. Create a new Job as well as Dataflow where you can extract your data.
Source Data:
2. In the Qry_Encrypt Transform you can define encrypt_aes function which is described as:
In our example, we are encrypting EMP_SALARY column (usually it is confidential), for this we are passing following values in the Arguments:
input_string - EMP_SALARY
passphrase - $G_Passphrase (Global Variable)
key_length_in_bits - $G_AESKey (Global Variable)
Global Variables are declared at Job Level by passing constants value in them. (For more Security we can directly take Passphrase and AES Key from Database Table rather than Hardcoding it in the job)
Output Data:
Steps to create enrichment job:
1. Now encryption of data is done, we may also have some Business Rules to implement. For that we can proceed with different dataflow in same job or we can go for different job and dataflow which we did in this Demo.
2. Here we are applying some Business Rules in Qry_Enrich like : If EMP_COUNTRY is “IN” then make it “India”,if “US” then make it “United States” and so on:
Output Data:
Steps to create decryption job:
1. This is the Final Job of Demo, where we are decrypting the encrypted data (done in the first job) with the same Passphrase and AES Key.
2. In the Qry_Decrypt Transform you can define decrypt_aes function which is described as:
In our example, we are decrypting EMP_SALARY column , for this we are passing following values in the Arguments:
input_string - EMP_SALARY
passphrase - $G_Passphrase (Global Variable)
key_length_in_bits - $G_AESKey (Global Variable)
Since for decryption we have to use same Passphrase and AES Key, thus we are using same global variables which will be declared in this job too with same hardcoded values.
Output Data:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |