Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
Thank you,
The SAP Community team.
The SAP Community wiki will be closed to new content submissions from December 7 6:00 p.m. CET to December 11 6:00 p.m. CET.
We apologize for the inconvenience, but we need to take the system offline while we improve the platform. Please plan your tasks accordingly.
Skip to end of metadata
Go to start of metadata

Product versions:
BusinessObjects Enterprise XI3.1
Data Federator 3.0 SP1
SAP NetWeaver BI 7.01 SP3

Data Federator creates a virtual database which can be accessed through JDBC by universes. If you want to create a universe that connects to this Data Federator database, there are two configuration steps required in BOE:

•Connect the Universes to Data Federator using JDBC (update the data access driver configuration file jdbc.sbo )
•Add the new Data Federator Universe strategy to generate the relational Universes automatically

Updating JDBC.SBO

The data access driver file jdbc.sbo has to be updated to include the classpath to the Data Federator jdbc driver (thindriver.jar):

  1. Edit jdbc.sbo with a text editor like notepad. You can find jdbc.sbo in C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc
  2. Search for "federator". You should see the following entry:
  3. Right below <JDBCDriver> add the following line:
  4. Save and close jdbc.sbo

Adding Universe Strategy

A strategy is a script that automatically extracts structural information from
a database. Strategies have two principle roles:
• Automatic join and cardinality detection (Join strategies)
• Automatic class, object, and join creation (Objects and Joins strategies)

Data Federator has a strategy for the automatic generation of relational universes from NW BI data. The strategy file can be found in the "BOE-Add-ons" folder on the Data Federator CD. To add the strategy to BOE:

  1. Copy the strategy file datafederator.stg to C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc
  2. Add the link to the Data Federator strategy file.
    a. Edit the file
    C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
    b. Find the section <DataBase Active="Yes" Name="Data Federator
    Server"> and add the link to the strategy file by adding the following entry as one of the parameters
    After the change it should look like:
    c. Save and close the file

d. here is an example that shows what your jdbc.sbo file should look like:

Now you can create a universe. This configuration is one of the steps required for: Implementing Data Federator 3.0 With SAP Netweaver BW Connector for Webi Reporting

Callback registration in Netweaver and Data Federator for NW BW Connector
Configuring Data Federator users for NW BW Deployments
Creating a SAP NetWeaver BW datasource in Data Federator Designer
SAP BW Relational Universe Connection With Universe Designer
Implementing Data Federator 3.0 With SAP Netweaver BW Connector for Webi Reporting
Leveraging Data Federator in SAP integrations

  • No labels