• separate multiple addresses with a comma.

Upserting Assets: External IDs & Names

374 Enrolled | 962 Completed

About this course

Instructor: Steven Woods, Solution Architect

Course Objectives:

  • Evaluate design choices for upserts by external entity ID or by name
  • Determine whether new asset will be created or an existing asset updated when performing upserts
  • Decide separator, case and structure prior to loading data

In this course, we will review upserts and the design choices you need to consider before you begin integration work. When integrating DGC with external applications, it’s important to evaluate whether to use the upsert with an external entity ID or by name. Both options perform the same basic function, but the difference is how DGC determines if a new asset is to be created or updating an existing asset in place.

Some important considerations when completing updates within the DGC from an external process include validating all loaded metadata assets to ensure that the name and/or external ID are unique for that domain. Governance staff should work closely with source system owners to understand the system and be involved with any upgrades in the source system prior to release. Integration developers should fully understand how system IDs are created and managed within the source system. This is part of the criteria to adopt for successful and consistent upserts with external applications and DGC integrations.

Collibra makes it easy for data citizens to find, understand and trust the organizational data they need to make business decisions every day. Unlike traditional data governance solutions, Collibra is a cross-organizational platform that breaks down the traditional data silos, freeing the data so all users have access.

©2022 Collibra. All Rights Reserved.


Not recently active