Data Filtering
You can add replication filters by using the CONNX Data Integration Suite built-in features. For example, you can use the Data Dictionary manager to 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 Advanced Features of CONNX in the User Reference Guide.
If two replications want the same tables but different data, in CONNX Data Integration Suite, 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.