由於SAP公司於2020年宣布2027年將不再維護SAP BW，鼓勵企業升級成SAP BW/4HANA，使系統可以運作的更加快速且存放更多資料量，同時SAP大學聯盟也宣布各個擁有SAP系統的學校將於2021年9月升級成HANA，與企業同步升級以提升學生競爭力並學習最新的技術。而對於學術界，相較於SAP BW，SAP公司提供IDES資料及能與此資料搭配使用的教材以供學術研究使用，使教學上能迅速上手，然而SAP公司並無針對SAP BW/4HANA提供任何資料及可搭配的教材，使得升級為SAP BW/4HANA後將無資料可使用且於教學上造成困擾。
對於系統升級成HANA，SAP針對SAP S/4HANA提供Global Bike資料以供教學，而本研究為了也使SAP BW/4HANA擁有資料供學術研究使用，將兩套SAP S/4HANA系統資料之Global Bike及Best Practice皆利用萃取轉換載入的方式匯入至SAP BW/4HANA中，使學術界擁有兩套資料可運用。
關鍵字：萃取轉換載入、SAP、HANA

Since SAP announced in 2020 that it will no longer maintain SAP BW in 2027, it encourages companies to update the system to SAP BW/4HANA, so that it can operate faster and store more data. At the same time, the SAP University Alliance also announced that each college with SAP system will update the system to HANA in September 2021 as well, which will be simultaneous with enterprises to enhance students' competitiveness and learn the latest technology. For academia, compared to SAP BW, SAP provides IDES data and textbooks that can be used with it for academic research, so that it can be used easily for teaching. However, SAP does not provide any data and related textbooks for SAP BW/4HANA. There are no resources that can be used after upgrading to SAP BW/4HANA which causes problems in teaching.
For updating to HANA, SAP provides Global Bike data for SAP S/4HANA for teaching purposes. In order to enable SAP BW/4HANA to reside data for academic research purposes, two sets of SAP S/4HANA system data, Global Bike and Best Practice are imported into SAP BW/4HANA by using extraction transformation loading (ETL), and thus there are sufficient data for educational use.
Keywords: ETL, SAP, HANA

〔1〕薛如珊：台灣IDC(國際數據資訊)分析師觀點-商業智慧18年。2007 年 2
月2日。取自https://www.idc.com.tw/research/detail.jsp?id=MjI=。
〔2〕Fortune Business Insights : Business Intelligence Market to Reach USD 39.35
billion by 2027; Increasing Acceptance of Big Data Analytics to Intensify Market, states Fortune Business Insights. January 14, 2021. accessed https://www.globenewswire.com/news-release/2021/01/14/2158447/0/en/Business-Intelligence-Market-to-Reach-USD-39-35-billion-by-2027-Increasing-Acceptance-of-Big-Data-Analytics-to-Intensify-Market-states-Fortune-Business-Insights.html.
〔3〕Albert Pang , Misho Markovski and Marija Ristik : Top 10 Analytics and BI
Software Vendors, Market Size and Market Forecast 2019-2024. November 4, 2020. accessed https://www.appsruntheworld.com/top-10-analytics-and-bi-software-vendors-and-market-forecast/.
〔4〕Albert Pang, Misho Markovski and Andrej Micik : Top 10 ERP Software Vendors, Market Size and Market Forecast 2019-2024. November 5, 2020. accessed https://www.appsruntheworld.com/top-10-erp-software-vendors-and-market-forecast/
〔5〕Jörg Hofmann : Big news! SAP has extended ECC support until 2027. February
6, 2020. accessed https://www.pikon.com/en/sap-ecc-support-2027-s4hana-2040/.
〔6〕Richard Miller Devens, Cyclopaedia of Commercial and Business Anecdotes,
1864.
〔7〕Cebotarean Elena, “Business intelligence”, Journal of Knowledge Management,
Economics and Information Technology, ScientificPapers.org, vol. 1(2), pp. 1-10, February 2011.
〔8〕Eckerson W, White C, “Evaluating ETL and data integration platforms”, Report
of The Data Warehousing Institute 184, 2003.
〔9〕Nithin Vijayendra and M. Lu, “A Web-based ETL Tool for Data Integration
Process”, IEEE Conference Publications, pp. 434-438, 2013.
〔10〕Nitin Anand and Manoj Kumar, “Modeling and Optimization of Extraction-
Transformation-Loading (ETL) processes in Data Warehouse: An Overview”, IEEE, pp.1-5, 2013.
〔11〕Vassiliadis P, “A survey of extract—transform—load technology”,
International Journal of Data Warehousing and Mining, pp. 1-27, 2009.
〔12〕Kimball R and Caserta J, The Data Warehouse ETL Toolkit: Practical
Techniques for Extracting, Cleaning, Conforming, and Delivering Data, Wiley Publishing, Inc,., 2002.
〔13〕Kimball R and Ross M, The data warehouse toolkit: the complete guide to
dimensional modeling, Second Edition, Wiley, 2003
〔14〕Wilson Kurian : SAP Business Content for SAP BW/4HANA Features, Value
& Benefits, October 2020. accessed https://assets.cdn.sap.com/sapcom/docs/2020/06/3cbbd4de-9a7d-0010-87a3-c30de2ffd8ff.pdf.
〔15〕guru99 : SAP BI Content: Installation, Activation. accessed
https://www.guru99.com/installing-bw-standard-content.html.
〔16〕hebergementwebs : SAP SCM - Integration Models. accessed https://www.hebergementwebs.com/sap-scm-tutorial/sap-scm-integration-models
〔17〕SAP, BW430_EN_Col17_SAP BW4HANA Data Modeling, 2020.
〔18〕SAP, TADM10_1_EN_Col18_Technical Impl. and Operation I for SAP
S/4HANA and SAP Business Suite - Week 1, 2018.