Restrictions on nicknames

The federated server does not support user-defined types, distinct types, and reference types as columns of nicknames.

To create a nickname on a remote object that uses these types, you can create a remote view on the remote object. The remote view must use supported data types. Then create a nickname on that remote view. For more information, see the topic about mapping data types from data sources to the federated database system