none
Manager reference in Soren PowerShell MA RRS feed

  • Question

  • Hi All,

    I get managerid as a string from our Authroritative source(SAP) .managerid is  employeeid of the manager and it is the anchor attribute. All the values are imported successfully but having issues with manager reference.

    If I define managerid as reference variable,mangerid gets deleted in CS. How do i add the manager reference ?

    Schema Script

    new-object -typename psobject -prop @{
        "anchor-EmployeeID|string" = ""
        "objectclass|string" = "user"
        "firstName|string" = ""
        "lastName|string" = ""
         "managerId|string"=""

    }

    Import Script

    foreach ($User in $UserData.Users.User)
        {
            
            $obj = @{}
            $obj.personIdExternal = $User.personIdExternal
            $obj."[ObjectClass]" = "user"
            $obj.firstName = $User.firstName
            $obj.lastName = $User.lastName
            $Obj.managerId=$User.managerId
            $obj
        }

    Any advise would be appreciated. Thanks!!

    Wednesday, August 14, 2019 9:05 AM

Answers

  • Thanks Guys,Forgot to update.Apologize. After I created a new MA it started working.
    • Marked as answer by sriniyk Friday, September 27, 2019 1:21 AM
    Friday, September 27, 2019 1:21 AM

All replies

  • The manager you are referring to would have to exist in the same connector space, i.e it would have to exist as a standard user before you could call it using the reference
    • Proposed as answer by Leo Erlandsson Wednesday, August 14, 2019 11:52 AM
    Wednesday, August 14, 2019 10:36 AM
  • Hi again,

    Are you using the Generic SQL Connector for the MA?  If you are you would set managerID as a reference in Schema 4 and then define the Partition for the reference attribute in Schema 5

    Regards,

    Rob

    Thursday, September 26, 2019 8:15 AM
  • Thanks Guys,Forgot to update.Apologize. After I created a new MA it started working.
    • Marked as answer by sriniyk Friday, September 27, 2019 1:21 AM
    Friday, September 27, 2019 1:21 AM