Synchronize SAP Datasphere Catalog

After you have prepared your Edge or Collibra Cloud site, you can configure and start the synchronization. To use the unified SAP Datasphere Catalog integration, you need:

Synchronizing SAP Datasphere Catalog is the process of integrating metadata from the systems connected to SAP Datasphere Catalog and making the metadata available in Collibra. You can either synchronize manually or automate the process by adding a synchronization schedule.

Before you synchronize, you have to configure the integration settings to specify the metadata that you want to integrate. Separate tabs on the Integration Configuration page in Data Catalog allow you to include metadata from the following data sources:

Tip When configuring the integration, you are required to select a default domain, and optionally, configure domain mappings. If you want to create new target domains for the ingested assets, review the integration steps overview for guidance on required domain types.

Prerequisites

In your Collibra environment:

Steps

  1. On the main toolbar, click Products icon Catalog.
    The Catalog homepage opens.
  2. In the tab bar, click Integrations.
    The Integrations page opens.
  3. Click the Integration Configuration tab.
  4. Locate the SAP Datasphere Catalog connection that you used when you added the SAP Datasphere capability and click the link in the Capabilities column.
    The synchronization configuration page opens.
  5. In the center of the page, click Add Configuration.
  6. Select a data source to configure the relevant integration settings: Enter the required information.
    FieldActionRequired?
    SAP Datasphere System Name

    Specify the SAP Datasphere system name.

    • The name you specify must be unique across all your SAP integration configurations in Collibra.
    • System names are not case-sensitive in SAP Datasphere Catalog.

    To add another SAP Datasphere system to the integration, click + Add Item.

    Yes

    Default Domain

    Specify the Collibra domain in which you want to integrate your tenant and space assets. Collibra will create a new domain per SAP space in the same community as the domain you specify.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    Yes

    SAP Datasphere Space IDs

    Use this filter to ingest assets only from one or more specified SAP Datasphere spaces.

    If you don’t specify any IDs:

    • Assets from all spaces are integrated.
    • Separate domains are created for each SAP space, with the name of the space.

    No

    Space ID

    Specify the space ID from which you want to ingest assets.

    To specify more than one space, click + Add Space ID.

    You can find the space IDs in the Space Management tab in SAP. The IDs are shown in bold in the following example image.

    Yes

    FieldActionRequired?
    SAP Analytics Cloud System Name

    Specify the SAP Analytics Cloud system name.

    • The name you specify must be unique across all of your SAP integration configurations in Collibra.
    • System names are not case-sensitive in SAP Datasphere Catalog.

    To add another SAP Analytics Cloud system to the integration, click + Add Item.

    Yes

    SAP Analytics Cloud URL

    Specify the SAP Analytics Cloud system URL.

    Note The URL that you specify is used to create a direct link between Collibra and SAP Analytics Cloud. Collibra cannot verify that the URL you have specified is correct. If it is incorrect, the links to SAP Analytics Cloud, as included on SAC Story and SAC Data Model asset pages in Collibra, will be broken.

    Yes

    Default Domain

    Select a default domain. This is the domain in which assets are ingested if you don't configure one or more domain mappings, as described below.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    Yes

    Domain include mappings

    Use mappings to ingest assets from specified containers and folders into specified Collibra domains.

    To add more than one mapping, click + Add Domain include mapping.

    Tip For ideas on how to effectively configure mappings, see example mappings and results below.

    No

    Path

    Specify the path to the SAP Analytics Cloud container or folder to be integrated.

    • Currently, you can only filter on system containers, meaning Public, Private, System, or one of the workspaces. To filter on Public, enter the path Public/*. This ingests everything in the Public container.
    • If you filter on a workspace, do not include "WORKSPACE" as part of the folder path. If you do, synchronization will fail.

    Yes

    Domain

    Select the domain in Collibra in which you want to ingest the metadata.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    No

    FieldActionRequired?
    Default Domain

    Select a default domain. This is the domain in which glossary terms are ingested if you don't configure one or more glossary mappings.

    If you don't configure one or more glossary mappings, all terms from all glossaries are ingested in this domain.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    The + Add Item button is currently not relevant.

    Yes

    Glossary Mappings

    Use mappings to ingest terms from specified glossaries into specified Collibra domains.

    To add more than one mapping, click + Add.

    No

    Glossary

    Specify the name of the glossary from which to ingest terms.

    • The name you specify must be unique across all your glossary mappings.
    • Glossary names are not case-sensitive in SAP Datasphere Catalog.

    Yes

    Domain

    Specify the Collibra domain in which you want to integrate the glossary terms.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    No

  7. Click Save.
  8. Click Synchronize.
    A notification indicates the synchronization has started.
  1. On the main toolbar, click Products icon Catalog.
    The Catalog homepage opens.
  2. In the tab bar, click Integrations.
    The Integrations page opens.
  3. Click the Integration Configuration tab.
  4. Locate the SAP Datasphere Catalog connection that you used when you added the SAP Datasphere capability and click the link in the Capabilities column.
    The synchronization configuration page opens.
  5. In the Synchronization Configuration section, click Add Configuration.
  6. Select a data source to show the relevant integration settings: Enter the required information.
    FieldActionRequired?
    SAP Datasphere System Name

    Specify the SAP Datasphere system name.

    • The name you specify must be unique across all your SAP integration configurations in Collibra.
    • System names are not case-sensitive in SAP Datasphere Catalog.

    To add another SAP Datasphere system to the integration, click + Add Item.

    Yes

    Default Domain

    Specify the Collibra domain in which you want to integrate your tenant and space assets. Collibra will create a new domain per SAP space in the same community as the domain you specify.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    Yes

    SAP Datasphere Space IDs

    Use this filter to ingest assets only from one or more specified SAP Datasphere spaces.

    If you don’t specify any IDs:

    • Assets from all spaces are integrated.
    • Separate domains are created for each SAP space, with the name of the space.

    No

    Space ID

    Specify the space ID from which you want to ingest assets.

    To specify more than one space, click + Add Space ID.

    You can find the space IDs in the Space Management tab in SAP. The IDs are shown in bold in the following example image.

    Yes

    FieldActionRequired?
    SAP Analytics Cloud System Name

    Specify the SAP Analytics Cloud system name.

    • The name you specify must be unique across all of your SAP integration configurations in Collibra.
    • System names are not case-sensitive in SAP Datasphere Catalog.

    To add another SAP Analytics Cloud system to the integration, click + Add Item.

    Yes

    SAP Analytics Cloud URL

    Specify the SAP Analytics Cloud system URL.

    Note The URL that you specify is used to create a direct link between Collibra and SAP Analytics Cloud. Collibra cannot verify that the URL you have specified is correct. If it is incorrect, the links to SAP Analytics Cloud, as included on SAC Story and SAC Data Model asset pages in Collibra, will be broken.

    Yes

    Default Domain

    Select a default domain. This is the domain in which assets are ingested if you don't configure one or more domain mappings, as described below.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    Yes

    Domain include mappings

    Use mappings to ingest assets from specified containers and folders into specified Collibra domains.

    To add more than one mapping, click + Add Domain include mapping.

    Tip For ideas on how to effectively configure mappings, see example mappings and results below.

    No

    Path

    Specify the path to the SAP Analytics Cloud container or folder to be integrated.

    • Currently, you can only filter on system containers, meaning Public, Private, System, or one of the workspaces. To filter on Public, enter the path Public/*. This ingests everything in the Public container.
    • If you filter on a workspace, do not include "WORKSPACE" as part of the folder path. If you do, synchronization will fail.

    Yes

    Domain

    Select the domain in Collibra in which you want to ingest the metadata.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    No

    FieldActionRequired?
    Default Domain

    Select a default domain. This is the domain in which glossary terms are ingested if you don't configure one or more glossary mappings.

    If you don't configure one or more glossary mappings, all terms from all glossaries are ingested in this domain.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    The + Add Item button is currently not relevant.

    Yes

    Glossary Mappings

    Use mappings to ingest terms from specified glossaries into specified Collibra domains.

    To add more than one mapping, click + Add.

    No

    Glossary

    Specify the name of the glossary from which to ingest terms.

    • The name you specify must be unique across all your glossary mappings.
    • Glossary names are not case-sensitive in SAP Datasphere Catalog.

    Yes

    Domain

    Specify the Collibra domain in which you want to integrate the glossary terms.

    Important Ensure that the domain you specify is not used for another SAP Datasphere synchronization. Any single Collibra domain can be the target domain of only one synchronization.

    No

  7. Click Save.
  8. In the Synchronization Schedule section, click Add Schedule.
  9. Enter the information.
    FieldDescription
    RepeatThe interval when you want to synchronize automatically. The possible values are: Daily, Weekly, Monthly, and Cron expression.
    Cron

    The Quartz Cron expression that determines when the synchronization takes place.

    This field is only visible if you select Cron expression in the Repeat field.

    Every

    The day on which you want to synchronize, for example, Sunday.

    This field is only visible if you select Weekly in the Repeat field.

    Every first

    The day of the month on which you want to synchronize, for example, Tuesday.

    This field is only visible if you select Monthly in the Repeat field.

    At

    The time at which you want to synchronize automatically, for example, 14:00.

    • You can only schedule on the hour. For example, you can add a synchronization schedule at 8:00, but not at 8:45.
    • This field is only visible if you select Daily, Weekly, or Monthly in the Repeat field.
    Time zoneThe time zone for the schedule.
  10. Click Save

Domain mappings and results

Domain include mappings are essentially filters that allow you to specify the SAP Analytics Cloud containers and folders from which you want to ingest assets. You use the Path field to specify the path to the relevant containers (folders and workspaces), and the Domain dropdown list to select the domain in Collibra in which you want to ingest the assets.

Important considerations:

Examples

The following filter paths and results refer to the example data structure shown above.

What's next

The synchronization job integrates the metadata.

After the synchronization: