Data Anonymization Jobs

Approved records are anonymized using an SQL procedure. For each Sensitive Context, you must configure the FintechOS job server to run a corresponding anonymization service.

1 Set up the Anonymization Service

Open the FintechOS Job Server's services.config file in a text editor, and add a service based on the following model:

Copy 
<service>
    <name>FTOS.Anonimization</name>
    <type>mixed</type>
    <steps>
        <step>
            <name>Run Sensitive_Context_Name anonymization</name>
            <type>sql</type>
            <command>exec ebs.uspFTOS_SNSD_DeleteSensitiveData 'Sensitive_Context_Name'</command>
            <sqlConnection>Data Source=SqlServerName ;Initial Catalog=DataBaseName;User ID=userName;Password=userPassword</sqlConnection>
            <mandatory>true</mandatory>
        </step>
    </steps>
</service>

2 Set up the Anonymization Service Trigger

Open the FintechOS Job Server's schedule.config file in a text editor, and add a trigger for the anonymization service based on the following model:

Copy 
<trigger>
    <name>FTOS.Anonimization</name>
    <!--<calendar>holyday1</calendar>-->
    <startTime>02.01.2019 11:00</startTime>
    <endTime>03.11.2080 11:02</endTime>
    <poolTime>60</poolTime>
    <repeatCount>-1</repeatCount>
    <rescheduleAfterRun>false</rescheduleAfterRun>
    <async>false</async>
    <expression>0/10 * * * * ?</expression>
    <services>
        <service>FTOS.Anonimization</service>
    </services>
</trigger>

The following settings apply:

  • <poolTime> is expressed in seconds.
  • <repeatCount> when set to -1 will run indefinitely. When set to a positive value (eg. 5) will run for only 5 times at each pool time.
  • <expression> is a Cron expression. When present, the Cron expression will override the <poolTime>.

3 Restart the FintechOS Job Server

After editing the services.config and schedule.config files, you need to restart the FintechOS Job Server for your changes to take effect:

  1. On the FintechOS Job Server environment, open the Command Prompt application in Administrator mode.
  2. Enter the following command and wait for the job server service to stop:
    Copy
    net stop FTOS.JobServer.<instance name>
  3. Enter the following command and wait for the job server to restart:
    Copy
    net start FTOS.JobServer.<instance name>