Which DB(all DBs like MSSQL, DB2 ORACLE) versions does JDBC supports

[chitti_prakash]

Hi All,

Here I would like to know what all the DB versions does JDBC supports in 3.0,7.0,7.01,7.02 of PI.

For eg. If we are trying to connect to ORACLE DB using JDBC adapter what are the basic requirements like,

Driver Name : oracle.jdbc.driver.OracleDriver

URL : jdbc:oracle:<drivertype>:<username/password>@<database>

JDK Version : ?

JDBC complaint : ?

Like this I need for all the DBs ( ORACLE,DB2,MSSQL,)

Please do the needful.

Regards,

Soorya

[Shabarish_Nair · Accepted solution]

the basic requirement would be to deploy the right drivers - https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

[chitti_prakash · Accepted solution]

Hi Vijay,

The document I have already read. This is to prepare a SDA file to deply in SDM tool.

I need the JDK versions and JDBC complaints for all the DB versions of following 3rd party databases:

- ORACLE

- MSSQL

- DB2

Regards,

Soorya

[prateek · Accepted solution]

There is no such technical limitation. If you have the drivers of your database and it could be installed on PI server, then you can very well use it.

Regards,

Prateek

[Shabarish_Nair · Accepted solution]

Do refer the FAQ note for JDBC - 831162.... it covers most of the questions ...