Database connector - support for heirarchyid

Adam van Vliet 7 years ago updated by anonymous 7 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).


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.