Planning

Migration of an on-premises Unit 4 Milestone 7 ERP system (M7) to the cloud.

UNIVERSITY OF STRATHCLYDE

This public procurement record has 1 release in its history.

Planning

14 Nov 2024 at 00:00

OJEU - F1 - Prior Information Notice
Summary of the contracting process

The University of Strathclyde is planning to migrate its on-premises Unit 4 Milestone 7 ERP system (M7) to the cloud. This procurement is currently in the planning stage with the university seeking preliminary market consultation under the Public Contracts (Scotland) Regulations 2015. The project is set to begin in January 2025 and conclude by December 2026. The industry category for this procurement is Education, and it will take place in Glasgow, Scotland (UKM82). The process aims to convert M7 data from Oracle databases to Microsoft SQL server databases, with a key focus on selecting a reliable implementation partner experienced in Unit 4 ERP systems.

This tender presents significant growth opportunities for businesses specialising in ERP system migrations, data conversion, and cloud solutions. Suitable companies are those with a proven track record in handling similar migrations, particularly those experienced with Unit 4 ERP systems and Oracle to SQL conversions. The procurement process may be divided into lots, focusing on data migration and cloud implementation, providing multiple opportunities for specialised suppliers. This is a strategic opportunity for businesses to engage in a substantial project that will demand robust technical support and innovative solutions in cloud-based ERP systems.

Find more tenders on our Open Data Platform.
How relevant is this notice?

D3 Tenders Premium

Win More Public Sector Contracts

AI-powered tender discovery, pipeline management, and market intelligence — everything you need to grow your public sector business.

Start Free Trial Book a Demo
All Features Pricing

Notice Information

Notice Title

Migration of an on-premises Unit 4 Milestone 7 ERP system (M7) to the cloud.

Notice Description

The University of Strathclyde (UOS) is currently considering the option of migrating our on-premise ERP system (Unit 4 Milestone 7) to the cloud. To support this consideration and under the terms of Regulation 41 of the Public Contracts (Scotland) Regulations 2015 UOS, prior to commencing a live procurement process, is using this notice to undertake Preliminary market consultation on services that will be required to support the migration. The migration must include the conversion of the M7 data from on premise Oracle databases to Microsoft SQL server databases. UOS seeks notes of interests from suppliers able to offer these support services to participate in initial market consultation. The undernoted provides details in relation to the envisaged project. Interested parties are required to note their interest against this notice, thereafter UOS shall engage with interested parties in order to test, inform and develop the procurement strategy. Please note that UOS reserves the right to engage with all, or any ( a limited number of ) suppliers as is deemed necessary to support this process. Further note that any contract opportunity arising in relation to this project may be the subject of a future contract notice. Part of the market consultation shall be to consider the appropriateness of splitting this requirement into lots, this will be confirmed in future notices and whilst UOS has indicated that, at this time, the contract is envisaged to be split into lots, UOS reserves the right to alter that approach. The migration must include the conversion of the M7 data from on premise Oracle databases to Microsoft SQL server databases. This is a key part of a project to migrate M7 to Unit 4's cloud. This is an intermediate step to enable that migration to take place as it is not possible to migrate an Oracle M7 to Unit 4's cloud. That project will start in Jan 2025 and is due to end in Dec 2026. This intermediate step will start in Jan 2025 will end at some point (TBD) in 2026. Due to the pressing timescales, it is important that UOS select a reliable implementation partner with a track record of converting Unit 4 ERP systems, and experience of supporting Unit 4 ERP systems.

Lot Information

Migrate the ERP data from Oracle Databases to Microsoft SQL Server

The current on-premises Unit 4 ERP solution comprises Milestone 7.9 and ORACLE 19C. The tasks will include: Carrying out workshops to understand the University's various interface requirements, reviewing the universities use of AG16s, reviewing the use of Excelorator reports, reviewing the use of triggers, reviewing the use of Oracle database views, and reviewing ACT's. All Excelorator reports and ACT's will need converted to SQL Server and AG16 will be tested as part of the conversion. Recommending and/or remediating any issues discovered during the review process. Carrying out an initial conversion so that any issues can be discovered. During this phase, any issues identified with ARC, Excelerator reports, AG16s, views etc. Should be converted and supported Carrying out a second conversion implementing all the fixes from the first trial. Testing during this phase - lead by the University - will be more detailed than the Initial conversion. The supplier must work with the in-house finance support team to ensure the solution works with the on-premises M7 or a cloud based M7 based on Lot 2. The supplier must provide support during and after (for a defined period) the final conversion to ensure any issues are resolved.

- Migrate the ERP to a cloud solution

As the database is being converted from Oracle to Microsoft SQL Server the M7 system should be migrated to a cloud based solution The partner should have experience of running and supporting Unit 4 ERP systems in the cloud. It is anticipated the solution will preserve the same version of M7 and at least two environments Production and Test. But there should be an option for adding at least two more environments - Development and Train. The solution must be covered by a cyber security accreditation like ISO27001 The University must have at least read only access to the underlying database. Which should be provided via VPN or similar technology. If write access is possible then that should also be provided. The solution must allow for multiple data refreshes from the production environment into the non-production environments. The solution must have a disaster recovery plan detailing a detailed process for recovering the system. The solution must be scalable with no or minimum cost increase. This is to ensure a minimum level of performance is always met. The supplier must provide support for the solution via a helpdesk. The solution must have a way to deal with incidents including a list of key roles and responsibilities, and instructions for escalating to a higher level of incident response. The solution should clearly state the SLA for helpdesk calls. The solution should clearly state what type of support is and is not included. The solution has to be on SQL server data conversion supplied by lot 1

Notice Details

Publication & Lifecycle

Open Contracting ID
ocds-r6ebe6-0000782481
Publication Source
Public Contracts Scotland
Latest Notice
https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=NOV518379
Current Stage
Planning
All Stages
Planning

Procurement Classification

Notice Type
OJEU - F1 - Prior Information Notice
Procurement Type
Standard
Procurement Category
Services
Procurement Method
Not Specified
Procurement Method Details
Not specified
Tender Suitability
Not specified
Awardee Scale
Not specified

Common Procurement Vocabulary (CPV)

CPV Divisions

72 - IT services: consulting, software development, Internet and support

CPV Codes

72266000 - Software consultancy services

Notice Value(s)

Tender Value
Not specified
Lots Value
Not specified
Awards Value
Not specified
Contracts Value
Not specified

Notice Dates

Publication Date
14 Nov 20241 years ago
Submission Deadline
Not specified
Future Notice Date
13 Jan 2025Expired
Award Date
Not specified
Contract Period
Not specified - Not specified
Recurrence
Not specified

Notice Status

Tender Status
Planned
Lots Status
Planned
Awards Status
Not Specified
Contracts Status
Not Specified

Buyer & Supplier

Contracting Authority (Buyer)

Main Buyer
UNIVERSITY OF STRATHCLYDE
Contact Name
Not specified
Contact Email
nicholas.nixon@strath.ac.uk
Contact Phone
+44 7811592949

Buyer Location

Locality
GLASGOW
Postcode
G1 1XQ
Post Town
Glasgow
Country
Scotland
Major Region (ITL 1)
TLM Scotland
Basic Region (ITL 2)
TLM3 West Central Scotland
Small Region (ITL 3)
TLM32 Glasgow City
Delivery Location
TLM82 Glasgow City
Local Authority
Glasgow City
Electoral Ward
Anderston/City/Yorkhill
Westminster Constituency
Glasgow North East

Further Information

Notice Documents

  • https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=NOV518379
    Migration of an on-premises Unit 4 Milestone 7 ERP system (M7) to the cloud. - The University of Strathclyde (UOS) is currently considering the option of migrating our on-premise ERP system (Unit 4 Milestone 7) to the cloud. To support this consideration and under the terms of Regulation 41 of the Public Contracts (Scotland) Regulations 2015 UOS, prior to commencing a live procurement process, is using this notice to undertake Preliminary market consultation on services that will be required to support the migration. The migration must include the conversion of the M7 data from on premise Oracle databases to Microsoft SQL server databases. UOS seeks notes of interests from suppliers able to offer these support services to participate in initial market consultation. The undernoted provides details in relation to the envisaged project. Interested parties are required to note their interest against this notice, thereafter UOS shall engage with interested parties in order to test, inform and develop the procurement strategy. Please note that UOS reserves the right to engage with all, or any ( a limited number of ) suppliers as is deemed necessary to support this process. Further note that any contract opportunity arising in relation to this project may be the subject of a future contract notice. Part of the market consultation shall be to consider the appropriateness of splitting this requirement into lots, this will be confirmed in future notices and whilst UOS has indicated that, at this time, the contract is envisaged to be split into lots, UOS reserves the right to alter that approach. The migration must include the conversion of the M7 data from on premise Oracle databases to Microsoft SQL server databases. This is a key part of a project to migrate M7 to Unit 4's cloud. This is an intermediate step to enable that migration to take place as it is not possible to migrate an Oracle M7 to Unit 4's cloud. That project will start in Jan 2025 and is due to end in Dec 2026. This intermediate step will start in Jan 2025 will end at some point (TBD) in 2026. Due to the pressing timescales, it is important that UOS select a reliable implementation partner with a track record of converting Unit 4 ERP systems, and experience of supporting Unit 4 ERP systems.

Open Contracting Data Standard (OCDS)

View full OCDS Record for this contracting process

Download

The Open Contracting Data Standard (OCDS) is a framework designed to increase transparency and access to public procurement data in the public sector. It is widely used by governments and organisations worldwide to report on procurement processes and contracts. 

{
    "tag": [
        "compiled"
    ],
    "id": "ocds-r6ebe6-0000782481-2024-11-14T00:00:00Z",
    "date": "2024-11-14T00:00:00Z",
    "ocid": "ocds-r6ebe6-0000782481",
    "initiationType": "tender",
    "parties": [
        {
            "id": "org-10",
            "name": "University of Strathclyde",
            "identifier": {
                "legalName": "University of Strathclyde"
            },
            "address": {
                "streetAddress": "McCance Building, 16 Richmond Street",
                "locality": "Glasgow",
                "region": "UKM82",
                "postalCode": "G1 1XQ"
            },
            "contactPoint": {
                "email": "nicholas.nixon@strath.ac.uk",
                "telephone": "+44 7811592949",
                "url": "http://"
            },
            "roles": [
                "buyer",
                "centralPurchasingBody"
            ],
            "details": {
                "classifications": [
                    {
                        "id": "Body governed by public law",
                        "scheme": "TED_CA_TYPE"
                    },
                    {
                        "id": "09",
                        "description": "Education",
                        "scheme": "COFOG"
                    }
                ],
                "url": "http://www.strath.ac.uk/"
            }
        }
    ],
    "buyer": {
        "name": "University of Strathclyde",
        "id": "org-10"
    },
    "planning": {
        "documents": [
            {
                "id": "NOV518379",
                "documentType": "plannedProcurementNotice",
                "title": "Migration of an on-premises Unit 4 Milestone 7 ERP system (M7) to the cloud.",
                "description": "The University of Strathclyde (UOS) is currently considering the option of migrating our on-premise ERP system (Unit 4 Milestone 7) to the cloud. To support this consideration and under the terms of Regulation 41 of the Public Contracts (Scotland) Regulations 2015 UOS, prior to commencing a live procurement process, is using this notice to undertake Preliminary market consultation on services that will be required to support the migration. The migration must include the conversion of the M7 data from on premise Oracle databases to Microsoft SQL server databases. UOS seeks notes of interests from suppliers able to offer these support services to participate in initial market consultation. The undernoted provides details in relation to the envisaged project. Interested parties are required to note their interest against this notice, thereafter UOS shall engage with interested parties in order to test, inform and develop the procurement strategy. Please note that UOS reserves the right to engage with all, or any ( a limited number of ) suppliers as is deemed necessary to support this process. Further note that any contract opportunity arising in relation to this project may be the subject of a future contract notice. Part of the market consultation shall be to consider the appropriateness of splitting this requirement into lots, this will be confirmed in future notices and whilst UOS has indicated that, at this time, the contract is envisaged to be split into lots, UOS reserves the right to alter that approach. The migration must include the conversion of the M7 data from on premise Oracle databases to Microsoft SQL server databases. This is a key part of a project to migrate M7 to Unit 4's cloud. This is an intermediate step to enable that migration to take place as it is not possible to migrate an Oracle M7 to Unit 4's cloud. That project will start in Jan 2025 and is due to end in Dec 2026. This intermediate step will start in Jan 2025 will end at some point (TBD) in 2026. Due to the pressing timescales, it is important that UOS select a reliable implementation partner with a track record of converting Unit 4 ERP systems, and experience of supporting Unit 4 ERP systems.",
                "url": "https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=NOV518379",
                "format": "text/html"
            }
        ]
    },
    "tender": {
        "id": "tbc",
        "title": "Migration of an on-premises Unit 4 Milestone 7 ERP system (M7) to the cloud.",
        "description": "The University of Strathclyde (UOS) is currently considering the option of migrating our on-premise ERP system (Unit 4 Milestone 7) to the cloud. To support this consideration and under the terms of Regulation 41 of the Public Contracts (Scotland) Regulations 2015 UOS, prior to commencing a live procurement process, is using this notice to undertake Preliminary market consultation on services that will be required to support the migration. The migration must include the conversion of the M7 data from on premise Oracle databases to Microsoft SQL server databases. UOS seeks notes of interests from suppliers able to offer these support services to participate in initial market consultation. The undernoted provides details in relation to the envisaged project. Interested parties are required to note their interest against this notice, thereafter UOS shall engage with interested parties in order to test, inform and develop the procurement strategy. Please note that UOS reserves the right to engage with all, or any ( a limited number of ) suppliers as is deemed necessary to support this process. Further note that any contract opportunity arising in relation to this project may be the subject of a future contract notice. Part of the market consultation shall be to consider the appropriateness of splitting this requirement into lots, this will be confirmed in future notices and whilst UOS has indicated that, at this time, the contract is envisaged to be split into lots, UOS reserves the right to alter that approach. The migration must include the conversion of the M7 data from on premise Oracle databases to Microsoft SQL server databases. This is a key part of a project to migrate M7 to Unit 4's cloud. This is an intermediate step to enable that migration to take place as it is not possible to migrate an Oracle M7 to Unit 4's cloud. That project will start in Jan 2025 and is due to end in Dec 2026. This intermediate step will start in Jan 2025 will end at some point (TBD) in 2026. Due to the pressing timescales, it is important that UOS select a reliable implementation partner with a track record of converting Unit 4 ERP systems, and experience of supporting Unit 4 ERP systems.",
        "status": "planned",
        "items": [
            {
                "id": "1",
                "additionalClassifications": [
                    {
                        "id": "72266000",
                        "scheme": "CPV"
                    }
                ],
                "deliveryAddresses": [
                    {
                        "region": "UKM82"
                    }
                ],
                "relatedLot": "1"
            },
            {
                "id": "2",
                "additionalClassifications": [
                    {
                        "id": "72266000",
                        "scheme": "CPV"
                    }
                ],
                "deliveryAddresses": [
                    {
                        "region": "UKM82"
                    }
                ],
                "relatedLot": "2"
            }
        ],
        "mainProcurementCategory": "services",
        "lots": [
            {
                "id": "1",
                "title": "Migrate the ERP data from Oracle Databases to Microsoft SQL Server",
                "description": "The current on-premises Unit 4 ERP solution comprises Milestone 7.9 and ORACLE 19C. The tasks will include: Carrying out workshops to understand the University's various interface requirements, reviewing the universities use of AG16s, reviewing the use of Excelorator reports, reviewing the use of triggers, reviewing the use of Oracle database views, and reviewing ACT's. All Excelorator reports and ACT's will need converted to SQL Server and AG16 will be tested as part of the conversion. Recommending and/or remediating any issues discovered during the review process. Carrying out an initial conversion so that any issues can be discovered. During this phase, any issues identified with ARC, Excelerator reports, AG16s, views etc. Should be converted and supported Carrying out a second conversion implementing all the fixes from the first trial. Testing during this phase - lead by the University - will be more detailed than the Initial conversion. The supplier must work with the in-house finance support team to ensure the solution works with the on-premises M7 or a cloud based M7 based on Lot 2. The supplier must provide support during and after (for a defined period) the final conversion to ensure any issues are resolved.",
                "status": "planned"
            },
            {
                "id": "2",
                "title": "- Migrate the ERP to a cloud solution",
                "description": "As the database is being converted from Oracle to Microsoft SQL Server the M7 system should be migrated to a cloud based solution The partner should have experience of running and supporting Unit 4 ERP systems in the cloud. It is anticipated the solution will preserve the same version of M7 and at least two environments Production and Test. But there should be an option for adding at least two more environments - Development and Train. The solution must be covered by a cyber security accreditation like ISO27001 The University must have at least read only access to the underlying database. Which should be provided via VPN or similar technology. If write access is possible then that should also be provided. The solution must allow for multiple data refreshes from the production environment into the non-production environments. The solution must have a disaster recovery plan detailing a detailed process for recovering the system. The solution must be scalable with no or minimum cost increase. This is to ensure a minimum level of performance is always met. The supplier must provide support for the solution via a helpdesk. The solution must have a way to deal with incidents including a list of key roles and responsibilities, and instructions for escalating to a higher level of incident response. The solution should clearly state the SLA for helpdesk calls. The solution should clearly state what type of support is and is not included. The solution has to be on SQL server data conversion supplied by lot 1",
                "status": "planned"
            }
        ],
        "communication": {
            "futureNoticeDate": "2025-01-13T00:00:00Z"
        },
        "coveredBy": [
            "GPA"
        ],
        "classification": {
            "id": "72266000",
            "scheme": "CPV"
        },
        "legalBasis": {
            "id": "32014L0024",
            "scheme": "CELEX"
        }
    },
    "language": "EN",
    "description": "(SC Ref:782481)",
    "links": [
        {
            "rel": "canonical",
            "href": "https://api.publiccontractsscotland.gov.uk/v1/Notice?id=ocds-r6ebe6-0000782481"
        }
    ],
    "noticetype": "OJEU - F1 - Prior Information Notice"
}