You are viewing limited content. For full access, please sign in.

Question

Question

Active Directory as a Data Source in Laserfiche Cloud

asked on May 13, 2021

Is there anyway to lookup data using the Active Directory Integration for Laserfiche Cloud? For example, retrieving a user's manager to populate and field and be used in a forms process.

0 0

Replies

replied on May 13, 2021

I imagine you would need to use SQL to accomplish this since AD is not really a "data source" in the traditional sense. I wrote a post way back explaining how we created a SQL "interface" for AD and there's two approaches:

  1. Use ASDI to build stored procedures and such to retrieve your data
  2. Create a scheduled SQL job to periodically pull the data and refresh a db that you then use as your data source.

With either of those, you can then connect them to Forms as a data source to use in form lookups.

(Manager was one of the first ones we tried, and something to note is that there's a lot of relational structures in AD that you don't typically see on the front end. For example, manager is stored as the Distinguished Name, like a reference, so if you want the managers full name, display name, etc. you need to pull it all together like a JOIN).

Active Directory as a Forms Data Source - Laserfiche Answers

0 0
replied on May 13, 2021

Hi Lukas,

Laserfiche Cloud doesn't have this functionality out of the box. However, you could certainly look into running a custom script with a Remote Agent to query AD for the info you need.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.