The MDM (Master Data Management) Excel Add-in allows you to connect to any relational database, load (a subset of) the data in Excel and store modifications back to the database—your single version of the truth. No need for an extra metadata database describing your model, the MDM Add-in just works right out of the box. Use Excel features like filtering, sorting and dropdown lists along with database capabilities like audit trailing and dataset relations to navigate through your data by selection. That, combined with native database security support gets you a powerful, user-friendly data management tool.
- Connects and enriches data
- Shows database relations as dropdown lists
- Navigates between relations
- Preloads filter datasets
- Provides an audit trail to view history with restore functionality
- Security support
- Excel Add-in