Client profile

Magnit Global is a world leader in contingent workforce management. Its industry-leading workforce management platform enables companies to optimize talent and diversity goals while achieving operational success. The platform offers software and services such as labor sourcing, payrolling, compliance, program management, and analytics.

Objective

Magnit needed to efficiently modernize and migrate their databases within a tight timeframe, in order to avoid the disruption of business processes.

Challenge

The transition to PostgreSQL was based on a number of challenges our customer faced:

• A high total cost of ownership created a substantial financial burden, limiting the company’s ability to allocate resources to other critical areas.
• Vendor lock-in, which restricted their flexibility and hindered future business development.

Solution

When migrating from Oracle and PostgreSQL, it is important to remember that PostgreSQL does not have all the necessary equivalents. Assessment Wizard provided a detailed report with an approximate migration assessment of 80% automation rate with default conversion. According to the report, customization of SQLWays Wizard would make it possible to achieve 95% automation. Therefore, we offered clients to customize SQLWays Wizard to minimize migration time.

The most important thing for our client was the migration time, which had to be minimized. For this purpose, Ispirer experts carried out seven customizations to achieve the maximum automation rate. This is what has been customized:

• Converting a table type to an array
• Adding a custom collation
• Removing an IF statement when it contains a DROP IF EXISTS statement
• Adding open swv_refcur for SELECT null
• Removing unnecessary INOUT refcursor parameters
• Converting an UPDATE with a JOIN statement
• Converting the format function

Technologies

SQL Server, Oracle, PostgreSQL

Benefits and Results

As a result of interaction with Ispirer, Magnit received the following results:

• Reduced total cost of ownership because of moving from proprietary Oracle and SQL Server to open-source PostgreSQL
• Migrate the databases at a 95% automation rate
• Streamlined migration project twice compared to manual migration

Client Feedback