i want to update users in SQL database table automatically day by day from the active directory to use them in e-forms.
what is the best solution in this case????
Hi Nada,
You can have LFDS sync with active directory. However there is no way out of the box to sync LF users from a SQL table.
What exactly are you trying to do?
Nada,
If you are looking to query AD user/group information from your forms it's pretty simple to setup a 'Linked Server' to AD within an SQL Server. This gives you a variety of options to query AD information from forms or workflow. Google 'AD Linked Server' for more information and how to set this up. I think this might be what you are looking for.
Andrew
Hi Andrew
in my case the users in the AD are changed every day... so i wanna to update my SQL database day by day from the AD.
By creating an AD Linked Server you can run queries against AD. Since it is linked directly to AD you will see all the AD changes, it's not just a snapshot and one time data import from AD. Its like having AD as an actual database.
If you want to create an actual AD database you can query against the linked server and populate tables from a schedule. We actually have a small db where we make such an update hourly. Our forms make queries against this db table and also directly against the Linked Server when more detailed information is required. Queries directly on the Linked Server are a bit slower than against an AD table that has been setup, that's why we setup a small table of basic user info.