This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 51%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
I want to transfer/extract data from my local(external) hive servers to my azure blob storage account in order to perform ETL activities on the data. I also want this task to be automated for future purposes. Can you suggest what would be the best way/services/tutorial to perform such a task?
Hi @Samyak Jain ,
Just checking in to see if the below answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
Hi @Samyak Jain ,
Click here to know more about Integration runtimes and there use cases.
Hi @Samyak Jain ,
I think @ShaikMaheer-MSFT covered your last question well
If the documentation is not fully clear then you can check this post as well :
https://www.cathrinewilhelmsen.net/integration-runtimes-azure-data-factory/
I think that it is more "user friendly" explanation :-)
Great to see you here @ShaikMaheer-MSFT
There is a huge different between the Microsoft product team members who come to the forum and the third party Microsoft supporters in the forum. It start in the way you respond (related to many users complaints about chasing points more than provide additional value) and obviously the content you provide. Well done +1
I noticed that you publish multiple recording on linkedin. If you have a Facebook account, then you are welcome to share your recordings in the Azure Data Platform group. You can find your teammates there (Jovan for example and others) and multiple data platforms MVPS. In fact the group was founded by one of your team members and we run the group together.
Hi @Ronen Ariely - Thank you for kind words. I joined that FB group. Thanks for sharing.
Please check if these two document cover what you need:
Copy and transform data from Hive using Azure Data Factory
Create Hive tables and load data from Azure Blob Storage (check the part about load the data from blob)
Hi @Ronen Ariely ,
Thanks for the help.
Could you also suggest which integration runtime(AutoResolveIntegrationRuntime, Azure, Self Hosted etc) can be used for my use case(ie to access an external hive server)?