Create and import Aeneis database

You can create a new database in the ServerAdministration in the Databases section. You can also manage your current one there:

Instruction:

1. Open the Aeneis ServerAdministration in one of the following ways:

   • Via the created desktop shortcut

   • In the browser via the following link: http://servername.domain.de:Port/admin/index.zul

2. Log in to the ServerAdministration

3. Open the Databases section

4. If you already have an Aeneis database as a raw data export (aeneis6db or aeneis7db), you can upload it as a template for a new database in the Raw data exports tab

5. In the Databases tab, click the Create new database button:

   

2. Set the following settings in the Create Database dialog:

   

   Property	Description
   Database schema	Select here the database management system on which the database will be created. Depending on the selected system, the following properties and options are displayed or hidden.
   ID	Enter the ID of the database with which it is stored and uniquely identifiable.
   Description	Enter the name of the Aeneis database.
   Database administrator password	Set the administrator password here. If you import an existing database (raw data export), the administrator password set here overwrites that of the imported database. (See also Use a raw data import as template). You can change the administrator password later in the Databases section. See also: Chapter Password Policy & Encryption.
   Username	SQL user name for logging in and accessing the SQL database.
   Password	Password/password of the SQL user (see user name).
   Host	Computer on which the database is running. If the database is located on a server, enter the server name here. Enable the Search free port option to have Aeneis automatically search for a free port each time it is started. If you are using a fixed port, uncheck the Search free port option and enter the port under Port.
   Port	If you have disabled the Search free port option, enter the port of the database here.
   Use SSL	Enable this option to use SSL certificates for the connection to the database.
   Database name	Enter the name of the database with which the Aeneis database was created in the DBMS. If you enable the Service name syntax option, the specified database name will be interpreted as a service and the internal connection string to the database will be built accordingly. By default, the option is disabled and the name of the database is interpreted as a so-called SID.
   Additional URL parameters	Enter parameters here that specify certain properties for the database connection. For example, you can include the instance name of the database if the database has different instances.
   Authentication mode	Select the system for authentication to the database. DATABASE LDAP LDAP_DATABASE KERBEROS PROXY
   Pool size	Enter the number of connections for the connection pool here. (Default: 50)
   LDAP server	Select the LDAP server for authentication to the database via LDAP here. See also: For more information, see Add LDAP server.
   Template	Select the template for the database here. Here you can choose whether to create an empty database, a database with sample content, or one that was previously uploaded as a raw data import (see chapter Use a raw data import as template).
   Delete all data if tables exist	If you enable this option, all existing data and tables that already exist in the database will be deleted and new tables will be created from the selected template.
   Change history (Audit trail)	If you enable this option, all changes in the database will be logged via audit trail.
   Secure history	Enabling this option ensures that the database history is secured against changes that take place at the SQL level. See also: Chapter Secured history.
   Notification	If you enable this option, appropriate users will be notified when changes are made to the database. See also: Chapter Change notifications.

3. Click the Test connection button to test the connection to the DBMS and the database with the set settings

4. Click the OK button to create the database

Result:

The new database is created with the set settings and is listed in the Databases section of the ServerAdministration.