Specifying a Publishing Table

After you create Publication Service and select a table for the service, when you save the adapter service configuration, the Publishing Table field in the Publication Options tab is automatically filled with the name of the selected table, with the prefix "P_".

If you select the Write to Database on Save check box in the adapter Configuration tab, after you create Publication Service with a source table selected and then save the adapter service configuration, a publishing table with the name filled in the Publishing Table field is automatically created in the database. If you want to change the name of the publishing table, you can change the value in the Publishing Table field in the Adapter Services tab.

If you do not select the Write to Database on Save check box, after you create Publication Service with a source table selected and then save the adapter service configuration, you have to create a publishing table in the database based on the name in the Publishing Table field.

A publishing table contains additional columns that are used by the adapter to detect new rows. For details about the additional columns, see Publishing Table.