SSIS ETL Tool

Sridhar Vuligonda 21 Reputation points
2021-02-05T20:37:45.827+00:00

Is the latest version of SSIS a fully cloud-based ETL tool?

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,481 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
0 comments No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,891 Reputation points
    2021-02-08T08:33:30.393+00:00

    Hi @Sridhar Vuligonda ,

    Azure Data Factory is Azure's cloud ETL service for scale-out serverless data integration and data transformation. It offers a code-free UI for intuitive authoring and single-pane-of-glass monitoring and management. You can also lift and shift existing SSIS packages to Azure and run them with full compatibility in ADF. SSIS Integration Runtime offers a fully managed service, so you don't have to worry about infrastructure management.

    Please refer to Azure Data Factory documentation and What is Azure Data Factory?.

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


2 additional answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,936 Reputation points
    2021-02-05T21:35:48.717+00:00

    Azure Data Factory (ADF) is your answer.
    SSIS is ETL for on prem. environment, but it also has Integrated Runtime (IR) for ADF.

    0 comments No comments

  2. Shahriar Khazaei 1 Reputation point
    2021-02-06T23:40:22.76+00:00

    It has functionalities on both Azure cloud and on-premise servers.

    0 comments No comments