UIM Server on Linux support for MS SQL Server DB

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Can UIM Server be installed on Linux/UNIX and use Microsoft SQL Server? 

Is Primary Hub on Linux supports MS SQL Server DB? Does this work?
 

Environment

UIM: 20.x
DB: MS SQL 

Resolution

The answer is No. 
UIM Server on Linux can work with MySQL and Oracle.

UIM Server on Windows can use MS SQL, MySQL or Oracle.
 
The reason is that the data engine probe - which is the core component of UIM that stores the data produced by monitoring probes - in UIM database uses Microsoft OLE DB Provider for accessing SQL Server. The OLE DB provider for SQL Server is only supported by Windows operating systems.
 

Additional Information

UIM does not have any dependency on the Operating System where the database is installed on. With respect to database, the only requirement I see is that the database must be compatible with the Operating System on which UIM is running. For instance, if UIM is installed on Windows it can use MS SQL, MySQL or Oracle. If its running on *NIX, it can use MySQL and Oracle only. The Operating System on which these database run is not a requirement for UIM. 

There is no specific dependency for the Operating System, except the compatible drivers and configuration. However Database and version specific tasks needs to be run.