Creating Data Warehouse using SAS Viya

[riofun]

I am writing a Project Management paper for creating a Data Warehouse using SAS.  In the past I used SAS 9.4 to do ETL then create Warehouse.  Here is my question.  Will I be able to do the same thing in SAS Viya or will I have to purchase both SAS 9.4 and Viya, create the warehouse in 9.4 then transfer Warehouse over to Viya on an MS Azure platform?

[JosvanderVelden]

The SAS Viya platform includes multiple servers to execute SAS code. The two primary servers are the SAS Compute Server (for running sas 9.4 code) and SAS Cloud Analytic Services, or CAS (allows for parallel processing on in-memory data).
For data management issues you can have a look at the information here: https://developer.sas.com/guides/sas-viya-data-management.html.
You can also read the paper for some background information: https://support.sas.com/content/dam/SAS/support/en/technical-papers/sas9-4-sas-viya-functional-compa... (paper is from 2020 and integration is even better now).

[LinusH]

Designing a DW solution is not easily done i a single post - there are a lots of "it depends".

If your reference is building the solution using SAS Data Integration Studio i 9.4, the corresponding tool in Viya 4 is SAS Studio Engineer.

At this point it has almost the capabilities found in DI Studio. But quite a few transformations ("Steps" in SAS Studio) are limited to nly a few source/target data sources.

Regardless, I don't recommend developing a new DW on 9.4.

What is your preferred DW database?

Other constraints, like competence - are your developers familiar with SAS 9.4/Viya?