/usr/share/doc/odbc-postgresql/docs/howto-bo.html is in odbc-postgresql 1:09.00.0310-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | <!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>
|