SQL Database Connector Howto


  • I have a SQL database and a table named people with columns EmployeeID,FirstName,LastName,AccountName,Password. I want users details and passwords to be exported to this SQL server. I would like the synchronization to be one way. If, for some reason, someone adds a record to the table, I don't want a user to be created in Identity Manager.

    I am having a hard time figuring out how to accomplish this.

    Wednesday, May 16, 2018 11:35 PM

All replies

  • Hi EricR-82,

    Do you mean that you want to use connector to SQL DB for export only? Configure MA only for that and turn off in SQL MA projection of objects.

    Emil Valiev

    Thursday, May 17, 2018 7:06 AM
  • Yes, I want to export only. However the user objects don't get exported. Here is the configuration for the SQL Management Agent.

    Synchronization Rules in the IdentityManager portal:

    • Edited by EricR-82 Thursday, May 17, 2018 3:42 PM
    Thursday, May 17, 2018 3:36 PM
  • In Synchronization Rule on General tab you selected the first Applied Rule. In that case you should also use triple - MPR, set and workflow. Did you create them?

    Emil Valiev

    Friday, May 18, 2018 6:06 AM
  • Thanks for looking at this, but unfortunately I have been tasked with something else and cannot come back to this at this time. I would remove the question, but do not know how.
    Friday, June 15, 2018 9:27 PM