erwin Data Transformation 9.2.6 - Installation Guide

Data Folder

Data Folder

Users may also change the default Data Folder path. Please, before moving an existing data folder, backup your erwin DT database: <DataFolder>/data/H2/CC.h2.db

On the first installation, users can migrate an old data folder if migrating from CC 6.0.1 or below with the button Migrate Data Folder. Select a valid DT data folder and choose “Yes, migrate” will copy all DT data to the new installation folder

Database

Database

The database tab allows the users to choose between a local H2 database or a remote H2 database to be used by erwin DT.

If installing with a local database, you’ll be allowed to choose between two options:

Database does not already exist (for a new installation)

Database already exists (for an upgrade from a previous version or when reconfiguring). In this case you can chose between maintain existing data or not.

See Appendix A for H2 remote installation.

1.Database Encryption

For local H2 databases, the H2 database file can optionally be encrypted. By default, no file encryption is used. Futher information on H2 database file encryption can be found at https://www.h2database.com/html/main.html

Supported stores for the encryption key include the erwin Data Transformation properties file, or the Microsoft Azure Key Vault.

Key Stores

Key Stores

Properties File

When using the Properties File, the only value required is the file encyption key to be used. This key will be stored encypted in the erwinDataTransformation.properties file in the erwin DT install directory.

Azure Key Value

When using the Azure Key Vault, the user must provide the url of the Key Vault to be used, the name of the key to be used, and the credentials of a client that has access to the required key. Note that the credentials will be stored encypted in the erwinDataTransformation.properties file in the erwin DT install directory.

Encrypting Database File

Encrypting Database File

To encrypt a previously unencrypted database file, select the key store and provide the required credentials.