tions and fit all business requirements presents mul-
tiple challenges. Companies should embrace Enter-
prise Application Integration (EAI) as an opportunity
to obtain competitive advantage by optimizing their
core business processes.
This article attempts to determine the software
architectural and integration challenges related with
the integration needed between ERP and e-commerce
systems in e-tailer companies. The specific research
questions are: 1) what are the main challenges on the
integration of e-commerce and ERP systems; and 2)
how these challenges can be addressed.
To support the research, a case study has been con-
ducted in a Portuguese retail company that operates
an online B2C business via two channels: own online
store and third-party marketplaces.
The remainder of this paper is structured as fol-
lows. Next section mentions related work on the
particular architectural and integration challenges re-
garding ERP and e-commerce systems. Section 3
presents the case study, functional and non-functional
requirements and main challenges. Section 4 justifies
the e-commerce platform selected. Section 5 defines
the system architecture and implementation details.
Section 6 concludes the paper.
2 RELATED WORK
While an online store can operate without a real-time
connection to accounting systems, ERPs or others, the
cost of manually managing sales and product catalogs
in these multiple systems is often higher than initially
expected. Here, EAI enables stocks, orders, deliver-
ies, returns and invoicing (among other related sales
data) to be automatically exchanged between inde-
pendent systems (Farzaneh, 2014). Existing literature
on the integration of e-commerce and ERP systems
point to potential issues that could be encountered.
For instance, in (Kaya and Aydın, 2019) it is con-
cluded that the automated and direct data transfer
from an e-commerce platform to an ERP database
could cause accounting problems because ERP sys-
tems are often in-use by the whole company every-
day. An intermediate database layer could be created
to mitigate this issue, so data is temporarily stored
prior to importation into the ERP.
In (Nikitovi
´
c and Mahmutovi
´
c, 2019), extensive
ERP customization is also referenced as a generator
of hidden costs, since some requirements elicitation
is only concluded during the implementation process.
Despite integration problems, e-commerce solu-
tions face also relevant challenges that should be
taken into account. Noted in (Thaw et al., 2009) is in-
formation security, which plays an important role be-
cause of consumer’s trust in online transactions (cru-
cial for the continuous growth and development of
any e-commerce activity). The usage of technology
enablers such as firewalls and security protocols (e.g.
3D Secure) could improve the overall security of the
system (Nili et al., 2019).
Maintaining an efficient product inventory is seen
as another challenge. It is important to prevent and ac-
count for stock outs to avoid losing sales and improve
customer experience (Patil and Divekar, 2014).
e-Commerce platforms and ERP systems are het-
erogeneous and complex since they are often de-
veloped independently in potential different tech-
nological ecosystems. Consequently, the industry
adopted technologies and standards which offer cross-
platform support such as eXtensible Markup Lan-
guage (XML) and Simple Object Access Protocol
(SOAP) (Wang and Shi, 2017).
Moreover, the integration of ERP and e-commerce
can be achieved by using specific agents to filter, orga-
nize and transfer information efficiently through web
services (Kong et al., 2007).
Regardless of the integration dimension/strategy
(presentation, functional or data, as referenced in
(Ruh et al., 2002)), the development of inter-
application middleware is a common architectural ap-
proach to enable connections between legacy sys-
tems, databases, servers, web applications, among
others (Lee et al., 2003). Figure 1 illustrates the com-
parison between the traditional vs. middleware ap-
proaches.
AlternativeTraditional approach
Legacy system Legacy system
Web applicationWeb application
Legacy systems Databases
ServersWeb applications
Inter-application middleware
Figure 1: Comparison of two software architectural ap-
proaches for EAI.
The traditional approach promotes the implementa-
tion of custom changes in each existing node of the
software application ecosystem to allow the commu-
nication between them. It will eventually concen-
trate the same business logic on distinct applications,
which leads to complex maintenance tasks and repet-
itive validation procedures for integration purposes.
Adopting inter-application middleware as a soft-
ware architectural solution makes possible to miti-
gate these problems, since it is focused on mapping
processes, workflows and data between diverse ap-
ICEIS 2021 - 23rd International Conference on Enterprise Information Systems
314