Connecting to an external database

This section describes the connection method when the database is set to "external database" when creating a query in "Query".

Target Database

Select the type of database server to connect to.

• PostgreSQL
• MySQL

Host Name

Set the connection host name of the database server.

Port

Set the port number of the database server.

Database Name

Set the database name.

Table Name

Set the table name operated by the query.

User Name

Set the user name used for connection.

Password

Set the password corresponding to the user name.

Test Connection

You can check whether connection is possible with the set values.

Columns cannot be added if the connection test is not successful, so be sure to do so when using an external database.