https://community.cloudera.com/t5/Support-Questions/Central-management-of-connection-strings-Sqoop-HDP/m-p/345314#M234484 <P>Hello everyone!</P><P>&nbsp;</P><P>Context: data ingestion made with Sqoop in HDP Cluster.</P><P>&nbsp;</P><P>I would like to know&nbsp; if there is or what is the best way to manage connection strings used by sqoop to connect to databases. My case is as follows:<BR />I have to do many data ingestions from rdbms to the Datalake of my company. We have many. With certain frequence the hosts of these databases changes to a new host. So when it hapens I have to change the jdbc string connection in my .properties file (that is passed to Sqoop) and make a new deploy of it to keep my ingestion working.<BR />I would like to have these jdbc strings externalized to something in the responsability of our operation team. I would like to have theses strings as an alias or something else that I could only refer and have the operation team taking care of the right host/vip to point to when sqoop opens a connection.<BR />Maybe a a set of entrys in a configuration file could be done in Ambari to store theses jdbc strings?</P><P>&nbsp;</P> Thu, 09 Jun 2022 19:25:59 GMT cardozogp 2022-06-09T19:25:59Z