Schema Tab

In Subscription Service, you can use the Schema tab to select tables, add child tables, and refresh table information. You must set subscriber table options before configuring other subscriber options.

An incoming message does not have to contain data for all the columns defined in the subscriber table. An adapter can be configured to expect only a subset of the columns. The adapter checks the repository for attributes defined in the class object definition of the subscriber table. When a message arrives, the adapter iterates through the attributes in the class object definition and looks for those same attributes in the incoming message.

Subscriber table names can be qualified with a schema name, such as SCOTT.EMP. To access tables in other schemas, the database user defined in the adapter Configuration tab must have the proper set of permissions granted. For more information, see TIBCO ActiveMatrix Adapter for Database Concepts.

When you configure the destination table, you only subscribe to columns that can be updated. If you subscribe to a column that cannot be updated and a message arrives with no data for that column, a null value will be written to that column.

For example:

  • If a source table is configured to send data for columns, c1, c2, and c3, and the destination table is configured to receive data for columns c1, c2, c3, c4, and c5, columns c4 and c5 will be ignored and take on whatever default values they are supposed to have, regardless of the TIBCO ActiveEnterprise message or XML message wire format.
  • If a source table is configured to send data for columns, c1, c2, and c3, and the destination table is configured to receive data for columns c1, c2, and c3 but not configured to receive data for columns c4 and c5, columns c4 and c5 will retain the defaults applicable to both tables.
Note: When the publishing table is configured to use parent-child relationships, the subscriber adapter must use the same repository as the publisher adapter.

The following table shows the Schema tab of Subscription Service:

The Schema tab includes the following tool icons:
  • Add Table : click this icon to add a root table. In Subscription Service, this table is the destination table, which is used to receive data.
  • Add Child table : click this icon to add a secondary table to the destination table.
  • Re-find schema from database : click this icon to refresh stored table information in TIBCO Business Studio by retrieving new information from the database.
  • Delete Table: to delete a table, right-click the table, and from the pop-up menu, click Delete Table. If the table has child tables, its child tables are removed as well.

The following table lists the fields in the Table view of an AE schema:

Name Description
Allow Key Columns Only Use this check box to determine whether child columns are joined to a column that is a non-key column. By default, this check box is selected.
The status is as follows:
  • Selected: child columns are joined only to a key column.
  • Cleared: child columns can be joined to any columns, including a non-key column.
Tables and Columns Loaded tables and columns.
Join To Name of a parent table column to which a child table column is joined for parent-child relationships.
User Key Click this check box to define a column as a user key.
AE Type Primitive type mapped to the TIBCO ActiveEnterprise (AE) type.