How Can I Add New Tables to a Channel with Activated Replication?

Question

How can I add new tables to a channel with activated replication?

Environment

HVR 6

Answer

To add new tables to a channel with activated replication, do the following:

1. Go to the applicable Channel Details page.

2. Click the tables link available in the Channel Summary pane to open the Tables page.

3. Click Add Tables.

4. Search for your tables. You can enter the table name or use the following format: SCHEMANAME.TABLENAME

5. Select the checkbox next to each table you want to add.

6. (Optional) By default, the selected tables are assigned to group GENERAL. You can change the table group name by entering a custom name in the Table Group for new tables field.

7. Reactivate your channel.

   i. Click Activate Replication at the top right.

   ii. In the Activate Replication dialog, under Locations, select the applicable source location.

   iii. Under Replication Components, ensure the Jobs and Table Enrollment options are selected. In addition, select the Replace All Old Enrollment option if your Capture job does not have high latency.

   iv. Click Activate Replication.

8. Refresh your data.

   i. In the Channel Details page, click Refresh Data.

   ii. Select the Create Missing Target Tables and Alter or Recreate Tables with Incorrect Layout option.

   iii. Provide a Refresh Task Name.

   iv. Click Refresh Data.