Driver | URL |
DB2 for Linux/UNIX/Windows 1 | jdbc:datadirect:db2://server1:50000;DatabaseName=jdbc; User=test;Password=secret |
DB2 for z/OS and i 2 | jdbc:datadirect:db2://server1:446;LocationName=Sample; User=test;Password=secret |
Informix | jdbc:datadirect:informix://server4:1526; InformixServer=ol_test;DatabaseName=your_database; User=test;Password=secret |
MySQL | jdbc:datadirect:mysql://server1:3306;User=test; Password=secret |
Oracle 3 | jdbc:datadirect:oracle://server3:1521;ServiceName=ORCL; User=test;Password=secret |
PostgreSQL | jdbc:datadirect:postgresql://server1:5432;DatabaseName=jdbc; User=test;Password=secret |
Progress OpenEdge | jdbc:datadirect:openedge://server1:2003;User=test; Password=secret |
Microsoft SQL Server 4 | jdbc:datadirect:sqlserver://server1:1433;User=test; Password=secret |
Sybase | jdbc:datadirect:sybase://server2:5000;User=test; Password=secret |