Manage Database Connections

Learn to manage DB connections.

Last published at: September 4th, 2025

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

 

The Manage Database Connections page is rendered below. 

 

Click the Actions menu to navigate to Create, Edit, Remove, Test, and Copy features. 

 

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 pop-up window is displayed for configuration. Provide the DB Connection name. Select the connection type (SQLClient, OLEDB, or 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 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 pop-up 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 corner. 

 

Click the Update button to confirm the changes. A confirmation message is displayed in the top-right 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 corner. 

 

 

Remove a DB Connection. 

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

 

A pop-up 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 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.

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

 

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

 

 

Update Report Connection configuration.

The config file (in 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 corner.