Hello,
I have a connection (.rds.amazonaws.com 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