Here is the good news about general availability of Azure Data Factory that will enable a better way to manage data from multiple on-premise and cloud data sources. Here is a graphical representation about the topic:
A simple way to integrate data services to automate the movement and data transformation. In simple terms like a in a manufacturing factor that manages equipment to churn raw materials into a finished product, Data Factory orchestrates existing services that collect raw data and transform it into ready-to-use information.
TO begin with, all you need to access and try out this simple use case is an Azure subscription. You can deploy a sample that implements this use case by following the steps described in the Samples article.
Here are few links for your own joy and time to learn about the features: