KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Working with an Encrypted Database
PRODUCT: 4D | VERSION: 18 | PLATFORM: Mac & Win
Published On: January 18, 2021

4D allows datafiles to be encrypted with a passphrase and key. If the database is being developed on is encrypted and the credentials to the datafile is not provided, the data will get masked and it will be difficult to test out the operations interacting with encrypted tables. However, there is still a way to test processes using encrypted tables.

First a new data file must be created or the tables of interest must be truncated. Then in the structure editor the encryptable property can be disabled. This will set the status of the table to be unencrypted and because there are no records there is not a need to decrypt anything. This will allow the developer to test the operations using the table and view newly created records.

When the update is returned, the encryptable status should be enabled again.