May 23, 2011

Extract datas from ERP system to BI system

BI (Business Intelligence) system is a data analysis tool and ERP system is an online translation processing system. Are there any relationships between these two systems? The answer is certainly yes. Moreover, let us take oil industry as an example, the ERP system is just like an oil field, and BI is an oil refining tool. During the oil refining period, we need the basic raw materials????oil. The oil is the data which is stored in the ERP system.

The users always worry about three problems when they extract data from ERP system to Business Intelligence system. First of all, the company should ensure the integrity of the data. If the data is incomplete, it may cause a great deal of problems. What is more, the data should be accurate. This is due to the fact that the accuracy of data is playing a vital role in the whole information system. Last but not least, the data must be extracted in time. If the data can not reach to the BI system timely, it is useless at all. The data extracting solution will be successful when these three problems are solved.

In realistic working process, data selection can be divided into two parts. The first part is initialized extracting, normally people will use totally extracting pattern during this process. That is to say, people will copy the entire data from ERP system to BI system without any modifications. It will last for a long time if the database of the enterprise is big. Furthermore, the second part is the follow-up extracting. After the first data selection finished, the data may be changed as the global market is changing all the time. In this case, people will not apply total replacement method into data selection. Instead, they will just update the new information into the database. It is efficient, convenient and money-saving to use this method.


- No comments Not publicly viewable


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

May 2011

Mo Tu We Th Fr Sa Su
Apr |  Today  | Jun
                  1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31               

Tags

Galleries

Most recent comments

  • I agree. Few companies today can grow their business by focusing on a single domestic market. Many e… by Junhua Lin on this entry
  • Hello. Thang. I am really impressed with your ideas by using 'the learning curve' to argue against s… by Peaw (peow) Kaitwatcharachai on this entry
  • Disagree with your idea about ERP starting with standardized business process. it has be identified … by Mengyun Hu on this entry
  • It seems almost impossible to achieve absolute standardization and flexibility with the implementati… by Sandhya Ramaseshan on this entry
  • BRP also play a critical role in ERP implementation. When implementation ERP system, there are two o… by on this entry

Blog archive

Loading…
Not signed in
Sign in

Powered by BlogBuilder
© MMXXI