none
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.

    2018년 5월 16일 수요일 오후 11:35

모든 응답

  • 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

    2018년 5월 17일 목요일 오전 7:06
  • 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:

    • 편집됨 EricR-82 2018년 5월 17일 목요일 오후 3:42
    2018년 5월 17일 목요일 오후 3:36
  • 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

    2018년 5월 18일 금요일 오전 6:06
  • 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.
    2018년 6월 15일 금요일 오후 9:27