how to Integrating Data in the Information System ?
Posted on: Tue, 02/10/2009 - 07:52
Anonymous
how to Integrating Data in the Information System ?
Our organization is running a number of business systems, including a hosted SAP CRM (As ERP), SQL Server databases, which store data for a variety of back-end systems. The bulk of the data we need to process and load (customer calls data), however, comes in positional flat files. Subsequent extracts the data from SAP and then performed to load a few data marts, based on MySQL.
The major challenge we faced when deploying our new Customer Rewards Portal was related to data integration. Initially,we needed to load existing account information, login data, and reward product information, as well as a number of reference data sets, in the underlying MySQL database. All this data existed,
Now, We needed to migrate data from our SAP CRM
system running on Oracle to the our Portal CRM, deployed in Software as a Service mode.
but was stored in a variety of formats – including SQL
Server databases, flat files, and Excel spreadsheets.
Now, We needed to migrate data from our SAP CRM
system running on Oracle to the our Portal CRM, deployed in Software as a Service mode.
but was stored in a variety of formats – including SQL
Server databases, flat files, and Excel spreadsheets.