Logic -
Username – YESBKKALYANA
Few imp pointers to note –
- SFTP is owned by the bank.
- Access to bank SFTP is based public/private key method. Both public/private are generated by Karix [Gowtham]. Public key was shared with bank for whitelisting. Private key is configured at Karix application level. Public key is shared here for your reference.
host name : yessftpaft.yes.bank.in
username : BDTS-FTP-KARIX
port : 6022
- Files are placed on SFTP without .DONE extension.
- There are 3 file formats namely ACTN, NACN and DWH. File extension of ACTN and NACN files are .txt and the files are zipped. DWH file placed in .csv format.
for ACTN files
content and user data will be in the file itself
for NACN files
content will be whitelisted in below table, only variables ad user data will be picked up as a variable from file
select `id`, `primary_key`, `primary_key2`, `primary_key2_index`, `secondary_key`, `secondary_key_index`, `mobile_num_index`, `email_id_index`, `email_subject`, `sms_text`, `email_text`, `param1_index`, `param2_index`, `param3_index`, `param4_index`, `template_id`, `email_val1_pos`, `email_val2_pos`, `email_exclusion_value`, `param1_apply_decimal_rule`, `param2_apply_decimal_rule`, `param3_apply_decimal_rule`, `param4_apply_decimal_rule`
from
`upftp`.`upftp_yes_bank_nacn_file_config`
KT video