TMB has project to retrieve data of insurance policies of TMB customers from 2 current insurance partners – MSIG Insurance (Thailand) Company (MSIG), Cigna Insurance Company (CIGNA) - by systematically transferring data over the internet from their sides to TMB Secure FTP server and to store in TMB data warehouse. The data files contain customer detail and card holder information that are defined as confidential and need to be complied with PCI-DSS. The agreed procedure is described as below:
At the agreed schedule, each insurance company (MSIG and CIGNA) establish secure FTP connection to TMB’s external SFTP server with limited access for authorized persons and source IP address.
Then, the zip file containing data files will be transferred to store in TMB external SFTP server via secure FTP channel. Each insurer has access to individual folder on TMB external SFTP server so that they has access to their data only and not able to see other insurers’ files.
After that, the scheduled job script automatically moves the zipped files to store in the internal SFTP server. Then, Data Warehouse batch job will process the data files located in the identified internal SFTP server.