Administration

Features

• Initial server configuration
• Connection management
• User management
• Server configuration

Overview

Initial server configuration

The first time you run the application, the application will require an initial configuration. On the initial configuration you will need to configure some things:

1. Server configuration - base application settings such as: administrator account, server info and base application behavior

   

2. Database connections - in that step you can add some common connections for yours databases

   

   The application will try to find databases on the host machine, so you can simply add existing databases or enter hosts to search in (hosts can be divided by spaces or comma):

   

   

Entering administration page

After the initial server configuration, you can login as an administrator:

• If the authentication is enabled: Settings (top right corner, the cog icon) > login

• Another option is to enter /#/admin page

  

After successful authentication with the administrator account, you can enter Administration page:

• via settings Settings (top right corner, the cog icon) > Administration
• Directly go to /#/admin page

Connection management

On the administration page, select the Connection Management tab. On the Connection Management tab you can create or delete connections, and configure connections (connection settings, users access).

1. Connection list

   

2. Connection creation

   Click on the Add icon on the tools bar to open the connection creation wizard:

   

   The connection can be created from the database driver or from databases searched in the entered hosts (hosts can be divided by spaces or comma).

   Before adding a connection you can test the connection. For that, you should fill in the authentication parameters (if needed). If the Template is checked, then users can add that connection from Connection > From Template otherwise the connection will be presented in the navigation tree if the user has access to that connection (directly or by role). Connection access can be configured on the connection Access tab.

   The connection authentication parameters can be filled in by the administrator and saved for all users, so they do not need to enter the connection credentials.

3. Connection edit

   The connection can be edited after creation. In the connections table click on the connection name or the angle icon.

4. Connection deletion

   The connection can be deleted. Select the connections in the table and click on the trash icon on the tools bar.

User management

On the administration page, select the Users tab. On the Users tab you can create or delete, and create or edit users.

1. User list

   

2. User creation

   Click on the Add icon on the tools bar to open the user creation form:

   

   You can set the user credentials and roles. You can also configure the connections access.

   Connection access can be provided via a user role, or directly.

3. User edit

   The user can be edited after the creation. In the users table, click on the user name or the angle icon.

4. User deletion

   The User can be deleted. Select the users in table and click on the trash icon on the tools bar.

Server configuration

On the administration page select the Server configuration tab. On the Server configuration tab you can edit the base application settings.