In Collibra 2024.02, we've launched a new user interface (UI) in beta 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:
The Physical Data Connector shows a table with a high-level overview of database information. The table has a tree-like structure that enables you to drill down to the column level of a database. It shows the connection between the physical data layer and the logical data layer and enables you to find Data Attribute assets that relate to individual Column assets.
Note In the Physical Data Connector, a Column asset is visible only if it has a parent Table asset and a parent Schema asset. For more details, go to Guided Data Stewardship operating model. A parent Database asset is not required.
You need the following permissions:
- You have a global role with the Catalog global permission, for example, Catalog Author.
- You have a global role with the Data Stewardship Manager global permission.
To open the Physical Data Connector, go to Stewardship → Physical Data Connector.
|
No. |
Name |
Description |
|---|---|---|
| 1 | Drop-down list | A drop-down list to filter on a specific database. |
|
2 |
Table menu |
The table menu contains buttons for actions you can perform on the table. |
|
A button to manage the columns shown. |
|
|
3 |
Table with database information |
A table that shows the content of the registered database and the connections between the physical data layer and logical data layer. |
|
Name
|
The name of the asset and the icon of the asset type. If you click on the asset, the asset page opens. To sort assets alphabetically, click on the column header. |
|
|
Data Classification
|
The data class of an asset. You can manually add, edit or remove the data class of a Column asset. You can also approve or reject suggested classes |
|
|
Data Attribute
|
The Data Attribute asset linked to the Column asset via relation type "Data Attribute represents / represented by Column". When you filter on a Data Domain or Data Entity, the other drop-down lists dynamically update to only show content that relates to your filter. You can select the Apply filter to all columns in the same table checkbox to use the same filters to link a Data Attribute to other Column assets in the same table.
Tip The physical data connector enables you to quickly connect Data Attribute assets to Column assets. However, you can also connect the physical data layer to the logical data layer via Data Catalog's asset pages by adding a relation of the type Data Attribute represents / represented by Column. |
|
|
Context
|
The context of the data. This field is read-only and is filled with the Data Domain asset and Data Entity asset related to the Data Attribute asset, if a relation exists. |
Physical Data Connector relation types
The Physical Data Connector enables you to easily connect the physical data layer to the logical data layer by filtering on the conceptual data layer.
The Physical Data Connector uses the following relation types to connect assets from the different data layers:
- Business Dimension (Data Domain) classifies / is classified by Asset (Data Entity)
- Business Asset (Data Domain) groups / grouped by Business Asset (Data Concept)
- Data Domain has subtype / is subtype of Data Domain
- Business Dimension (Data Concept) classifies Asset (Data Attribute)
- Data Entity contains Data Attribute
- Data Attribute represents Column
- Schema contains Table
- Table contains Column
