SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS Servers :: Data Warehousing

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

SAS Servers :: Data Warehousing

[ Edited ]

 

Hello, all.

 

I am a new student learning data science, and have just been introduced to SAS SUE.

 

In my next course I will be learning about data warehouses.

 

Does SAS Institute have any data warehouses in a test environment available to us to experiment with and learn on?

 

What other SAS software toolset must I learn in order to build a data warehouse on a cloud resource such as Azure, AWS or Hadoop?

 

Thank you for your consideration.

 

DJ

 

 


Accepted Solutions
Solution
‎06-21-2018 08:54 AM
Super User
Posts: 5,917

Re: SAS Servers :: Data Warehousing

Posted in reply to HigherPurp0se
I'm not aware of any SAS sample environments that should reflect a data warehouse.
The main SW in SAS arsenal specific for DW IMO is Data Integration Studio. And that is unfortunately not available in any of the learning editions of SAS. That said, DW is a concept, not SW. Anyone with a data store and scripting/programming environment could build a data warehouse.
Not sure if there is any cloud specific SAS trainings, but knowledge about SAS/ACCESS should come in handy.
Data never sleeps

View solution in original post


All Replies
Respected Advisor
Posts: 4,791

Re: SAS Servers :: Data Warehousing

[ Edited ]
Posted in reply to HigherPurp0se

Data Warehouses are mainly about how to organize your data so they are easy to maintain and access(query). On this level Data Warehouses are agnostic to technology.

 

Data Warehouses come in many different shapes and sizes so it will depend on what your course will focus on.

 

But if you're after some SAS file based sample data then Cynthia's answer here might guide you.

https://communities.sas.com/t5/General-SAS-Programming/How-to-access-sample-orion-star-data-files-us...

 

 

Occasional Contributor
Posts: 6

Re: SAS Servers :: Data Warehousing

Thank you, Patrick.
Solution
‎06-21-2018 08:54 AM
Super User
Posts: 5,917

Re: SAS Servers :: Data Warehousing

Posted in reply to HigherPurp0se
I'm not aware of any SAS sample environments that should reflect a data warehouse.
The main SW in SAS arsenal specific for DW IMO is Data Integration Studio. And that is unfortunately not available in any of the learning editions of SAS. That said, DW is a concept, not SW. Anyone with a data store and scripting/programming environment could build a data warehouse.
Not sure if there is any cloud specific SAS trainings, but knowledge about SAS/ACCESS should come in handy.
Data never sleeps
Occasional Contributor
Posts: 6

Re: SAS Servers :: Data Warehousing

Thank you, LinusH.
SAS Employee
Posts: 17

Re: SAS Servers :: Data Warehousing

DI Studio is a tool for building all the processes for ingesting data into (and out of) a DW, and there's nothing inherent in it that takes any particular form or design of DW into account.

 

I think it's best to think of DIS as an ETL tool - "Extract Transform Load" (as well as some of the conceptual variants of paradigm like ELT.)

 

I would separate "Data Warehouse design" from "ETL design".

 

There are definitely a number of "patterns" that would come to mind, in thinking of ETL design - but that's a subject for a longer post.

 

What I would say is that the primary considerations are about long term cost of ownership and operation of the ETL processes, rather than the minutiae of "DW design".

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 169 views
  • 2 likes
  • 4 in conversation