RVR-SF-RDBMS-317

Issue summary

• The error message "Failed to establish a connection to the RDBMS with specific details. Error Code: RVR-SF-RDBMS-317" indicates that there was a failure in setting up a connection to the Relational Database Management System (RDBMS) through Data Integration. This error relates to configuration or network issues preventing successful communication with the database.

Action steps

To resolve the error, follow these steps:

• Check Credentials and Connection Details: Ensure that all required credentials (username, password) and connection parameters (host, port, database name) are correct.

  CREATE USER '`<Data_IntegrationUsername>`' IDENTIFIED BY '`<password>`';
  GRANT SELECT, SHOW DATABASES, SHOW VIEW, EXECUTE ON *.* TO '`<Data_IntegrationUsername>`';
• Network Access: Ensure the Data Integration you have allowlisted the IP addresses in your database's network settings to allow incoming connections from Data Integration servers.
• Test Connectivity: Use the Test Connection feature in Data Integration to verify if the setup is correct and the database is reachable.
• Firewall and Security Groups: Check your organization's firewall settings and ensure that the necessary ports for database communication are open.

External references

• Data Integration Documentation for IP address allowlisting and further troubleshooting steps.
• Relevant database documentation specific to the RDBMS you are connecting to.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.