A device receives, from a data warehouse, a request for incremental data, creates one or more temporary tables based on the request, and extracts incremental data from tracking tables of an enterprise resource planning (ERP) system. The device also stores the extracted incremental data in the one or more temporary tables, and joins the one or more temporary tables with one or more regular tables, where the one or more regular tables include data associated with the incremental data stored in the one or more temporary tables. The device further retrieves data from the joined one or more temporary tables and the one or more regular tables, and stores the retrieved data in the data warehouse.