Set up SAP Datasphere Catalog

Warning Because these tasks are performed outside of Collibra, it is possible that the content changes without us knowing. We strongly recommend that you carefully read the source documentation.

1 Prepare SAP Datasphere Catalog

  1. In SAP, on the SAP Datasphere homepage, click Catalog > Monitoring.



    The Remote Systems page opens.
  2. Above the list of systems, click +.

    The Create System dialog box appears.
  3. Enter the required information.

    FieldDescription
    System Type

    The type of system you want to synchronize. In this case, select Local SAP Datasphere or External SAP Datasphere.

    Note You can add as many SAP Datasphere systems as you want, but there can only be one local SAP Datasphere system.

    Name

    The name of your SAP Datasphere tenant.

    Tip To find the name, go to Administration > Info as a System Administrator.
    UUID

    The UUID of your SAP Datasphere tenant.

    Tip To find the UUID, go to Administration > Info as a System Administrator.
  4. Click Authenticate Now.

  5. Select the system you created and click Synchronize System.
  6. Optionally, edit the system and change the name.
    The name of the system will be the name of the SAP Tenant asset in Collibra.

2 Optionally, synchronize SAP Analytics Cloud data in SAP Datasphere Catalog

Important You have to carry out this step if you want to include the metadata of one or more SAP Analytics Cloud systems in your integration.

Note You need to be the System Owner of the SAP Analytics Cloud system that you want to synchronize.

  1. In SAP, on the SAP Datasphere homepage, click Catalog > Monitoring.

    The Remote Systems page opens.
  2. Above the list of systems, click +.
    The Create System dialog box appears.
  3. Enter the required information.
    FieldDescription
    System TypeThe type of system you want to synchronize. In this case, SAP Analytics Cloud.
    Name

    The system name of the SAP Analytics Cloud system you want to synchronize.

    Tip To find the system name, on the SAP Analytics Cloud homepage, click System > About. In the About dialog box, you need the value in the System Name field.

    UUID

    The system UUID of the SAP Analytics Cloud system you want to synchronize.

    Tip To find the system UUID, on the SAC homepage, click System > About. In the About dialog box, you need the value in the System UUID field.

  4. Click Authenticate Now.
    All SAP Analytics Cloud data is synchronized to SAP Datasphere Catalog.
  5. Click Create.
  6. Select the system you created and click Synchronize System.
  7. Optionally, edit the name of the system and give it a meaningful name.
    The name of the system will be the name of the SAP Tenant asset in Collibra.

3 Ensure that the assets you want to integrate are published

Collibra Data Lineage can only ingest assets in SAP Datasphere Catalog that are published. Therefore, you need to ensure that all of the assets in SAP Datasphere Catalog that you want to integrate are published. You need at least one published asset for the APIs to work.

  1. In SAP, on the SAP Datasphere homepage, click Catalog > Catalog.

    The Catalog page opens.
  2. Ensure that the assets you want to integrate have publication status Published. If they do, there's nothing more to do. If they don't, proceed to the next step.
    1. Click the Assets checkbox, to select all assets.
      Important You can publish only assets with functional status Current.
    2. In the Publish Actions drop-down list, click Publish.
Tip 

You enable or disable the Auto Publish feature at the system level. By default, this feature is disabled.

  1. In SAP, on the SAP Datasphere homepage, click Catalog > Monitoring.

    The Remote Systems page opens.
  2. Select the system for which you want to enable auto-publication.
  3. Above the list of systems, click .
    The Edit System dialog box appears.
  4. Select the Enable Auto Publishing to the Catalog option.
  5. Click Save.
    Any unpublished assets in the system are automatically published.

4 Configure a new OAuth client

Note You need to be an Administrator in SAP Datasphere to perform this action.

  1. In SAP, toward the bottom of the SAP Datasphere homepage, click System > Administration.

  2. Click App Integration.

  3. In the OAuth Clients section, below the Configured Clients, click Add a New OAuth Client.

    The New OAuth Client dialog box appears.
  4. Enter the required information.
    FieldDescription
    NameThe name of the new OAuth client. This can be anything, as long as it is unique.
    OAuth Client IDThe ID is generated when the OAuth client is created.
    Purpose

    In the drop-down list, select API Access.

    Access

    In the drop-down list, select Catalog User API.

    Authorization GrantIn the drop-down list, select Client Credentials.
    SecretThe secret is generated when the OAuth client is created.
    Token Lifetime

    The amount of time that the server login session remains open while Edge is communicating with SAP Datasphere Catalog.

    During the token lifetime, you need to build your Edge connection, configure your Edge capability, and start the integration. But after that, Collibra keeps the token alive.

    The maximum value is 1440 minutes (1 day).

  5. Click Add.
  6. Copy the following information: oAuth token URL, oAuth Client ID, oAuth secret. You will need this information when you configure your connection and capability in Collibra.

5 Ensure that certain endpoints are allowed

Note You need to be an Administrator in SAP Datasphere to perform this action.

Ensure that the following endpoints are allowed:

Endpoint Comments
*.hanacloud.ondemand.com  
*.k8s-hana.ondemand.com  
The token URL: <tenant>.authentication.usxx.hana.ondemand.com
Note In the URL, "uxxx" can also be "euxx".
  1. In SAP, toward the bottom of the SAP Datasphere homepage, click System > Administration.

  2. Click App Integration.

    The App Integration page opens. There you'll find the token URL.
System URL: <tenant>.usxx.hcs.cloud.sap
Note In the URL, "uxxx" can also be "euxx".
  1. In SAP, on the SAP Datasphere homepage, click Catalog > Monitoring.

    The Remote Systems page opens.
  2. Click the relevant local or external SAP Datasphere system.

    The details page opens. There you'll find the system URL.

What's next?

You can prepare Edge for the integration.