SQL Server Metadata Toolkit

When it comes to building enterprise-level data integration as well as transformations, one of the most popular platforms providing such functionality is Microsoft’s SQL Server Integration Services (SSIS). This platform was designed specifically in order to offer users access to a broad range of data migration tasks.

However, when it comes to interpreting data from such transactions and tasks, dedicated metadata visualizers are required. This is where SQL Server Metadata Toolkit comes into play. This app was developed specifically in order to allow you means to manage metadata from within SSIS, Analysis Reporting Services, as well as Reporting Services, by relying on several built-in features whose scope pertains to a multitude of tasks.

Those tasks include data lineage, business, and technical metadata, as well as impact analysis. This latest iteration of SQL Server Metadata Toolkit was updated to handle and detect metadata from even more versions of Windows Server, ranging from 2005 and all the way up to 2019.

It also comes equipped with support for Transact SQL capabilities, and it will be able to scan SSIS, SSAS, and SQL Server Databases, as well as Reporting services.

Last, but not least, it comes equipped with an “Executor”, which will allow the use of a GUI for various analyzers.