Execute SQL query via RIH (Reltio Integration Hub)

Problem : 

The SQL query executes successfully in SQL Developer; however, it returns a '503 Service Unavailable' error when run through the Reltio Integration Hub (RIH) recipe.

Solution : 

The issue is occurring because the connection between the recipe and the database has not been properly set up. This improper configuration is preventing the system from establishing a successful link to the database, which is essential for retrieving and managing recipe data. Without a correctly configured connection, the application cannot access the necessary information, leading to errors or failures in processing the recipes as intended. It is important to review the connection settings, ensure that all credentials and parameters are accurate, and verify that the database is accessible to resolve this problem effectively.