Importing hierarchical information

You can use Connector to import hierarchical information from a ODBC source. To import hierarchical information, a pair of tables is required. One table holds the child elements, the other parent element table holds the hierarchical information.

To categorize the parent element table:

  1. Create or import a table that holds the hierarchical information. It must contain the parent field, the child or ID field and, optionally, the weighting field.
  2. Create or import a table that holds the child elements. It must contain the ID field.
  3. Select the ID field of the child element table and set the Primary key column in the Properties to True.
  4. Set the type of the parent field in the Properties to IS_PARENT.
  5. Select the parent field and the child field and set the Primary key column in the Properties to True.
  6. Optionally, set the type of the Weight field in the Properties to IS_WEIGHT.
  7. Specify the relation between the parent elements of the parent table and the ID fields in the child table. The ID field of the child element table must be Master.

    The mappings of the child element table will be hierarchical, if the source provides adequate information.

    Note: The parent element table must be defined as a detail table.