Name of the database and its location.

Regarding the name of the database: The name that you define can't wear white space, and the number of characters allowed maximum is 25, for example Maintenance Plant 1 instead use Hyphens or underscores this: Mantenimiento_Planta_1, in addition to it is not allowed that the name of your database-carry special characters such as these: ¡ " # , $ % & ( ¿ ) ? } { The reason for this is that there are some rules or policies that the database engines prohibit the use of these characters.

You'll have another field of up to 50 characters that will allow a broader description and complete database.

Example:

Luego de que has creado tus bases de datos en el MP, estas se alojan en el Servidor de Base de datos que hayas elegido. Por ejemplo, las bases de datos creadas por medio de la opción simplificada se alojan en tu computadora, la ruta en las que puedes encontrarlas es C:\Windows\SysWow64. Regularmente son Archivos con la Extension.FDB

Las bases de datos creadas en los siguientes tipos de bases de datos: MariaDB, MySQL, SQL-Server, Cloud y Oracle no generan Archivos. La información se almacena en múltiples tablas de esquemas de información o en entornos especiales de tu servidor.

Regardless of the type of database Server that you manage, we recommend to make backups of your information frequently so that you get a receipt of your information as a preventive measure in case of an emergency, see the section Backup and restore a database.

Server IP, user name and password of the database engine

Today, virtually all companies have at least one IT professional who is responsible for, among many other functions to manage the data and servers of the company. Among their functions include the administration of a database engine, which, for security reasons, has access by means of a user name and a password. If not, any person could enter the network, and provide high-databases, query, modify and even delete confidential information of the company.

For example:

Al momento de crear una base de datos o una conexión nueva en SVISION, el programa solicita el nombre del servidor o IP en donde se creará o se encuentra la base de datos a la cual deseas conectarte, así como un nombre de usuario y su contraseña.

The username and password that here we ask, are precisely those that allow access to the database engine permissions privileges to create the database.

Now, the administrator of the database can also create different user accounts to allow access to more people by giving them privileges and permissions custom.

With the aim of not to use the administrator user of IT and its respective password each time that the department of maintenance required to create a database or a connection to an existing database, it is recommended that the IT administrator create a user account specifically for the maintenance department.

A single user account to the database engine is sufficient for the creation and connection of multiple databases.

The username and password that here is requested, you do not have any relationship with the licenses of use are acquired or the amount of users that can access the database, so that a single user account can be enough, because in this case it refers specifically to the user and password of the database engine.

What is a access to the database?

When you create a database, it automatically creates an access to the database. Access is a file that contains encoded all information regarding the IP address or name of the server where the database resides. This information is also recorded in a QR code, which will facilitate the connection of mobile devices to the database.