Tutorial

Training database

For the first steps we provide a training installation on:

training.diversityworkbench.de,5432

Please turn to the development team for a login.

Connect to a database

To access the database select from the menu. A dialog will open as shown below. If you have been connected to a database in previous sessions you can select on of these session with the option. Otherwise you can specify the name or IP-adress. For a test you can send a ping with a click on the button (see below).

Next enter the port numberĀ of the server and the authentication mode

  • Windows authentication: Using the Windows Login information.
  • SQL-Server authentication: User and password as defined in the database.

Ā Ā 

The standard port number for SQL-Server is 1433 and will be set as a default (see left image above). If the database server is configured using a port differentĀ from that port, youĀ must give the port number in the field Port (see left image above). If the connection informations are valid, you can choose a database from the server. In the main form you can select the databases thatĀ are available under Connection - Database... Video starten

If you access a database for the first time you will be asked to consent to the storage and processing of your personal data (see below) according to the General Data Protection Regulation. Without your consent the access is not possible.

Encryption

The connection to the databases by default is encrypted, symbolized by the icon. To change to an not encrypted connection, click on the icon which will change to accordingly, indicating a not encrypted connection.

Editing

The main forms of all modules have a design as shown below

Main form Main form

Status

In the status area you find

  • The name of the module,
  • The name of the database if different fron the module
  • The version of the software

The menu contains the options provided by the module

Commands

The commands area contains buttons for e.g. handling the data:

  • - To connect to a database click on the button.
  • - To save the changes in a dataset click on the button.
  • - To propagate the changes in a dataset to linked modules click on the button.
  • - To undo the changes a dataset click the button. This will recover the original data unless the changes had been saved or changes were done in certain tables or hierarchies were the data must be stored to display the hierarchy.
  • - To create a new entry in the database, click on theĀ  button below the search resultĀ listbox. This will create a entry with theĀ specimen and show it in the list.
  • - To copy a specimen, choose it from the list and click on the button .
  • - To options a dataset click on the button .
  • - To change the arrangement of the query click on the button.