I'm trying to develop an automated New User Approval form. I need to be able to query RM information while the user is entering the data on the form to validate the supervisor approval for ProcessFlow Integrator.
Infor seems to think this can be done (yes I asked), but not one seems to know how. Has anyone heard of or developed a viable way to do this? I don't really want to have to periodically dump the RM information to an application table.
It would be most helpful if there were an RMObject similar to the DMEObject functions
Any insight would be appreciated.
Thanks,
David
David - yes this is doable if you get a little creative. One way that Ive done something similar is by creating a linked server within the database (and you should be able to do this with either SQL Server or Oracle....not 100% on DB2) and link that to the LDAP. That then allows you to make that visible within DBDEF (again - have to be a little creative and you may have to create a table definition that you then actually replace with a view on the physical DB that points to the linked LDAP.
Have done this similar with Active Directory as well so that you can query AD users from within the database....
Hi George,
Can you provide more specifics? This is unfamiliar territory for me. Our LDAP is an AD-LDS instance on the app server and DB is SQLServer on a separate machine. I'm not aware how to link a flat-file AD-LDS instance to a SQLServer table.
An alternative would be to create a flow with an RMQuery in it and send the result to a table in the Lawson DB but that wouldn't be dynamic. There should be some way to do this without having to jump through major hoops in the database world.
Here is a good article on setting up a linked server on SQL Server to point to an LDAP:
https://support.helpspot....hp?pg=kb.page&id=176
And here is a good article on how to actually execute the queries:
http://www.skylinetechnol...t-and-OpenQuery.aspx
Hopefully that should get you at least most of the way there....