Table Tab

You must set publisher table options before configuring other publisher options.

Source table names can be qualified with a database user name. To access tables in other schemas, the database user specified in the Using Connection Settings Templates must have the proper set of permissions granted. This is described in Referencing an External Schema.

Note: If a primary key is not defined for a table, the update and delete triggers will not be generated for the table. To define a primary key for the table, select the User Key column in a table row. The update and delete triggers will then be defined.

Icons

You can use the following table icons to create, edit, and organize the tables:

•

Add Table

—Displays a dialog that list tables available to the database user specified in the adapter Connection tab. Select the source table to publish from when data is inserted into it.

•

Add Child Table

—Displays a dialog from which a secondary table can be added to the configuration.

•

Add Table from Other Schema

—Displays a dialog from which you can add a table from a different schema than the current database user schema. For instructions on granting access privileges to an external schema, see Referencing an External Schema. You can use this icon to add different schema at the parent and child levels.

•

Remove Table

—Deletes the selected table from the list.

•

Re-find tables from database

—Causes TIBCO Designer to refresh stored table schema information by retrieving new information from the database.

•

load table schema from database

—You can load a database table schema, and convert it into a TIBCO ActiveEnterprise schema, and store it in the schema folder of an instance.

Check boxes

The following two check boxes are used for working on child columns and publishing the table columns.

•

Allow Key Columns Only

Select this check box, and child columns are joined only to a key column. Clear this check box, and child columns can be joined to any column.

•

Select/Deselect All Columns To Publish

Select this check box, and all of the check boxes in the Use? column are selected, which indicates that all columns in the tables are published. Clear this check box, and all of the check boxes in the Use? column are cleared. You can also individually select or clear the check boxes in the Use? column.

Table Columns

The following table lists and explains all contents of table columns:

Publication Service: Table Columns
Field	Description
Tables and Columns	Loaded tables and columns. indicates a table or child table. indicates a normal column. indicates a User Key column.
Type	Primitive type.
AE Type	Primitive type mapped to a TIBCO ActiveEnterprise type.
User Key	Click to define the column as a user key.
Use?	Click to publish this column when data is changed.
Join To	The name of a parent table column to join to for parent-child relationships.