Need to pull data from MSSQL over WAN into Hive. Storing them as files on HDFS would be a bonus.
Curios to know if Sqoop is able to provide a robust import over WAN? Would Sqoop meet requirements of a production environment?
Thanking in advance
If you have other data processing occuring inside Azure take a look at Azure Data Factory for your data movement. It can orchestrate reads and writes across SQL Server, Hive, Pig, and much more.