Resolution:
An option called 'AlternateServers' allows a list of additional database servers to be specified. The value of the AlternateServers connection option is a string that specifies the server name and port number of alternate servers that can be tried if the primary server is not accepting connections. This option should be placed in the connection URL string and have the following syntax:

jdbc:datadirect:sqlserver://server1:1433;DatabaseName=TEST;User=test;Password=secret;AlternateServers=(server2:1433;DatabaseName=TEST2,server3:1433;DatabaseName=TEST3)

Specifying the above URL causes the driver to attempt to connect to the TEST database on server1. If that connection fails, the driver tries to connect to the TEST2 database on server2. If that attempt fails, the driver attempts to connect to server3, and so on until all servers in the list are tried.

How to configure BW JDBC connection failover to an MS SQLServer database.