Skip to Content

design tool new connexion issue "DBD: The connection attempt failed "

Sep 27, 2017 at 12:12 PM


avatar image


I have a connection ( use POSTGRES tool) creation problem please find bellow all details :

I modified the file greenplum.sbo on "D:\Apps\BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc"


add on Greebplum.sbo :

<DataBases> <DataBase Active="Yes" Name="Postgres 8"> <Aliases> <!-- You can add an alias here if you are using some connections that are defined with an older database engine --> <Alias>Postgres 8</Alias> </Aliases> <JDBCDriver> <!-- Uncomment and edit the following lines to define java classes required by JDBC driver <ClassPath> <Path>your jar or class files directory</Path> </ClassPath> --> <ClassPath> <Path>D:\Apps\BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\postgresql\postgresql-8.3-606.jdbc3.jar</Path> </ClassPath> <Parameter Name="JDBC Class">org.postgresql.Driver</Parameter> <Parameter Name="URL Format">jdbc:postgresql://$DATASOURCE$/$DATABASE{replace18}lt;/Parameter> </JDBCDriver> <Parameter Name="Family">GreenPlum</Parameter> <Parameter Name="Extensions">postgresql9,postgresql,jdbc</Parameter> <Parameter Name="Array Fetch Size">10</Parameter> </DataBase> </DataBases> </DriverConfiguration>


and add the driver on "D:\Apps\BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\postgresql\postgresql-8.3-606.jdbc3.jar"

So when I go to create the new connexion on design tool, I chose PostgreSQL 8 and next


when I clic on test connexion I have this error message "DBD: The connection attempt failed."


thanks in advance for your help

postgres.jpg (45.6 kB)
erreur.jpg (24.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers