To enable the SQL persistence for the Notifications extension notification-elastic, set the application property notification.​persistence to sql for the applications Studio Server and User Changes Application.

Supported SQL databases can be found in the document http://bit.ly/cmcc-12-supported-environments.