Dashboard Designer - Datasource

book

Article ID: 207313

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

We have imported our existing dashboards from an old instance to a fresh UIM 20.3 (OC 20.3.2) instance so the database/datasource connections are changed.

Since we are unable to edit an existing datasource connection inside Dashboard designer, we tried creating a new one with the new DB instance details but get the below error. 

------------------------------------------------------------------------------------------------------------------------------

"could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Login failed for user)"

------------------------------------------------------------------------------------------------------------------------------

I think this could be something to do with how the driver class or JDBC URL are entered.

Database connection :

Name           : DXIM
Driver Class : com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL   : jdbc:sqlserver://DECDC01PWSQL010:1433;databaseName=DXInfrastructureManager
User             : domain\username

Could you please check and let us know if they is something that is not set in the right format/method.

Environment

Release : 20.3

Component : UIM - UMP_DASHBOARD

Resolution

Customer was able to connect to the default nis connection listed in the dashboard designer.