Establish connectivity to SAP BusinessObjects

This article describes how to connect to BusinessObjects (BOBJ) in order to load data into Datasets and Reports in Metric Insights.

PREREQUISITES

Your Metric Insights instance must be configured to support BusinessObjects:

  • BusinessObjects Rest API must be enabled (default port is 6405)
  • 6400 and 6405 ports must be open for access to the BOBJ server from the MI server
  • Web Application Container Server must be installed properly

1. Access Admin > Data Sources

At the bottom of the screen, click [+ New Data Source].

The Select the Type of New Data Source pop-up opens.

2. Select the Type of the New Data Source

  1. Select "Other" and choose "SAP BusinessObjects" from the drop-down list
  2. Move to the Next step

3. Provide the Required Parameters

Specify how to connect to SAP BusinessObjects:

  1. Data Source Name:  is default but you may modify it
  2. Auth.type: define the authentication type used (e.g., secEnterprise, secLDAP, secWinAD)
  3. CMS: provide the host hame of the BusinessObjects server (include the HTTP/HTTPS scheme as shown above)
  4. Username/Password: note that your Username must be in the same format that your SAP BusinessObjects server uses for authentication
  5. Save your entries and Test Connection

3.1. If connection fails, test that BOBJ is set up correctly

1. Enter the data below in the Command line to verify that Port 6405 is set as default for BOBJ:

http://bobj.<yourcompany>.com:6405/biprws/logon/long

If you receive the result as shown in the image, the Port is correct. Verify your settings for existing errors.

2. If you receive "This site can't be reached" message, the Port is set incorrectly. Contact your BOBJ admin to resolve the issue.

4. Optional Parameters

Click the Edit (Gear) icon to define optional parameters:

  1. Folder Filter [optional]: specify the Folder ID to limit the number of Objects that will be fetched to Metric Insights 
    • You can also use a list of comma-separated Folder IDs
  2. Port [optional]: input the Port number if your server uses a port other than the default BusinessObjects REST API port (6405)

4.1. How to find a Folder ID in SAP Business Objects?

In SAP BusinessObjects UI:

  1. Open the Documents tab
  2. Right-click the selected Folder > choose Properties
  3. On the General Properties pop-up window,  find and copy the Folder ID

5. Advanced Configuration

  1. Use Remote Data Collector: is set to "no" by default
    • If required, switch to "yes" and add a Remote Data Collector by clicking [+New Remote Collector] 
  2. Generate Object List 
    • automatically: all Reports are going to be fetched by the system
    • manually: Reports may be added one-by-one or via CSV file
  3. Object List Refresh Trigger: from the dropdown, select the Trigger that will be used to fetch data via the Google Play Console plugin
  4. Object Selection Method: specify how Google Play Console Reports will be fetched
  5. Optionally, state the maximum number of concurrent Threads to utilize during data and/or image fetch to be used in background processing when the system updates Reports for this Data Source 
    • If you do not specify any value for this setting, batch data collection processing will be single-threaded

6. Other Settings

  1. You can Datasets directly from the respective tab
  2. Click Permissions to assign Permissions to Groups or Power Users