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.