how to import jdbc postgres driver to SAP?

[Former Member]

hi, I want to create a JDBC channel for a postgres database?

Does SAP support postgres by default?

If not, I have a jar file, the issue is how can I import it to SAP? thank you

[Former Member]

Hi,

SAP installation by default only support major database like Oracle, MSSQL, DB2, MAXDB. But if what do you meant is whether SAP PI JDBC adapter supported Posgress database, i can said yes, as long the database supported by normal JDBC you can upload the JDBC jar file driver to SAP PI J2EE engine.

You need to deploy the .jar file throught SDM.

Best Regards

Fernand

[Former Member]

I'm using PI7.1, and I telnet to sap administator, and then use the DBPOOL commands:

deploy_jdbc_driver mydriver my.jar

It output the deployment is succesful, but I still got the "class not found" exception when test the driver.

I saw lots threads metioned SDM, where I can start SDM or is there a transaction code for it?

[Former Member]

Hi,

I am not too sure whether SAP supports Postgres DB by default, as there are lots of suggested DBs for SAP, but unless they have a large install base, they won't be made a default DB.

But you can connect to the postgres DB from SAP. You just need to make the JDBC driver available in the Java server (in the appropriate JDBC destination) and install it there. Once that is done, you will be able to see the driver in the ID ->CC.

You can get in touch with your basis team to get further assistance.

regards,

Neetesh