These are a design questions, and there are no exact answers, and SAS components and data is a loose coupling. But I can try to elaborate a bit.
- ETL Flows - Is this done in DI Studio? Be aware that Viya not yet supports native transformations when migrating from 9.4. From data perspective, my guess would be that a majority of your ETL work load will not be able to utilize CAS without major reengineering, so SPRE if you want an easy migration.
- SAS OLAP Star Schema Cube - have to be recreated in VA, so CAS.
- SAS OLAP Detailed Cube - if used for drill through in reports, CAS, otherwise it could be in SPRE depending on your ETL process.
- SAS Relational Information Map - CAS.
- SAS Stored Process - CAS.
- SAS Visual Analytics Reports - CAS
- Enterprise Miner - are you migrating to VDMML? If so, my guess would be CAS.
- Visual Data Builder - this is a light wight ETL tool to make data available for 9.4 VA, not sure if you have data specifically for this... You'll use other corresponding data prep tools in Viya. I would analyse what you have here now, and see how to migrate/implement in Viya, then decide upon the data part.
- Model Manager - Same reasoning as for EM, se above.
Data never sleeps