smaple.tr
Data & AI

Tribute Technology – Funeral Home Data Migration Platform

A self-service platform that converts funeral homes' legacy data into Tribute's format, so new customers can move to CRäKN (now Tribute Management Software) without one-off manual imports.

Client
Tribute Technology / CRäKN (USA)
Industry
Funeral home software
Period
Jun 2022 – Sep 2023, maintenance into 2024
Engagement
Fixed-milestone project, then maintenance
Apache AirflowPythonDjango RESTReactMongoDBPostgreSQLAWS S3Docker

Key Results

Manual one-off imports replaced by an automated, repeatable pipeline; 13 milestones delivered and the code handed over to Tribute's own AWS

Tribute Technology – Funeral Home Data Migration Platform

The Challenge

Every funeral home that switches to CRäKN arrives with years of case data locked in another vendor's system: MSSQL backups, MySQL databases, CSV exports. Each import was a manual, one-off job, which slowed onboarding and made data quality hard to prove.

Our Solution

We won the work through an RFP in 2022 and built a cloud data-transformation platform. Source adapters run as Airflow DAGs for MIMS backups (MSSQL .BAK/.MDF), FrontRunner (MySQL), CSV and JSON/XML. Raw data lands in MongoDB; staff then map fields in a React interface, clone and re-run versioned mappings, and approve or reject the results before export to Tribute's JSON data spec. Four roles (superadmin, admin, staff, client) control who can do what. While the platform was being built we also ran 11 manual conversions so onboarding never stopped.

The Outcome

In February 2023 Tribute stopped manual imports in favour of the automated process. Tribute's product owner judged success by matching migrated data against A/R reports, case counts and spot checks. In September 2023 we moved the production code into Tribute's repositories and AWS account, with installation and architecture documentation.

Highlights

  • Airflow source adapters for MSSQL backups, MySQL, CSV and JSON/XML
  • Field-mapping UI with versioned, re-runnable mappings
  • Approve/reject workflow before export to Tribute's data spec
  • Role-based access for superadmins, admins, staff and clients
  • Clean handover to the client's repositories and AWS
"The Smart Maple Technology team builds what you want them to build and it works. That shouldn't be impressive or unique among custom software vendors, but it is."

Eric Moore

Product Owner, Funeral Tech Company

Verified review on Clutch, Mar 2024 ↗

Interested in Data & AI Services?

Learn more about our data & ai capabilities and see how we can help with your project.

Explore Data & AI Services

Have a Project in Mind?

Let's discuss how we can bring your vision to life with a custom solution.

Start Your Project