14 / 35
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