Date of Award

Spring 4-1-2011

Document Type

Thesis

Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Ronghua Shan

Second Advisor

Stephen Krebsbach

Third Advisor

Mark Moran

Abstract

The aim of this project is to empower individuals with the ability to simply launch an excel with updated and consolidated data ("Resource Time Management and Approval Process" in our case) , view and update it and upload the excel back with updated data at individual's convenience and hence updating the SAP integrated Database Directly, therefore connecting different platforms and accessing Data from a heterogeneous combination of Systems. (The MS Excel with all its popular features can also be stored and processed at user's convenience.) Also the user can update the SAP database by simply loading back the updated excel sheet on the SAP database. The user just needs to load back the rows which are to be changed or just need to add the rows to be added in the SAP database (not the whole data). Integration of MS Excel with sap is advantageous because sap has many complex business oriented logic enabled data mining capabilities, more and more business's are going towards it. Sap reduces the redundant errors in the system as it provides real time information. It is easy to implement globally and updates need only to be done once for implementing it company wide.

Comments

dsu-th-233

Download

Share

COinS