Database configuration requirements for self-administered instances
Intended audience: System administrators and Amazon QuickSight administrators |
For a database to be accessible to QuickSight, it must meet the following criteria:
-
It must be accessible from the internet. To enable internet connectivity, see your database management system documentation.
-
It must be configured to accept connections and authenticate access using the user credentials that you provide as part of creating the data set.
-
If you are connecting to MySQL or PostgreSQL, the database engine must be accessible from your host or IP range. This optional security limitation is specified in MySQL or PostgreSQL connection settings. If this limitation is in place, any attempt to connect from a nonspecified host or IP address is rejected, even if you have the correct username and password.
-
In MySQL, the server accepts the connection only if the user and host are verified in the user table. For more information, see Access Control, Stage 1: Connection Verification
in the MySQL documentation. -
In PostgreSQL, you control client authentication by using the
pg_hba.conf
file in the database cluster's data directory. However, this file might be named and located differently on your system. For more information, see Client Authenticationin the PostgreSQL documentation.