Manage Data Privacy Repositories

The default repository is created using a Derby database. This is only intended as a sample repository. We strongly recommend that you create a repository on a database server. You can define additional rules repositories on the database of your choice including Derby, Microsoft SQL Server, Sybase, Oracle, or Db2. To create a new repository, you need to be assigned the BMC Compuware Data Privacy Global Resource Admin role or the BMC Compuware Data Privacy Admin role.

When a new repository is added to File-AID Services, the tables required for a rules repository are created in the selected DBMS. When defining the repository, a user ID and password are requested and are subject to normal database authentication during creation and access. In addition, a user must have table create permission to define a repository.

Important

  • When creating a Sybase repository, a 16K minimum page size is required by the Sybase server, and a minimum of 50 MB should be allocated for the database.
  • For Db2, a minimum page size of 8K is required for the tablespace in which repository tables are created.

For more information on adding, editing, connecting/disconnecting, and migrating Data Privacy repositories, see Working with Repositories.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*