Improvements to Active Directory data processing

It is now possible to extract:
  • List of group(s) members
  • List of groups the user(s) belongs to

active directory datasource

We do recommend using a filter during design to reduce the pressure on the server

active directory connection

When no user name/password are provided the current user is used

Run the following SQL against the repository to enable Active Directory Connection

Insert into OBJECT_TYPES
 (OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('312','Active Directories')

Insert into OBJECT_TYPES
 (OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('313','Active Directory')

INSERT INTO OBJECTS_TREE
(OBJECT_ID,
 PARENT_ID,
 NAME,
 OBJECT_TYPE
)
Select
  OBJECT_ID*-6 as OBJECT_ID,
  PARENT_ID,
  'Active Directory' as NAME,
  312 as OBJECT_TYPE
From
  OBJECTS_TREE
where OBJECTS_TREE.OBJECT_ID=16

Download Free Trial of Advanced ETL Processor
Direct link, no registration required.