https://community.cloudera.com/t5/Support-Questions/Central-management-of-connection-strings-Sqoop-HDP/m-p/348255#M235348 <P>As far as I know this is not something that Ambari or SQOOP allow for.</P><P>What you could do to achieve your goal is one of the two:</P><UL><LI>Prepare sh scripts and refer to your jdbc string as a variable</LI><LI>Prepare an Oozie Worklfow and pass the jdbc string as a variable</LI></UL><P>At that point you might have an external tool (e.g. Jenkins) maintaining a list of jdbc strings and taking the responsibility to specify the desidred one.</P><P>In solution 1, Jenkins should SSH to the node, set the variable to the JDBC string, launch the sh.</P><P>In solution 2, Jenkins should use Oozie API to start the workflow while specifying the desired variable value.</P><P>&nbsp;</P><P>Solution 2 is much better than 1, since it relies on a distributed, highly available service (Oozie).</P><P>&nbsp;</P><P>Regards</P> Wed, 20 Jul 2022 15:25:37 GMT amallegni 2022-07-20T15:25:37Z