Database settings

You should configure the database settings in the Report Server to import users and groups from an existing database.

Configure database connection details

1. To configure the database connection details, click the settings option in the Report Server left-side panel.
2. Navigate to the User Directory tab and select Database as shown in the following image.

3. You can import users from the following types of databases:

   • SQL Server
   • MySQL
   • PostgreSQL
4. Click database type drop-down to change the database type.

SQL Server database

1. Fill the SQL connection details such as server name, authentication type, username, password, and database name.
2. Click Test Connection to validate the connection details.

MySQL database

1. Fill the MySQL connection details such as DSN, username, password, and database name.
2. Click Test Connection to validate the connection details.

PostgreSQL database

1. Fill the PostgreSQL connection details such as server name, port, username, password, and database name.
2. Click Test Connection to validate the connection details.

Map database columns

1. After the connection details are filled, click Next to get schema of the provided database connection.
2. The data page will be as follows, after the database has been connected.
3. Select the matched columns from the database schema for username, first name, email address, last name (optional), and IsActive (Optional) fields.

4. If the columns are selected from different tables, the following scenarios will happen:

   • If the tables have single relationship - The join will be made with the particular relationship.
   • If the tables have multiple relationships - The relationship can be selected from the list of relationships and then click Apply.
   • If there is no relationship between tables - Form Join with the selected tables and then click Apply.
5. After selecting all the columns, click Save to save the database details. Based on this saved details, it will pull the users from the configured database.
6. After the changes are completed, the success message will be displayed as shown in the image.
7. Use the Back button in the settings page to edit the database details before mapping and saving the database configuration.