Is it possible to publish from a table residing in an external schema? If yes, where do I specify the external schema name? What is the significance of the database name in adb_subinfo table?
Article ID: KB0088096
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Resolution:
External schema means schema owned by other users other than the ADB user.
For both Oracle/SQL servers, external schema support means pub/sub from/to a table owned by other users.
In Oracle, the publishing table will reside under the ADB user; in SQL server, the publishing table can be under the ADB user or other users when you config using .dot notion.
Database name column in the adb_subinfo table has not been used; it has nothing to do with this external schema support.
External schema means schema owned by other users other than the ADB user.
For both Oracle/SQL servers, external schema support means pub/sub from/to a table owned by other users.
In Oracle, the publishing table will reside under the ADB user; in SQL server, the publishing table can be under the ADB user or other users when you config using .dot notion.
Database name column in the adb_subinfo table has not been used; it has nothing to do with this external schema support.
Issue/Introduction
Is it possible to publish from a table residing in an external schema? If yes, where do I specify the external schema name? What is the significance of the database name in adb_subinfo table?
Environment
Product: TIBCO Adapter for ActiveDatabase
Version: 3.3.1
OS: All
--------------------
Feedback
Yes
No
Powered by
