The Shibboleth IdP V3 software has reached its End of Life and is no longer supported. This documentation is available for historical purposes only. See the IDP4 wiki space for current documentation on the supported version.
Column
- Rod Widdowson
- Scott Cantor
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 |
|---|---|---|
| string, required | Name of the column in the result set coming from the database or attribute coming from LDAP |
| 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.