When an SPS is created from a database (DB) with the File | New from DB command, you can select the option to use a global resource (screenshot below). Other commands where a database-type global resource can be used are database-related commands in the menu.
In the Connection dialog (screenshot above), all the database-type global resources that have been defined in the currently active Global Resources XML File are displayed. Select the required global resource and click Connect. If the selected global resource has more than one configuration, then the database resource for the currently active configuration is used (check Tools | Active Configuration or the Global Resources toolbar), and the connection is made.