Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Infor / Lawson Platforms
S3 Systems Administration
Connecting to LDAP from SQL Server
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5120
People Online:
Visitors:
282
Members:
0
Total:
282
Online Now:
New Topics
Lawson S3 Financials
PO Matched Dollars and Matched Quantity
5/10/2024 6:51 PM
Can anyone share the Lawson calculation to determi
S3 Customization/Development
COBOL CSV file
5/10/2024 2:36 PM
We have a custom Cobol program ZU200 that creates
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1354
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Systems Administration
Connecting to LDAP from SQL Server
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
RickyY
Veteran Member
Posts: 50
1/13/2012 4:01 PM
We are trying to connect to Lawson Security LDAP from SQL Server. Has any been successful connecting to LDAP and get data? Any help is much appreciated. Thanks.
Ricky
Greg Moeller
Veteran Member
Posts: 1498
1/13/2012 7:22 PM
Successful, yes. I've written scripts that go out to the LS security and create web pages out of groups and all their members, etc. Not sure though what the Windows equivalent is.... I'm working from a Unix box and using ldapsearch command.
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.
Greg Moeller
Veteran Member
Posts: 1498
1/13/2012 7:24 PM
You can use JXplorer to connect to LDAP from a Windows box to look around.
http://jxplorer.org/
JimY
Veteran Member
Posts: 510
1/16/2012 11:17 AM
Hi Greg,
We have unix here also, but I can not find the command ldapsearch. Is this a separate package that you installed? Thank you.
Greg Moeller
Veteran Member
Posts: 1498
1/16/2012 1:23 PM
No, Jim, ldapsearch should have been installed as a part of TDS, I believe. Ours is in /opt/IBM/ldap/V6.2/bin --- Yours may have a different version of db2/tds.
Let me share one of my scripts- It's not real pretty, but it works.
Please modify as you need. I only ask you leave me in the comments as the original author.
One thing: some versions of ldapsearch will not support the -1 option, so I believe you could leave it off.
-Greg
Attachments
users_groups_rpt.zip
Kwane McNeal
Veteran Member
Posts: 479
1/16/2012 2:50 PM
Ricky,
While Greg has given you a very solid way to do this via script, this can also be done natively in T-SQL.
See this website for ideas:
http://www.databasejourna...rver-using-T-SQL.htm
Kwane
Greg Moeller
Veteran Member
Posts: 1498
1/17/2012 3:47 PM
Ricky: Kwane has given you a solid suggestion as well!
As long as we are in the process of sharing. I can share another script with you. This one will list the group names and all of the users that belong to that group underneath. We use this every single day keeping track of all of our LBI stuff.
Cheers!
Attachments
003_002_001_groupheader_users.zip
Greg Moeller
Veteran Member
Posts: 1498
1/17/2012 3:54 PM
Ricky: Reading the subject of your original post, it appears to me that ldap may not be installed on the server that you are trying to connect to the Lawson LDAP from. You can get ldapsearch from the OpenLDAP packages.
http://www.openldap.org/
If you are on Sun/Oracle you can get the package file from www.sunfreeware.com Or you can do searches to find it other places specific to your platform.
RickyY
Veteran Member
Posts: 50
1/31/2012 11:37 PM
Greg: We are on a windows box. Will ldapsearch work? Basically, we trying to connect to Lawson Security to pull information. We have JExplorer but you can't set any auto jobs on it. Or maybe it can but I'm not aware of it. Do you know? Thanks.
RickyY
Veteran Member
Posts: 50
1/31/2012 11:37 PM
Greg: We are on a windows box. Will ldapsearch work? Basically, we trying to connect to Lawson Security to pull information. We have JExplorer but you can't set any auto jobs on it. Or maybe it can but I'm not aware of it. Do you know? Thanks.
Greg Moeller
Veteran Member
Posts: 1498
2/1/2012 2:08 PM
ldapsearch will indeed work... but you may have to download ldp.exe see:
http://publib.boulder.ibm...2Fitm_install161.htm
Or you can find other equally good ldapsearch equivalents for Windows...
http://securityxploded.com/ldapsearch.php
If your LSF environment is on Windows, I'd expect there to already be a command called ldapsearch on your server... or maybe ldp.exe or ldapsearch.exe
RickyY
Veteran Member
Posts: 50
2/1/2012 3:14 PM
So if not, do i install ldapsearch on the database server or the the application server?
Greg Moeller
Veteran Member
Posts: 1498
2/1/2012 3:27 PM
It really doesn't/shouldn't matter. You could install ldapsearch on your worstation, if you choose to. It will just connect to the servername you specify in the -h parameter at the port specified by the -p parameter. Doesn't matter where you do the search from. Install it where ever it makes the most sense for you and/or your organization.
Post back if you still have questions or issues.
RickyY
Veteran Member
Posts: 50
2/2/2012 3:24 PM
Hi Greg: Thanks for the info. Another question for you if you don't mind. Its a little off topic but hopefully you don't mind. How are you guys tracking changes user made in portal? For example, ESS changes/inquire, PA changes, and HR11 changes. Any audit you guys doing?
Greg Moeller
Veteran Member
Posts: 1498
2/2/2012 3:45 PM
Ricky: Yes, maybe that question deserves it's own post, but to get started, I'll answer what I know.
Not really any auditing going on. We do have one Smart Notification, that will alert the HR staff if someone adds a bank for their direct deposit. (Or maybe I'm just dreaming that)?
I'll do some checking and post back.
RickyY
Veteran Member
Posts: 50
2/2/2012 5:54 PM
So you guys don't have any sort of audit log to capture who changed what in the database?
Greg Moeller
Veteran Member
Posts: 1498
2/2/2012 6:19 PM
Just for the tables that have userid or user_name on them... I hear that much more auditing is coming with Infor 10.
xxxxxttysfh
Veteran Member
Posts: 62
6/29/2016 10:29 PM
hello i am trying to use Crystal reports to Query LDAP? have you done this before?
You are not authorized to post a reply.