Connection Info Oracle (DevTest delivers this connection jar in LISA_HOME/lib/shared folder)
Select one of the two connection URLs depending on usage of SID or SERVICE
JDBC Driver: oracle.jdbc.driver.OracleDriver
Connect String: jdbc:oracle:thin:@[HOST]:1521:[SID]
jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE
Connection Info MS SQL Server (DevTest delivers this connection jar in LISA_HOME/lib/shared folder)
JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServer
Connect String: jdbc:sqlserver://[SERVER]:[PORT];databaseName=[DATABASENAME]
Connection Info DB2 (DevTest delivers this connection jar in LISA_HOME/lib/shared folder)
JDBC Driver: com.ibm.db2.jcc.DB2Driver
Connect String: jdbc:db2://[HOSTNAME]:[PORT]/[DATABASENAME]:progressiveStreaming=2;
Connection Info MySQL (DevTest does not deliver this connection jar, refer to link https://dev.mysql.com/downloads/connector/j/ to get jar)
JDBC Driver: com.mysql.jdbc.Driver
Connect String: jdbc:mysql://[DBHOST]:[DBPORT]/[DBNAME]
Connection Info Derby ((DevTest delivers this connection jar in LISA_HOME/lib/shared folder)
JDBC Driver: org.apache.derby.jdbc.ClientDriver
Connect String: jdbc:derby://[SERVER]:[PORT]/[DATABASE]