In job.properties file i have hard coded oracle DB username and password for sqoop action and that will pick by workflow.xml file while running. The problem is in the oozie editor/dashboard if i see the running job sqoop action, in the configuration tab i could see the DB username and password visible.
i want to make DB username and password in the oozie configuration tab as hidden value or hastrik. is it possible to do that? if yes can anyone please suggest the solution.
You can store the password file either in local or in hdfs. The file permission should be 400. For you case, I suggest you store it in hdfs then no matter which nodemanger host runs you job, it will be able to access the password file.