SAP BO

Connectivity Summary

An out-of-the-box connector is available for SAP BO. It provides support for crawling and lineage building. The connectivity to SAP BO is via Rest API, which is included in the platform.

SAPBOscreen

The connector supports all latest versions of SAP BO. 

Connector Capabilities

The connector capabilities are given below:

Crawling

Supported objects for crawling are: Reports

Please see this article Crawling Data, for more details on crawling. 

Lineage Building

Lineage Entities Details

Table lineage

Supported

Column lineage

Supported

Lineage Sources

Supported

Report Columns

While building lineage, we will get report columns.

Pre-requisites

To use the connector, the following need to be available:

  • For Building Lineage

    • The server should be windows based.
    • Before crawling, make sure that the following software is installed in the server machine to get  the metadata:
      • Visual Studio 12  or later than version 12 will be good - (https://visualstudio.microsoft.com/vs/older-downloads/)
      • Crystal Report for Visual Studio: (https://origin.softwaredownloads.sap.com/public/file/0020000000898892019)
  • An admin/service account that has read permission on reports/folders. The minimum privileges required are:
Operation Access Permission

Connection validate

Read Permission

Crawl Domains

Read Permission

Crawl Reports

Read Permission

  • The Service Account should be created with the authentication type as sec Enterprise.

Connection Details

The following connection settings should be added for connecting to an SAP BO:

  • Database Type: SAP BO
  • Connection Name: Select a Connection name for the SAP BO. You specify a reference name to identify your SAPBO connection in OvalEdge easily.
  • Base URL: Rest API instance URL 
    Example: http://18.222.163.191:6405/biprws/
  • Username: SAP BO login username
  • Password: SAP BO login password
  • Authentication Type: The authentication type is like windows authentication or a normal username and password (sec Enterprise).
  • Filter: If nothing is specified, it will show all the folders available in SAP BO, or users can enter a specific folder to crawl.

Points to note

  • OvalEdge application crawls all the folders and reports from respective folders and saves them in the Data Catalog.
  • The folder structure will be the same in OvalEdge as in the SAP Business Objects.
  • During the crawling phase, the OvalEdge application gets the metadata(xml/JSON) from crystal, and webi reports, save them in the OvalEdge Database and uses it for further processing.
  • Ensure sure ovaledge.temppath and rpttoxml.executable.path are configured correctly.