Description of the Sub-Menu SQL Management
From Metis Documentation
Line 53: | Line 53: | ||
===Transfering an SQL Connection=== | ===Transfering an SQL Connection=== | ||
- | The | + | The "Transfer" button [[File:MetisSmartModelingTransferButton.PNG|link=]] allows the user to transfer data from one SQL connection to another. Selcting a connection and clicking on the button opens the '''Transfer''' window with the following options appearing in the window. |
Line 89: | Line 89: | ||
- | ===Maintenance on | + | ===Maintenance on Databases === |
+ | |||
+ | The "Maintain" button [[File:MetisSmartModelingMaintainButton.PNG|link=]] allows the administrator to set the selected database in maintenance mode. This disables all access to the selected database. Once clicked, a warning message asks for for confirmation on blocking access to the database. | ||
+ | |||
+ | |||
+ | [[File:MSM-Data-Management-SQL-Connections-Maintain.png|center]] | ||
+ | |||
+ | |||
+ | Once validated, the selected database is shown in the list with a red cross in the leftmost column of the table. To enable back access to the database, the administrator should select it and click on the "Maintain" button [[File:MetisSmartModelingMaintainButton.PNG|link=]] again. This will bring to the screen a warning message asking to confirm the operation. | ||
+ | |||
+ | |||
+ | [[File:MSM-Data-Management-SQL-Connections-Maintain2.png|center]] | ||
+ | |||
- | |||
==SQL Access Tab== | ==SQL Access Tab== | ||
- | On this tab, the SQL Accesses are presented in a table | + | On this tab, the SQL Accesses are presented in a table by showing simply the SQL Access Name. All but the maintenance feature are available in this tab. |
+ | [[File:MSM-Data-Management-SQL-Access.png|center|600x400px]] | ||
===Adding an SQL Access=== | ===Adding an SQL Access=== | ||
- | + | The "Add" button [[File:MetisSmartModelingAddButton.PNG|link=]] allows the administrator to create a new SQL access. Clicking on it opens the '''SQL Access''' window. Here he can define a new SQL Access by providing the necessary information. | |
+ | |||
+ | |||
+ | [[File:MSM-Data-Management-SQL-Access-Add.png|center]] | ||
- | + | * '''Designation''' : name of the SQL access | |
+ | * '''Smart Modeling''' : define which SQL Connection the new Access will use in Metis Smart Modeling. | ||
+ | * '''Smart Quotes''' : define which SQL Connection the new Access will use in Metis Smart Quotes. | ||
- | + | Once all fields have been set, validating the window will save the new SQL Access in Metis Smart Suite and it will be made available in the Functionality Profile definition screen. | |
- | + | ||
- | + | ||
- | === | + | ===Transferring an SQL Access=== |
- | The | + | The "Transfer" button [[File:MetisSmartModelingTransferButton.PNG|link=]] allows the user to transfer data from one SQL connection to another. Clicking on the button opens the '''Transfer''' window with the following options appearing in the window. |