You can add replication filters by using the ConnecX SQL Engine built-in features. 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 ConnecX SQL Engine, Chapter 21-Advanced Features of CONNX.

 

If two replications want the same tables but different data, in ConnecX SQL Engine, 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.

 

.