Can the Mulesoft application replace on premise SSIS ?

Mudassar A 486 Reputation points
2021-09-26T16:08:54.943+00:00

As I know Mulesoft is a Integration platform for moving data between application via API methods . I see that as Interface which queries cloud systems ( saas) and generates files ( XML, CSV or JSON) and passes that data for actual ETL tool to process the data further .So is the current Mulesoft can replace SSIS and do even the complex transformations of a Data warehouse ?

I know this question should have been asked on Mulesoft forum but I wanted a perspective for SSIS experts from the Microsoft forum.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 35,546 Reputation points
    2021-09-27T06:17:09.387+00:00

    Hi @Anonymous ,

    It's hard to say if A product could replace B product. Both of them has advantages and disadvantages.

    All vendors are doing their best to keep their products from being replaced.

    As far as I'm concerned, as long as it meets your needs, it's the best product.

    Regards,

    Zoe


    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.
    Hot issues October

    1 person found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Tom Phillips 17,721 Reputation points
    2021-09-27T18:20:47.71+00:00

    Having had this "conversation/evaluation" several years ago, I can tell you this:

    Mulesoft is best as an API/service interface where things are pushed/pulled from the server in real time.

    SSIS is best as a "batch job" processing.

    Yes, you can force either of them into the other role, but these are the general groupings. They are different and serve different purposes.

    So, it depends on your need.

    1 person found this answer helpful.
    0 comments No comments

  2. COZYROC 101 Reputation points
    2021-09-28T01:10:58.077+00:00

    I have heard people looking to transition to SSIS from MuleSoft because of the huge MuleSoft cost and not much advantage to show for it.

    1 person found this answer helpful.
    0 comments No comments

  3. Mudassar A 486 Reputation points
    2021-10-03T02:52:41.747+00:00

    Thanks , everyone for your comments.

    0 comments No comments