Configure Organizational Attribute data connections

Use Organizational Attribute data connections to synchronize organizational attributes and people attributes.

Properties tab

Specify the Data Source that contains the external data that you want to synchronize.

Mappings tab

Specify which external data you want to synchronize and how.

Field Explanation and Tips
Assign attributes to Specify the organizational context to which you want to assign the attributes. This item must also exists in the external data source, otherwise no items are synchronized.
Look up on Specify the search method for organizational context in the external data.

Using data field

Specify the field or column in the external data that stores this search method.

Look up attribute on

Specify how to search for attributes in the external data. This allows you to use different designs of external data sources.

  • Row value:
    • In the Using data field field, specify the field or column in the external data that stores the name of the attributes.
    • In the And set value to field, specify the field or column in the external data that stores the value of the attributes.

    In this example, the data connection looks up Organizational Attributes by row value:

    • The data connection looks up the departments in the external data source by Name in the column Departments.
    • The data connection looks up the Organizational Attributes by row value. It looks in the column OA Name for its name and in the column OA Value for its value.

    This results in the following:

    • For the department Support, the data connection applies the Organizational Attribute City with value Chicago.
    • For the department Support, the data connection applies the Organizational Attribute Building with value Chrysler Building.
    • For the department Support, the data connection applies the Organizational Attribute MailingList with value ML_Support.
    • Etc.
  • Column name:
    • In the Using data field field, specify the column(s) in the external data that store the attribute information you want to synchronize. The selected column names are the names of the attributes.

    In this example, the data connection looks up Organizational Attributes by column name:

    • The data connection looks up the departments in the external data source by Name in the column Departments.
    • The data connection looks up the Organizational Attributes by column name in the columns City, Building and MailingList.

    This results in the following:

    • For the department Support, the data connection applies the Organizational Attributes Chicago, Chrysler Building and ML_Support.
    • For the department Sales, the data connection applies the Organizational Attributes London, Tower Bridge and ML_Sales.
    • For the department R&D, the data connection applies the Organizational Attributes Den Bosch, Head Quarters and ML_RnD.

Path separator

Specify the separator that is used in the external data. This field is only relevant if the data connection looks up on Name or Path + Name.

Allow updates/Allow deletes

Additional synchronization options that are particularly useful if you have synchronized the data connection before.

Diagnostics tab

View information about the previous synchronization, including its duration and the number of affected records.

See also