none
Write back to SQLMA RRS feed

  • Question

  • Hi

    we are provisioning mailboxes in a mail system in the cloud (not o365) and they have provided the MA and dll for that side of the sync.

    We are developing our side of the sync which is a local SQL database.

    We can sync our sql view into the metaverse, provision mailboxes on the cloud mail system successfully.

    However when it comes to populating the email field in the SQL view presented to the SQLMA we are stuck what to do next.

    I have configured attribute flow in the SQL MA. How do I enable provisioning the email addres field in our local SQL?

    Friday, December 23, 2016 10:18 AM

All replies

  • Jon-

    You'd likely want an import flow for the email address from the 3rd Party MA to the mail attribute in the metaverse, and then an export flow on your SQL MA from the mail attribute in the metaverse to the column in your view. Note that if your view is complicated, SQL might not accept the update to it. In that case, you'll need to write an INSTEAD OF trigger on the view to accept the write.


    Thanks,
    Brian

    Consulting | Blog | AD Book

    Saturday, December 24, 2016 2:04 AM
    Moderator