UNIFY Broker for SQL Virtual Table Support

Bob Bradley 5 years ago in UNIFYBroker SDK and UNIFYCore updated by Matthew Davis (Technical Product Manager) 2 years ago 1

Sometimes SQL tables and views are not able to be modified as part of an implementation, but the next best thing would often be the use of virtual tables (i.e. a select statement encapsulated by parentheses followed by a table alias.  Presently this is not possible to configure via the UI - perhaps this is only a UI limitation and not a service limitation.

The benefits of this will be in removing dependencies on DBAs, particularly during the build phase when 3rd party SQL resource availability may be an issue (e.g. 3rd party).


Hey Bob,

Thanks for the suggestion. I've added this to our backlog for investigation as to whether it's a UI limitation or a service limitation.