1. SQL Server :
SQLServerABC/type=javax.sql.DataSource
SQLServerABC/driver=net.sourceforge.jtds.jdbc.Driver
SQLServerABC/url=jdbc:jtds:sqlserver://10.0.1.111:1433;DatabaseName=abc
SQLServerABC/user=abc
SQLServerABC/password=abcd
2. Oracle :
oracleAbc/type=javax.sql.DataSource
oracleAbc/driver=oracle.jdbc.driver.OracleDriver
oracleAbc/url=jdbc:oracle:thin:@10.0.1.111:1521:abc <sid>
oracleAbc/user=abc
oracleAbc/password=abcd
oracleAbc/FetchTSWTZasTimestamp=true
3. My SQL :
mySqlAbc/type=javax.sql.DataSource
mySqlAbc/driver=com.mysql.jdbc.Driver
mySqlAbc/url=jdbc:mysql://localhost:3306/abc <datamart_name>?autoReconnect=true
mySqlAbc/user=abc
mySqlAbc/password=abcd
4. Infobright :
infobrightAbc/type=javax.sql.DataSource
infobrightAbc/driver=com.mysql.jdbc.Driver
infobrightAbc/url=jdbc:mysql://10.0.5.111:5029/datamart_abc
infobrightAbc/user=abc
infobrightAbc/password=abcd
infobrightAbc/FetchTSWTZasTimestamp=true