Example of merging entities from two data sources - Card Synchronization 3.2

Card Synchronization Plugin Guide 3.2
Applies to
Card Synchronization 3.2
Last updated
2023-04-17
Content type
Guides > Plugin and extension guides
Language
English
Product
Card Synchronization
Version
3.2

You can merge entities from two different data sources using global keys.

In the following example, cardholders from two different data sources are merged. Data source A has a higher priority than Data source B.
Data sources. Data source A is of higher priority.

Global key configuration for Data source A

A data source with the email address selected as a global field.
  • Resolve data source relationships using global keys is not selected.
  • Email address is selected as a global key field for cardholders.

Cardholder data in Data source A

Unique ID Email Name Custom field A
ACH1 CH1@genetec.com Cardholder A1 CFA1
ACH2 CH2@genetec.com Cardholder A2 CFA2
ACH3 CH3@genetec.com Cardholder A3 CFA3

Global key configuration for Data source B

A data source with the email address selected as a global field.
  • Resolve data source relationships using global keys is not selected.
  • Email address is selected as a global key field for cardholders.

Cardholder data in Data source B

Unique ID Email Name Custom field B
BCH1 CH1@genetec.com Cardholder B1 CHB1
BCH2 CH2@genetec.com Cardholder B2 CHB2
BCH3 CH4@genetec.com Cardholder B3 CHB3

Result

Four cardholders are created in Security Center.
  • ACH1 and BCH1 are merged into one cardholder because they share the value CH1@genetec.com, which is defined as a global key for both.
    • The name of the cardholder is Cardholder A1 because the value is taken from the data source with the highest priority.
  • ACH2 and BCH2 are merged into one cardholder because they share the value CH2@genetec.com, which is defined as a global key for both.
    • The name of the cardholder is Cardholder A2 because the value is taken from the data source with the highest priority.
  • ACH3 and BCH3 are created as two cardholders because their global keys do not match with any other global keys.
Email Name Custom field A Custom field B
CH1@genetec.com Cardholder A1 CFA1 CHB1
CH2@genetec.com Cardholder A2 CFA2 CHB2
CH3@genetec.com Cardholder A3 CFA3  
CH4@genetec.com Cardholder B3   CHB3

Result if no global keys were configured or if only one data source had a global key configured

No cardholders are merged. Six cardholders are created in Security Center.
Email Name Custom field A Custom field B
CH1@genetec.com Cardholder A1 CFA1  
CH2@genetec.com Cardholder A2 CFA2  
CH3@genetec.com Cardholder A3 CFA3  
CH1@genetec.com Cardholder B1   CHB1
CH2@genetec.com Cardholder B2   CHB2
CH4@genetec.com Cardholder B3   CHB3