SAS Viya: Data Management on Azure Cloud
DE286W : DE286W
This course prepares you to use Azure data sources with SPRE/SAS and SAS Viya/CAS. Topics include the Azure Eco system, Azure Data Lake Storage Gen2 (ADLS2), MS SQL Server, Azure Synapse, and connecting SAS and CAS to Azure data sources. The course provides practical hands-on exercises to fortify the material.
Learn How To
- access a SAS-managed Azure environment
- create persistence volume and persistence volume claim to Azure File Share
- configure Viya 4 environment for Azure Access Key and Access Clients components
- load data to Azure File share and ADLS2 storage
- access sas7bdat files in Viya 4 CAS
- connect Azure MS-SQL, ADLS2, Synapse from SAS and CAS
- read ORC and Parquet files from ADLS2 to SAS and CAS
- create Azure Synapse dedicated and SQL pool
- read and write data from Azure Synapse dedicated SQL Pool database to SAS and CAS
- create Azure Synapse serverless SQL pool and Spark Pool
- load/ingest data/files from ADLS2 to Azure Synapse Built-In SQL pool and Spark Pool
- create Azure Databricks Service with Spark Cluster
- load/ingest data/files from ADLS2 to Databricks Spark Cluster
- read Spark/Hive table from Azure Databricks to SAS and CAS.
Who Should Attend
Technical resources who support SAS Viya on a cloud environment
Prerequisites
You should have a working knowledge of UNIX/Linux and experience with the visual interfaces in SAS Viya.
SAS Products Covered
SAS Viya
Course Outline
Azure Eco System
- Azure Virtual Machine
- Azure MS-SQL
- Azure ADLS2
- Azure Databricks
- Azure Synapse
- ORC LIBNAME to ADLS2 location
- FILENAME to ADLS2 location
- SAS access to MS-SQL server
- SAS access to Synapse dedicated SQL Pool database table
- SAS access to Synapse serverless SQL Pool database table
- SAS access to Synapse Spark Pool database table
- ADLS CASLIB to read ORC, Parquet, and CSV files from ADLS2 location
- CAS access to MS-SQL server using data connector
- CAS access to Databricks Spark/Hive table
- CAS access to Synapse Dedicated SQL Pool database table
- CAS access to Synapse Serverless SQL Pool database table
- CAS access to Synapse Spark Pool database table
Live Class Schedule
Duration: 10.5 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and mentoring may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.