Database
On a database, and depending on the target DBMS, control parameters of the various data processing tools (synchronization, generation, reverse generation etc.) will be defined.
Creating Databases
A database enables specification of data physical storage structure.
To create a database in HOPEX Data Governance:
1. Click the Architecture > Databases navigation menu.
In HOPEX Data Architecture, click the Databases navigation menu.2. Right-click the databases folder and click New > Database.
3. Enter the name of the database.
4. Click OK.
The database created appears in the list of databases.
When a database is created, the ANSI/ISO 9075:1992 SQL DBMS is associated with it by default.Database Properties
To access the properties of a database:
1. Select the database and click the Properties 
button.
button. The properties window of the database appears.
2. Click on the drop-down list to access the different properties pages.
Properties pages are used to:
• Access the Components of the database (tables, physical views, data groups, etc.).
• Modify the Characteristics of the database (name, target DBMS, etc.).
• Define Responsibilities.
• Define the Risks associated, the Standards used, the Objectives and Requirements.
• To define the Options linked to:
• the generation of tables. See Configuring Database Generation.
• synchronization. See Configuring Synchronization.
Associating a Package with a Database
You can create a data package from the database or connect an existing package to it. The package enables representation of the structure of the database, the classes it contains and their parts.
The database package is the default owner of the objects represented in the class diagram. However it is possible to use objects held in other packages.
In the same way, you can connect a data model to a database, if the corresponding formalism has been selected. See Formalisms.To create a package from a database:
1. Right-click the database and click New > Package.
2. Enter the name of th package.
3. Click OK.
To connect an package to a database:
1. Right-click the database and click Connect > Package.
The query dialog box appears.
2. Click Find.
3. Select the desired package and click Connect.
You can see the name of the packages associated with a database in the database properties, in the Characteristics page.
Importing a DBMS Version
When you create a new repository, you are provided with different DBMS and versions by default, except for the latest versions, such as "Oracle 18c" and "Oracle 19c. You can download these versions and their datatypes from the HOPEX Store.
When a database is created, the default SQL DBMS is ANSI/ISO 9075:1992. You can choose another target DBMS in its properties pages.
DBMS datatypes are not supplied by default. To view the datatypes of a DBMS in the HOPEX repository, you need to import the corresponding module, whose name takes the form "Database Design XXX" with the DBMS name. Modules are available in the HOPEX Store.
For more information on importing a module, see Importing a Module into HOPEX.See also Configuring Synchronization.