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:
- Verify Connection Details: Make sure that the credentials (username, password) and connection parameters (host, port, database name) are correct.
- Whitelist Data Integration IPs: Ensure that Data Integration IP addresses are whitelisted in the database server's firewall rules to allow connectivity. You can find Data Integration IP addresses for whitelisting 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.
If the issue persists or you need further assistance, please open a ticket with Data Integration support.