KB16345: How to configure MicroStrategy Intelligence Server Universal running on Linux to work with PostgreSQL 8.x

In Strategy 8.0.3 and 8.1.0, PostgreSQL is certified as a Warehouse with Strategy Intelligence Server running on Microsoft Windows and Linux operating systems. In Strategy 8.0.2, PostgreSQL is certified as a Warehouse with Strategy Intelligence Server running on the Microsoft Windows operating system only.
 
This technical note is broken into the following three parts: ODBC Driver installation, ODBC Driver setup, and Product setup.
 

1. ODBC Driver installation
   Follow the steps below to install the certified PostgreSQL driver on Linux (Version 7.01.03):
    
   
• Go to http://rpm.pbone.net/index.php3
• In the search box enter unixODBC-2.2.11-1.i386.rpm
• Download and install the package. This package contains PostgreSQL driver version 7.01.03.
2. ODBC Driver setup
   In order to get an ODBC connection with the 32-bit PostgreSQL driver, the following is an example section that needs to be added to the odbc.ini file:
    
   
   PostgreSQL_LABSTUTO=PostgreSQL
   
   
   Driver= /usr/lib/libodbcpsql.so
   Description=Sample PostgreSQL DSN
   Servername=10.11.12.13
   Username=labstuto
   Database=labstuto
   ReadOnly=No
   Servertype=postgres
   Port=5432
   FetchBufferSize=99
   ServerOptions=
   ConnectOptions=
   Options=
   ReadOnly=no
   
3. In this example, 10.11.12.13 is the IP address of the PostgreSQL server, 5432 is the Port number, and the database/username is labstuto. The name of the DSN is PostgreSQL_LABSTUTO.
    
   
4. Product setup
   In Strategy 8.0.2 and 8.0.3, use the PostgreSQL 8.1 DBMS object for connectivity to PostgreSQL 8.1 database. This object is set in Database Instance Manager > Database Instance > Database Connection Type. In Strategy 8.1.0, use the PostgreSQL 8.1 DBMS object for connectivity to PostgreSQL 8.1 database and the PostgreSQL 8.2 DBMS object for connectivity to PostgreSQL 8.2 database.
    
   For proper functioning of the PostgreSQL warehouse connectivity in Strategy 8.0.3, it is necessary to add the following parameters to the 'Additional connection string parameters' in Strategy Desktop:
    
   SERVER=IP_ADDRESS;DATABASE=DATABASE_NAME;PORT=5432;ReadOnly=0
   
5. In the above example, the additional connection string is:
    
   SERVER=10.11.12.13;DATABASE=labstuto;PORT=5432;ReadOnly=0
   
6. Use the guidelines in the following Strategy Knowledge Base technical note to add additional connection string parameters:
    
   
• KB42620 - How does the Additional Connection String Parameters feature for database connections work in Strategy 9.x? 
7.  
   NOTE: PostgreSQL connectivity will not work through Strategy Test ODBC tool in Strategy 8.0.3 because the additional connection string parameters cannot be added for Test ODBC. In Strategy 8.1.0, these connection string parameters are not necessary and Test ODBC should work fine.
    
   

Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.