Enterprise Data Catalog User Guide > Perform Asset Tasks > Export and Import of Custom Attributes
  

Export and Import of Custom Attributes

You can export all the custom attributes that are configured for asset types in a resource to a Comma-Separated Values (CSV) file and import the CSV file back into Enterprise Data Catalog.
The exported CSV file displays all the custom attributes, asset types, Axon glossaries, business glossary terms, and data domains that you selected during export. You can use the exported CSV file to assign or edit custom attribute values to multiple assets at the same time, view data domains that are associated with the assets, associate or edit Axon glossaries, and associate or edit business glossary terms. When you import the CSV file back into the catalog, the catalog updates the assets based on the attribute values that you specify in the exported CSV file.
For example, if relational tables in a resource called Finance_Department contains details about the payroll, you might want to assign a custom attribute to all the tables containing payroll information and search for the tables using the assigned custom attribute. You can export the custom attribute called Payroll to a CSV file. In the exported CSV file, you can assign the Payroll custom attribute to the tables that contain details about payroll and import the file into the catalog. The catalog updates the tables based on the attribute values you assigned in the exported CSV file.
Before you import, you can choose to configure email notifications to send an email notification on the import status. The email notification message contains a log file with the details of the import job.
After the import job is complete, Enterprise Data Catalog sends the email to the email address that you specify during the import job. You can send the email notification to more than one person. To send email notifications to multiple recipients, use a comma to separate the email address entries.

Export File Description

You can create a CSV file to assign or edit custom attributes values of multiple assets. You can also associate or edit business glossary terms and Axon glossaries of multiple assets. To edit multivalued custom attributes in the CSV file, enclose each value in double quotes and separate values using comma. The content of the CSV file needs to be in the same order and format that the import job requires. The CSV file must contain all the column headings. All the columns in a CSV file need not have values assigned.
The following table lists the default order of the columns, column headings, and the format for the values in the CSV file:
Column Heading
Column Value Description
ID
Object ID of assets in a resource.
Name
Specifies the name of the assets that you exported from a resource.
Class Type
Specifies the type of asset that you exported.
Title (Informatica Business Glossary)
Displays business glossary terms that are associated with the assets you exported. Use this column to edit or associate business glossary terms to assets.
Title (Informatica Axon)
Displays Axon glossaries that are associated with the assets you exported. Use this column to edit or associate Axon glossaries to assets.
Inferred and Accepted Data Domains
Displays data domains that are inferred or accepted for the assets you exported. Do not edit the values of this column.
Custom Attribute Name
Specifies the name of the custom attribute. Use this column to edit or assign custom attributes to assets.

Exporting Custom Attributes

You can export custom attributes to a Comma-Separated Values (CSV) file.
    1. From the overview tab of a resource, open the menu () and select Export.
    The Export Custom Attributes window appears.
    2. Select the asset types that you want to export along with custom attributes. Optionally, select the Select Asset Types check box to export all asset types that are in the resource.
    3. Click Next.
    The Export Custom Attributes window displays a list of custom attributes that are configured in the resource.
    4. Select the custom attributes that you want to export.
    5. Click OK.
    Note: Do not edit or modify the values of the custom attributes that are not applicable in the exported CSV file.

Importing Custom Attributes

You can import a CSV file into Enterprise Data Catalog after you make the required changes to the exported CSV file.
    1. From the overview tab of a resource, open the menu () and select Import.
    The Import Custom Attributes window appears.
    2. Click Browse to select the CSV file you want to import from the local machine. Optionally, to import the file, you can drag and drop the CSV file into the dotted rectangle in the Select file to import section.
    3. Click Next.
    4. To receive notifications on the import status, select the Send email notification check box and enter a valid email address in the address field. Enter multiple email addresses separated by a comma.
    Note: You must enable the Receive Alerts through Email option for the catalog service and enable email service in the Informatica Administrator to receive notification on the import status.
    5. Click OK.
    6. Optionally, choose to allow the import job to run in the background, or click OK to submit the import job.
    The Enterprise Data Catalog sends you a notification after the import job is complete and updates assets based on the attribute values that were assigned in the exported CSV file.