About EasyMorph Tutorials & Examples Web-help

Encrypted column in SQL

Hi, I’m trying to create a generic project that it is going to decrypt different pgp files. I’m planning to create a configuration table in the sql server, but the passphrase would be encrypted. But I saw that EM doesn’t support encrypted column. What would be the best approach for my project?


Hi @rkawana,

You can try to use the “Custom SQL” mode of the “Database command” action to insert values to an encrypted column. It supports multiple SQL statements. Similarly, you can use the “Custom SQL” mode of the “Import from database” action to open the key and then decrypt and import encrypted values.

I didn’t test this approach, but it worth a try.

To learn more about EasyMorph visit easymorph.com.