FAQs
Can I use FPE with BDT? If yes, which FPE algorithms are supported in BDT?
BDT supports FF1 and FF3 algorithms. To do so, update the BDT config file as shown here:
For FF3, set
@type
toFPE
For FF1, set
@type
toFF1
Is there a way to configure BDT to not remove the double quotes from the header row?
As of now, BDT removes qualifiers from headers and input data. To avoid it, the user can use any other character UTF-8 character as qualifier; for example,
#
,@
, or %. But then the column name must also be changed fromADRES_ID
to\"ADRES_ID\"
.{ "id":"policyId", "name":"policyName", "source":{ "@type":"CSV_FILE", "filepath":"persoonexample.csv", "delimiter":",", "qualifier":"#", "unescapeInput":false, "columnCount":51, "hasHeaderRow":true }, "destination":{ "@type":"CSV_FILE", "filepath":"persoonout.csv" }, "fpemode":"ASCII", "createBadRecordFile":true, "tables":[ { "columns":[ { "name":"\"ADRES_ID\"", "action":"ENCRYPT", "config":[ { "@type": "FPE", "key":"bdt_key", "characterSet":"alphanumeric", "tweak":"AUTO" } ] } ] } ] }