Creating Databases and Encrypting Databases

To create a Progeny database

1. Launch the Progeny Desktop application using the Progeny 10 icon.
2. On the Login window, first, select Local Database and then click Create.
   • The Save As dialog box opens. The Save as Type field is automatically populated with the file type of database (.db) and you cannot change this value.
3. Browse to the location in which the database is to be saved, and then in the File name field, enter a name for the database.
4. Click Save.

To encrypt a Progeny database

5. In the next pop-up window, you have the option of encrypting your new database using either simple or strong encryption.
   • Simple Encryption: equivalent to Simple Obfuscation. Simple Obfuscation is intended to make it difficult, but not impossible, for someone using a disk utility to casually inspect the contents of your database. Simple Obfuscation does not require a key (password) to encode the database.
   • Strong Encryption: uses Advanced Encryption Standard (AES) method. Strong encryption makes a database unusable without a key (password). The data in the database is secure from inspection. An algorithm encrypts the information contained in your database and transaction log files so it cannot be read. The algorithm used to implement strong encryption is AES: a block encryption algorithm chosen as the new Advanced Encryption Standard for block ciphers by the National Institute of Standards and Technology (NIST). This encryption technology is included and does not require a separate license. Please remember that if you lose the encryption key you will not be able to unencrypt the contents of the database.
6. Click OK to create the database.
7. Once it completes the creation process you will receive a message letting you know it completed successfully. Click OK.

Please remember if you enable Strong Encryption with a key, you will need to enter the key value when configuring the Database Service. Please refer to the Progeny Application Installation article for more information on that topic.

Progeny also has the ability to enable Transport Layer Security (TLS) encryption on the database communication level. Sybase’s implementation of TLS secures communications between your Progeny database server and your Progeny clients. It enables encryption, tamper detection, and certificate-based authentication. It uses a combination of public-key and symmetric-key encryption for authentication and communication. Please refer to the Advanced Usage article for more information on this topic.