Abstract: 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 user's decision and for the improvement of drilling technology with multi-perspective flexible display.