Documentation forDatabase Mapper
Effective February 28, 2024, Database Mapper has reached its end of life and is no longer available or supported. If you liked Database Mapper, consider trying another SolarWinds product.

Database Mapper Excel Spreadsheet

EOL: An end of life announcement has been made for Database Mapper on February 28, 2023. See the Solarwinds End of Life Policy for more information.

Excel Spreadsheet

Solution Item Icon Solution Item Description
Database Mapper Excel Spreadsheet Provider

SolarWinds Database Mapper allows you to quickly develop a Lineage overview of your Excel Workbooks (*.xlsx) that contain SQL Server and Analysis Services data sources.

Adding Excel Spreadsheet

Additional Information: You need to add a Database Mapper solution before adding an Excel Spreadsheet solution item. For more information about adding a solution, see the Configuring Solutions and  Database Mapper Solutions articles.

Add an Excel Spreadsheet solution item to your Database Mapper solution by completing the following steps:

1. Select Add to add a new solution, or select Open to openan existing solution in the Database Mapper Configuration tool. Database Mapper Solution Configuration Tool Open Solution

2. Select Add to open the Add Solution item window. Database Mapper Solution Configuration Tool Add Solution Item

3. Enter an item name, then select Excel Spreadsheet from the Source type drop-down list.
Database Mapper Add Solution Item Excel Spreadsheet

4. Select File to document an Excel Workbook on the file system, or select Folder to recursively document all Excel Workbook items within the selected folder.

Note:  Selecting the ellipsis launches the file explorer, allowing you to navigate to the desired file or file folder. 

5. Select OK to add the Excel Spreadsheet Solution item to your Database Mapper solution.
Database Mapper Add Solution Item Excel Spreadsheet select Ok

Additional Information: You need to take a snapshot of your solution and Excel Spreadsheet solution item before viewing any documentation or lineage. For more information about taking a snapshot, see the Generating Documentation and Scheduling a Snapshot articles.

After adding a solution with your Excel Spreadsheet solution item, and taking a snapshot, you are ready to view your documentation. 

Additional Information: For more information about the Documentation tab in Database Mapper, see the Documentation article.

After adding a solution with your Excel Spreadsheet solution item, and taking a snapshot, you are ready to view your solution's lineage within the environment. 

Additional Information: For more information about the Lineage tab in Database Mapper, see the Lineage article.