The <Column> element specifies a mapping from a column in a database table or an attribute in an LDAP result set to an IdPAttribute name. In most cases this is equivalent to aliasing a result column in a SQL statement, but may be clearer to look at, and in the case of LDAP it provides missing aliasing capability.

Schema Name and Location

This element is defined by the urn:mace:shibboleth:2.0:resolver schema, which is located at http://shibboleth.net/schema/idp/shibboleth-attribute-resolver.xsd .

Example

<Column columnName="homephone" attributeID="phonenumber" />
<Column columnName="prenom" attributeID="firstname" />

Attributes

Each <Column> element must have two attributes:

Name	Type	Description
`columnName`	string, required	Name of the column in the result set coming from the database or attribute coming from LDAP
`attributeID`	string, required	Name of the (internal) identifier to give the IdPAttribute representing the column or attribute

Child Elements

No child elements are defined.

Notes

The result set processing expressed by the <Column> elements can instead be defined by specifying the mappingStrategyRef attribute on the data connector. This allows for much more advanced result set processing, including the generation of non-string valued results.

Browser not supported