In this work, we present a framework implemented within the EU project MOSAIC, funded under the FP7 framework, to gather Type 2 Diabetes (T2D) patients' data coming from three European hospitals and a local health care agency. A subset of the MOSAIC activities is centered on the development of Temporal Data Mining models to identify relevant clinical pathways in patients' histories and will in particular benefit from the data coming from the medical centers involved in the project. To best exploit this repository, the need for creating a common and sharable data model becomes immediately apparent. This model is the main subject of this paper. The proposed approach relies on the Informatics for Integrating Biology and the Bedside (i2b2) and the Shared Health Research Information Network (SHRINE) open source software tools. It provides an integrated research setting to merge clinical and environmental data that will enable obtaining a broader vision of individual patients' histories, which will be then mined with multivariate models to identify relevant clinical pathways.