RVR-RDBMS-201
Issue summary
- The error "Failed to connect to rdbmsError Code: RVR-RDBMS-201" is generally linked to connection issues between Data Integration and an RDBMS database (e.g., SQL Server, Oracle, MySQL, etc.). This error indicates a failure in establishing the connection to the database due to incorrect configuration, network issues, or incorrect credentials.
Action steps
To resolve the error, follow these steps:
- Verify Connection Details: Make sure that the credentials (username, password) and connection parameters (host, port, database name) are correct.
- Allowlist Data Integration IP addresses: Ensure that Data Integration you have allowlisted the IP addresses in the database server's firewall rules to allow connectivity. You can find Data Integration IP addresses for allowlisting in their documentation here.
- Check Database Status: Confirm that the target database is running and accessible from the network.
- Use SSL/SSH if Required: Some databases require SSL or SSH tunneling for connections. If applicable, configure SSL/SSH settings in Data Integration appropriately.
- Test Connection: Use the Test Connection feature in Data Integration to validate that the connection parameters are correct and the connection is successful.
External references
- Data Integration Connections Guide - Official guide on setting up connections in Data Integration.
- Troubleshooting Data Integration Database Connections - Guide specific to troubleshooting database connection issues in Data Integration.
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.