Synchronize SAP Datasphere

Important 

In Collibra 2024.05, we launched a new user interface (UI) for Collibra Data Intelligence Platform! You can learn more about this latest UI in the UI overview.

Use the following options to see the documentation in the latest UI or in the previous, classic UI:

Synchronizing SAP Datasphere is the process of integrating metadata from the databases connected to SAP Datasphere and making this metadata available in Collibra Data Intelligence Platform.
You can synchronize manually, or you can automate it by adding a synchronization schedule.

Before you begin

Requirements and permissions

  • The Edge user must have the following permissions:
    • The Edge site global role.
      Important Ensure that the Edge site global role has the Manage all resources global permission.
    • A resource role (for example, Owner) that has the following resource permissions, for the community or domain in which the assets are ingested:
      • Asset > Add
      • Asset > Attribute > Add
      • Asset > Attribute > Remove
      • Asset > Attribute > Update
      • Asset > Remove
      • Asset > Update
      • Asset > Update Status
      • Domain > Add
  • You have a resource role with the Configure external system resource permission, for example, Owner.
  • You have a global role with the Catalog global permission, for example, Catalog Author.
  • You have a global role with the View Edge connections and capabilities global permission, for example, Edge integration engineer.

Steps

  • Manually synchronize SAP Datasphere
  • Add a synchronization schedule
  1. On the main toolbar, click Products icon, and then click Catalog.
    The Catalog Home opens.
  2. In the tab bar, click Integrations.
    The Integrations page opens.
  3. Click the Integration Configuration tab.
  4. On the main toolbar, click .
    The Create dialog box appears.
  5. In the Register with Edge section of the Create dialog box, click Register a data sourceIntegration Configuration.
    The Register contentIntegration Configuration tab page opens.
  6. Locate the SAP Datasphere Catalog connection that you used when you added the SAP Datasphere synchronization capability and click the link in the Data sources/Capabilities column.
    The synchronization configuration page opens.
  7. In the Configuration SectionSynchronization Configuration section, click Add Configuration.
  8. Complete the fields as needed.
    FieldAction
    SAP Datasphere tenant domain

    Specify the domain in which you want to integrate your tenant and space assets. Collibra Data Lineage will create a new domain per SAP space in the same community as 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.

    SAP Datasphere Tenant ID

    Specify the Datasphere Tenant ID.

    You can find this ID in the SAP Datasphere Catalog > Monitoring tab. The Tenant ID is the same as the system UUID in Datasphere Catalog.

    SAP Datasphere Space ID

    Specify the SAP space IDs that you want to integrate.

    You can find the IDs in SAP Datasphere Space Management.
    If you don’t specify any IDs, we integrate everything and create separate domains for each SAP space with the name of the SAP space.

  9. Click Save Configuration.
  10. Click Synchronize.
    A notification indicates the synchronization has started.
  1. On the main toolbar, click Products icon, and then click Catalog.
    The Catalog Home opens.
  2. In the tab bar, click Integrations.
    The Integrations page opens.
  3. Click the Integration Configuration tab.
  4. On the main toolbar, click .
    The Create dialog box appears.
  5. In the Register with Edge section of the Create dialog box, click Register a data sourceIntegration Configuration.
    The Register contentIntegration Configuration tab page opens.
  6. Locate the SAP Datasphere Catalog connection that you used when you added the SAP Datasphere synchronization capability and click the link in the Data sources/Capabilities column.
    The synchronization configuration page opens.
  7. In the Configuration SectionSynchronization Configuration section, click Add Configuration.
  8. Complete the fields as needed.
    FieldAction
    SAP Datasphere tenant domain

    Specify the domain in which you want to integrate your tenant and space assets. Collibra Data Lineage will create a new domain per SAP space in the same community as 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.

    SAP Datasphere Tenant ID

    Specify the Datasphere Tenant ID.

    You can find this ID in the SAP Datasphere Catalog > Monitoring tab. The Tenant ID is the same as the system UUID in Datasphere Catalog.

    SAP Datasphere Space ID

    Specify the SAP space IDs that you want to integrate.

    You can find the IDs in SAP Datasphere Space Management.
    If you don’t specify any IDs, we integrate everything and create separate domains for each SAP space with the name of the SAP space.

  9. Click Save Configuration.
  10. In the Synchronization Schedule section, click Add Schedule.
  11. 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.
  12. Click Save

What's next?

The synchronization job integrates the metadata.
After the synchronization: