Creating Exports

Data Relationship Management provides several export types to output data in different formats.

The following table lists the export types for Data Relationship Management.

Export Type

Description

Usage Frequency

Output Formats

Hierarchy Export

Outputs a record for each node and its properties for hierarchies. This export can be used to create a parent-child type format or a basic list of hierarchy nodes.

High

File, Database Table

Hierarchy Export XML

Outputs nodes, their relationships, and properties from hierarchies in an XML format.

High

File

Generation Export

Creates a generation- or level-based format for nodes in hierarchies. Outputs a record for each node, its ancestor nodes, and their properties. This export type can be used to create a format where hierarchy relationships are represented as columns.

Medium

File

Compare Export

Compares two hierarchies and outputs a record for each node that met the comparison criteria. This export can be used to provide incremental changes to target systems.

Medium

File, Database Table

Difference Export

Compares two hierarchies and outputs a record for each difference found. This export can be used for reporting incremental changes to users.

Low

File

Version Export

Outputs a record for each node and its properties for an entire version. Hierarchy relationships and local properties are not available for this export type.

Medium

File, Database Table

Property List Export

Outputs a record for each item in the list of values for a property definition. This is a special use case export type.

Low

File

Property Lookup Export

Outputs a record for each key-value pair in the lookup table for a property definition. This is a special use case export type.

Low

File

Transaction Log Export

Outputs a record for each item in the transaction log that met the filter criteria. This export can be used for audit purposes.

Medium

File, Database Table

Merge Export

Outputs a record for each item in the merge log that met the filter criteria. This export is only applicable if the Merge feature is used.

Low

File