Can the data_engine use a different port for the database connection

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

We would like to use a port other than the default database port for our database service connection. Can this be done?

Environment

• Version: Any
• Component: data_engine, any version

Cause

• Guidance

Resolution

Yes. The port can be different than the database server default port.

The port used in the data_engine to connect to the database can be different than the specific database server default port which is:

1433 for MS SQL Server

1521 for Oracle

3306 for MySQL

This would be changed in the data_engine configuration GUI or Raw configure on the Data Source line of the Database tab, with a comma after the ip address, e.g., 

Data source-> <ipaddress>, <custom_port#>

Additional Information

The customer will have to change the default port to use a custom port for MS SQL Server.
Configure SQL Server to listen on a specific TCP port