Export Metadata¶

To export the metadata, go to Administration > Import / Export > Export. The Export dialog will appear.

Dialog to export Data Catalog’s metadata¶

By default, it will export all the Virtual DataPort servers registered in the Data Catalog, together with its catalog metadata:

• Databases

• Views

• Web services

• Categories

• Tags

• Custom properties

• Saved queries

• Usage statistics

• Endorsements, warnings and deprecations

You can choose additional settings to be exported by checking the corresponding options:

• Content search settings

• Personalization settings

• Kerberos settings

• Permissions settings

• Recommendation data

• Requests data

• Email settings

• Assisted query settings

By default, Data Catalog encrypts sensitive data within the export file using a fixed export key, so every installation is able to import the metadata. This makes it easier to transfer the settings from one server to another but it can be considered a security risk. You can change this export key with the configure_datacatalog_export_key script. This way, only those Data Catalog that have configured the same export key will be able to import the metadata. In addition, you can specify a custom export key for a particular export file:

1. Enable the option Use custom password for sensitive data encryption.

2. Enter the custom export key in the Custom password field.

3. Enter the custom export key again in the Confirm custom password field.

You will need to provide the custom export key when importing this export file. Otherwise, the import will fail.

Import Metadata¶

To import the metadata, go to Administration > Import / Export > Import. The Import dialog will appear.

Dialog to import Data Catalog’s metadata¶

Here you can drag-and-drop a metadata file previously exported or select one in the file chooser by clicking the drop area. If the Data Catalog already contains some metadata, you can override it by checking the Override existing metadata option.

If the export file was exported with a custom export key, you must provide it as follows:

1. Enable the option Use custom password for sensitive data encryption.

2. Enter the custom export key in the Custom password field.

Take this into account:

• To import the Kerberos settings or the recommendation data you need to check the Override existing metadata option.

• By default, importing the permissions settings will merge the permissions in the export file with the ones in your Data Catalog. If you check the Override existing metadata option, the permissions settings will be merged as well, except for the roles that are present both in the Data Catalog and in the export file, that will be replaced.