How can we improve Microsoft Azure Data Factory?

Add the SQL SSIS features and functionality in Azure PaaS components

Many customers have the requirement to migrate on premise applications to the cloud (not hybrid) as PaaS applications. If SQL SSIS features and functionality do not get added into Azure PaaS features somewhere (I don't care which product) then that is a show stopper for meeting customers 100% PaaS solution. They do not want to have one or more VMs in Azure as IaaS just for SQL SSIS. This seems like an oversight.

18 votes
Vote
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
You have left! (?) (thinking…)
Linda Chapman shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Todd Chittenden commented  ·   ·  Flag as inappropriate

    Azure Data Factory V2 now allows SSIS and Integration Services Catalog to be hosted on an Azure SQL DB. And you can (supposedly) hook it to a VNet and then hook that VNet to a Point-to-site VPN to have access to on-premise resources. But even without SSIS on Azure, check out ADF V2. They just released the GUI tools for the portal a few days ago.

  • Anonymous commented  ·   ·  Flag as inappropriate

    There is more than a little confusion about whether Data Factory is intended to augment or deprecate SSIS. Microsoft's publication of its 'roadmap' intent for SSIS/SSRS with respect to AZURE integration would be very welcome. SSAS in AZURE, even as a 'beta' is a godsend.

Feedback and Knowledge Base