Hello SAC gurus,
We have SAC and 3 data sources: SAP ERP, SAP S/4 and SAP BW. I need to study the best choice for a connection architecture to SAC with those 3 data sources. As the SAP ERP is very customized solution (many Y* and Z* specifics) and as SAC is based on HANA database, how can I see those connections? As the data model is different from SAP ERP and SAC and also SAP BW and SAC, with many specifics in SAP ERP, must I need an ETL between SAP ERP and SAC? from my side I see those options:
Import Data connection with one shot replication:
SAP ERP ==> ETL ==> SAC or SAP ERP ==> SAP BW ==> SAP ETL ==> SAC?
Another question: Can BW play as ETL knowing that I will have very customized data model in ERP and BW?
Thank you for your help.
BR,
Mohammed