This video demonstrates using 1024-bit RSA encryption to encrypt and decrypt sensitive data from a Workflow project. The sample project that corresponds with the video is attached below--simply double click on the .package file to import it into your Workflow environment. Please Note: This video is best viewed in full screen mode by clicking on the square icon in the lower right hand corner of the media player.
Keywords - Encrypt, decrypt, RSA, encryption.dll, Import Components, hash, PGP, DES, generate key, form builder, GenerateRSAKeyComponent, EncryptionKeyPair, Private Key, Public Key, EncryptStringAsymetricalComponent, DecryptStringAsymetricalComponent, ListBox, byte array, browse data, debugger
00:09:42
00:04:10
Excellent, I am in the process of doing just that. I am running into some issues but they seem to be my own problems. I also added a usage column kind of a "Name" field so you can understand where the keys came from.
As I recall, the keys are also byte arrays. So you should be able to store a key in a database field as a varbinary(max). And thenb Then when you retrieve Then when you retrieve the key back into Workflow through a database read, it should come back in as a byte array. Just take extra care to have the database table secure, for obvious reasons.
If you put the data into a database. Is there a way to store your keys so you can retrieve data from a database row at any time not just when you are in the session.
Hi QuietLeni,
I did a test and was able to store the encrypted byte array In SQL Server. Basically, in your database field, you can use the datatype varbinary(MAX). Then from a Workflow database generator, you can directly read and write the byte array from that type of field. For example to write the byte array, I just did a single mapping directly from the byte array to that field. Then when you read it back, it comes back as a byte array again.
Let me know if you have any questions on this...
-Chris
Chris,
Thanks for this excellent video. Just one thing, what kind of data type do I need to use to store the encrypted byte array within SQL Server in this case?