Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Can process automation query Active Directory

2 Replies

1 Subscribed to this topic

53 Subscribed to this forum

Sort:

Author

Messages

Shane Jones

Veteran Member

Posts: 460

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?

KK - Infor

Veteran Member

Posts: 61

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: 110

New Poster

Engaged Reader

Avid Reader

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...ap-from-plsql-9i.php)

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