Big businesses and smaller ventures running complex activities have business and technical data emerging many locations and many forms.
Sometimes they are served with one unified software system. However, there are other solutions as well.
One of these solutions is when we use data integration tools to left the data source systems as they are meanwhile creating a new database extracting and transforming the data from their sources. This new database could serve more sophisticated needs serving from one location.
Data integration and datamarts could be built on widely accepted Open Source software.
ETL is the acronym for "Extract - Transform - Load" which describes how these systems work.
- Main tools: Pentaho DI
- Services: Survey, recommendations, implementation