File Encryption And Decryption In Information Cloud

Description

The purpose is to securely transfer the data from source flat file to the target database by performing the encryption and decryption. Our source flat file is an on-premise file. Before loading the data into the target database, the source flat file is encrypted and decrypted using the file processor connector. For performing the encryption and decryption we need to generate the keys using the third party tool. We need to generate the notifications after loading the data into the database.

Step 1:

Select the administrator module and install the connectors. Here we are installing the File Processor connector to perform encrypt process on a file.

Step 2:

Now create file processor connections for encryption and decrption

Step 3:

Create the flat file connections for storing the encrypted and decrypted files

Step 4:

Now generate public key and private key in https://pgpkeygen.com/ website. The passphrase key here should be same as the passkey, given while creating the connections for encryption and decryption.

Step 5:

Now select the Data Integration module and create a new mapping to perform the encryption of a source file.
Click on source and set conncetion details and Query options and set Object to file-encrypt.

Click on target and set target connection to flat file connection

After creating the mappings Run the job from my jobs

After executing the job the encrypted file is created in the specified location .
Below is the output encrypted file

A file is created with the details of file encryption process

Step 6:

Create a new mapping to perform the dencryption of a source file.

Click on source and set source properties.

Step 7:

Click on target and set target connection to flat file connection

Below is the output for decrypted file