Insights · Case studies · Summit Companies

Summit moved two legacy systems to Oracle in five months

Rite migrated 17,000 projects and 1 million customer entities from Sage and Salesforce, and automated AIA retention billing inside Oracle Cloud.

Result

Billing was accurate from the first day

Summit Companies is a national leader in fire protection and life safety, and it grows by acquisition. It needed its Sage and Salesforce data in Oracle Fusion without losing the billing history that its long-running contracts depend on.

17Kprojects
1Mcustomer entities
200Kopen AR invoices
Client
Summit Companies
Industry
Fire protection and life safety
Migration
Sage and Salesforce to Oracle Fusion
Delivered by Rite
Data conversion with ConvertRite, retention billing with AIA Workbench, hypercare and application managed support
Rite applications usedConvertRiteAIA Workbench
Rite Software came in during a critical phase of our Oracle Cloud implementation and completely turned the project around. Their subject matter expertise, agility, and deep understanding of the Oracle Cloud ecosystem made an immediate impact. They are a trusted extension of our internal team, leading multiple initiatives and delivering consistent, measurable value. Their ability to combine strong implementation experience with proprietary tools and automation has truly set them apart.
Matt PraughtCIO, Summit Companies
Challenge

What made this project difficult

  • Two source systems

    Data sat in Sage on MSSQL and in Salesforce. That meant two schemas and two APIs feeding one target.

  • Years of acquisitions

    Earlier acquisitions had left inconsistent structures, orphaned records and gaps in master data.

  • Retention history

    Projects run three to four years. AIA G702 billing needs cumulative retention, so open receivables alone were not enough.

  • Five months

    There was no time for wasted load cycles, so the data had to be validated before every load.

The plan in place before Rite joined was to load invoices straight into receivables. That would have made retention impossible to calculate per contract, and the G702 documents would have been wrong.

Solution

How the data and the billing were moved

Rite used ConvertRite to bring both systems into Oracle Fusion. For billing, the team converted the history itself, so that Oracle could work out retention from real records.

  1. Pull and stage

    ConvertRite connected to Sage and Salesforce through database connectors and staged the data.

  2. Validate before loading

    Checks ran before every load, so problems were fixed in staging and no cloud refresh was needed.

  3. Rebuild billing in Oracle

    Historical billing events went into Oracle Contracts, which then generated the invoices natively.

How the data reached Oracle, and how billing runs now

ConvertRite moved both legacy systems into Oracle Fusion. AIA Workbench then works from that history to calculate retention and produce the billing documents.

  • 5months, start to finish
Two legacy systems
  • Sage (MSSQL)
  • Salesforce
Converted by
ConvertRite
Pulled, validated in staging and transformed before every load
Loaded into
Oracle FusionOracle Contracts
Historical billing events loaded, so Oracle generates invoices natively
Billed with
AIA Workbench
Retention calculated automatically at contract line level
AIA billing documents
  • G702 summary
  • G703 detail sheet
Seven data domains in one pipeline
  • Items
  • Inventory
  • Customers
  • Sites
  • Projects
  • Areas
  • Billing events
Impact

The impact on Summit’s business

Summit went live with billing it could trust, and it now has a repeatable way to bring each new acquisition into Oracle.

  • Scale and speed5months

    to move 17,000 projects, 1 million customer entities and 200,000 open AR invoices from Sage and Salesforce into Oracle Fusion.

  • Billing accuracyDay 1

    Billing to date, retention and G702 documents were accurate from the first day. No history had to be rebuilt.

  • Data integrity0

    orphaned records between Salesforce and Oracle, which now work as one system of record.

  • Repeatability7

    data domains in one pipeline that every new acquisition now follows.

  • Acquisitions100K

    customers and sites, and 10,000 projects, already migrated from a year of acquisitions (approximate).