infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Technology Customer Community [READ ONLY]
Synchronize Lawson S3 HR with Microsoft Active Directory
tom
Does anyone use the Decision Analytics " Examiner for Lawson S3" for this or now anything about this product.
Is there any other automated or bolt on products to do this? Just looking for the best product for the $$.
Examiner looks to do the job but was looking for any feed back on this product.
Find more posts tagged with
Infor Lawson Technology Group - Discussion
Comments
unknown
I am looking for a way to dump out the Lawson LDAP user entries in an automated fashion (from script / command line) so we can load into SQL and run our own integrity checks but unfortunately don't have the budget to purchase Examiner S3. If anyone is doing this on their own I would like to hear about what extract method you are using. Thanks.
moellerg
We are doing this, for LBI reports... Are you Unix or Windows?
I'll attach a Unix script that should give you an idea.
unknown
We use Pentaho Data Integration to do this. It is an open source ETL tool. I gave a talk on our process at Inforum. Slides should be posted soon and you can look for LAWSC-3716C. If you are interested in Pentaho you can email me at Nathan.Smith@olathehealth.org and I'll send you the transformations we use. You would have to modify them for your environment.
unknown
Thanks for the info Greg. We are windows but have MKS and LUU. Whose program is "/usr/bin/ldapsearch"? Nathan I will shoot you an email.
tom
Greg M , we are on UNIX (AIX). I would like to see the Unix script for synchronizing MS Active Directory with HR data.
moellerg
@jjotoole
ldapsearch is available with OpenLDAP
http://www.openldap.org/
or just about any implementation of LDAP includes some sort of search utility... maybe not exactly called ldapsearch?
@Greg
Yoder - are you looking for ways to say update the AD with HR11 email addresses, and other related info or possibly the other way around?
Let me do some more digging, I think I can share an example of something like that.
moellerg
@jjotoole
: If you are proficient with Perl, and can download Net::LDAP, I beilieve that has something similar to ldapsearch in it as well.... Unfortunately, I don't have any Perl scripts to share with you as examples, though.
unknown
Thanks Greg, I'll ake a look at OpenLDAP.
tom
@jjotoole
, Yes to your question about updating AD with HR11 data. Our process for name, department, title..... changes results in this being updated in HR11. It is way to often missed in our Active Directory as that requires a second process to occur. So synchronizing this data from HR11 to AD is what we are looking to do. As well as synchronizing email addresses from AD to HR11. We have other tools that rely on the AD information, however it is frequently out of date and incorrect..
Thanks
moellerg
Actually, I believe that our ldapsearch came from IBM, or Oracle with either the OS installation or with IBM's TDS.
moellerg
We currently manage our changes in AD (at least to phone numbers and email addresses). Nightly we do an AD export, and then use a similar script to what I have attached, to update these values in HR11.
Monthly HR Payroll Call-20250116_140313-Meeting Recording.mp4
unknown
Hello - We wrote a Sql Server SSIS package to update two fields in Lawson from AD. We updatethe networkid and email address. We store the network id in an HR user field. NOTE: The only way we could do this Synch is if the AD account, when created, had the employee number. That is the only way to join the two data sources looking for changes.
Then, We wrote an Informatica process (3rd party ETL tool) to update AD from Lawson. We update about 12 AD fields from Lawson so if someone right clicks an employee in Outlook, the data is consistent.
0911060553270289.pdf
unknown
Note: Every day, we have a job that dumps every AD user into a SQL database with all associated fields and groups. This is SO much faster to query than querying AD/LDAP search.
unknown
Steve, what are you using to extract the records out of AD for the database load?
unknown
We use SqlServer Integration Studio (SSIS) to Read AD and write to a Sql database. We schedule it to run it twice a day so it is always fresh.
unknown
So your SSIS package can directly read the Lawson LDAP info? If you could provide any example of how you connect and read from within the SSIS that would be great. Thanks.
[Updated on 10/9/2014 3:04 PM]
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Popular Tags
Infor Lawson Human Resources Group - Discussion
Infor Lawson Technology Group - Discussion
General Discussions
VISUAL - Enterprise General Discussions
Infor Lawson Supply Chain Management - Discussion
Process Automation (IPA) - General Discussions
Pegasus - Partner General Discussions
Infor Lawson Supply Chain Group - Discussion
Infor Lawson Financials Group - Discussion
Infor EPM Discussions