Database Mapper Excel Spreadsheet

Update: SentryOne Document is now SolarWinds Database Mapper (DMR). See the Database Mapper product page to learn more about features and licensing. Want to explore Database Mapper? An interactive demo environment is available without any signup requirements.

Excel Spreadsheet

Solution Item IconSolution 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 open an 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.

Database Mapper Add Solution Item Excel Spreadsheet File
Database Mapper Add Solution Item Excel Spreadsheet 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.