Database connector - support for heirarchyid

Adam van Vliet (Chief Information Security Officer) 6 years ago updated by anonymous 5 years ago 3

Consider adding support for the database type of heirarchid.

When importing from the database connector where a type is not known, the following exception is generated:

System.Exception: A type converter is not available for type SqlHierarchyId.
at Unify.Framework.ObjectToValueAdapter.Transform(Object sourceValue)
at Unify.Product.IdentityBroker.ConnectorEntityFromDataRowConverter.Transform(DataRow sourceValue)
at Unify.Product.IdentityBroker.ConnectorEntitiesFromDataTableConverter.<Transform>b__0(DataRow dataRow)

The field name should be included in the exception details at the very minimum. Also consider adding support for new data types (including heirarchyid).

Affected Versions:
Fixed by Version:

By changing the Connector to connect to HumanResources.vEmployee and remove the old Schema and then request a new schema. I could run an Import all on the connector.

Exception message done.

Moving to v5.1.0 to consider adding support for data type.