Applications
      Back to home
      1. Knowledge Base
      2. Connectors
      3. Applications

      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.