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 SystemAzure Virtual Machine Azure MS-SQL Azure ADLS2 Azure Databricks Azure SynapseData Access from Azure Data Sources to SASORC 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 tableData Access from Azure Data Sources to Viya/CASADLS 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
