Add and Manage Databases
Last updated 21/10/2024
Who Can Add and Manage Databases?
Please refer to the chapter Five's Users and Roles.
Supported External Databases
You can select to create a connection to the following external Database Management Systems (DBMS).- MSSQL
- MySQL
Connection String Details
tip
When importing an SQL file, the name of your database in the external database must exactly match the name of your database in Five. This is the value in the Database ID field for the database record.
To use an external database, you will need to have an account created with the database provider.
The connection string configures Five's database connection to connect to the external DBMS. You need to provide the connection string to establish the database connection. The connection string represents a set of parameters in the form of key=value pairs separated by semicolons.
Key | Value | Example |
---|---|---|
Driver | The database driver allows you to interact with your chosen DBMS through Five's interface. | driver=mssql |
URL | A database connection URL provides a way of identifying a database so that the selected driver recognizes it and connects to it, this can be a host name or an IP address including the port number. | url=serverdb.host.com:1433 |
Username | Your username in your DBMS. | username=user |
Password | Your password in your DBMS. | password=password |
Name | The name of your database in your DBMS. | name=exampleDB |
Example
driver=mssql; url=serverdb.host.com:1433; username=user; password=password; name=exampleDBcaution
The value in the Database ID field must exactly match the name value in your connection string as shown in the image below, meaning, the Database ID and the name of your external database must exactly match.

Figure 1 - Database form