BI 4.1 SP2 Information Designer and PostgreSQL 9.3 connection - HOW?

[Former Member]

Hello,

Business Objects BI 4.1 on Windows 7, with IDT (Information Designer tool ) on client PC

I have spent couple of days in trying to sort out a Universe connection to a PostgreSQL 9.3 database.

I have followed the dataaccess document and lots of other examples but I seem to be getting the following error :

Java Class not found in classpath : org.postgresql.Driver

I have

1. Downloaded the .jar file from PostgreS and put it in the necessary path.

2. I have put in the <ClassPath> information in the .SBO file

3. I have tried this in the jdbc.sbo file  and GreenPlum.sbo file but no luck

Any one out there can you advise on the steps

Thanks

Sanjay

[former_member185603 · Accepted solution]

Are you creating the connection in your local machine or on the server (Bottom of IDT screen where repositories shows)?

[Former Member · Accepted solution]

Hi Jawahar,

I am creating the connection via the IDT screen and at the bottom where repository shows.

and the .Jar file and .sbo files are setup on the local machine

Sanjay

[Former Member · Accepted solution]

Hi jawahar.

I have now successfully been able to create a Local and Secured connection in IDT for a JDBC connection to PostgresSQL database.

1. Locally, after setting up the .sbo and the jar files, I needed to restart the PC.

2. For Secured again similarly, After setting up the greenplum.sbo and the relevant Jar file, I had to restart the  Server Intelligence Agent. Then create a secured connection.

The testing of connection passed at the IDT level

To test overall,

3. publish the universe to the repository.

4. Create a report on the universe using Webi Rich Clinet (Desktop tool ) - This works fine

5. Create a report via Launch pad and This works.

Thanks for your help any way !

Sanjay

[Former Member · Accepted solution]

Hi Sanjay,

I have done what you said in the above but it is not working for me.

could you please explain where did you change it.

Thanks.

Best Regards,

Edu

[usman1158 · Accepted solution]

what were the steps? you marked this question as Answered, i dont see any steps ?