Description of the Sub-Menu SQL Management

As Metis Smart Suite Databases can be located either locally or remotely from the application and especially that Metis Smart is able to connect different databases from one installation, the application requires all connections to be configured within Metis Smart Suite. The SQL Management sub-menu enables the administrator to define both SQL Connections and Accesses. SQL Access are settings using a combination of Connections to simplify the selection of appropriate Connections when defining a [[Description_of_the_Sub-Menu_Functionalities|functionality profile]]. Split over two tabs, the user can add, delete, edit, preview connections and accesses in this sub-menu, as well as transfer data from one connection to another and prepare databases for maintenance.

This destination server must allow network transactions. For any questions regarding SQL Administration. The organization should be contacted!

* '''Connection Name''' : name of the connection

* '''Server''' : name of the server

* '''Database''' : name of the database

* '''User''' : name of the user used to access the Database

In the '''SQL Connections''' sub-menu, on the SQL Connections tab, the "Add" button [[File:MetisSmartModelingAddButton.PNG|link=]] located above the main table allows the user/administrator to create a new SQL Connection. When it is clicked, the '''SQL Connection''' creation window opens, it allows to define all related information.

* '''Authorized''' : The check-box can be ticked to authorized data transfers to the selected selected database. Multiple check-boxes can be ticked.

* '''Transfer to''' : The connection to which data transfer can be established. Ticking the check-box of any of the listed SQL Connections will allow data transfer from the newly created connection to the ticked connections.

| Mandatory fields are displayed in '''bold''' or with a red triangle in front of the field.

 

 

 

 

 

 

The "Transfer" button [[File:MetisSmartModelingTransferButton.PNG|link=]] allows the user to transfer data from one SQL connection to another. Selecting a connection and clicking on the button opens the '''Transfer''' window with the following options appearing in the window.

* '''From''' : drop-down list of the connections to take data from

* '''To''' : drop-down list of the connections to send data to

 

The following check-boxes are displayed and can be individually checked or the user can use the ''Select All | None'' option found at the bottom. These represent Metis objects to be transferred.

Once the choices have been made, the user must click on the "Start transfer" button at the bottom of the window. Once the button has been clicked, a warning message is displayed explaining what will happen if the data transfer is carried out.

In the '''SQL Connections''' sub-menu, on the SQL Accesstab, the "Add" button [[File:MetisSmartModelingAddButton.PNG|link=]] located above the main table allows the user/administrator to create a new SQL Access. When it is clicked, the '''SQL Access''' creation window opens, it allows to define all related information.

Once all related mandatory and optional information have been set, the new SQL Access can be saved by validating the '''SQL Access''' window using the [[File:MetisSmartModelingOKButton.PNG|link=]] button at the bottom of the 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.

| Having this functionality in the SQL Access tab is intended to limit moving back and forth in the two tabs.

[[File:MSM-Data-Management-SQL-Connections-Edit.png|center|600x400px]]

 

 

For detailed descriptions of all information available in this window please refer to the section dedicated to the creation of a new SQL Connection or SQL Access. Modifications applied to the selected SQL Connection or SQL Access will only be saved once the SQL Connection or SQL Access edition window is validated using the [[File:MetisSmartModelingOKButton.PNG|link=]] button at the bottom of the window. This will update the tables displayed on the main screen. Using the "Cancel" [[File:MetisSmartModelingCancelButton.PNG|link=]] button discards all changes and closes the window.

In both tabs, the "Delete" button [[File:MetisSmartModelingDeleteButton.PNG|link=]] located above the main tables allows the user/administrator to delete the selected SQL Connection or Access. Selecting one or more SQL Connections or Accesses and clicking on it displays the following confirmation window.

[[File:MSM-Data-Management-SQL-Connections-Del.png|center]]

In both tabs, the "Preview" button [[File:MetisSmartModelingPreviewButton.PNG|link=]] located above the main table allows the user/administrator to see all properties and information related to the selected SQL Connection or Access.

 

 

[[File:MSM-Data-Management-SQL-Access-Preview.png|center]]

 

Selecting an SQL Connection or Access from the table and clicking on it opens the '''SQL Connection or Access''' preview window. For detailed descriptions of all information available in this window please refer to the section dedicated to the creation of a new SQL Connection or Access.  

| Edition of the information and properties displayed herein is not possible. If modification are necessary, the edition function described above should be used.