How to Delete Table from Existing Channel

Question

How can I remove a table from an existing channel?

Environment

HVR 5

Answer

Perform the following steps to remove a table from an existing channel:

1. Suspend the capture job to prevent capturing any more changes for the table that you want to delete (e.g. orders).

2. Let the Integrate job consume the existing transaction files. This step ensures that there are no more transaction files being kept for changes on this table.

3. Right-click the table and select Delete.

   

4. Confirm that you want to delete the table.

5. Remove this table from the table enrollment file by performing Initialize with only the Table Enrollment option enabled. This ensures that the deleted table is not enrolled anymore and the changes for the table are not be picked up by the capture job. Do the following:

   1. Right-click on the channel (for example, chn1) and select HVR Initialize.

      

   2. In the pop-up dialog, select the source location only.

      

   3. Click the Advanced Options tab, select only the Table Enrollment option and all tables, as shown below.

      

   4. Click Initialize. This initializes the remaining tables and removes the deleted table from the enrollment file.

6. Start the Capture job.