LDAP User Import

LDAP ETL

Atlas BI Library ETL | LDAP Supplimentary ETL

WebsiteDemoDocumentationChat

codacy maintainabilitydiscord chatlatest release

Loads data from an LDAP server into a database that is accessible by the primary Atlas metadata ETL.

🏃 Getting Started

Create Database

Use the LDAPDatabaseCreationScript.sql to create a database with the required tables.

Dependencies

This ETL uses python > 3.7. Python can be installed from https://www.python.org/downloads/

C++ build tools are needed on Windows OS.

ODBC Driver for SQL Server is required for connecting to the database.

Install Packages

This ETL uses poetry as the package manager. Alternatively, you can use pip to install the dependencies listed in pyproject.toml/dependencies.

poetry install

Create .env file

Create a .env file with the following settings, modified to fit your needs.

(or, pass the variables as environment variables)

SERVERURI=ldap.example.com
ADUSERNAME=EXAMPLEHEALTH\me
ADPASSWORD=exampl3
DATABASE=DRIVER={ODBC Driver 17 for SQL Server};SERVER=atlas;DATABASE=LDAP;UID=datagov;PWD=123
ADDOMAIN=EXAMPLEHEALTH
SUFFIX=DC=examplehealth,DC=net
SEARCHBASES=EPIC, Employees, Doctors, Non-Staff, Students, Volunteers
GROUPSEARCHBASES=Email Distribution Groups, Room & Shared Mailboxes,Access & Permissions

# LDAP Configuration
USESSL=True
USETLS=True

Running

poetry run python ldap.py

Other Tools

Active Directory Explorer is a useful tool to browse your LDAP setup to find the correct bases and dc.