Fetching a Table After Creating Publication Service

If you skip the Schema Type window when you create Publication Service, you can fetch a table in the Schema tab after creating the service.

After you create Publication Service, the service-specific tabs are displayed in the configuration panel.

Procedure

  1. In Publication Service, click the Schema tab and click Add Table .
  2. In the "Table name Pattern" window, specify a search criterion, such as CUSTOMER% and click OK.
  3. In the "Select table" window, select CUSTOMER from the table list and click Finish.
    If you click Next in the "Select table" window, you can edit the selected table by selecting or clearing the Use check box next to a table column. If the Use check box next to a table column is cleared, the table column is not used. By default, all columns of the table are selected.
  4. Click the Publication Options tab and verify that P_CUSTOMER is set in the Publishing Table field.
    If this value is not set, type this value in the field.

What to do next

If you want to use parent-child table relationships, you can add child tables in Publication Service. For details, see Adding Child Tables in Publication Service.