Generate DE IBAN

The Generate DE IBAN masking activity allows you to generate IBAN numbers specific to Germany.

Table of contents


To use the Generate DE IBAN masking activity, it must be placed inside a table masking activity or a similar activity that iterates over data. Once placed, select the property you want to mask. Lastly, enter the routing number of the bank you want your generated IBANs to relate to. Note that the routing number has to be entered in string format.


In this example we want to mask IBANs in the Account table with German IBANs, so first we place the Account masking activity into opened Package.xaml and put the Generate DE IBAN masking activity within it. Once placed, we select the Iban property, and enter "10020500" as the routing number.

To use this generator the following namespace needs to be imported: Ekobit.BizDataX.DataMasking.DataGenerators.DE in the Package.xaml file and the following NuGet package needs to be installed: Ekobit.BizDataX.PerfidiaWrapper.

Generate DE IBAN example Figure 1: Generating DE IBANs


Property group Property name Description Example
Input properties Bank The bank's routing number used to generate values. "10020500"
DataItemProperty The property to mask. Write x => x.Iban or choose property from the dropdown list
EnforceUnique If true, random selection should select unique values. true or false
Input: Filter Filter Expression used for filtering records - only filtered items will be masked. x => x.Iban.EndsWith("000")
SkipDefaultValues If true, default values will be omitted in masking (i.e. null values are not masked). true or false
Input: Repeating RepeaterId The ID of the repeater that will be used to detect repeating and save results when masking item key repeats. IbanRepeater
RepeatingKey Key to use for repeating detection. Write x => CompositeKey.Create(x.Iban) or choose properties from the pop-up window
Misc DisplayName Display name of the activity in the workflow. Generate DE IBAN
Result Contains the masking definition object. It's a part of the masking infrastructure and should be ignored. -