Thread: Addition to pgsql-odbc FAQ

I just got Business Objects working with Postgresql ODBC and there are a
few things that you need to do to get it to work.  I would like to
submit the following FAQ item under "Other Apps"  (a new category)

Will Postgresql ODBC work with Business Objects?

Yes, with three caveats.

1)  Technically, Business Objects does not support PostgreSQL.  They do
support generic ODBC access to databases, however.

2)  You must change the ODBC parameter file on any machine that uses
Designer.  The ODBC files is usually C:\Program Files\Business
Objects\Data Access X.X\ODBC\ODBC10EN.PRM.  You must change the OWNER
parameter to N and the QUALIFIER parameter to N (ie, OWNER=N,
QUALIFIER=N).
     NOTE:  It is only necessary to change this file for people who use
Designer.  BusinessObjects, WebIntelligence, and all other BO programs
that use existing Universes are unaffected.

3)  As with all other generic ODBC connections, you cannot do outer
joins in Designer.

It's rumoured that Peter S. Hamlen once said:
> I just got Business Objects working with Postgresql ODBC and there are
> a few things that you need to do to get it to work.  I would like to
> submit the following FAQ item under "Other Apps"  (a new category)

Hi Peter,

Thanks for your contribution. I have added it under the HOWTO section
rather than the FAQ section as it is not a particularly frequently asked
question, but of course will still be useful to those wanting to use
Business Objects. You can find it at
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-bo
Please let me know if there are any corrections to make.

Regards, Dave.