Home > SQL / BI > Microsoft Project Barcelona

Microsoft Project Barcelona

One of the internal projects I’ve been following for some time has gone public and are now blogging about their development process. It’s a really interesting read from a dev point of view, but the product itself is also very clever. It’s addressing the ‘impact analysis’ and ‘data lineage’ world.

Imagine you’re a DBA, and you want to make a change to a column in a table. What views are connected to that table? What ETL packages refer to that view? What data source does that package load? Are there cubes built from that warehouse? Are there reports using the cube? Are their Excel spreadsheets connected to that report?

This chain of data is complex and for most organisations ever-changing. Project Barcelona aims to address this by crawling all these objects and building a node graph showing the movement of data throughout. They explain it much better than I can: take a look at their blog here: http://blogs.msdn.com/b/project_barcelona_team_blog/

I love that they’re publishing previews of the user experience online through Azure as well, at http://projectbarcelona.cloudapp.net/:

barcelona

Cool stuff.

Advertisements
Categories: SQL / BI
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: