Using LDAP means that Yellowfin access can be controlled externally, and organisation-wide, simply and quickly. Users can use their existing intranet password for Yellowfin, and reports can be given access restrictions which include or exclude users in specific LDAP groups. In addition, removal/lockout of the user in the LDAP directly will automatically flow through to Yellowfin, as Yellowfin has to authenticate via the directory for every login request, minimising the manual effort of mananaging users.
- Create a Yellowfin User (or specify an existing user) within the LDAP directory to allow Yellowfin to connect and search for Users and Groups.
- Create a 'Yellowfin User' Group within the LDAP directory (or specify one) which will be used to determine which users will have access to Yellowfin.
- Ensure network connectivity between the Yellowfin server and the LDAP server.
- Define the default Yellowfin Role for LDAP users.
Defining the Default Role
For Yellowfin to provision users automatically it has to assign a role to them. This role is defined as a Yellowfin 'Default' Role. In the Roles page, define one Role as the Default.
- Navigate to Administration > General > Role Management
- Select the Role you wish to make Default
- Tick the Default Role box and Save
Note: if no role is set as default the users will not be provisioned correctly into Yellowfin and the process will fail.
Yellowfin LDAP ConfigurationConfiguration page. The attributes required by Yellowfin include:
LDAP server hostname or IP address
TCP/IP port that the LDAP server is listening on
|Encryption||The encryption method implemented by the LDAP server. (None, TLS, SSL)|
LDAP Base Distinguishing Name (DN)
The LDAP node that all users and groups are contained within.
LDAP (Yellowfin User) Group
LDAP Group Name that identifies which users can log into Yellowfin. This group exists in the LDAP directory, not Yellowfin. Only members of this group will be able to login to Yellowfin.
LDAP Bind User
This is an LDAP User that the Yellowfin application uses to connect to the LDAP directory for search access, it must have rights to search the LDAP directory.
LDAP Bind Password
The LDAP Password required for the Yellowfin application to connect to the LDAP directory, associated with the LDAP Bind User defined above.
LDAP Search Attribute
This is a unique User Name field that LDAP users will login to Yellowfin with.
LDAP First Name Attribute
This maps to the First Name attribute of the user within the LDAP directory. This is so Yellowfin can match the user to a name and create an internal user account.
LDAP Surname Attribute
This maps to the surname attribute of the user within the LDAP directory. This is so that Yellowfin can match the user to a name and create an internal user account.
LDAP Email Attribute
This maps to the email address attribute of the user within the LDAP directory. This is so that Yellowfin can match the user to an email address for broadcast reports.
LDAP Role Attribute
This maps to a Yellowfin Role to be assigned to the user instead of the Default Role. See RoleCode in OrgRole table.
|LDAP Group Filtering Criteria||Criteria used to filter a list of LDAP groups. Only groups returned in the filtered list will be passed to Yellowfin.|
|Ordering||This order in which internal authentication is performed. (LDAP Authentication First, Internal Authentication First)|
Once defined, Yellowfin will automatically provision users as they attempt to login to Yellowfin for the first time.
Note: if the users in LDAP exceed the number of licences purchased, any new users will not be provisioned into the system.
|LDAP Base DN||cn=Users,dc=i4,dc=local|
|LDAP Group||CN=Yellowfin Users,CN=Users, CD=i4,CD=local|
|LDAP Bind User||cn=Administrator,cn=Users,dc=i4,dc=local|
|LDAP Bind Password||*********|
|LDAP Search Attribute||employeeID|
|LDAP First Name Attribute||givenName|
|LDAP Surname Attribute||lastName|
|LDAP Email Attribute||userPrincipleName|
|LDAP Role Attribute||Writer|
|Ordering||LDAP Authentication First|
- Connect to LDAP host 192.168.4.241 on port 389
- Users will be searched from cn=Users, dc=i4, and dc=local
- Users will be allowed to access Yellowfin if they are a member of cn=Yellowfin Users, cn=Users, dc=i4, or dc=local
- The user search will be conducted with user cn=Administrator, cn=Users, dc=i4, dc=local bound to the LDAP server with the password defined.
- The user will use employeeID as their login ID and Yellowfin will load their given name, surname, and email from the LDAP directory attributes givenName, lastName, and userPrincipleName respectively.
Note: if a user is not found in the LDAP directory, it will look for the username as a standard Yellowfin user.
Yellowfin Security & LDAP
- Open the Add LDAP Group drop down
- A list of LDAP groups will be displayed. Select the group to be used to create members for the Yellowfin Group
- Click Add to add the LDAP Group members into the Yellowfin Group