Previous Page  14 / 35 Next Page
Information
Show Menu
Previous Page 14 / 35 Next Page
Page Background

Important and critical information, notably the policy and

damage information of insurance companies, are kept at

the Insurance Information and Monitoring Centre. Analytical

reports are being presented to the Undersecretaries of

Treasury, TSB (Insurance Association of Turkey), insurance

companies and other stakeholders via data warehouse

system.

Production and Test databases on single node servers

have been carried to Exadata Eight Rack Platform with 2

nodes within the scope of the migration of Data Warehouse

Platform of Insurance Information and Monitoring Centre.

Oracle Data Integrator tool has been started to use for daily

data transfers. 750 interfaces and 86 packages which feed

583 target tables daily have been developed during the

course of the project following the training sessions which

started in mid-April.

Benefits

High availability, zero downtime patching and backup by

Oracle RAC architecture

Data transfer by processing data on the platform without

bringing to the network by ODI product that optimized the

overnight transfers, which took 10 hours are now 2 hours.

10x faster Query and report response with Exadata Smart

Scan and high parallelism.

Quicker and faultless business development.

Keeping the data compressed up to 20 times.

Better quality and consistent data.

More powerful and real-time tests.

Faster resolution of problems with local support and

maintenance services.

NOW:

2 H

BEFORE:

10 H

SBM Data Warehouse

– Migration to Exadata

Platform and ODI

Important and critical information, notably information on

policies and damages belonging to insurance companies

are kept in the data centre of Insurance Information and

Monitoring Centre.

The data was previously being transmitted to SBM by the

insurance companies via a channel without encryption, the

FTP file transfer protocol.

According to the sub-paragraph 5 of the Article 31/B of the

Insurance Law, it is stated that, "All the transactions and

records of Insurance Information and Monitoring Centre are

confidential", security measures have been increased in

order to prevent unauthorized access to the data, and;

With the transition to sFTP Secure File Transfer Protocol

from FTP File Transfer Protocol the security risks that may

arise from data theft during data exchange or cyber-attacks

have been minimized.

The environment required for “Secure HTTP” has been

established by the joint work of many departments and

the definitions on FTP system have been transferred here

so that all the insurance companies could be transferred

successfully to sFTP.

Benefits

End-to-end secure transfer of confidential data to SBM

from the insurance companies has been provided.

Since the data is secured with 256 bit encryption, it

cannot be read even if it is stolen during transfer.

Secure and uninterrupted operation has been provided

with the newly redundant server infrastructure

established.

The files uploaded can be monitored by taking track

records such as time stamps without the necessity of

additional software.

Since sFTP protocol and SSH use the same port,

additional definitions in the security devices are no

longer needed of by insurance companies, so easy

migration is provided.

Transition to sFTP

(Secure

File Transfer Protocol)

Projects From SBM Which Will Take the Sector One Step Further

CURRENT

14