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...
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
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
Menu
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.