Skip to end of metadata
Go to start of metadata

Article contributor
Ravi Kumar Pola

Product versions: SAP BI4.0

1. Prerequisites

  • BI4.0 is running on Unix/Linux platform and Monitoring Derby database is backup-ed in the Unix/Linux location. (Example: /usr/derby/)
  • derby.jar is downloaded from Apache Derby web site (http://db.apache.org/derby/ , download db-derby-10.5.1.1-bin.zip and extract derby.jar)
  • Copy derby.jar to the known location on Unix/Linux (example: /usr/derby/derby.jar )
  • Edit jdbc.sbo/derby.sbo files and add Class Path and Parameter
    (location of jdbc.sbo/derby.sbo on Unix/Linyx is; <bi40_root_install_folder>/sap_bobj/enterprise_xi40/dataAccess/connectionServer/jdbc)
    <ClassPath>
    <Path>/usr/derby/derby.jar</Path>
    </ClassPath>
    <Parameter Name="JDBC Class">org.apache.derby.jdbc.EmbeddedDriver</Parameter>

  • Copy backup Derby database to the Windows box where BI4.0 Universe Design Tool or Information Design Tool are installed
    (Example: Copy from Unix /usr/derby/ to Windows C:\derby)
  • Copy derby.jar as well to the same location on Windows box

  • Edit jdbc.sbo/derby.sbo on Windows box and add Class Path and Parameter
    (Location of jdbc.sbo on Windows is C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc)
    <ClassPath>
    <Path>C:\derby\derby.jar</Path>
    </ClassPath>
    <Parameter Name="JDBC Class">org.apache.derby.jdbc.EmbeddedDriver</Parameter>

2. Create Universe (UNV) with BI4.0 Universe Design Tool

  1. Login into BI4.0 Universe Design Tool and create Generic JDBC connection
  2. Define Login Parameters for UNV universe and point Database URL to Derby DB on Windows
    Database URL= jdbc:derby:C:\derby;create=false
    JDBC Class= org.apache.derby.jdbc.EmbeddedDriver
  3. From Table Browser select three tables from APP scheme
  4. Create universe
  5. Edit the UNV connection and point Database URL to Derby DB on Unix
    Database URL= jdbc:derby:/usr/derby/;create=false
  6. Publish UNV universe to the repository on Unix

3. Create Universe (UNX) with BI4.0 Information Design Tool

  1. Open BI4.0 Information Design Tool and create relational Apache Derby 10 Embedded JDBC connection

  2. Define connection Parameters and make sure that Server parameter points to Derby DB on Windows
    Server (<host>:<port>)= C:\derby;create=false
  3. Create single source Data Foundation (DF) and use connection created in the first step
  4. From Table Browser of DF select three tables from APP scheme and move them to Master. Create joins
  5. Create Derive table for each table from APP scheme (Define derived table SELECT as: select * from <table_name>)
    (This step is necessary if table columns are not visible when trying to create joins in pervious step)


    (Name Deriva table as original table name and add _DT. Example: MANAGED_ENTITY_STATUS_DETAILS_DT)
  6. Create joins between derive tables
  7. Create Relational Business Layer by using Data Foundation created in previous steps
  8. Publish the connection to the BI4.0 repository running on Unix.
    (When prompted, click Yes to create connection shortcut which is saved in the Derby project)
  9. Go to Data Foundation to change the connection. Chose the shortcut to the secure connection (connection has extension cns)
  10. Publish Business Layer to the BI4.0 repository
  11. Edit published secure connection and change "Server (<host>:<port>)" parameter to point to Derby location on Unix box
    (Make sure that you created session with the Repository and that you are editing the published Derby connection)
    Server (<host>:<port>)= /usr/derby;create=false
  1. Guest

    Hi,

    Thanks for this great Wiki,

    I have one question:

    - Currently we hesitate to install BI 4.0 on an unix or a windows server:

    Do you have meet issues or bug during installation or configuration in Unix ?

    Kr
    Alexis DOLCI

  2. Hi Alexis,
    Sorry for slow feedback.
    I personally installed BI4.0 on AIX and Linux platform.
    Also, several our rump-up customers are using Unix platform.

    Hope this help
    Sinisa

  3. Guest

    Hi,

    Can anyone convey if this solution is available for BI 4.0 running on Windows server?

    Thanks

    Manohar