LDAP User Import

LDAP ETL

Atlas BI Library ETL | LDAP Supplimentary ETL

WebsiteDemoDocumentationChat

codacymaintainabilitydiscord 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.

Install Packages

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
DC=ExampleHealth
SEARCHBASES=EPIC, Employees, Doctors, Non-Staff, Students, Volunteers
GROUPSEARCHBASES=Email Distribution Groups, Room & Shared Mailboxes,Access & Permissions

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.