Description of the Sub-Menu SQL Management
From Metis Documentation
| Line 127: | Line 127: | ||
| - | ===Transferring | + | ===Transferring in SQL Access=== |
| - | 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 | + | 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 '''SQL Connection Transfer''' window. The function is the same previously described, as it refers to SQL Connections. |
| - | + | {{Note | |
| + | | Having this functionality in the SQL Access tab is intended to limit moving back and forth in the two tabs. | ||
| + | }} | ||
| - | |||
| - | |||
| - | |||
| - | + | ==Modifying an SQL Connection or Access== | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | In both tabs, the "Edit" button [[File:MetisSmartModelingEditButton.PNG|link=]] allows the user to edit an SQL Connection or Access. | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | Selecting a connection or access and clicking on it opens the '''SQL Connection''' or '''SQL Access''' window. All the fields, dropdown lists and checkboxes that were available in the '''Add''' window are now editable here. | |
| - | |||
| - | + | [[File:MSM-Data-Management-SQL-Connections-Edit.png|center|600x400px]] | |
| - | + | ||
| - | + | ||
| + | The modifications will be stored once the window is validated. | ||
| + | ==Deleting an SQL Connection or Access== | ||
| - | = | + | In both tabs, the "Delete" button [[File:MetisSmartModelingDeleteButton.PNG|link=]] allows the user to delete an existing SQL Connection or Access. When deleting a connection or access, the following pop-up window appears: |
| - | |||
| - | + | [[File:MSM-Data-Management-SQL-Connections-Del.png|center]] | |
| - | + | [[File:MSM-Data-Management-SQL-Access-Del.png|center]] | |
| - | |||
| - | |||
| - | + | The user must confirm the message before the connection or access can be deleted. | |
| - | |||
| + | {{Note | ||
| + | | In each tab, multiple Connections or Access can be selected for deletion. | ||
| + | }} | ||
| Line 186: | Line 174: | ||
==Previewing an SQL Connection or Access== | ==Previewing an SQL Connection or Access== | ||
| - | + | In both tabs, the "Preview" button [[File:MetisSmartModelingPreviewButton.PNG|link=]] allows the user to see the properties of the selected SQL connection or access. Selecting an SQL connection and clicking on it opens the '''SQL Connection''' or '''SQL Access''' window where the properties are displayed. | |
| + | |||
| + | |||
| + | [[File:MSM-Data-Management-SQL-Access-Preview.png|center|600x400px]] | ||
| - | |||