CData Python Connector for LDAP

Build 20.0.7745

Person

Contains personal information about a user.

Table Specific Information

Select

All columns support operators =, >= , <=, !=, LIKE, AND and OR. For example:

SELECT * FROM Person WHERE  ObjectClass_1 = 'top' AND  CN  LIKE 'NewUser' LIMIT 5 

Insert

To add a Person, fields can be specified except Id, DN and BaseDN. Required fields that should be provided are RDN, ObjectClass_1, ObjectClass_2, ObjectClass_3, ObjectClass_4. For example:

INSERT INTO Person (RDN, ObjectClass_1, ObjectClass_2, ObjectClass_3, ObjectClass_4) VALUES ('CN=Domain Admins', 'top', 'person', 'organizationalPerson', 'user')

Update

All columns except Id, DN and BaseDN can be updated by providing the Id in the WHERE clause. For example:

UPDATE Person SET Description = 'desc' WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'

Delete

Persons can be deleted by providing the Id of the Person and issuing a DELETE statement. For example:

DELETE FROM Person WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'

Columns

Name Type ReadOnly References DataFormat Description
Id [KEY] String True

Combined index and DN. Multiple indices are only possible when a column is set to SplitDataByRow.

DN String True

The full distinguished name.

RDN String False

The relative distinguished name.

BaseDN String True

The base distinguished name.

ObjectClass_1 String False splitDataByCol

The list of classes from which this class is derived.

ObjectClass_2 String False splitDataByCol

The list of classes from which this class is derived.

ObjectClass_3 String False splitDataByCol

The list of classes from which this class is derived.

ObjectClass_4 String False splitDataByCol

The list of classes from which this class is derived.

SN String False delimitedData

This attribute contains the family or last name for a user.

CN String False delimitedData

The name that represents an object. Used to perform searches.

UserPassword String False delimitedData

The user's password in UTF-8 format. This is a write-only attribute.

TelephoneNumber String False delimitedData

The primary telephone number.

SeeAlso String False splitDataByRow

List of distinguished names that are related to an object.

Description String False delimitedData

Contains the description to display for an object. This value is restricted as single-valued for backward compatibility in some cases but is allowed to be multi-valued in others. See Remarks.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Filter String

Defines the LDAP filter explicitly, overriding any other values set in the WHERE clause.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7745