Management Information Systems - Knowledge Inventory File.

Authors Avatar

Wilfrid Laurier University

BU 625 – Management Information Systems

Knowledge Inventory File

Dr. Michael Haughton

Spring 2004

Enterprise Resource Planning

Submitted By

Ayan Banerjee

I.D. # 039004294


Table of Contents

Knowledge Inventory File Synthesis ………………………………………………….……3

Article # 1: Migrating to an ERP System…………………………………………………..4

Article # 2: Successful ERP Implementation the First Time……………………………...7

Article # 3: Getting Your ERP Implementation Back on Track………………………….8

Article # 4: Managing ERP Applications for Strategic Advantage………………………11

Article # 5: Outsourcing ERP Support…………………………………………………….14

Article # 6: Justifying Data Warehousing Investments……………………………….… 17


Knowledge Inventory File Synthesis

In order to compete in this complex business world, companies need better information management of the company’s data, a management that will help in better analysis of the processes involved. Organizations are however having a difficult time integrating and correlating data from various software applications and are looking forward to a single application. This is where the organization can employ Enterprise Resource Planning (ERP) Software. The first article discusses the factors which should be considered while migrating to an ERP system.

The second article outlines that purpose of ERP technology is to support the business processes that support the company’s strategic opportunities. No amount of advanced information technology can offset the problem of a flawed business strategy and poorly performing business processes. The article also emphasizes that successfully implementing ERP the first time requires a structured methodology that is strategy, people and process-focused. Doing it right the first time is the only cost-effective way to go.

The third article outlines some of the causes of failure of ERP implementations and suggests ways to overcome such failures.

The fourth article emphasizes that since ASPs have proven technology, methodology, and ERP application expertise already in place, ASP customers by paying a predictable, flat-rate monthly fee, can move attention away from the day-to-day management of applications and technology and divert the same towards more value-added activities that turn the promise of ERP into profits.

The fifth article suggests that implementing an ERP is only the first step and the real challenge lies in the successful execution of a quality assurance plan, otherwise known as a post-implementation optimization plan. ERP outsourcing relieves the cost pressures from organizations by weeding out unnecessary recurrent costs. By negotiating with outsourcing service providers for fixed charges that are lower than the internal IT costs, organizations can not only efficiently reduce costs but also effectively create the time and money needed for the projects they really need or want to put in place.

The sixth article enables us to look for ways to justify the huge investment made in ERP Solutions. Investments in ERP packages are considered as similar to buying a financial call options. The cost of the projects is analogous to the cost of buying the option or the value of option. In other words an organization acquires an option by investing in an ERP. This method of valuing of investment projects results in a higher value than traditional financial techniques such as net present value (NPV). Also using option pricing methodology recognizes the investments can be more valuable when there is a high degree of uncertainty.

Throughout this KIF the risks and advantages associated with the entire life cycle of ERP projects have been assessed. The IT managers must be aware of all the risks before the organization proceeds for a consideration of a major ERP implementation.  


Article # 1: Migrating to an ERP System

Author: By Roshmi Choudhury,

Publisher: , 04/06/2004

Summary

ERP generally refers to software that supports a wide set of activities which help the company manage its important functions like production, marketing, inventory, finance and human resource management. As such, ERP consists of a multi-module application, which allows data to flow from one module to the other. It therefore not only integrates the business processes, but also offers intelligent information by correlating data from various modules.

When deciding for an ERP solution, many factors come into play- the most important is that the solution should serve the company for a longer term. That is to say, the solution should be able to adapt itself to the changing technologies like operating systems and new hardware features. Most companies like Peoplesoft, SAP, Ramco, etc offer such upgrades; they have teams that cater to the changing needs in the software. All that is required is the application of a service pack.

In this changing business world, companies are being bought and sold. It is likely that a company will be sold off or may merge with some other company. It may so happen that these companies may be using different ERP packages. These ERP packages should now be able to work together. ERP solutions like SAP have offered technologies like web enabled services and exchanging technologies that help integrate these completely different ERP environments.

A bulk of the IT budget in a company is spent not on new developments but on support. Having an ERP system minimizes support. At most, a two-member team is required for generating reports and solving minor problems that surfaces up when a lot of varied data is in the database. This way a company could spend less on support and divert the money in purchasing new capabilities.

The database should be meticulously chosen because a lot depends on it. It is the choice of the database that determines the performance of the ERP system. Server database that runs on a multi-user platform is required for an ERP application. Server databases contain mechanisms that ensure reliability and consistency of data. The primary factor that should be looked for is the concurrency model. The two most commonly used server databases are Microsoft SQL server and Oracle. Both have their own advantages and disadvantages. They differ widely in terms of the concurrency model. Oracle provides a multi version read consistency with no read locks and no dirty reads. Readers do not block writers and writers do not block readers. In Microsoft SQL server, read consistency is not available. It requires shared read locks to avoid dirty reads, if locks are not shared, dirty reads are possible. Also readers block writers and writers’ block readers. Deadlocks can be a serious issue with Microsoft SQL server, which escalates row-level locks, to table-level locks depending on the transaction’s volume. To the user, the application simply hangs. These unpleasant deadlock situations can result in aborting one or more of the concurrent users. Oracle, on the other hand, does not escalate row level locking. Microsoft SQL server is easier to use, easier to manage, less complex and requires lot less tuning than Oracle and is an excellent choice on windows platform. For cross platform support, Oracle is an excellent choice, which runs very well both on windows and Linux platforms. Most ERP solutions are built on both these platforms, and it is up to the customer to decide the database of their choice.

Perhaps the most important module in an ERP application is the security module that creates logins and grants select, update, insert, delete, and execute etc rights to the various database objects such as tables and stored procedures. Most ERP solutions restrict user from directly accessing tables. The user can perform operations on a table via a stored procedure and these stored procedures have many validation checks for the data. Also, the idea is to pass the entire logic to back-end stored procedures so that debugging and alterations become easy for the IT team. Another feature that should be looked for in the security module is password encryption for the user logins. Password encryption prevents direct access to the database servers thereby preventing malicious users from gaining access to the servers. The user can only access the server through the ERP software.

The new ERP provider should be able to convert the existing ERP data to its new system with minimal effort, that is, by using data translators, scripts and useful programming techniques. The data should make sense in the new ERP system. Also the ERP provider should audit the data to ensure its integrity before making the system live. If the data is not suitable for transfer, the ERP provider should perform initialization techniques like calculating the opening balance amount for the new system, for inventory it can calculate the opening stock for each of the items, etc.

This is a question frequently asked. It should be noted that no two business processes are alike. An ERP solution that suffices for a company may not be the be all and end all solution for another company. At some point of time, customization is required. The customization should also remain intact for future upgrades of the software. The factor that should be looked upon is whether the ERP provider is capable of doing this. The ERP solution should also have builder tools for creating new forms and report writer tools for generating new reports. By having this, some customization can be done at the user end also.

Potential Value to Managers of IT

This article provides a glance of ERP Systems to IT managers who are in the process of deciding ERP Packages for their organization. This article also discusses the factors that should be considered while migrating to an ERP system from the existing

The article provides effective input to the IT managers for choosing database – Microsoft SQL or Oracle and discusses the potential benefits and concerns associated with each database. Finally the article gives an idea to IT managers regarding security modules used in ERP solutions.

Questions Left Unanswered

  1. The success of ERP implementations depend a lot on the business process rather than the software itself. The article seems to have neglected all those factors which deserve a mention. How would the company ensure that the above issues are taken care of?
  2.  Who will be responsible for implementation of the ERP solutions? Will the same be outsourced and what shall be the decision criteria towards the same?
  3. The article admits that no two businesses are alike and an ERP solution that works well with one company may not fare well for the other. How would organizations ensure that the ERP solutions become successful at the first instant?
  4. Why at all should be go for a new ERP package? What are the missing links between our current package and the software of our choice?
Join now!

Points of Agreement

I fully agree with the article that database should be meticulously chosen because a lot depends on it and the choice of the database affects the performance of the ERP system. I also agree that while choosing ERP packages such solutions should be chosen which can address the undergoing changes in the business world like merger, acquisition etc.

I also agree with the authors concern about the security module of ERP packages. Finally I would support the author that the new ERP provider should be able to convert the existing ERP data to its ...

This is a preview of the whole essay