Existing Database Settings

This section explains how to configure Database Settings with the Syncfusion Report Server.

Get Database Connection Details

To import users into Syncfusion Report Server from Existing Database configure the existing database details in database settings page in the administration page of Syncfusion Report Server.

Import Users from Database - Home

Users can be imported from below types of Databases.

  1. SQL Server
  2. MySQL
  3. Oracle
  4. PostgreSQL

To select the database type from which the users to be imported, click on Database type dropdown.

Select Database Type

SQL Server Database

For SQL Server Database, fill the form with Server name, Authentication type, Username, Password and Database name.

The connection details can be tested by click on ‘Test Connection’

Connect SQL Server Database

MySQL Database

For MySQL Database, fill the form with DSN, Username, Password and Database name.

The connection details can be tested by click on ‘Test Connection’

Connect MySQL Database

Oracle Database

For Oracle Database, fill the form with DSN, Admin username, Admin password, Database name and Database password.

The connection details can be tested by click on ‘Test Connection’

Connect Oracle Database

PostgreSQL Database

For PostgreSQL Database, fill the form with Server name, Port, Username, Password and Database name.

The connection details can be tested by click on ‘Test Connection’

Connect PostgreSQL Database

Once the connection details are filled, click on ‘Next’ for getting schema of the provided database connection.

Connect Database

Map Database Columns

The page will look like below once the database has been connected.

Select Column

Select the matched columns from the database schema for Username, First name, Email address, Last name(Optional) and IsActive (Optional) fields.

Match Database Column

If the columns are selected from different tables, below 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 on Apply

Select Table Relation

  • If there is no relationship between tables - Form Join with the selected tables and then click on Apply

Form Table Relation

After selection of all columns, click on Save to save the database details. Based on this saved details it will pull the users from the configured Database.

Saving database details

Successful saving

Also included the Back button in the settings page to edit the database details before complete mapping and saving the database configuration.