The <Column> element specifies the a mapping from a column in a data base database table to an attribute 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 c schema, which can be is located at http://shibboleth.net/schema/idp/shibboleth-attribute-resolver-dc.xsd.
Example
| Code Block | ||
|---|---|---|
| ||
<dc:Column columnName="homephone" attributeID="phonenumber" /> <dc:Column columnName="prenom" attributeID="firstname" /> |
...
Each <Column> element must have two attributes:
| Name | Type | Description |
|---|---|---|
| string, required | the name Name of the column in the result set coming from the database |
| string, required | Name of the (internal) identifier to give the attribute for the rest of the attribute resolution, filtering and encoding.IdPAttribute representing the column |
Child Elements
No child elements can be providedare 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.