PMID- 27006872 OWN - NLM STAT- PubMed-not-MEDLINE DCOM- 20160323 LR - 20201001 IS - 2193-1801 (Print) IS - 2193-1801 (Electronic) IS - 2193-1801 (Linking) VI - 5 DP - 2016 TI - Application of an integrated multi-criteria decision making AHP-TOPSIS methodology for ETL software selection. PG - 263 LID - 10.1186/s40064-016-1888-z [doi] LID - 263 AB - Actually, a set of ETL software (Extract, Transform and Load) is available to constitute a major investment market. Each ETL uses its own techniques for extracting, transforming and loading data into data warehouse, which makes the task of evaluating ETL software very difficult. However, choosing the right software of ETL is critical to the success or failure of any Business Intelligence project. As there are many impacting factors in the selection of ETL software, the same process is considered as a complex multi-criteria decision making (MCDM) problem. In this study, an application of decision-making methodology that employs the two well-known MCDM techniques, namely Analytic Hierarchy Process (AHP) and Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) methods is designed. In this respect, the aim of using AHP is to analyze the structure of the ETL software selection problem and obtain weights of the selected criteria. Then, TOPSIS technique is used to calculate the alternatives' ratings. An example is given to illustrate the proposed methodology. Finally, a software prototype for demonstrating both methods is implemented. FAU - Hanine, Mohamed AU - Hanine M AD - Departement of Computer Science, Laboratory of Engineering and Information Systems, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco. FAU - Boutkhoum, Omar AU - Boutkhoum O AD - Departement of Computer Science, Laboratory of Engineering and Information Systems, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco. FAU - Tikniouine, Abdessadek AU - Tikniouine A AD - Departement of Computer Science, Laboratory of Engineering and Information Systems, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco. FAU - Agouti, Tarik AU - Agouti T AD - Team of Telecommunications and Computer Networks, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco. LA - eng PT - Journal Article DEP - 20160302 PL - Switzerland TA - Springerplus JT - SpringerPlus JID - 101597967 PMC - PMC4775722 OTO - NOTNLM OT - AHP (analytic hierarchy process) OT - Business Intelligence OT - ETL OT - ETL software selection problem OT - MCDM (multi-criteria decision making) OT - TOPSIS (technique for order preference by similarity to ideal solution) EDAT- 2016/03/24 06:00 MHDA- 2016/03/24 06:01 PMCR- 2016/03/02 CRDT- 2016/03/24 06:00 PHST- 2015/02/24 00:00 [received] PHST- 2016/02/16 00:00 [accepted] PHST- 2016/03/24 06:00 [entrez] PHST- 2016/03/24 06:00 [pubmed] PHST- 2016/03/24 06:01 [medline] PHST- 2016/03/02 00:00 [pmc-release] AID - 1888 [pii] AID - 10.1186/s40064-016-1888-z [doi] PST - epublish SO - Springerplus. 2016 Mar 2;5:263. doi: 10.1186/s40064-016-1888-z. eCollection 2016.