Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
8 subscribers
Views
1757 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Encrypting data for encrypted text fields
Richard
over 7 years ago
We have a new application in Appian that is replacing a legacy application in a fairly closed environment. Because of the nature of our shared tenancy Appian environment the new application uses Encrypted Text fields for some of the sensitive data, and persists the data as encrypted text. There is however, a significant amount of legacy data that we wish to import, is there a method or best practice around encrypting those fields in the legacy data?
OriginalPostID-233829
Discussion posts and replies are publicly visible
0
siddharthg837
over 7 years ago
Hi Richard
One way of achieving this is following:
1. As a first step dump all your legacy data in the new system database.
2. Have an utility process in place that will pull your data from the new system database (which you need to store them as encrypted) - this process will then encrypt your data using a!encryptedtext field component wrapped in a rule that will save your encrypted value in your inputs which you can then use them to store them in the database. (If you are on 16.2 you can use a!writetodatastore component directly to write the encrypted text to respective tables in database- else you would need to take the encrypted values in your utility process and then write to database).
Ideally you can have one interface for every table you wa to write to make sure all your encryption are done.
Hope this helps !
Cancel
Vote Up
-1
Vote Down
Sign in to reply
Verify Answer
Cancel