Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Can process automation query Active Directory

 2 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Shane Jones
Veteran Member
Posts: 460
Veteran Member
7/11/2014 9:30 PM
    Can process automations query Active Directory...   We have some information in Active Directory that we need to pull into Lawson and I was hoping to have process flow query the Active Directory but I was informed that Active Directory does not store in an SQL database...

    Anyone know?
    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    KK - Infor
    Veteran Member
    Posts: 61
    Veteran Member
    7/11/2014 10:28 PM
      Yes Shane, you can.
      'For example:
      ldapsearch -D cn=$admin -w $admin-password -h $tds_host -p 389 -b "ou=resources,o=lwsnrmdata,o=lwsn,dc=genesishealth" cn=10002019 zzlwsnattrRole

      Will return every Role that user 10002019 has been assigned.'

      This has been shared in detail in this post.
      https://www.lawsonguru.co...dap-from-sql-server/

      Hope this helps!
      Carl.Seay
      Veteran Member
      Posts: 109
      Veteran Member
      7/28/2014 1:03 PM
        For an Oracle database, you could use DBMS_LDAP to write a stored procedure, which could be called from IPA. (http://www.oracle-base.co...p-from-plsql-9i.php)

        I would assume there's something similar for SQL Server.