Specify DBMSType Extended Attribute for the Output Library

To use a non-SAS database for the Profitability Management output library, you must specify an extended attribute, DBMS type, using SAS Management Console.

1. Open SAS Management Console.

2. Click the Plugins tab.

3. Expand the Libraries folder (under Environment Management Data Library Manager) and select your Profitability Management output library.

   

4. Right-click the library and select Properties.

5. Select the Extended Attributes tab.

6. Click New.

7. In the Field Name column, type DBMSType.

   
   

8. In the Value and Description columns, type one of the following pairs (the Description is optional):

   Value	Description
   MSSQL	Microsoft SQL Server
   Oracle	Oracle
   MySql	MySql

   For example:

   

9. Click OK.