Configuring the Domain Relationship Extractor task

Use the Domain Relationship Extractor system task to extract parent–child relationships between domains. Only domains under Domains, Services & Applications are collected.

Domain relationships are directed connections between two domains. Each relationship connects a parent domain and a child domain. These relationships describe how domains are logically structured within the Workspace hierarchy.

After the first successful task run, the domain_relationship table is created in the database. 

To configure the Domain Relationship Extractor task:

1. Navigate to Administration > ETL & System Tasks > System tasks.
2. In the System tasks table, locate the Domain Relationship Extractor task.
3. To run the task immediately, click Run active configuration.
4. To schedule the task, click Schedule. 
5. To change the frequency or start time, click Edit task. To edit the task, see Managing ETL and System tasks.
6. In the Run History table, verify that the Last exit column displays OK.

The Domain Relationship Extractor task stores extracted parent‑child domain relationship data in the domain relationship table. This data is maintained in the database and is updated on each successful task run. To view and query the table contents, create a SQL datamart.

To create a SQL datamart for domain relationships:

1. Navigate to Administration > Data Marts.
2. Click Add > Data Mart based on SQL.
3. In Primary entities field, select Domains. 
4. In the SQL query field, enter select * from domain_relationship.
5. Save and run the datamart.

Domain relationship table:

Column	Description
entid	The unique identifier of the domain.
entname	The name of the domain.
enttypeid	The type of the domain.
parent_id	The unique identifier of the parent domain. A value of 0 indicates a top-level domain with no parent.
parent_name	The name of the parent domain.
parent_typeid	The type of the parent domain.