Manually Connecting an SAP Datasphere System

For a standalone SAP Datasphere setup, you can manually connect your SAP Datasphere system to the catalog. Once connected, the catalog will start monitoring the SAP Datasphere system for new, updated, or deleted assets.

Prerequisites

To manually connect a source system to the catalog, you must have a global role that grants you the following privileges:
  • Data Warehouse General (-R------) - To access SAP Datasphere.

  • Catalog System (CRUDE--) - To create, view, edit, and delete source system connections and manually synchronize source system.

The Catalog Administrator global role and the DW Viewer role template (used directly as a global role) applied together, for example, grant these privileges. For more information, see Privileges and Permissions and Standard Roles Delivered with SAP Datasphere.

Ensure you have the system identifier and login credentials for the user account used to authenticate the source systems and extract metadata (see Obtaining the System Identifier and User Credentials).

Context

These steps are for manually connecting an SAP Datasphere system for a standalone SAP Datasphere setup.

For SAP Business Data Cloud, source systems added to an SAP Business Data Cloud formation automatically connect to the catalog. By default, the authorized users aren't set up, and you can set them up by editing the source system on the Metadata Extractions page (see Setting Up the Authorized User for Metadata Extraction). For details on creating a formation, see the SAP Business Data Cloud documentation: Creating SAP Business Data Cloud Formations.

Procedure

  1. In the side navigation area, choose (Catalog & Marketplace)Start of the navigation path Next navigation step End of the navigation path (Metadata Extractions).
  2. In the Remote Systems table, choose Create.
  3. In the System Type field, choose Local SAP Datasphere or External SAP Datasphere.

    For the local SAP Datasphere, the system name and identifier are automatically entered. If needed, you can change the system name.

  4. For an external SAP Datasphere, do the following:
    1. In the Name field, type a name to identify the system.
    2. In the UUID field, enter the system identifier.
  5. Optional: To automatically publish objects from the source system to the catalog every time the catalog synchronizes with the source system, select the Enable Auto Publishing to the Catalog checkbox.
  6. Choose Authenticate.
    A dialog with instructions on how to authenticate the user for the source system appears. Follow the instructions for authenticating the source system user.
    1. In the Authenticate System User dialog, choose (Copy) to copy the link for authenticating the system user.
    2. Open a private browsing window and paste the link in the address bar.
    3. Log on to the system.
    4. After the source system user is authenticated and you see the confirmation message, close the private browsing window.
    5. When you are back on the Authenticate System User dialog, choose Confirm Authentication.
  7. Back on the Create System dialog, choose Create.

Results

Once added, the connection to the SAP Datasphere system appears in the Remote Systems table, and the catalog starts monitoring the source system for new, updated, or deleted assets. The catalog monitors the following object types:
  • Analytic Model

  • Data Flow

  • Graphical View

  • Intelligent Lookup

  • Local Table

  • Remote Table

  • Perspective

  • SQL View

For information on the supported object types, see the SAP Datasphere documentation: Acquiring, Preparing, and Modeling Data with SAP Datasphere.

In the Remote Systems table, you can choose the source system and use a tool from the toolbar to edit, manually synchronize, or delete the system.

To edit a system's connection settings, select the system in the list and choose Edit. You can perform any of the following tasks: review the source system details, including the system URL, change the user-defined system name, or reauthenticate the authorized user.

You can also choose (Navigation) to view the system details page that includes the system's extraction summary logs.

Next Steps

Now that the your system is connected to the catalog, what's next?
  • If the system already contains existing objects before you connect it to the catalog, and you want to add those objects as assets to the catalog, you'll need to manually synchronize the system. To do this, choose Synchronize from the toolbar (see Manually Synchronizing a System).

  • If you're interested in monitoring the success or failure of individual extractions and troubleshooting common errors during the extraction process, see Monitoring Metadata Extractions to learn more.

  • If you're responsible for enriching, classifying, and publishing objects extracted from these systems, see Governing Catalog Assets.