![]() You can then click either Create app to immediately start building a Retool app or Back to resources to return to the list of resources. Save the resource Ĭlick Create resource to complete the setup. It cannot check whether the provided credentials have sufficient privileges or can perform every supported action. Testing a connection only checks whether Retool can successfully connect to the resource. If the test fails, check the resource settings and try again. Provide the following information to configure SSL: SettingĬlick Test Connection to verify that Retool can connect to PostgreSQL. SSL is required for AWS IAM authentication and cannot be disabled. If you're using username and password authentication, check Connect using SSL to display additional fields for this information. ![]() Retool supports SSL connections for both authentication methods using custom certificate credentials. This ensures the connection is secure and prevents attackers from using invalid server certificates to gain access to your data. Retool strongly recommends using SSL and not to skip TLS certificate validation. The AWS region in which the database is located. Select AWS IAM Authentication as the authentication method, then provide the following information. Select User and Password as the authentication method, then provide the following information. Retool can connect to a PostgreSQL database using either user and password, or AWS IAM authentication. You can also click Import from connection string and enter a database connection string to automatically populate these settings. General SettingĪdditional connection options to use with Retool. Retool displays the resource name and type in query editors to help users identify them. Specify a name and location for the PostgreSQL resource. Retool can automatically populate values from a PostgreSQL connection string. Sign in to your Retool organization and create a new PostgreSQL resource from the Resources tab. Retool can connect to almost any API or database, and has built-in integrations for popular data sources. Add the IP addresses to your firewall's Allowlist before you create the resource. If your PostgreSQL database is behind a firewall, you must allow access from Retool's IP addresses. Allow Retool to access the PostgreSQL database Retool automatically configures the necessary SSL credentials and certificates for AWS-hosted databases. If required by your database host, you can provide CA certificate, client key, and client certificate credentials that allow Retool to connect using SSL. SSL connections īoth authentication methods use SSL by default. Use the AWS IAM console to create and manage AWS IAM keys. AWS IAM įor AWS-hosted PostgreSQL databases, Retool supports IAM authentication that enables authentication using access keys. This provides more granular control over PostgreSQL users and allows you to control the scope of permissions. It is strongly recommended that you create a username and password for this purpose and not reuse an existing user. You can provide a username and password for Retool to authenticate with your PostgreSQL host. The authentication method you use determines the configuration settings required. Retool authenticates with PostgreSQL databases using either a username and password, or with AWS IAM credentials. Firewall rules that allow Retool to access your PostgreSQL host.This includes the hostname, port, and database name. ![]() Connection details for the PostgreSQL database host.This can be either a username and password, or AWS IAM authentication (for AWS-hosted PostgreSQL databases). Authentication credentials for the PostgreSQL database.To create a PostgreSQL resource, you need: If your organization manages user permissions for resources, you must be a member of a group with Edit all permissions. ![]() All users for Retool organizations on Free or Team plans have global Edit permissions and can add, edit, and remove resources. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |