From 3f39613471a2c4ca4aa628692c1b36b8759b7a29 Mon Sep 17 00:00:00 2001 From: Dave Page Date: Mon, 24 Apr 2006 20:03:33 +0000 Subject: [PATCH] =?utf8?q?Additional=20Business=20Objects=20notes=20from?= =?utf8?q?=20Mart=C3=ADn=20de=20la=20Herr=C3=A1n?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- docs/howto-bo.html | 98 +++++++++++++++++++++++++--------------------- 1 file changed, 54 insertions(+), 44 deletions(-) diff --git a/docs/howto-bo.html b/docs/howto-bo.html index a8d666d..f9a3811 100644 --- a/docs/howto-bo.html +++ b/docs/howto-bo.html @@ -1,45 +1,55 @@ - - - - - psqlODBC HOWTO - Business Objects - - - - -

psqlODBC HOWTO - Business Objects

- -

- - -Author: Peter S. Hamlen (phamlen@teachforamerica.org)
-Release Date: 26 May 2003
-Description: PostgreSQL and Business Objects - -

-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. - -
  2. 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, -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. - -
  3. As with all other generic ODBC connections, you cannot do outer -joins in Designer.
     
    4. - - -

    - - + + + + + psqlODBC HOWTO - Business Objects + + + + +

    psqlODBC HOWTO - Business Objects

    + +

    + + +Author: Peter S. Hamlen (phamlen@teachforamerica.org)
    +Release Date: 26 May 2003
    +Description: PostgreSQL and Business Objects +     +

    +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. + +
    2. 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, +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. + +
    3. As with all other generic ODBC connections, you cannot do outer +joins in Designer.
       
      4. +
    + +

    + +

    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

    + +BACK_QUOTE_SUPPORTED=Y
    +TABLE_DELIMITER="

    + +These parameters are necessary to use tables with spaces and unusual chararacters in them. +

    + + \ No newline at end of file -- 2.39.5