SAP BusinessObjects connection

To access your data in SAP BusinessObjects, create a connection asset for it.

SAP BusinessObjects is a reporting and visualization platform.

Supported versions

SAP BusinessObjects Business Intelligence Platform 4.3 SP1 and SP2

Prerequisites

Client Tools 4.3 with Semantic Layer Java SDK is required. You can install it only on the Windows operating system.

Before you can create a SAP BusinessObjects connection, install and configure Manta Flow Agent to use it for extraction. You must install this agent on the same workstation as the SAP BusinessObjects instance.

Preparing for installation of MANTA Flow Agent

Before you start the installation of MANTA Flow Agent, expose the MANTA Artemis service details, and generate a new agent configuration file.

Expose the MANTA Artemis service details. MANTA Flow Agent is installed outside the Cloud Pak for Data cluster, it communicates with MANTA Artemis service in Cloud Pak for Data. Use the NodePort or ClusterIP services in Red Hat OpenShift to find the TCP port and the hostname of the MANTA Artemis service.
Generate the configuration file for the new MANTA Flow Agent.
1. Register a new MANTA Flow Agent.
  1. Open the MANTA Automated Data Lineage Admin UI:
```
https://<CPD-HOSTNAME>/manta-admin-gui/
```
  1. Go to Application Manager > List of Agents and click Register new Agent.
  2. Provide a name and register a new agent.
2. Generate the agent configuration file:
  1. Select Generated by MANTA option and click Generate.
  2. Download the generated config.zip file.

Installing MANTA Flow Agent

Install a MANTA Flow Agent on the same workstation as the SAP BusinessObjects instance.

Start the installer.
Select the clean installation mode and specify the installation directory.
Specify the path to the agent configuration .zip file that you downloaded earlier.
Specify the agent configuration values:
- Artemis host: the host name of the MANTA Artemis service that you exposed in Red Hat OpenShift.
- Artemis port: the TCP port number of the MANTA Artemis service that you exposed in Red Hat OpenShift.
- AgentId: leave the default value.

Create a connection to SAP BusinessObjects

To create the connection asset, you need the following connection details:

Hostname or IP address: The hostname or IP address of the SAP BusinessObjects server.
Server port: The port to connect to the SAP BusinessObjects server.
Rest API port: The port for SAP BusinessObjects HTTP requests.
Extracted documents: A list of SAP BusinessObjects documents to extract, separated by comma. To extract all documents, leave the field empty.
Excluded documents: A list of SAP BusinessObjects documents to exclude from extraction, separated by comma.
SAP BusinessObjects installation path: The path to the installation folder of SAP BusinessObjects. Escape folder separators, for example C:\\Program Files (x86)\\SAP BusinessObjects\\SAP BusinessObjects. If Client Tools is not installed, leave this field empty.
Extraction agent: The ID of the MANTA agent used for the extraction process. You can find the value in MANTA Automated Data Lineage in Application Manager > List of Agents.
Username: The username for accessing the SAP BusinessObjects server.
Password: The password associated with the specified username.
Authentication method: The authentication method that is used to connect to the SAP BusinessObjects server. The default method is secEnterprise.
SSL certificate (if required by the database server)

Choose the method for creating a connection based on where you are in the platform

In a project: Click Assets > New asset > Prepare data > Connect to a data source. See Adding a connection to a project.

In a catalog: Click Add to catalog > Connection. See Adding a connection asset to a catalog.

In the Platform assets catalog: Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

In a project, create and run a metadata import with the Get BI report lineage goal to add assets to a catalog. For more information, see Getting lineage for business intelligence reports.

Federal Information Processing Standards (FIPS) compliance

The SAP BusinessObjects connection cannot be created in a FIPS environment.

Restriction

You can use this connection only for source data. You cannot write to data or export data with this connection.

Supported file types

The SAP BusinessObjects connection supports these file types: business intelligence reports, business intelligence report queries, and business intelligence report query items.

Learn more

SAP BusinessObjects 4.3 SP2 documentation

Parent topic: Supported connections