If you're an administrator, one of your first steps will be connecting a supported database to Infinity. In this article we'll describe this process from beginning to end.
Select a database
To select a database, choose the icon and select the option from the left navigation bar.
In the Create Data Source window, select the appropriate database card.
Infinity supports the databases listed above. If you don't see your preferred database listed, or if you are an enterprise customer, please contact [email protected] to have your database added.
Configure the connection
You can configure the database connection by providing connection credentials. For security reasons, you may need to allow the IP associated with your private Infinity workspace. Please note that the IP address shown below is not the IP address for your workspace. Your workspace IP will be unique to your organization and will be shown in the connection configuration screen.
Fields you may encounter when defining credentials include:
Datasource Name*: A nickname for the database (for display in Infinity).
Database Name*: The name of the database that you are connecting to.
Host*: A host, defined as either an IP address or as a domain.
Port*: Enter a relevant port number for the connection. If user does not have a port number, then use the database's default port value. This fields is used when connecting Redshift (default port 5439), PostgreSQL (default port 5432), and MySQL (default port 3306) databases.
Username*: The username associated with a user account.
Password: The password associated with a user account.
Roles: The list of user roles who can tap into this connection. By default, all roles will have access to all connections.
Additional Parameters: Any additional custom parameters, if needed.
SSL: Select the switch to require a SSL connection.