You'll need to navigate to the Integration - Connections page. 

The Manage Database Connections page is rendered below. 

Click the Connections to navigate to the oAuth, RabbitMQ, FTP, and SFTP connections page.   

Create DB Connection. 

You must click the Actions - Create menu option. 

A popup window is displayed for configuration. Provide the DB Connection name. Select the connection type (SQLClient, OLEDB, MongoDB) from the drop-down list. Switch OFF the connection string builder. Provide the connection string as below.    

Click the Test button. A confirmation message is displayed for a valid connection string in the top right-end corner. 

Click the Create button. The DB Connection name is created successfully. 

Edit DB Connection. 

Select the connection item from the table and click the Actions - Edit menu option. 

A popup window is displayed for modification. Make the necessary changes and click the Test button to validate the connection. A confirmation message is displayed in the top right-end corner. 

Click the Update button to confirm the changes. A confirmation message is displayed in the top right-end corner. 

Test DB Connection. 

Select the connection item from the table and click the Actions - Test menu option.

The connection string is validated, and a confirmation message is displayed in the top right-end corner. 

Remove a DB Connection. 

Select the connection item from the table and click the Actions - Remove menu option.

A popup window is displayed for confirmation. Click OK to proceed. 

The database connection is removed permanently, and a confirmation message is displayed in the top right-end corner. 

Database details

Use this feature to view the database tables and their table structure. The table lists the connection names, as shown in the UI below.

On the Manage Database Connections page, select the DB connection from the table and click on the Utils—DB Details menu option.   

The table names belonging to the selected connection database are listed in the left pane. Click on the table to view the column names and information on the data type.  

Update Report Connection configuration

The config.file (on the application root folder) contains all connection strings used by the UI and the engines. 

On the Manage Database Connections page, select Utils - Update Report Connections to update all the stored connections in this configuration file. 

A confirmation message is displayed in the top right-end corner.