ERP, short for enterprise resource planning, is a transactional database that records a company’s information on daily business processes. According to the traditional business model, day-to-day data is also recorded in two other transactional databases: HRM (human resource management) and CRM (customer relationship management).
However, transactional databases are not considered optimal for business intelligence. This is for a variety of reasons, including the fact that data is not optimized for reporting and analysis. Additionally, querying directly against these databases may slow down the system and prevent the databases from recording transactions in real time.