Features
Everything you need to manage master data — without the overhead of legacy tools.
Your Data, Your Database
All data lives in your SQL Server. Query it directly, build views, export anytime. No proprietary storage, no black box.
SQL Server Storage
Master data stored directly in your SQL Server database. Run queries, build reports, connect BI tools — your data is always accessible.
Read the docs
Integration Views
Build custom views that combine data from multiple entities. Create the exact data shape your data warehouse or ETL pipeline needs.
Read the docs
On-premise Deployment
Install on your own infrastructure. No cloud dependency, no data leaving your network. Full control over security and compliance.
Read the docs
Cross-model References
Share entities across models with domain references. Build a connected master data graph where entities reference each other.
Read the docs
Staging Tables
Every entity gets an auto-generated staging table (mdm_stage). Load data from external systems, enrich it with extra columns, then sync it into Primentra.
Read the docs
Stored Procedures Only
Zero raw SQL in the application. All database logic runs through stored procedures — centralized, testable, and safe from SQL injection by design.
Read the docs
Full Audit Trail
Every create, edit, and delete is logged with field-level detail, timestamps, and user info. Domain values are resolved at write time so history stays readable forever.
Read the docs
Zero Vendor Lock-in
Export any entity to JSON, CSV, or Excel with one click. Your schema is standard SQL Server tables — migrate away anytime without data conversion.
Read the docs
Staging Scheduler
Let your ETL drop rows into a staging table and have Primentra pick them up on a schedule, or the moment enough rows arrive. Run by a SQL Agent job, with retention and drift detection.
Read the docs
Define and visualize entity hierarchies
Master data is inherently hierarchical. A cost center rolls up into an area, which belongs to a zone, which sits under a country. Primentra lets you define these relationships through domain attributes and automatically visualizes the full hierarchy chain in the admin panel.
No manual diagram drawing required. As soon as you link entities via domain fields, the hierarchy appears — making it easy to verify that your data model is structured correctly before entering any data.
Excel-grade Editing
Data grids that feel like a spreadsheet but work like a database. Built for data teams who live in Excel.
Inline Cell Editing
Click any cell to edit. Validation happens in real-time. Tab through cells, Enter to save. Just like Excel, but with data integrity.
Read the docs
Instant Undo
Made a mistake? A 10-second undo toast appears after every edit, letting you revert changes with a single click. Or use Ctrl+Z anytime.
Read the docs
Copy/Paste from Excel
Select cells in Excel, paste into Primentra. Select cells in Primentra, paste into Excel. It just works.
Read the docs
Keyboard Navigation
Full keyboard support. Arrow keys, Tab, Enter, Escape, Ctrl+Z, Ctrl+Y. Power users never need to touch the mouse.
Read the docs
Multi-column Filtering
Filter and sort across any column. Combine text filters with column sorting to find exactly what you need.
Read the docs
Instant Column Search
Type to search within any column. Results filter instantly as you type — find the right record in milliseconds, even in datasets with thousands of rows.
Read the docs
Drag-select & Fill Handle
Click and drag to select rectangular cell ranges. Drag the fill handle to copy a value to adjacent cells — just like Excel.
Read the docs
Export & Import
Export entity data as JSON, CSV, or Excel. Import with per-entity actions: add new records, overwrite existing, or delete and reimport. Dependency-aware ordering handles parent entities first.
Read the docs
Bulk Edit
Select rows with checkboxes, pick a field, set a value — applied to all selected rows at once. Update hundreds of records in seconds.
Read the docs
Paste Rows
Copy rows from Excel, click Paste Rows, and they appear in the grid. Headers are auto-detected and mapped to the right columns.
Read the docs
Excel & CSV Import
Drag-and-drop an .xlsx or .csv file into the 4-step import wizard. Columns are matched by name, data is previewed before commit, and domain references resolve automatically. Handles up to 50,000 rows.
Read the docs
Cascading Dropdowns
Link parent-child domain fields so selecting a Zone filters Areas, or selecting a Branch filters Departments. Bidirectional: picking a child auto-fills the parent.
Read the docs
Auto-generated Codes
Give a column a prefix, a width and a starting number, and the database assigns the code — on grid saves, pasted rows, imports, staging and the API alike. Never two users handed the same one.
Read the docs
Date & Time Formats
Define a format once for the whole installation and link columns to it. Change it in one place and every column using it follows, in every entity and every model.
Read the docs
Parent-Child Hierarchies
A column can point at its own entity, so a structure can have a parent structure. Filter it by another column and a parent can only be chosen from inside the same group.
Read the docs
Rules Your Data Has to Pass
Catch bad data before it reaches the master record — on every route in, not just the ones you remembered to check.
Eight Guided Templates
Unique, combination unique, number limits, text format, date limits, required-when, compare two columns, or build your own. Pick one, fill in a form, and the rule is written for you.
Read the docs
IF / THEN, Nested
AND and OR groups nested as deep as you need, NOT over a whole group, and operators filtered by the column’s own data type. MDS gave you one level and a designer that needed Internet Explorer.
Read the docs
Refuse the Save, or Flag the Row
Severity is per rule. An error stops the write; a warning lets it through and marks the row for a steward. MDS never blocked anything at all, so both habits are available to you.
Read the docs
Test It Before You Save It
Run a draft rule against your live data and see how many rows fail, and which ones, before it is enforced on anybody. MDS had no preview and no dry run — you published and hoped.
Read the docs
Every Way In, Not Just the Grid
Grid saves, the REST API, file imports, staging batches from your ETL, and approvals. Force Approve is not exempt: it overrides who may approve, never whether the data is valid.
Read the docs
Fill a Value, Never Overwrite One
A rule can fill a column left empty — always, or only when something else holds. It never touches a value somebody typed, and every fill is written to the audit log naming the rule.
Read the docs
Migrate from Microsoft MDS
Still running SQL Server Master Data Services? Don't start from scratch. Import everything in minutes.
Migration Wizard
Export metadata from SQL Server Master Data Services with a single SQL query. Upload the JSON and our wizard imports models, entities, attributes — automatically.
Read the docs
Conflict Detection
Importing into an existing setup? The wizard detects conflicts and lets you choose: overwrite, skip, or merge.
Read the docs
Smart Field Matching
Upload your MDS export and Primentra automatically maps JSON fields to entity attributes. Data types, domain references, and cross-model links are resolved without manual configuration.
Read the docs
Just Enough Governance
Enterprise MDM tools bury you in governance overhead. Primentra gives you the controls you need — and nothing more.
Roles & Permissions
Create roles with per-entity and per-attribute permissions. Control who can read, write, or administer each data domain — down to individual fields.
Read the docs
Permission Inheritance
Set permissions at model level and let them cascade to entities. Override at any level with visual indicators showing inherited vs. custom access.
Read the docs
Model Administration
Define models with custom entities and attributes through a visual admin panel. No XML, no config files, no consultants.
Read the docs
Audit Log
Every change is logged with who, what, when, old value, and new value. Filter by date, action type, model, or entity. Export the full audit trail to JSON, CSV, or XLSX for compliance reporting.
Read the docs
Entity Clone
Duplicate an entity in one click. Optionally clone data and permissions. All attributes are deep-copied with new IDs — perfect for creating variations.
Read the docs
Approval Workflows
Require approval before changes go live. Submitters propose edits, approvers review a side-by-side diff, then approve, reject, or return. Notes can be added at every step.
Read the docs
Derived Columns
Pull values from related entities through domain chains. A Branch can display its Area's Zone name as a read-only column — no denormalization needed.
Read the docs
Preview As
Test what any user or role sees without logging out. Admins can preview the exact grid, permissions, and field visibility that a specific person experiences.
Read the docs
Model Promotion
Move a model from test to production as a file — entities, attributes, integration views, business rules and optionally the data. Choose create, overwrite or skip for each item before anything is written.
Read the docs
Developer-friendly Architecture
No containers, no Kubernetes, no cloud console. Install in minutes, manage yourself.
Simple Installation
Download, install, configure your SQL Server connection. No Docker, no cloud accounts, no infrastructure team needed.
Read the docs
Customizable Dashboard
Drag-and-drop widgets, favorite entities, KPI cards. Each user can customize their own workspace.
Read the docs
Instant Search
Find any entity, attribute, or record instantly. Search works across all models and entities.
Read the docs
Dark Mode
Switches themes based on sunrise and sunset at your location, or toggle it manually. Your choice is saved across sessions.
Read the docs
Deep Link Routing
Every entity, admin page, and view has a unique URL. Bookmark or share a link to any screen — it opens exactly where you left off.
Read the docs
REST API
Read and write entity records from any external system via a secure REST API. Authenticate with API keys, control access through roles, and enable or disable the API globally at any time.
Read the docs