What’s the Mashup Engine?

I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing:

2019-04-22 10_52_34-SQLQuery13.sql - Plato_SQL2017.sandbox (PLATO_Steve (57))_ - Microsoft SQL Serve

I had never seen the Mashup Engine listed in a program list, and I certainly don’t have any program installed by that name.

Or do I?

I actually do. It’s embedded in Excel 2016, as part of Power Query. Fellow MVP, Reza Rad, has a good introduction to what this actually is. Apparently it’s the engine that makes it easy for data movement and transformation. Kind of an SSIS light, that’s a part of Power BI as well.

If you see this on your instance, you’ll know that someone is connecting with another tool. As to which one it is, that might be harder to determine.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

1 Response to What’s the Mashup Engine?

  1. Frankie4Fingers says:

    I see this app when processing OLAP in SSAS 2017

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.