SSIS on Azure SQL and Azure Data Factory queries. RRS feed

  • Question

    1. Is it possible to deploy SSIS on Azure Sql Service without using AzureVM? If yes, then provide some links.
    2. How to connect local (on-premises) database (For example. Oracle) from Azure SQL using SSIS?
    3. How to fetch on-demand data from Azure Data Factory pipeline?
    4. If the source and target databases are on-premises, what information need to be stored in Azure using ADF? How to load data from on-premises source database and upload it to on-premises target database? For eg. I have SQL server on-premises. I want to fetch data from it and load it to Azure SQL, do some processing and save it back to same SQL resides on-premises. How to achieve it?
    5. Can ADF be deployed on other cloud environments like AWS?
    6. Can ADF connect to other cloud data sources like on AWS?

    Thursday, December 15, 2016 6:20 AM