Description of the Sub-Menu SQL Management
From Metis Documentation
Line 1: | Line 1: | ||
- | + | As Metis Smart Suite Database can be located either locally or remotely form the application and especially that Metis Smart is able to connect different database 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 slection of appropriate Connections when defining a Functionality Profile. Split between two tabs, the user can add, delete, edit, preview connections and accesses in this menu, as well as transfer data from one connection to another and maintaining the various databases. | |
- | + | ||
- | + | ||
- | + | ||
Line 13: | Line 10: | ||
==SQL Connections Tab== | ==SQL Connections Tab== | ||
- | + | In this tab, the SQL connections are presented in a table with the following five columns: | |
+ | |||
+ | * '''Red X''' or '''Green Check-mark''' : A red X means that the connection is not available and is currently under maintenance or not reachable. The green check-mark means that everything is ok with the SQL connection. | ||
+ | * '''Connection Name''' : the name of the connection | ||
+ | * '''Server''' : the name of the server | ||
+ | * '''Database''' : the name of the database | ||
+ | * '''User''' : the name of the user used to access the Database | ||
+ | |||
+ | |||
+ | [[File:MSM-Data-Management-SQL-Connections.png|center|600x400px]] | ||
- | |||
- | |||
- | |||
- | |||
- | |||
===Adding an SQL Connections=== | ===Adding an SQL Connections=== | ||
- | On the SQL Connections tab, the | + | On the SQL Connections tab, the "Add" button [[File:MetisSmartModelingAddButton.PNG|link=]] allows the user to create a new SQL connection. Clicking on it opens the '''SQL Connection''' window. The window is split into two sections, the first being the properties of the new SQL connection. |
- | |||
- | + | [[File:MSM-Data-Management-SQL-Connections-New.png|center|600x400px]] | |
- | |||
- | *SQL Connection Name | + | The first section contains the following fields: |
- | *Server Name | + | |
- | *Database Name | + | * '''SQL Connection Name''' : internal name given to the connection |
- | *Username | + | * '''Server Name''' : DNS name of the server or IP address |
- | *Password | + | * '''Database Name''' : Name of the database to be accessed on the given server |
- | + | * '''Username''' : username for accessing the database | |
+ | * '''Password''' password for this username | ||
- | |||
The second section is a list of all other SQL connections organized into two columns: | The second section is a list of all other SQL connections organized into two columns: | ||
- | *Authorized: The checkbox can be ticked to authorized data | + | * '''Authorized''' : The checkbox can be ticked to authorized data transfers to the selected selected database. Multiple checkboxes can be ticked. |
- | *Transfer to: The connection to which data transfer can be established. Ticking the checkbox of any of the listed SQL Connections will allow data transfer from the newly created connection to the ticked connections. | + | * '''Transfer to''' : The connection to which data transfer can be established. Ticking the checkbox of any of the listed SQL Connections will allow data transfer from the newly created connection to the ticked connections. |
+ | |||
{{Note | {{Note | ||
Line 50: | Line 50: | ||
}} | }} | ||
- | |||
===Transfering an SQL Connection=== | ===Transfering an SQL Connection=== | ||
Line 88: | Line 87: | ||
===Maintenance on defined Databases === | ===Maintenance on defined Databases === | ||
- | + | The '''Maintain''' field is a checkbox with a Yes or No option. It should be ticked when the SQL Connection needs to be worked on for maintenance. | |
==SQL Access Tab== | ==SQL Access Tab== |