Data Filtering

You can add replication filters by using the built-in features of CONNX. Using the Data Dictionary manager, apply a SQL based filter to any table in the SQL View Clause field.

 

To filter replication by data content, use a SQL View Clause when creating the CDD entry. For more information, see the SQL View Clause Text Box topic in the General Features section of the CONNX User Reference Guide, Chapter 21-Advanced Features of CONNX.

 

If two replications want the same tables but different data, in the CONNX CDD Manager, clone the original table, add all the columns to the cloned table, and use a SQL View Clause to filter the data. For more information about cloning tables, see the Clone Table Assistant section in the Advanced Features of CONNX chapter in the CONNX User Reference Guide.

 

.