Details

    • Solution:
      Hide

      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

      Show
      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 a database user name & passwort JDBC-URL: "jdbc:exa:<host-range>:<port>" 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

      Attachments

        Issue Links

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: