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.
Integration Views
Build custom views that combine data from multiple entities. Create the exact data shape your data warehouse or ETL pipeline needs.
On-premise Deployment
Install on your own infrastructure. No cloud dependency, no data leaving your network. Full control over security and compliance.
Cross-model References
Share entities across models with domain references. Build a connected master data graph where entities reference each other.
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.
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.
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.
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.
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.
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.
Copy/Paste from Excel
Select cells in Excel, paste into Primentra. Select cells in Primentra, paste into Excel. It just works.
Keyboard Navigation
Full keyboard support. Arrow keys, Tab, Enter, Escape, Ctrl+Z, Ctrl+Y. Power users never need to touch the mouse.
Multi-column Filtering
Filter and sort across any column. Combine text filters with column sorting to find exactly what you need.
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.
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.
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.
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.
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.
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.
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.
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.
Conflict Detection
Importing into an existing setup? The wizard detects conflicts and lets you choose: overwrite, skip, or merge.
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.
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.
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.
Model Administration
Define models with custom entities and attributes through a visual admin panel. No XML, no config files, no consultants.
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.
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.
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.
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.
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.
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.
Customizable Dashboard
Drag-and-drop widgets, favorite entities, KPI cards. Each user can customize their own workspace.
Instant Search
Find any entity, attribute, or record instantly. Search works across all models and entities.
Dark Mode
Switches themes based on sunrise and sunset at your location, or toggle it manually. Your choice is saved across sessions.
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.
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.