THE USA JOURNALS
THE AMERICAN JOURNAL OF ENGINEERING AND TECHNOLOGY (ISSN
–
2689-0984)
VOLUME 06 ISSUE09
104
https://www.theamericanjournals.com/index.php/tajet
PUBLISHED DATE: - 26-09-2024
https://doi.org/10.37547/tajet/Volume06Issue09-12
PAGE NO.: - 104-110
ARCHITECTURAL APPROACHES TO SCALING
FINANCIAL SYSTEMS BASED ON SAP HANA
Michal Gembčík
Entrepreneur, CEO at CMG TECH s.r.o. /contractor for PMP/AITEN/DXC
TECH Slovakia, USA
INTRODUCTION
The scalability of financial systems plays a crucial
role in meeting the growing demands for
processing large volumes of data and ensuring
high performance in real-time. In recent years,
financial organizations have been confronted with
the necessity of integrating complex analytical and
transactional operations, which requires flexibility
and reliability from information systems. In this
context, architectural approaches to scalability
become essential tools for maintaining business
competitiveness and resilience.
One of the most promising platforms for the
creation and scaling of financial systems is SAP
High-Performance Analytic Appliance (SAP
HANA). Through its in-memory technology, SAP
HANA provides high-speed data processing and
enables the unification of transactional and
analytical operations within a single system. This
platform allows organizations to respond swiftly
to changes in the business environment and
leverage modern technologies to optimize
financial processes.
The relevance of this study is driven by the rapid
development of technologies and the increasing
volume of data encountered by modern financial
systems.
The purpose of this work is to explore architectural
approaches to scaling financial systems based on
the SAP HANA platform.
1. Characteristics of SAP HANA as a Platform for
Financial Systems
The SAP HANA platform represents a cutting-edge
innovation in the architecture of enterprise
RESEARCH ARTICLE
Open Access
Abstract
THE USA JOURNALS
THE AMERICAN JOURNAL OF ENGINEERING AND TECHNOLOGY (ISSN
–
2689-0984)
VOLUME 06 ISSUE09
105
https://www.theamericanjournals.com/index.php/tajet
systems. The core element of this technology is the
In-Memory approach, which involves storing all
data and performing operations directly in the
main memory at the database level.
This approach fundamentally alters the traditional
understanding of working with databases,
eliminating the need for multiple disparate storage
systems. All information is now concentrated in a
single unified data array that is updated in real-
time, significantly accelerating the processes of
data analysis and processing. The HANA platform
combines the capabilities of both transactional and
analytical data processing, integrating OLAP and
OLTP technologies. This allows for computations
and report generation at unprecedented speeds,
increasing operational efficiency by tens and even
hundreds of times.
The database architecture has been completely
rethought and now utilizes vertical (columnar)
data storage, which has substantially reduced the
number of necessary tables. A unified table has
been created for managing financial information
and accounting, containing all the analytical data.
The same principle is applied to logistics data
management. Reports can now be generated
directly within the ERP system, making the process
more convenient and faster.
Furthermore, the HANA platform significantly
reduces hardware resource requirements,
enabling cost savings on server equipment
purchases. The need for computational power for
data storage has decreased by several orders of
magnitude, leading to substantial savings on the
acquisition and maintenance of additional system
modules, as well as on software licensing and
support .
The primary advantage of SAP HANA lies in its use
of main memory to store data in columnar tables,
which greatly accelerates information processing
compared to other modern database management
systems. By combining functionality for real-time
analytical processing (OLAP) and real-time
transactional processing (OLTP), SAP HANA
becomes a unique solution offering superior speed
and efficiency.
Additionally, the platform functions as an
application server, facilitating the development of
intelligent analytical applications that utilize real-
time data, in-memory technology, and machine
learning. These features are available in both cloud
services and on-premises installations, providing
flexibility and scalability for various business tasks
.
In turn, the financial module of SAP HANA
possesses a number of unique characteristics that
make it one of the leading solutions in the field of
financial management. This modern software,
included as part of the integrated SAP Business
Suite 4 High-Performance Analytic Appliance
Enterprise Resource Planning (S/4HANA ERP)
system, is designed to significantly simplify
financial processes, provide real-time information,
and support comprehensive financial analytics
(Table 1).
Table 1. Unique Characteristics of the SAP HANA Financial Module [3].
Characteristic
Description
General Ledger
Accounting
Functions include creating detailed financial reports, maintaining parallel
accounting according to various standards, and extending capabilities by adding
organization-specific data.
THE USA JOURNALS
THE AMERICAN JOURNAL OF ENGINEERING AND TECHNOLOGY (ISSN
–
2689-0984)
VOLUME 06 ISSUE09
106
https://www.theamericanjournals.com/index.php/tajet
Accounts
Payable and
Receivable
Management
Ensures optimization of interactions with suppliers and clients. This module
automates processes related to payments, credit risk management, and dispute
resolution.
Asset
Accounting
Enables efficient management of depreciation, asset revaluation, and accounting
for assets under construction. The module also supports the asset lifecycle,
including transfer, retirement, and disposal.
Centralized
Bank Account
Management
Provides centralized management of bank accounts, including change control and
management of bank signatures. This simplifies cash management processes and
communication with banks, offering standardized formats for interaction.
Financial
Planning and
Analysis
Offers tools for budgeting, forecasting, and profitability analysis. Integration with
SAP Analytics Cloud allows for the creation of advanced reports and
visualizations.
Centralized
Management
Dashboard
Automates processes for closing and reconciling intra-company operations.
Thus, S/4HANA Finance stands out from previous
versions such as ECC 6.0 (Enterprise Central
Component 6.0) and R/3 (Real-Time 3-tier)
primarily due to its architecture, built on the SAP
HANA in-memory database, which enables instant
processing and analytics. The simplified data
model, modern SAP Fiori interface, and enhanced
integration capabilities make S/4HANA Finance a
more powerful and user-friendly tool for
contemporary organizations [3].
Table 2. The Main Advantages and Disadvantages of SAP HANA in the
Financial System [4].
Advantages
Disadvantages
The main advantage of SAP S/4HANA Finance
is its ability to combine high data processing
speeds with comprehensive functions that cover
a wide range of financial operations, including
accounting and management control. This tool
enables companies to significantly accelerate
processes such as quarterly account
reconciliation, providing a centralized source of
financial information for the entire organization.
However, the technical and architectural
advantages of SAP S/4HANA Finance, including
a unified financial database and the integration of
transactional, analytical, and planning
applications, can pose significant challenges for
organizations. First and foremost, companies
need to decide which data and processes to
migrate from their legacy ERP system to the new
SAP S/4HANA Finance deployment. It is also
THE USA JOURNALS
THE AMERICAN JOURNAL OF ENGINEERING AND TECHNOLOGY (ISSN
–
2689-0984)
VOLUME 06 ISSUE09
107
https://www.theamericanjournals.com/index.php/tajet
According to SAP, this allows organizations to
achieve their financial goals more effectively
and quickly.
important to assess the quality of existing data
and determine whether the organization has
sufficient resources to carry out the transition.
Another significant advantage is the ability to
use analytical tools for real-time data analysis.
This provides financial specialists, including
CFOs, with the opportunity to model and
forecast potential changes in the organization,
such as mergers and acquisitions, allowing for
more informed management decisions.
The transition to a new system is often
accompanied by the need to reduce the number of
accounts in the chart of accounts, which can be a
challenging task. Additionally, according to
Deloitte, there are certain limitations regarding
the types of data supported by Central Finance,
which necessitates a thorough assessment of the
product’s alignment with the organization’s
needs.
The ability to retain the existing infrastructure
during system implementation, minimizing
disruptions and avoiding significant changes to
the underlying data.
Migration to SAP S/4HANA Finance also has its
particularities. Many companies consider
implementing Central Finance as the first step
toward fully migrating their ERP system to
S/4HANA. The financial function is generally
less susceptible to changes than other business
processes, making its replacement relatively
straightforward. SAP claims that the transition to
a new financial system can be achieved with
minimal impact on other business operations.
Partial automation of financial operations,
contributing to process optimization.
Meanwhile, consolidating financial transactions
through Central Finance enables organizations to
harmonize their financial data, often becoming
the first step in a broader digital transformation.
At the same time, other financial systems can
remain in existing environments without the need
for conversion.
The implementation of advanced financial
practices and the standardization of business
processes.
Reduced total cost of ownership of the system.
In the latest versions of SAP S/4HANA Finance,
including the 2021 release, new features have been
introduced, such as integration with SAP
Integrated Business Planning (IBP) and enhanced
monitoring and automation capabilities for
financial processes. This makes the system even
THE USA JOURNALS
THE AMERICAN JOURNAL OF ENGINEERING AND TECHNOLOGY (ISSN
–
2689-0984)
VOLUME 06 ISSUE09
108
https://www.theamericanjournals.com/index.php/tajet
more attractive to companies aiming to improve
the accuracy and efficiency of their financial
operations.
2. Architectural Approaches to Horizontal and
Vertical Scaling of Financial Systems
Architectural approaches to scaling financial
systems are a critical aspect of ensuring the
resilience, performance, and adaptability of these
systems in the face of rapidly growing transaction
volumes and complex computational tasks.
Financial systems are typically characterized by a
high degree of criticality and resource intensity,
which necessitates a careful selection and
implementation of scalable architectures. The
main methods are illustrated in Figure 1.
Fig. 1. Scaling methods [5].
Horizontal scaling, also known as scaling out,
involves adding new servers to the existing
architecture to distribute the load and handle
increasing data volumes. In the context of financial
systems, this means increasing the number of
servers that can process financial transactions,
user requests, and other computational tasks in
parallel. This approach is particularly relevant for
high-load systems where fault tolerance and high
availability are critical.
The primary advantage of horizontal scaling is its
ability to enhance the fault tolerance of the system.
For example, if one server fails, others can continue
operating, minimizing the risk of a complete
system shutdown. This makes horizontal scaling
the preferred choice for systems where
uninterrupted access is crucial, such as trading
platforms, banks, and other financial institutions.
However, horizontal scaling requires significant
effort in system design and management. For
instance, to ensure effective load distribution, load
balancing systems and distributed databases must
be used. This can lead to increased architectural
complexity and higher costs for system
development and maintenance. Moreover,
synchronizing data across multiple servers can
Scaling of systems
Combined
Vertical
Horizontal
THE USA JOURNALS
THE AMERICAN JOURNAL OF ENGINEERING AND TECHNOLOGY (ISSN
–
2689-0984)
VOLUME 06 ISSUE09
109
https://www.theamericanjournals.com/index.php/tajet
present a significant technical challenge, especially
under high-load conditions.
Vertical scaling, or scaling up, involves increasing
the performance of existing servers by adding
resources such as processors, memory, or disk
space. This approach is most commonly applied
when increasing the computational power of a
single server can significantly boost the overall
performance of the system. In financial systems,
vertical scaling may be used to enhance the
performance of critical components such as
databases or analytical modules that require high
data processing speeds and low latency.
Simplicity of implementation is one of the key
advantages of vertical scaling. Unlike horizontal
scaling, it does not require significant changes to
the system architecture and can be accomplished
without the need to redistribute data or balance
the load between servers. However, this approach
has its limitations. First and foremost, there is a
physical limit to how much the resources of a
single server can be increased. For example,
adding more processors or memory will eventually
encounter limitations imposed by the server's
hardware architecture.
Another drawback of vertical scaling is the risk of
creating bottlenecks within the system. Increasing
the performance of one component does not
necessarily
improve
the
overall
system
performance if other components remain less
efficient. For instance, if the database is scaled
vertically, but the application using this database
remains
unchanged,
the
overall
system
performance may be constrained by the
capabilities of that application.
In modern financial systems, a combined approach
is often employed, which integrates both
horizontal and vertical scaling. This approach
allows for an optimal balance between
performance, fault tolerance, and cost efficiency.
For example, horizontal scaling may be applied at
the web server level, where high availability and
load distribution are essential, while vertical
scaling may be used for databases that require high
performance and data consistency.
Additionally, the combined approach may include
the use of hybrid cloud solutions, which allow for
scaling resources both horizontally and vertically,
depending on the system's current needs. This is
particularly relevant for financial systems that face
unpredictable load spikes, such as during large
sales
events
or
unexpected
economic
developments.
3. Strategies for Performance Optimization and
Ensuring Fault Tolerance in SAP HANA-Based
Financial Systems
Achieving high performance in SAP HANA systems
requires thorough preparation and a robust
infrastructure. To enhance the functionality of SAP
systems, it is essential to implement appropriate
optimization measures, taking into account the
specific characteristics of each installation. While
these systems offer significant capabilities, their
effective use demands substantial infrastructure
resources. System optimization is achieved
through continuous monitoring and timely
adjustment of parameters based on current needs.
It is crucial to constantly monitor the SAP
environment, and there are a number of
specialized tools available to simplify the process
of monitoring and management.
To maximize the return on investment in SAP
HANA hardware, several key strategies should be
considered. First and foremost, it is important to
ensure the timely provision of accurate
information to relevant specialists, such as
platform experts or specialists in specific aspects
of the system, who manage its daily operations. It
is also critical to have a comprehensive
understanding of each system's performance to
anticipate and prevent potential performance
issues before they can negatively impact
THE USA JOURNALS
THE AMERICAN JOURNAL OF ENGINEERING AND TECHNOLOGY (ISSN
–
2689-0984)
VOLUME 06 ISSUE09
110
https://www.theamericanjournals.com/index.php/tajet
operations.
Effectively addressing bottlenecks and optimizing
lengthy processes are vital aspects of maintaining
high performance. Monitoring system loads and
optimizing SQL queries can help identify and
correct issues in programs written in ABAP.
Regularly checking the performance of ABAP code,
analyzing application logs, and assessing database
access are essential for preventing potential
failures. Additionally, it is important to keep the
SAP system up to date by promptly installing
updates and support packages.
In-depth system analysis provides a holistic
understanding of the system architecture,
including aspects such as hardware, database
configuration, memory allocation, and workflows.
This approach ensures the long-term stability and
high performance of the SAP HANA system.
CONCLUSION
The study has demonstrated that the choice of an
architectural approach to scaling financial systems
based on SAP HANA is a key factor in ensuring their
high performance and fault tolerance. Horizontal
scaling provides enhanced fault tolerance and
scalability, but it requires complex management
systems. Vertical scaling, on the other hand, is
simpler to implement but has resource limitations
and can create bottlenecks within the system. A
combined approach, incorporating elements of
both methods, appears to be the most effective for
modern financial systems. In the future, it will be
necessary to explore the possibilities of integrating
SAP HANA with cloud solutions and applying new
technologies to further improve the scalability and
resilience of systems.
REFERENCES
1.
SAP S/4HANA Business Architect is a new
generation ERP system. [Electronic resource]
Access
mode:
https://lenta.ru/articles/2016/12/14/hana /
(accessed 08/15/2024).
2.
What is taco SAP KHAN. [Electronic resource]
Access mode: https://www.sap.com/central-
asia-caucasus/products/technology-
platform/hana/what-is-sap-hana.html
(accessed 08/15/2024).
3.
Overview of the SAP S/4 HANA Accounting and
Finance module. [Electronic resource] Access
mode:
https://www.erpresearch.com/en-
us/sap-s4-hana-finance-accounting-module
(accessed 08/15/2024).
4.
SAP S/4HANA Finance. [Electronic resource]
Access
mode:
https://www.techtarget.com/searchsap/defin
ition/SAP-S-4HANA-Finance
(accessed
08/15/2024).
5.
Using the capabilities of SAP HANA: real-time
analytical information to achieve business
success. [Electronic resource] Access mode:
https://fastercapital.com/content/Unleashing
-the-Power-of-SAP-HANA--Real-Time-
Insights-for-Business-Success.html (accessed
08/15/2024).
6.
10 ways to maximize investments in SAP HANA
hardware. Electronic resource] Access mode:
https://www.saptutorials.in/sap-hana-
hardware/#:~:text=Maximizing%20your%20
SAP%20HANA%20hardware,in%20training%
20for%20IT % 20 employees (accessed
08/15/2024).
