Encrypt
Encrypt or decrypt text in the source field using a password taken from a field, a given value, or from an expression.
- decrypt - Decrypt text using the specified password.
- encrypt - Encrypt text using the specified password.
The transform utilizes a simple AES256 based encryption mechanism. The key is first hashed using 128-bit SHA and then the hash is used to encrypt the data.
Launch the template by choosing a text field and then double-clicking the Encrypt template. When the template launches we can specify options.
Encrypt : decrypt
Decrypt text that has been encrypted using Encrypt using the specified password.
We use a table with two nvarchar text fields. The Encrypted Text field contains text that has been encrypted using Encrypt : encrypt. We will decrypt the text the Encrypted Text field and place the result in the Decrypted Text field.
With the focus on the table, in the Transform pane we choose the Encrypted Text field, and then we double-click the Encrypt template to launch it.
In the Encrypt template we choose decrypt as the Operation option. We enter manifold as the Password, since we know that password was used to encrypt the text.
For the Result destination, the pull down menu offers us a choice of any existing field in the table, the same field, or a new field. We choose the existing Decrypted Text field.
Press Transform.
The Decrypted Text field is instantly populated with text from the Encrypted Text field that has been decrypted using the specified password.
If we attempt to decrypt using the wrong password, the result is all NULLs. Therefore, it is a good idea when decrypting text to place the results into some other field, and not to place the results into the Same Field, in case of a typo in the password.
Encrypt : encrypt
Encrypt text using the specified password.
We use a table with two nvarchar text fields. We will encrypt the text in the Description field and place the result in the Encrypted Text field.
With the focus on the table, in the Transform pane we choose the Description field, and then we double-click the Encrypt template to launch it.
In the Encrypt template we choose encrypt as the Operation option. We can choose whatever password we want. For this example, we enter manifold as the Password.
For the Result destination, the pull down menu offers us a choice of any existing field in the table, the same field, or a new field. We choose the existing Encrypted Text field.
Press Transform.
The Encrypted Text field is instantly populated with text from the Description field that has been encrypted using the specified password.
Manifold utilizes a simple AES256 based encryption mechanism. The password is first hashed using 128-bit SHA and then the hash is used to encrypt the data. Do not use the example password of manifold or an easily-guessed password such as 12345.