This paper proposes an integrated approach for data warehousing of the educational metadata in the area of open educational resources (OER). The aim is designing an architecture that integrates automatic metadata extraction and rule-based methods to better utilize the OER. This architecture helps synchronizing metadata from the resulting repository with versatile OER Web-based resources. Therewith, the approach to data warehousing involves an extract-transform-load (ETL) process. The proposed architecture, as our experimentation shows, in terms of data management and process flow, improves performance in handling OER metadata. This rule-based architecture allows for automatic extraction and classification of metadata in a number of pre-defined categories. These metadata categories are available through a web portal.