{"id":2287,"date":"2020-04-14T01:48:20","date_gmt":"2020-04-14T01:48:20","guid":{"rendered":"https:\/\/support.mpsoftwarecmms.com\/?page_id=2287"},"modified":"2023-11-17T23:18:07","modified_gmt":"2023-11-18T05:18:07","slug":"opciones-de-conectividad-de-la-base-de-datos","status":"publish","type":"page","link":"https:\/\/support.mpsoftwarecmms.com\/en_us\/opciones-de-conectividad-de-la-base-de-datos\/","title":{"rendered":"Opciones de conectividad de la Base de Datos"},"content":{"rendered":"
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Home<\/a> \/ About the installation, databases and the environment<\/a><\/p>\n

Connectivity options of the database<\/strong><\/h2>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Index<\/strong>
\n<\/a><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Types of databases and where you can stay<\/a>
\nAccess to the database engine when hired Cloud or Hosting<\/a><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/span><\/span><\/span><\/span><\/span>
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\r\n
\r\n\t
\r\n\t\t

Related topics<\/strong><\/h4>\n

\u25b8 Uses the database of examples to practice and learn the Software<\/a>
\n\u25b8 Basic concepts about the creation of new databases<\/a>
\n\u25b8 What is an access to the database?<\/a>
\n\u25b8 Selection of the Database when you enter the application<\/a>
\n\u25b8 How do I create a new database?<\/a>
\n\u25b8 Streamlined for the creation of databases on your local computer<\/a>
\n\u25b8 Advanced option for the creation of databases in the cloud or on a network<\/a>
\n\u25b8 Introduction to data migration from previous versions<\/a>
\n\u25b8 How do I migrate the information from my previous versions?<\/a>
\n\u25b8 Migration of databases without warranty<\/a>
\n\u25b8 Reason to register the users who will have access to each database<\/a>
\n\u25b8 What happens if I do not log users?<\/a>
\n\u25b8 Who is the admin user of the databases?<\/a>
\n\u25b8 Register users and assign user profiles<\/a>
\n\u25b8 Create custom access levels<\/a>
\n\u25b8 Log of transactions<\/a>
\n\u25b8 Connection of the programs installed on your computer with the database<\/a>
\n\u25b8 Create a shortcut in your pc to connect to a database<\/a>
\n\u25b8 Connection of the database with mobile devices<\/a><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t

<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Types of databases and where you can stay<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

All the information you register in the Suite are stored in databases and can be shared by multiple users at the same time.<\/p>\n

To store, query, protect, share and manage the information in the database, just like any other computer system, it requires the service of a database engine to perform the process.<\/p>\n

On the market there are different manufacturers of engines of databases, each with its own characteristics and features, some free to use, and other trade that requires the purchase of a license not included.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\r\n
\r\n\t
\r\n\t\t\n\n\n\n\n\n\n\n\n\n
THE COMPLETE SUITE IS COMPATIBLE WITH THE DATABASE ENGINES USED TODAY<\/strong><\/td>\n<\/tr>\n
Free to use:<\/td>\n<\/td>\nThe Databases can be hosted on:<\/strong>
\n\u2013 The user's PC
\n\u2013 Virtual teams
\n\u2013 All type of networks (Wan, Lan, Wlan, Vlan, etc)
\n\u2013 Servers or web hosting in the cloud
\n\u2013 In our servers in the cloud if you hired the service Cloud<\/a> or Hosting<\/a><\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nFirebird<\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nMySQL<\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nMariaDB<\/td>\n<\/tr>\n
Owner or business:<\/td>\n\u00a0<\/strong><\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nMicrosoft SQL-Server<\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nOracle<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

OH OFFERING YOU WITH THIS, A WIDE RANGE OF CONNECTIVITY OPTIONS!<\/strong><\/h2>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Since many computer applications require any of these database engines, it is very likely that your company already have installed any one of the database engines described above.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>
<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\r\n
\r\n\t
\r\n\t\t

Your IT department or systems will be able to advise you and help you to choose the database engine, as well as the location of the database, in accordance with the infrastructure and policies IT company.<\/h4>\n

Now, if you need mobility, no matter where you are and don't want to bond in these topics, or do not wish to use the IT infrastructure of the company, you can choose to hire our hosting services in the cloud Cloud<\/a> or Hosting<\/a>.<\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Access to the database engine when hired Cloud or Hosting<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Service Cloud<\/strong><\/span><\/p>\n

Cloud is a service that we offer in the form are optional, for the accommodation of your databases on one of our servers in the cloud, allowing you to access on a shared basis to your databases in the cloud from any place with access to the Internet.<\/p>\n

In the case of the service of Cloud hosting, you should be aware that the program is installed and run from your local computer. The only thing that is hosted in the cloud are your databases. Therefore, you need to install the program on each of the computers on which you use it as a user with full access, by following the steps that are described in the installation of the program.<\/a><\/p>\n

The Support team is responsible for preparing a server in the cloud, exclusive for your company with a database engine MySQL properly enabled, making it easy for you and avoiding the work that this process might be involved for you or your company.<\/p>\n

Once hired, the service Cloud, the support team provides you the access data to the server for the creation and connection of your databases in the cloud<\/a>.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\r\n
\r\n\t
\r\n\t\t\n\n\n\n\n\n
\n

Information to create and connect to MySQL databases in the Cloud
\n<\/strong>(These data are sent at the time of contracting the service MPcloud in your detail purchase)<\/p>\n<\/td>\n<\/tr>\n

IP address of the server<\/td>\nThese data are unique to each company and with them, you can create your new database, as well as connect to existing databases<\/td>\n<\/tr>\n
User BD<\/td>\n<\/tr>\n
Password<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Hosting Service<\/strong><\/p>\n

Hosting is a service that we offer in the form are optional, for the accommodation of the suite of programs, and your database on one of our servers in the cloud, allowing you to access on a shared basis to the programs and databases in the cloud from any place with access to the Internet.<\/p>\n

In the case of Hosting, unlike the Cloud, you don'T NEED to INSTALL THE PROGRAM ON YOUR computer, as the program is installed in the cloud and users are running on a shared basis by means of a remote desktop.<\/p>\n

When you buy the Hosting service, the Technical Support team is responsible for preparing a server in the cloud, exclusive for your company with a database engine MySQL properly enabled, in addition to stops installed the operating system and the programs of the suite, so that you can go to the programs and their respective databases from any location with Internet access and any device, whether a pc, tablet, Ipad, or any mobile device regardless of the operating system, since the program is run in the cloud server.<\/p>\n

In addition, when you hire this service, the Technical Support team is responsible for managing the server in the cloud, so you won't have to worry about anything else apart from the management of the maintenance of your assets.<\/p>\n

When you buy the Hosting service, the Technical Support team makes you get all the information you need to enter the service<\/a>. In addition, along with the information above, the Technical Support team provides you with the data you will need for creation and connection of your databases in the cloud<\/a>.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\r\n
\r\n\t
\r\n\t\t\n\n\n\n\n\n
Information for creating and connecting to MySQL database Hosting<\/strong>
\n(These data are sent at the time of hire the Hosting service)<\/td>\n<\/tr>\n
Server name<\/td>\nThese data are unique to each company and with them, you can create your new database.<\/td>\n<\/tr>\n
User BD<\/td>\n<\/tr>\n
Password<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>
<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\tNext topic: Creating new databases<\/span><\/a>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\r\n
\r\n\t
\r\n\t\t

Can't find the answer to your doubts or questions?<\/h1>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Additionally, we offer training courses<\/strong><\/h2>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Our flexible options of online training and face-to-face will provide you with all the knowledge necessary to understand and implement your software maintenance.<\/span><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>Contact us<\/span><\/a>\r\n
\r\n\t
\r\n\t\t


\n

\r\n \r\n
\u00d7<\/span>
\r\n \r\n

Consideration if you are going to use the engine for Firebird database<\/strong><\/h4>\r\n\t\t\t

\r\n

However, the excellent performance that this database engine provides, it is important to take into account that this database engine is only recommended for users that do NOT want to use the mobile applications MPsolicitudes or MPmobile, because these APPs ARE NOT COMPATIBLE WITH THE ENGINE FIREBIRD DATABASES.<\/p>\r\n \r\n <\/div>\r\n<\/div>
\n

\r\n \r\n
\u00d7<\/span>
\r\n \r\n

Name of the database and its location.<\/strong><\/h4>\r\n\t\t\t

\r\n

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: \u00a1 " # , $ % & ( \u00bf ) ? } { The reason for this is that there are some rules or policies that the database engines prohibit the use of these characters.<\/p>\r\n\t\t\t\t\t\r\n\t\t\t

You'll have another field of up to 50 characters that will allow a broader description and complete database.<\/p>\r\n\t\t\t

Example:<\/p>\r\n\t\t\t\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Name of the database<\/strong><\/td>\r\nName of the access to the database<\/strong><\/td>\r\nLong description of the database<\/strong><\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_1<\/td>\r\nACCESS TO PLANTA_SPEREN_1<\/td>\r\nPLANT SPEREN PARQUE INDUSTRIAL EXPORTEC II<\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_2<\/td>\r\nACCESS TO PLANTA_SPEREN_2<\/td>\r\nPLANT SPEREN PARQUE INDUSTRIAL HUEHUETOCA<\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_3<\/td>\r\nACCESS TO PLANTA_SPEREN_3<\/td>\r\nPLANT SPEREN INDUSTRIAL PARK JILOTEPEC<\/td>\r\n<\/tr>\r\n
HOTEL_Mara_A<\/td>\r\nACCESS TO HOTEL_Mara_A<\/td>\r\nHotel All Inclusive Mara Place, Cancun, QR<\/td>\r\n<\/tr>\r\n
HOTEL_Mara_B<\/td>\r\nACCESS TO HOTEL_Mara_B<\/td>\r\nGran Executive Hotel Mara Place mexico City, Mexico<\/td>\r\n<\/tr>\r\n
HOSPITAL_TRAUMATOLOGIA<\/td>\r\nACCESS TO HOSPITAL_TRAUMATOLOGIA<\/td>\r\nHospital of Traumatology Loma Verdes, Naucalpan<\/td>\r\n<\/tr>\r\n
HOSPITAL_NEUROLOGIA<\/td>\r\nACCESS TO HOSPITAL_NEUROLOGIA<\/td>\r\nNational institute of Neurology and Neurosurgery, CDMX<\/td>\r\n<\/tr>\r\n
FLOTILLA_1<\/td>\r\nACCESS TO FLOTILLA_1<\/td>\r\nFleet Cars and trucks SPEREN EXPORTEC II<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\t\t\t

After you've created your databases in the MP, these are hosted on the Database Server that you've chosen. For example, the databases created by the streamlined staying in your computer, the path in which you can find is C:\\Windows\\SysWow64 or C:\\Windows\\System32. Regularly are Files with the Extension.FDB<\/p>\r\n\t\t\t

The databases created in the following types of databases: MariaDB, MySQL, SQL-Server, MPcloud and Oracle does not generate Files. The information is stored in multiple tables of schema information, or in special environments of your server.<\/p>\r\n\t\t\t

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.<\/p>\r\n \r\n <\/div>\r\n<\/div>
\n

\r\n \r\n
\u00d7<\/span>
\r\n \r\n\t\t

Server IP, user name and password of the database engine<\/strong><\/h3>\r\n\t\t

\r\n\r\n

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.<\/p>\r\n\r\n

For example:<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
DATABASE ENGINE<\/strong><\/td>\r\nADMINISTRATOR USER BY DEFAULT<\/strong><\/td>\r\nPASSWORD\r\n<\/strong>(Known only to the manager of IT)<\/strong><\/td>\r\n<\/tr>\r\n
MySQL<\/td>\r\nroot<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Microsoft SQL-Server<\/td>\r\nsa<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Oracle<\/td>\r\nSystem<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
MariaDB<\/td>\r\nroot<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Firebird<\/td>\r\nSYSDBA<\/td>\r\n******<\/td>\r\n<\/tr>\r\n<\/table>\r\n

When you create a database, or a new connection on the MP, the program prompts you for the server name or IP where you will create or is the database to which you want to connect to, as well as a user name and password.<\/p>\r\n

The username and password that here we ask, are precisely those that allow access to the <\/em>database engine <\/em>permissions privileges to create the database. <\/em><\/h4>\r\n

\r\n\t\t\t\r\n

\r\n

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.<\/p>\r\n\r\n

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.<\/em><\/h4>\r\n

A single user account to the database engine is sufficient for the creation and connection of multiple databases.<\/p>\r\n\r\n

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.<\/p>\r\n\t\t \r\n <\/div>\r\n<\/div>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>","protected":false},"excerpt":{"rendered":"Inicio \/ Acerca de la instalaci\u00f3n, bases de datos y el entorno Opciones de conectividad...","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/2287"}],"collection":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/comments?post=2287"}],"version-history":[{"count":39,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/2287\/revisions"}],"predecessor-version":[{"id":7117,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/2287\/revisions\/7117"}],"wp:attachment":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/media?parent=2287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}