Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

Encrypting Sensitive Data within Workflow Solution

Created: 26 Apr 2010 • Updated: 08 May 2011 | 5 comments
ChrisBern's picture
0 0 Votes
Login to vote
Symantec single video player.

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

Comments 5 CommentsJump to latest comment

QuietLeni's picture

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?

What is the point of an Asset Management Solution that needs excessive management? Let me help you.

0
Login to vote
ChrisBern's picture

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

+1
Login to vote
thawk's picture

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.

0
Login to vote
ChrisBern's picture

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.

0
Login to vote
thawk's picture

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.

0
Login to vote