Connection Settings Errors

Error Summary

• Hevo is unable to connect to the configured Source database in the Pipeline.

Potential Causes

• The database connection details are incorrect.

• Hevo’s IP address(es) for your region is not added to the database IP allowlist.

• The database user authorizing the connection does not have sufficient permissions to access the database.

• The Source database is terminating the connection.

Suggested Action(s)

• Verify that the database connection settings, such as the Database Host and Database Port, specified in the Source configuration screen are correct.

  The following table lists the default port numbers for Source databases supported in Edge Pipelines.

  Database	Default Port
  PostgreSQL	5432
  MySQL	3306
  Oracle	1521
  SQL Server	1443

  You can confirm the port number of your database with the database administrator.

• Verify that your Source database is publicly accessible and connections from the public internet are allowed on the database port.

• Specify the public IP address of your database as the Database Host.

• Check if Hevo’s IP address(es) for your region is added to the database IP allowlist. Refer to the Allowlist Hevo IP addresses for your region section in the respective Source documentation for the steps to check this.

• Verify that the Security Group and VPC subnet associated with your Source database allow access from all Hevo’s IP addresses for Amazon RDS databases.

• Ensure that the Database User specified in the Source configuration screen has the required permissions to access the specified database. Read the Grant privileges to the user section in the respective Source documentation to learn about the permissions required for Hevo to connect to your database.

• Try connecting to your Source database through an SQL client, using the information provided in the configuration screen.

• Invite another team member with the required privileges to create the Pipeline.