[SOL-192] Business Objects connection Created: 06.11.2014  Updated: 29.07.2019

Status: Published
Project: Solution Center
Component/s: 3rd Party Tools, EXASolution, ODBC
Affects Version/s: EXASolution 5.0
Fix Version/s: None

Type: How To
Reporter: Captain EXASOL Assignee: Captain EXASOL
Labels: None

Issue Links:
Blocking
Duplicate
Solution:

Connecting SAP Business Objects to Exasol:

ODBC32-installation (recommended):

  • Set up the connection in Windows ODBC Adminstration, then
  • In Information Design Tool (Start->SAP Business Intelligence->SAP BusinessObjects BI platform 4 Client Tools->Information Design Tool)
    • open a project, then
    • -> “Relational Connection”
    • In the Dialog put a name, then under “driver selection” select “GENERIC” -> ”Generic ODBC Datasource” -> ”ODBC driver”
    • Next put the username & pw; choose as data source name the ODBC alias

Some lines of the file odbc.prm should be edited to set these parameter values:

<Parameter Name="DB_TYPE">GENERIC</Parameter>
<Parameter Name="EXT_JOIN">YES</Parameter>
<Parameter Name="CONCAT">||</Parameter>
<Parameter Name="COMMA">||' '||</Parameter>
<Parameter Name="OUTERJOINS_GENERATION">USUAL</Parameter>
<Parameter Name="LEFT_OUTER">$(+)</Parameter>
<Parameter Name="RIGHT_OUTER">$(+)</Parameter>
<Parameter Name="EXT_JOIN_INVERT">YES</Parameter>

Parameters that may be helpful:

<Parameter Name="DATABASE_DATE_FORMAT"></Parameter> 
<Parameter Name="GROUP_BY_SUPPORTS_COMPLEX">YES</Parameter>
<Parameter Name="USER_INPUT_DATE_FORMAT">'yyyy-mm-dd-hh.mi.ss'</Parameter>  
# if the EXASOL parameter "NLS_TIMESTAMP_FORMAT" is a its default  'YYYY-MM-DD-HH.MI.SS.FF6'
<Parameter Name="SORT_JOINS_BY_QUERY_OBJECTS">'YES'</Parameter> 
# if issues with outher joins; must be set in prm file, DataFoundation & BO Universe (Query Script Parameters)

Done.

JDBC installation:

Go to the folder where BusinessObjects is installed. E.g.:

E:\BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc

Open the file “jdbc.sbo” in a text editor and edit:


        <JDBCDriver>

            <ClassPath>

                <Path>$ROOT$/drivers/java/dbd_jdbcwrapper.jar</Path>

                <Path>C:\JDBC-drivers\exajdbc.jar</Path>

            </ClassPath>

…

<DataBases>

        <DataBase Active="Yes" Name="Exasol JDBC">

                <Parameter Name="JDBC Class">com.exasol.jdbc.EXADriver</Parameter>

                <Parameter Name="URL Format">jdbc:exa:$DATASOURCE$</Parameter>
   
…


In Information Design Tool (Start->SAP Business Intelligence->SAP BusinessObjects BI platform 4 Client Tools->Information Design Tool)
open a project, then
-> “Relational Connection”
In the Dialog put a name, then under “driver selection” select “GENERIC” -> “Exasol JDBC” -> “JDBC Drivers”
As parameters put

  1. a database user name & passwort
  2. JDBC-URL: "jdbc:exa:<host-range>:<port>"
  3. JDBC Class: “com.exasol.jdbc.EXADriver”
    (both without quotes)

Done.

See also:

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp5_data_acs_en.pdf#_OPENTOPIC_TOC_PROCESSING_d108e8674

Category 1: 3rd Party Tools
Category 2: Clients, Interfaces & Drivers - ODBC

 Comments   
Comment by Marcel Boldt (Inactive) [ 24.02.2016 ]

.

Comment by Marcel Boldt (Inactive) [ 24.02.2016 ]

added some ODBC parameters

Comment by Marcel Boldt (Inactive) [ 24.02.2016 ]

.

Generated at Sun Jul 12 15:26:09 CEST 2020 using Jira 7.13.13#713013-sha1:4c0f5f5e3383570393fbbf3d2fd5de1eb4057c36.