Generic SQL MA multi-valued anchor and DN? RRS feed

  • Question

  • I'm setting up the Microsoft Generic SQL MA for the first time using a table that has a multi-valued anchor. But I can't figure out how to configure the DN. If I set the "DN is Anchor" checkbox on the Connectivity tab, it doesn't let me select multiple attributes for the DN/anchor on the Schema 3 tab. So that's obviously not good. But if I don't check that box, it still doesn't let me select multiple attributes for the DN. So it appears the DN cannot be multi-valued. I don't have a unique, non-nullable, attribute in this table so is my only option to add one? Or are there other ways to configure the DN and/or anchor that I'm unaware of? I've always used the SQL Server MA in the past for this DB but the DB has been moved to MySQL so I'm using the Generic SQL MA. Thoughts?

    • Edited by StevenJ. _ Tuesday, April 17, 2018 5:42 PM
    Monday, April 16, 2018 11:11 PM

All replies

  • Hi,

    I have the same problem with multivalued attributes. I'm wondering if it need to be a Group as objecttype or not. Do you have a solution for this yet?

    Kindly Anne

    Tuesday, January 15, 2019 9:14 AM