<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=US-ASCII"> <title>psqlODBC HOWTO - Business Objects</title> </HEAD> <body bgcolor="#ffffff" text="#000000" link="#ff0000" vlink="#a00000" alink="#0000ff"> <h1>psqlODBC HOWTO - Business Objects</h1> <p> <i> Author: Peter S. Hamlen (phamlen@teachforamerica.org)<br> Release Date: 26 May 2003<br> Description: PostgreSQL and Business Objects </i> <br><br> Will Postgresql ODBC work with Business Objects? <br><br> Yes, with three caveats: <br> <ol> <li>Technically, Business Objects does not support PostgreSQL. They do support generic ODBC access to databases, however.<br> </li> <li>You must change the ODBC parameter file on any machine that uses Designer. The ODBC file is usually <i>C:\Program Files\Business Objects\Data Access X.X\ODBC\ODBC10EN.PRM</i>. You must change the OWNER parameter to N and the QUALIFIER parameter to N (ie, OWNER=N, QUALIFIER=N).<br><br> 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.<br> </li> <li>As with all other generic ODBC connections, you cannot do outer joins in Designer.<br> </li> </ol> </p> <p>Martín de la Herrán also adds the following notes:</p> <p>Also add the following parameters to C:\Program Files\Business Objects\Data Access X.X\ODBC\ODBC10EN.PRM<br><br> BACK_QUOTE_SUPPORTED=Y<br> TABLE_DELIMITER="<br><br> These parameters are necessary to use tables with spaces and unusual chararacters in them. </p> </body> </html>