Latest versions of Advanced ETL Processor, Visual Importer ETL, Data Exchange Wizard and QlikView connector support extracting data from active directory now

Extracting Data from Active Directory

Following Data can be exported from Active Directory
List of Users:
  • distinguishedName
  • cn
  • instanceType
  • objectCategory
  • objectClass
  • objectSid
  • sAMAccountName
  • title
  • Name
  • givenName
  • UserPrincipalName
  • description
  • mail
  • physicaldeliveryofficename
  • telephoneNumber
  • facsimileTelephoneNumber
  • mobile
  • company
  • department
  • useraccountcontrol
  • lastLogon
  • pwdLastSet
  • whenCreated
  • whenChanged
List of Groups:
  • distinguishedName
  • cn
  • groupType
  • instanceType
  • objectCategory
  • objectClass
  • objectSid
  • sAMAccountName
  • description
  • whenCreated
  • whenChanged
List of Computers:
  • distinguishedName
  • cn
  • instanceType
  • objectCategory
  • objectClass
  • objectSid
  • sAMAccountName
  • description
  • useraccountcontrol
  • operatingSystem
  • lastLogon
  • whenCreated
  • whenChanged

Professional and Enterprise versions to follow

Learn More Download Buy It

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies