string department(sql) to reference department(mv) RRS feed

  • Question

  • In the person object, I have a department reference attribute. I need to flow the department values from a sql table to FIM department reference attribute. In the  CONFIGURE ATTRIBUTE FLOW, I have dept(sql- reference) to dept(reference - Type direct/object type - person). but how can I let FIM know the flow is of department object?
    Friday, February 14, 2014 9:59 PM

All replies

  • If it is a reference in SQL, it can be resolved by Management Agent.

    In its Properties, in Configure Columns section, find the attribute you want to specify as reference, select it and click Edit button. Then tick that this column is "Reference":

    Then, just flow directly this value to metaverse's reference attribute.

    You have to have referenced object also available in the table/view that is accessed by this MA. According to TechNet Article:

    If a reference column is used, you must also use a single anchor column. In certain cases, to guarantee a unique object identifier, you must also create a separate column that contains an identifier (such as employeeID) with an additional column containing the object type.

    Please see here:

    Keep trying

    • Edited by Dominik Trojnar Saturday, February 15, 2014 9:47 AM
    • Proposed as answer by MKołódź Saturday, February 15, 2014 7:10 PM
    Saturday, February 15, 2014 9:05 AM
  • I have that already. After FI, the preview has the import atribute flow - final value as deleted.

    a)The object type of the anchor(person) is different from that of this reference attribute(department). Does it matter?

    b)searching the connector space of the sql ma, I could see a place holder for the department object.

    Monday, February 17, 2014 6:34 PM