Synchronize Lawson S3 HR with Microsoft Active Directory

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

Comments

Legacy Contributor

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.

Legacy Contributor

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.

Legacy Contributor

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.

Legacy Contributor

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

Legacy Contributor

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

Legacy Contributor

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.

Legacy Contributor

Steve, what are you using to extract the records out of AD for the database load?

Legacy Contributor

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.

Legacy Contributor

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]

Copyright © 2025 Infor. All rights reserved.