• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.