LDAP Connector

Back Next

LDAP source synchronization task example

LDAP source
synchronization
task example

You work for the IT department and you have an LDAP directory server to store data of assets allotted to employees. You want to track the availability and utilization of virtual machines across employees in the organization.

You want to generate an analytic report in Tableau Server. Based on the report, you want to take decisions to allocate unused hardware effectively.

You perform the following

synchronization

tasks:

Define the synchronization task.: Configure a
synchronization
task to use the insert operation.

Use an LDAP source object.: The source object for a
synchronization
task is an LDAP computer class object that contains the asset details. Use the LDAP connection to connect to the LDAP directory server and read data. The LDAP object is a single source in the
synchronization
task.; The following table describes the fields for the computer source object that you can include:

Field
Description

name
The name of the asset.

description
Description of the asset.

managedBy
Name of the employee who owns the asset.

memberOf
Team or group that the employee belongs to.
Create a Tableau target.: The target in a
synchronization
task is Tableau Server. Use the Tableau connection to connect to Tableau Server. Use the target_write.tde as the target object in the
synchronization
task.; Include the name, description, mangedBy, and memberOf target fields from the source object that you want to insert into the target object.
Configure a field mapping.: Map the fields of the LDAP computer source object to the Tableau target object.; The following image shows the mapping of the computer source with the Tableau target:
Configure the advanced source and target properties.: In the advanced source properties, you choose properties that are specific to LDAP. Specify OU=Platform_QA_Adapters,OU=R&D,OU=INFA,DC=ADPQATEST,DC=COM as the parent DN in the LDAP directory server namespace from where you want to fetch the data.; In the advanced target properties, you choose properties that are specific to Tableau Server. Save and run the task. The Secure Agent retrieves the computer data from LDAP directory server and writes to Tableau Server based on the fields you mapped in the
synchronization
task.

Field	Description
name	The name of the asset.
description	Description of the asset.
managedBy	Name of the employee who owns the asset.
memberOf	Team or group that the employee belongs to.

Open the project in Tableau Server to visualize the exported data.

The following image shows the data categorized by asset availability in Tableau Server:

You can view the allocation of assets for each employee, listed along with the number and type of applications that are running on each computer.

IT managers can use the information to visualize and query the computer assets to make decisions.

Rename Saved Search

Table of Contents

LDAP Connector

LDAP Connector

LDAP source synchronization task example

LDAP source synchronization task example

LDAP source
synchronization
task example