Need to connect to GreenPlum Database in SAP BI 4.0

[pradeep_putty]

Hi ,

We Need to connect to GreenPlum Database in SAP BI 4.0,

i dont see any specific driver to set up a system dsn for this data source.

So can any one share your experience if you built a universe based on green plum db(UNX using IDT in 4.0)

or even in earlier versions of BO how to create a system dsn for greenplum db,

which driver we need to use.

[Former Member · Accepted solution]

Hello Pradeep,

Need to use PostgreSQL 8.4 ODBC drivers for Greenplum 3.2 database.

Thanks,

Cs

[pradeep_putty · Accepted solution]

Thanks,

just download that and install it on the server

or do i need to make any changes in configuration files like .sbo etc.

do i need to install in any specific folder like where i installed SAP BI 4.0 like that.

Thanks for your inputs.

[Henry_Banks · Accepted solution]

Hi,

Infact, GreenPlum 4 is not 'officially supported' with BI 4.0 until Feature Pack 03 next year.

This is OK currently:

Greenplum 3.2 JDBC PostgreSQL 8.4 JDBC

Greenplum 3.2 ODBC PostgreSQL 8.4 ODBC

This will come with 4.0.FP03 :

Greenplum 4 JDBC PostgreSQL JDBC 8.4-701

Greenplum 4 ODBC PostgreSQL ODBC 9.00.03.00

Regards,

H

[pradeep_putty · Accepted solution]

Thanks Surendra and Henry for your inputs