How to filter/scope target system values

Question

I am using v7.0.2 Synchronization Editor, in a SQL Server type synchronization project. I have a SQL Server connection and want ALL records read from all database tables, but: 
 
 - I have a table which contains both users and roles, a column determines the type 
 How can I apply a filter to only process users (where type='USER') in one synchronization workflow and apply another filter of another synchronization workflow (apply some scope like where type='ROLE') 
 
 I cannot apply the WHERE filter in the Database connection configuration because it will filter out records. 
 Thanks

Markus Weiss-Ehlers · Answer

Hi, 
 you have to create two custom target system schema classes and two mappings. In the custom schema classes you can apply a filter to distinguish between users and roles. 
 I've done that for an Oracle User Profile sample. 
 Sample: 
 
 Create a custom target schema class while you are creating your mapping (my sample is for role in role) 
 Define a System filter to limit the amount of data fetched from your table. (System filter is literally a where clause in case of the database connector) 
 Repeat the same steps for your other use case with different system filter 
 
 In your case, the system filters would be 
 
 type='ROLE' 
 type='USER'

Endpoint Privilege Management

How to filter/scope target system values