Note that if you are using version 1.6.0, or newer, this service is not available. The 'Export in Relational data' service located in the 'Data model' table allows you to export metadata as a relational tables. Then, you can export the relational tables in XML format or as an Excel spreadsheet with the add-on for Excel. This allows you to use a third party tool to query and handle information contained in the table. The relational table containing the metadata is located in the 'Information Governance - export' data space.
'Data model documentation' is a normalized data model used to handle the data from data hierarchy views as illustrated below. Since this is also a relational data storage mode, you can query using SQL third party tools.
From the 'Field' table, the 'View by tables and fields' data hierarchy view allows you to get a list of the Administered Items by tables and fields.
Special notation: | |
---|---|
In relational mode, the size of a string is limited (2,000 characters in Oracle). Any definitions over this size are truncated. |