Architecture for Integration and Migration of Information Systems by Using SOA Services across Heterogeneous System Boundaries

Author(s):  
Lars Frank ◽  
Rasmus Ulslev Pedersen

The objective of this chapter is to describe how it is possible to integrate and/or migrate information system where local heterogeneous databases are involved. ERP (Enterprise Resource Planning) systems are very complex standardized information systems, and they are often vital for the companies that use them. Therefore, the authors use integration and migration of ERP systems as an example. Normally, ERP systems are migrated/converted overnight as it normally is not possible to integrate different ERP modules from different ERP suppliers. This is very risky as many types of industries cannot function without a running ERP system. The main focus of this chapter is to illustrate how it is possible to migrate/convert an ERP system module by module and thus minimizing the risk of staying without a functioning ERP system. In central databases, the consistency of data is normally implemented by using the ACID (Atomicity, Consistency, Isolation and Durability) properties of a DBMS (Data Base Management System). This is not possible if heterogeneous databases are involved and the availability of data also has to be optimized. Therefore, in this chapter, the authors use so called relaxed ACID properties across different database systems or ERP modules. The objective of designing relaxed ACID properties across different database systems is that the users can trust the data they use even if the involved database temporarily are inconsistent.

2013 ◽  
pp. 314-328
Author(s):  
Lars Frank ◽  
Rasmus Ulslev Pedersen

The objective of this chapter is to describe how it is possible to integrate and/or migrate information system where local heterogeneous databases are involved. ERP (Enterprise Resource Planning) systems are very complex standardized information systems, and they are often vital for the companies that use them. Therefore, the authors use integration and migration of ERP systems as an example. Normally, ERP systems are migrated/converted overnight as it normally is not possible to integrate different ERP modules from different ERP suppliers. This is very risky as many types of industries cannot function without a running ERP system. The main focus of this chapter is to illustrate how it is possible to migrate/convert an ERP system module by module and thus minimizing the risk of staying without a functioning ERP system. In central databases, the consistency of data is normally implemented by using the ACID (Atomicity, Consistency, Isolation and Durability) properties of a DBMS (Data Base Management System). This is not possible if heterogeneous databases are involved and the availability of data also has to be optimized. Therefore, in this chapter, the authors use so called relaxed ACID properties across different database systems or ERP modules. The objective of designing relaxed ACID properties across different database systems is that the users can trust the data they use even if the involved database temporarily are inconsistent.


2021 ◽  
Vol 17 (4) ◽  
pp. 69-84
Author(s):  
Godwin Banafo Akrong ◽  
Yunfei Shao ◽  
Ebenezer Owusu

Globally, governments are taking steps to help them increase their income generation margin by implementing tax administrative ERP systems. However, the impacts on the internal system users of these ERP system quality features have not drawn the attention needed. This study, therefore, examines the relationship between the information systems' (IS) quality and individual impact using the theoretical foundation of the DeLone and McLean IS success model and, secondly, addresses the interrelationships between the quality constructs of information systems (IS). The authors also used the structural equation modeling technique of partial least squares to evaluate and analyze the data. The results show that system quality, the information quality, and the service quality characteristics of the tax administrative ERP system have a strong positive impact on the success of the IS at the individual level. There is also a positive relationship between the information systems' (IS) quality construction. The results provide additional empirical observations and consequences for management.


Author(s):  
Lars Frank

ERP (Enterprise Resource Planning) systems consist normally of ERP modules managing sale, production and procurement in private businesses. ERP systems may also have modules for special lines of business or modules for the different sectors of E-Government. However, the ERP systems of today use a common database and therefore, it is normally only possible to use modules supported by the ERP supplier. This limits the possibilities for special lines of business like the different sectors of E-Government. It is normally not possible to use the traditional ACID (Atomicity, Consistency, Isolation and Durability) properties across heterogeneous ERP modules and therefore, it is not possible to integrate such modules without inconsistency and anomaly problems. That is, the users cannot trust the data they are reading and even worse they can undermine the validity of the databases if they update the databases by using such invalid information. However, it is possible to use so called relaxed ACID properties. That is, it should, from a user point of view, look as if the traditional ACID properties were implemented, and therefore, the users can trust the data they are reading and cannot do anything wrong by using this data.


2021 ◽  
Vol 11 (15) ◽  
pp. 6792
Author(s):  
Alessio Faccia ◽  
Pythagoras Petratos

Accounting information systems (AISs), the core module of any enterprise resource planning (ERP) system, are usually designed as centralised systems. Nowadays, the continuous development and applications of blockchain, or more broadly—distributed ledger technology (DLT), can change the architecture, overcome and improve some limitations of centralised systems, most notably security and privacy. An increasing number of authors are suggesting the application of blockchain technologies in management, accounting and ERPs. This paper aims to examine the emerging literature on this field, and an immediate result is that blockchain applications can have significant benefits. The paper’s innovative contribution and considerable objective are to examine if blockchain can be successfully integrated with AIS and ERPs. We find that blockchain can facilitate integration at multiple levels and better serve various purposes as auditing compliance. To demonstrate that, we analyse e-procurement systems and operations using case study research methodology. The findings suggest that DLT, decentralised finance (DeFI), and financial technology (FinTech) applications can facilitate integrating AISs and ERP systems and yield significant benefits for efficiency, productivity and security.


2014 ◽  
Vol 933 ◽  
pp. 860-868
Author(s):  
Muneam Zamzeer Al-Magsoosi

Successful implementation of ERP systems should take full advantage of the access to information, but not be constrained by many of the deficiencies associated with infinite capacity scheduling methodologies. In this paper an algorithm is developed which improves the performance of the ERP system. Lot sizing decisions based on capacity availability are used as an instrument to integrate more effectively capacity requirements planning (CRP) and Material Requirements Planning (MRP). MRP is a planning tool for a sub-set of manufacturing system specially in hierarchal multi-product, multi-period and multi-stage production planning and inventory control system. The Vehicle used for this integration is planned order release (POR) quantity. The algorithm requires minimal deviation from the MRP logic. In this sequential process MRP first issues the action notices and then the algorithm analyses the capacity situation in the work centers. The algorithm scans all planned order release quantities of lower level items in the action bucket before orders are released to the shop. For each item a delta value is computed identifying the degree orders are contributing to capacity problems. This delta is specific to each POR. The POR causing the highest overload and the one passing through the lowest utilized work centers are selected for a lot size decrease, respectively, an increase. After identifying the candidates, a series of checks analyses the suitability of the candidates for that change. The planned order release quantities of more items can be performed. Projected capacity profile after iteration will be updated and capacity requirements over a short duration are smoothed. The experiments are performed with MAP/3000 as a simulation model for this study. The developed algorithm is added to MAP/3000 as additional subroutines. The design of the experiments consists of a base test identifying the significance of different environmental parameters of MRP systems and a main test which performs a detailed evaluation. The results are evaluated using analysis of variance techniques. Most ERP systems built on the historical development of MRP and CRP systems, and the assumption of infinite capacity is affecting the performance of those systems badly. This paper is presenting an algorithm to smooth capacity problems by using the existed capacity.


2018 ◽  
Vol 14 (4) ◽  
pp. 89-107
Author(s):  
Ashraf Ahmed Fadelelmoula

This article empirically assesses the impacts of the quality dimensions of the enterprise resource planning (ERP) system on the realization of the fundamental business objectives of information systems and perceived usefulness. To assess these impacts, a theoretical model was developed based on the theory of information systems success. The model comprises the quality dimensions of the ERP system and their hypothesized relationships with the realization of the fundamental business objectives and perceived usefulness. To test the postulated relationships, a questionnaire was constructed based on a thorough survey of the information systems literature. The questionnaire was distributed to a sample of 300 end users of the ERP system in a public university in the Kingdom of Saudi Arabia (KSA). The collected data were tested using regression analysis. The findings reveal that information quality has the highest effect on the realization of business objectives, while service quality has the highest effect on the perceived usefulness. These findings indicate that the crucial aspects of both information quality and service quality should receive greater management attention in order to enhance the individual and organizational impacts of the ERP systems.


2020 ◽  
Vol 16 (2) ◽  
pp. 54-72
Author(s):  
Yu Zhao ◽  
Kakoli Bandyopadhyay ◽  
Cynthia Barnes

Enterprise resource planning (ERP) systems allow businesses to achieve high performance through distinctive capabilities and are one of the fastest growing areas within information systems. Many universities have adopted ERP in their management information systems (MIS) curriculum to increase the marketability of their students. Drawing on the IS success model and several constructive learning theories, this study develops a model that is predictive of students' continued ERP software use intention, satisfaction, and perceived learning outcomes. SAP is the ERP system used in this study. Business students at four mid-sized state universities in the United States were surveyed. The universities are members of the SAP University Alliance. There were 373 usable responses. Partial least squares structural equation modeling (PLS-SEM) was used to empirically test the model. The findings indicate that student motivation, perceived instructor support, and ERP system quality are strong predictors of student satisfaction, and learning outcomes. Student motivation and ERP system quality, but not perceived instructor support, are also significant predictors of continued use intention.


2004 ◽  
Vol 31 (2) ◽  
pp. 263-271 ◽  
Author(s):  
Sangyoub Lee ◽  
Ahsan Ullah Arif ◽  
Hyounseung Jang

The enterprise resource planning (ERP) system can integrate the major business management functions of the enterprise with a single common database to allow sharing of all information and achieve efficient communications between management functions. Based on the needs of running a construction enterprise, ERP shows potential applicability to the construction industry. This paper sought to quantify the benefits of ERP systems when applied to construction materials procurement. Specifically, this paper briefly described the business processes involved in construction materials procurement and illustrated how ERP systems could be implemented and the efficiency of the construction materials management system consequently enhanced. The transformation from a non-ERP system into an ERP system through application integration, internal integration, external integration, and automation were simulated. Results show that the individual task improvements of models can increase the productivity of the materials management cycle by up to 5.2%, 18.2%, 27.8%, 13.5%, and 79.2% through internal integration, external integration, application integration, automation, and ERP system, respectively, by automating most of the repeated transactions and reducing manpower required to perform the tasks.Key words: enterprise resource planning, materials management system, productivity, simulation.


2004 ◽  
Vol 1 (1) ◽  
pp. 63-72 ◽  
Author(s):  
Daniel E. O'Leary

This paper uses a database, derived from a data repository, in order to do an analysis of enterprise resource planning (ERP) system benefits. ERP benefits are important for a number of reasons, including establishing a match between what ERP systems benefits are—as compared to ERP expectations—setting a benchmark for other firms, and measuring those benefits. ERP benefits also are central to the business case for deciding whether a firm will invest in an ERP system. It is found that some benefits vary across industry, while others seem to be important to firms independent of industry. In particular, tangible benefits are largely industry-independent, while intangible benefits vary across industry. In addition, when compared to an earlier study by Deloitte Consulting, the results are statistically consistent with their findings, but find substantial additional intangible benefits.


Author(s):  
Walter W. Austin ◽  
Linda L. Brennan ◽  
James L. Hunt

This case is inspired by a complaint and response filed in the U.S. court system. One of the case’s authors served as an expert witness in the case. Because the suit settled before going to trial, some of the details of the case are not part of the public record; therefore, the names of the companies involved have been changed and certain details disguised to protect the identity of the litigants. However, the essentials of the case remain faithful to the actual circumstances and provide a basis for analysis of decision points and a discussion of costs and responsibilities for the issues in the case. A leading manufacturer of building materials in the United States selected an integrated enterprise resource planning (ERP) system to install on its existing hardware infrastructure. This case describes the ERP selection, implementation and migration challenges, impaired functionality, and the business and legal issues that ensued due to the software’s incompatibility with the hardware. With the software not performing as expected, the vendor withdrawing its software support, and costs escalating, the manufacturer sought legal counsel.


Sign in / Sign up

Export Citation Format

Share Document