Exporting Custom Property Values

• Console
• CLI
• API

• 1. On the Home tab, click Data Assets.
  2. On the Data Assets page, from the list of data assets, select the data asset for which you want to enrich the metadata.
  3. In the data asset detail page, depending on the data asset, click the appropriate tab as follows:
     • Schemas for relational database
     • Buckets for Oracle Object Storage
  4. Select the schema or the bucket for which you want to export the custom property values.
  5. In the details page, click Export custom properties.
     Note
     
     To export at the data entity level, click the Data Entities tab of the schema or bucket and select the data entity for which you want to export the values. In the data entity details page, click Export custom properties.
  6. In the Export custom properties panel, select the object types for which you want to export the custom property values.
     The object types are displayed depending on the object level at which you're exporting. For example, for a relational database, if you're exporting at the schema level, you can select from the schema, data entities, or attributes object types. For Oracle Object Storage, if you're exporting at the bucket level, you can select from the bucket, data entities, or attributes object types

     After you select the object types, provide the following details to specify the location where the file is exported:

     • Compartment: Select the compartment of the Object Storage bucket.
     • Bucket: Select the bucket in which the exported file needs to be stored.
     • Filename: Enter the filename without an extension. If the specified file already exists in the bucket, it gets overwritten with the latest content.
  7. Click Export.

     An Excel file gets downloaded to the specified bucket. The name of the Excel file indicates the name of the object at which you clicked Export custom properties.

     The Excel file contains a ReadMe sheet and as many sheets as the types of objects that you selected to be exported. The ReadMe sheet includes details of the selected object types, the root object, the date and time of export, and so on. The subsequent sheets are named based on the object types. They contain the objects of that type with the custom properties associated with the objects, and their existing values, if any.

     In each of the object type sheet, enter values for the custom properties. While adding details to the Excel file, remember the following:

     • Don't change the Type, Object path, and Name columns—they're intended to provide you additional information.
     • Don't change the values in the Internal Key column, as the column is used to uniquely identify an object during import.

• This task isn't available in the CLI.

• This task isn't available in the API.