Connecting to BW Systems

On the Metadata Extractions page, you can create a connection for a BW system (SAP BW∕4HANA, SAP BW 7.5, or SAP Datasphere, SAP BW bridge) to the catalog. By connecting to the catalog, objects in the BW systems become available for discovery in the catalog.

Make sure that your BW system is ready to be connected to the catalog by checking that certain setup activities have already been completed. For example, the BW system connection to SAP Datasphere has been configure correctly and that you have a user account with the appropriate access permissions.

Prerequisites for SAP Datasphere, SAP BW bridge Systems

Before connecting your SAP Datasphere, SAP BW bridge system to the catalog, make sure that the following prerequisites are satisfied. You can access the full documentation set on the SAP Help Portal: SAP Datasphere, SAP BW bridge.

Prerequisite

Learn more

Obtained a user account that has access permission to the space where the connection exists and is assigned the SAP_DW4_BC_MODELING_DWC_PC business catalog to access InfoAreas and objects.
SAP Datasphere documentation:
SAP Datasphere, SAP BW bridge documentation:

Consented to let SAP Datasphere run the synchronize schedule that you set up.
SAP Datasphere documentation:

Configured OpenID Authentication to be able to create the synchronize schedule.

Getting Started with SAP Datasphere, SAP BW bridge documentation:

Prerequisites for SAP BW∕4HANA

Before connecting your SAP BW∕4HANA system to the catalog, make sure that the following prerequisites are satisfied. You can access the full documentation set on the SAP Help Portal: SAP BW∕4HANA.

Prerequisite

Learn more

Implemented SAP Note 3601550 Information published on SAP site into your systems and checked that you're on SAP BW∕4HANA 2023 SPS 4 or newer, so that all supported system objects are visible in the catalog.
SAP for Me:

Obtained a user account that is assigned a role with the appropriate permissions to access InfoAreas and objects.
SAP BW∕4HANA documentation:

As a best practice, set up the live data connection to use the single sign on authentication method (Authentication Method is set to SAML Single Sign On).

If you chose the user name and password method, check the following settings are used:

  • Authentication Method is set to User Name and Password.

  • Save this credential for all users on this system option is selected.
SAP Datasphere documentation:

Configured the Cloud Connector with required resources for metadata extraction.
SAP Datasphere documentation:

Consented to let SAP Datasphere run the synchronize schedule that you set up.
SAP Datasphere documentation:

Prerequisites for SAP BW

Before connecting your SAP BW 7.5 system to the catalog, make sure that the following prerequisites are satisfied. You can access the full documentation set on the SAP Help Portal: SAP Business Warehouse, powered by SAP HANA.

Prerequisite

Learn more

Checked that you're on SAP BW 7.5 SPS 33 or newer so that all supported system objects are visible in the catalog.
SAP for Me
SAP BW 7.5 documentation:

Obtained a user account that is assigned a role with the appropriate permissions to access InfoAreas and objects.
SAP BW 7.5 documentation:

As a best practice, set up the live data connection to use the single sign on authentication method (Authentication Method is set to SAML Single Sign On).

If you chose the user name and password method, check the following settings are used:

  • Authentication Method is set to User Name and Password.

  • Save this credential for all users on this system option is selected.
SAP Datasphere documentation:

Configured the Cloud Connector with required resources for metadata extraction.
SAP Datasphere documentation:

Consented to let SAP Datasphere run the synchronize schedule that you set up.
SAP Datasphere documentation:

Next Steps

After you check the prerequisites for your BW system, you're ready to connect it to the catalog (see Manually Connecting a BW System).