Sqooping data from LOCAL MSSQL Server to HDInsight over Azure? RRS feed

  • Question

  • I am trying to Sqoop data from a local on-site Microsoft SQL server to Hive in HDinsights in Azure.

    Inside Secure Shell in HDInsight, I CAN sqoop data in from Azure SQL Server but UNABLE to sqoop data from SQL Server locally.

    I can also setup Azure SQL Server, setup firewall setting and synchronize with local SQL Server. I cannot connect/ping the external SQL Server's ip.

    - why can't my sqoop connect to the local SQL Server?

    - are there any firewalls setup in HDInsight that prevents connection?​


    Tuesday, December 15, 2015 9:35 PM


  • Hi,

    I believe this will not work unless your HDInsight cluster and your on premise SQL server are connected thorugh a VPN.

    I would recommend trying alternatuves like Azure Data Factory for such a hybrid data movement scenario.


    Debarchan Sarkar - MSFT ( This posting is provided AS IS with no warranties, and confers no rights.)

    Saturday, December 19, 2015 9:07 PM

All replies