The <Column>
element specifies a mapping from a column in a database table 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.
Schema Name and Location
This element is defined by the urn:mace:shibboleth:2.0:resolver:dc
schema, which is located at http://shibboleth.net/schema/idp/shibboleth-attribute-resolver-dc.xsd.
Example
<dc:Column columnName="homephone" attributeID="phonenumber" /> <dc: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 |
| string, required | Name of the (internal) identifier to give the IdPAttribute representing the column |
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 RelationalDatabase
DataConector. This allows for much more advanced result set processing, including the generation of non-string valued results.