https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159029#M121420 <P>As it is installed on all the nodes, firewall should be opened from all 28 nodes, else restrict the sqoop client to limited number and open the firewall from that.</P> Wed, 08 Feb 2017 18:09:33 GMT rajsyrus 2017-02-08T18:09:33Z https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159025#M121416 <P>We have a cluster of 28 nodes and working in a firewall Environment and scoop client is installed in all 28 nodes. We need to scoop data from oracle(outside organisation) to hive. For Sqooping do we need to open all the ports 28 nodes IP to external oracle IP. or is there any alternative way by which we can give a single IP and establish the connection.</P> Fri, 03 Feb 2017 17:38:59 GMT https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159025#M121416 23_gaurav_jain 2017-02-03T17:38:59Z https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159026#M121417 <P>@Gaurav, If you are trying to use SQOOP CLI, then from the server,where you are triggering,your firewall should be exposed with oracle. </P><P>But if you are trying to use through oozie, since you have installed sqoop client in all the 28 servers, so oozie can pick any, so firewall should be opened from all the nodes.</P> Fri, 03 Feb 2017 19:09:18 GMT https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159026#M121417 rajsyrus 2017-02-03T19:09:18Z https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159027#M121418 <P>Thanks Rajendra, as of now we have installed sqoop client in 28 nodes, so can we uninstall the sqoop client and keep the client in 2 or 3 nodes ?? </P> Fri, 03 Feb 2017 19:43:48 GMT https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159027#M121418 23_gaurav_jain 2017-02-03T19:43:48Z https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159028#M121419 <P>No Gaurav, let it be installed on all 28 nodes as it is now. Because oozie will not be sure to pick which node, it can be anyone out of 28. So now firewall should be opened from all nodes. Please clarify Rajendra if my understanding is wrong.</P> Sat, 04 Feb 2017 02:27:08 GMT https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159028#M121419 VikramKatilu 2017-02-04T02:27:08Z https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159029#M121420 <P>As it is installed on all the nodes, firewall should be opened from all 28 nodes, else restrict the sqoop client to limited number and open the firewall from that.</P> Wed, 08 Feb 2017 18:09:33 GMT https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159029#M121420 rajsyrus 2017-02-08T18:09:33Z https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159030#M121421 <P><A rel="user" href="https://community.cloudera.com/users/15816/katiluvikramkumar.html" nodeid="15816">@Vikram Kumar Katilu</A> </P><P>You are right.</P> Wed, 08 Feb 2017 18:10:45 GMT https://community.cloudera.com/t5/Support-Questions/how-sqoop-talks-to-external-world/m-p/159030#M121421 rajsyrus 2017-02-08T18:10:45Z