UNIFY Broker for SQL Virtual Table Support

Bob Bradley 1 year ago in UNIFYBroker SDK and UNIFYCore updated by Matthew Davis (Engineering Manager) 11 months 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).

Affected Versions:
Fixed by Version:

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.