Introduction into User Management

Introduction into User Management

Xplain Data utilizes an interface that might be used to embed user management into your existing user management infrastructure, e.g. by using LDAP or OAuth.

In order to get started quickly with the first tests with the Object Explorer, it is delivered with a ready-made implementation of this interface. This implementation offers you some basic features to manage your Object Explorer users. Keep in mind, that – at any time – you can extend this simple approach with a more sophisticated one.

You can access this implementation via your command line / terminal. This tool enables to list, add and delete users via the following commands:

java -jar usertool.jar

This command lists all users in your user database.

java -jar usertool -d <user>

Deletes a given user. <user> has to be replaced with the corresponding user name.

java -jar usertool -u <username> -p <password>

Inserts a new user.

Attention!

This simple, out-of-the-box user management implementation is supplied without any claim to completeness or further safety aspects. You should only use it to perform initial tests with Xplain Data without much installation effort.

We strongly recommend replacing the SQLite database used in this simple implementation with a relational database of your choice (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, …).

Please proceed as follows to achieve this: create a file named application.properties in the root directory of your application and edit it with any text editor.

Enter the following lines:

spring.datasource.url=<your JDBC connect string>

spring.datasource.username=<your username>

spring.datasource.password=<your password>

spring.datasource.driver-class-name=<JDBC driver name>

For instance, this file could look as follows:

spring.datasource.url=jdbc:mysql://localhost:3306/ourDbServer?useSSL=false

spring.datasource.username=xplainUser

spring.datasource.password=Hoe12+IoA$12jQyoP

spring.datasource.driver-class-name=com.mysql.jdbc.Driver