Rosset Dental ETL — Dental data conversion, done right.
We extract from legacy PMS (Dentrix, Abeldent, ClearDent, Curve Hero, Open Dental), validate and normalize your data, and deliver a signed, audit-ready bundle for a clean cutover.
What We Do
Rosset Dental ETL extracts, validates, and converts legacy dental PMS data into a modern, unified schema— safely and verifiably—ready for Ferladent or your target platform.
Data Extraction
Secure connectors pull data from legacy PMS sources with least-privilege, time-boxed credentials. Supports direct DB reads and vendor exports.
Normalization
Transforms heterogeneous schemas into a unified Rosset schema with strict field mapping (patients, providers, schedules, treatment plans, ledgers).
Validation
CDA/CDCP code checks, referential integrity, deduping, phone/email normalization, date/timezone sanity checks, and orphan record detection.
Migration & Cutover
Blue/Green export with dry-run previews. Deterministic batches, resumable jobs, and rollback-ready change sets.
Audit & Compliance
Immutable, hash-chained logs for every import/transform/export with SHA-256 artifacts. PHIPA/PIPEDA-aligned evidence trail.
Error Recovery
Self-healing queue with retries, dead-letter inspection, and transaction replay without data loss.
Supported Conversions
We convert from the systems below into a unified Rosset schema ready for import. Each run ships with an affidavit-ready audit bundle and rollback plan.
| Source PMS | Coverage | Status |
|---|---|---|
| Dentrix (G5/G6, SQL) | Direct DB extract + CSV exports; patients, providers, appts, ledger, procedures. | Available |
| Abeldent (SQL Server) | Direct DB extract; mapping to Rosset schema v1. | Available |
| ClearDent (MySQL) | DB read or vendor export; charting + imaging references preserved. | Available |
| Curve Hero (cloud export/API) | Vendor export ingestion; schedule + financials normalized. | In validation |
| Dentrix Ascend (cloud export) | CSV/API export ingestion with data integrity checks. | In validation |
| Open Dental (MySQL) | DB read; strong coverage of charts/schedules/ledger. | Available |
Trademarks belong to their owners. Compatibility reflects field mapping and tested export/import paths; live API usage depends on vendor terms and access.
How It Works
Ready to convert?
Send us a sample export or schedule, and we’ll produce a validation report and cutover plan.