Changqing drilling engineering company has experienced informatization construction in many years

and accumulated a large number of data about drilling

formed a research basis about drilling big data.But the large number of data distributed in different heterogeneous data sources because of the long-term decentralized construction.So it is difficult to get the comprehensive analysis about the relevant data.This paper introduces the data integration of drilling big data

the methods of designing and implementing the analysis system against this kind of practical problems.The system uses kettle which is a integration tool to establish a new database implementing the data integration

and uses final report

the business intelligence tool

to implement the on-demand organized view of the drilling big data.It also provides a strong data support for users decision and for the improvement of drilling technology with multi-perspective flexible display.