PostgreSQL

[former_member182065]

Hello colleuagues,

My customer uses PostgreSQL(Open SQL) in their company. Does any of you experience MII and PstgreSQL connectivity? and which driver is used then?

Thank you for your advice.

Sincerely, Shiroh Kinoshita - SAP Japan

[Former Member]

Hi Shiroh,

yes we have established a connection between xMII 12.0 and PostgreSQL. It works like a charm.

We used the the JDBC Driver 8.4 JDBC 3. Please take also a look into the JDBC Driver documentation

to provide the JDBCDriver string and the ServerURL.

JDBCDriver String:

ServerURL: jdbc:postgresql://<host>:<port>/database

ServerURL:

JDBCDriver: org.postgresql.Driver

Sample ValidationQuery:

select version();

BR

Pedro Iglesias

[former_member182065]

Hello Pedro,

thank you very much for your answer. I will try.

best regards, SK

[Former Member]

Hi,

I never used PostgreSQL till now. But I hope by having the JDBC driver for PostgreSQL we can do connect.I'm not sure will it work.You can down load JDBC for PostgreSQL over [Here|http://jdbc.postgresql.org/download.html].

Server URL will be like this:

jdbc:postgresql://hostname:port/dbname

.

Hope this helps you in someway.

-Suresh