We have a security requirement to keep confidential information encrypted in all new systems.
The legacy source DB2 has a column with the confidential data. It is not encrypted due its legacy nature. But it must be encrypted in all new systems. As we are working on replicating this table using Qlik Replicate we'd like to have a transformation function that will allow us apply AES256 encryption for this column during replication transformation. The volume of changes in this table is relatively low and performance is not a significant concern.
There are a few option to extend SQLite to support encryption https://stackoverflow.com/questions/5669905/sqlite-with-encryption-password-protection and add it to Replicate as UDF. But we don't have capacity to build and support it in our team.