Does ADB support materialized views/views?
Article ID: KB0089693
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Resolution:
Yes. ADB supports views: in the sense that you can configure publisher service to publish from a view. But you need to know that you cannot choose "save to database" check box in the instance level, for the reason that oracle or other databases does not support create insert/delete/update triggers on views. You need manually modify the trigger to be created on the base table which the view is defined on. Usually we recommend to use publish by reference and create the triggers on the base table to put the key values in the publishing table
Yes. ADB supports views: in the sense that you can configure publisher service to publish from a view. But you need to know that you cannot choose "save to database" check box in the instance level, for the reason that oracle or other databases does not support create insert/delete/update triggers on views. You need manually modify the trigger to be created on the base table which the view is defined on. Usually we recommend to use publish by reference and create the triggers on the base table to put the key values in the publishing table
Issue/Introduction
Does ADB support materialized views/views?
Feedback
Yes
No
Powered by
