Native Connections
Native connections are direct connections to a database's own network protocols and drivers. Therefore, no additional drivers need to be installed. Native connections provide the most efficient method of interacting with the database and full feature support.
If you intend to deploy files for execution on a Linux or macOS server, you do not need to install drivers on the target server.
You can set up native connections to the following DBs:
•MariaDB
•MySQL
•SQLite
•PostgreSQL
Connection setup
To set up a native connection, follow the steps below:
1.Start the database connection wizard.
2.Select the DB you want to connect to.
3.In the dialog that appears, enter the relevant connection details, for example, the host (e.g., localhost), optionally the port (typically 5432), SSL Mode in the case of MySQL, the database name, username, and password in the corresponding boxes.
4.Click Connect.
SQLite conections
For detailed information about SQLite connections, see the topic SQLite Connection.
Notes for PostrgreSQL
If the PostgreSQL database server is on a different machine, note the following:
•The PostgreSQL database server must be configured to accept connections from clients. Specifically, the pg_hba.conf file must be configured to allow non-local connections. Secondly, the postgresql.conf file must be configured to listen on specified IP address(es) and port. For more information, check the PostgreSQL documentation (https://www.postgresql.org/docs/9.5/static/client-authentication-problems.html).
•The server machine must be configured to accept connections on the designated port (typically, 5432) through the firewall. For example, on a database server running on Windows, a rule may need to be created to allow connections on port 5432 through the firewall, from Control Panel > Windows Firewall > Advanced Settings > Inbound Rules.