Works with your Microsoft stack
- SQL Serverholds every record
- SSISloads the staging tables
- Excelpaste in, export out
- Power BIreads the Integration Views
MDS stops at SQL Server 2022
SQL Server 2022 is the last version with MDS, and its mainstream support ends on 11 January 2028. Primentra connects to your MDS database, so you can move before that date at your own pace.
- ConnectPoint Primentra at your MDS database. It only reads. MDS stays as it is.
- Check the dry runSee what will be created and what clashes before Primentra writes anything.
- Run itModels, entities, members and domain links arrive in one run. A typical migration takes under an hour.
No connection to the MDS server? Run our two export scripts and upload the two files instead.
Scan your MDS
Run one read-only query on your MDS database and paste the result here. The report shows what comes over to Primentra and what does not. There is nothing to install.
- Models
- 10
- Entities
- 34
- Attributes
- 79
- Members
- 114 to 119
- Domain-based attributes
- 15
- Hierarchies
- 6
- Business rules
- 75
Estimated run time: about 2 to 6 minutes.
This is the run itself. We measured 1,000,000 members in about 11 minutes and added a margin for a slower server.
Numbers from our MDS test lab.
The same customer is in ERP, CRM and Excel in three spellings, Primentra sees that they match, the three records merge into one, and that one record goes to Power BI, SSIS and the data warehouse.
Find the duplicates in your lists
Lookalikes finds records that are the same thing typed in different ways, and you merge them into one.
Lookalikes works inside one entity. Records from ERP, CRM or Excel are merged once they are in Primentra, by import or the API. Primentra keeps no link back to the copy in each source system.
Tap or click the picture to see the full screen.
AI assist can give a second opinion on a group. It is optional and off by default.
What it looks like
Real screens from the product. Pick one.
Tap or click the picture to see the full screen.
What else is in it
Grid editing
Type, paste from Excel, sort and filter. Like a spreadsheet, but Primentra checks every cell.
Hierarchies and domains
Link entities to each other, so a region picks its country from a list.
Roles per entity and attribute
Decide who can read or edit each entity, down to a single column.
Staging tables
Load batches from SSIS or any ETL tool. The same rules apply as on screen.
REST API
Read and write records from other systems with an API key.
Import and export
Excel, CSV and JSON, one entity at a time or a whole model.

Ronald Kraijesteijn
Founder
Why we built Primentra
After 20 years in data management, we were tired of tools that needed a six-month project before anyone could use them.
So we built one you install on Monday and work in on Tuesday. Support mail reaches the people who build it, and what customers ask for decides what we build next.
One price per production server
€7,500per year, excl. VAT
- The price covers your dev, test and acceptance servers.
- Unlimited users, models and entities, and every feature.
Try it on your own SQL Server
Free for 60 days. No credit card.





