psqlODBC HOWTO - Business Objects
Author: Peter S. Hamlen (firstname.lastname@example.org)
Release Date: 26 May 2003
Description: PostgreSQL and Business Objects
Will Postgresql ODBC work with Business Objects?
Yes, with three caveats:
- Technically, Business Objects does not support PostgreSQL. They do
support generic ODBC access to databases, however.
- You must change the ODBC parameter file on any machine that uses
Designer. The ODBC file 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,
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.
- As with all other generic ODBC connections, you cannot do outer
joins in Designer.
Martín de la Herrán also adds the following notes:
Also add the following parameters to C:\Program Files\Business Objects\Data Access X.X\ODBC\ODBC10EN.PRM
These parameters are necessary to use tables with spaces and unusual chararacters in them.