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.

| <mediaplayer width='400' height='300' image='http://http://www.xpert-technologies.ch/mediawikidev/images/f/fa/VID_Enable_the_connection_to_other_databases.png'>File:Enable_connection_to_other_databases_OK.mp4</mediaplayer>

| Enabling an SQL Connection to other databases.

| Ticking the check-box of an SQL connection in the second section ONLY allows data transfer from the newly created connection to the ticked connection, not both ways. The user must edit both of the connections and tick the corresponding check-boxes for mutual data transfer.

 

 

 

 

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.

 

 

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

 

 

 

 

* '''Systems''' : transfer system related data

* '''Models''' : transfer model related data

* '''Rights''' : transfer Right and Profile related data

* '''Users''' : transfer User related data

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

===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-Maintain2.png|center]]

==SQL Access Tab==

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

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.

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

* '''Designation''' : name of the SQL access

 

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

In both tabs, the "Edit" button [[File:MetisSmartModelingEditButton.PNG|link=]] located above the main tables allows the user/administrator to apply modifications to all properties related to the selected SQL Connection or SQL Access . Selecting either one and clicking on it opens the corresponding edition window where all related properties and information can be edited.

 

 

 

 

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.