1. UNIFYBroker Forum
  2. Ideas
0
Completed

Database connector - support for heirarchyid

Adam van Vliet 10 years ago • updated by anonymous 9 years ago • 3

Consider adding support for the database type of heirarchid.

Done:
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).


hierarchyid.png
André van der Westhuizen 10 years ago

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.

Adam van Vliet 10 years ago

Exception message done.

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

Adam van Vliet 9 years ago

Migrated to VSO.

Customer support service by UserEcho