A global oil company began a strategic project to completely upgrade and enhance the enterprise wide EBOSS global production system. The existing SAP BusinessObjects™ landscape primarily consisted of Windows 2003 Standard Edition 64 bit SP2 and SAP BusinessObjects™ Enterprise XI3.1 FP1.9 with some 25 LaFixes (Limited Availability Fix) and other custom JSP pages and applications.
Like many major organisations, this global oil company appreciated the benefits of outsourcing specialised expertise rather than go through the expensive and time consuming processes of interviewing, recruiting, training and retaining IT professionals whose specific knowledge would only be required for a relatively limited period.
Realising that the migration and upgrade project would require highly specialised, in-depth knowledge, the global oil company approached Xoomworks – a Consulting and Technology Company that specialises in Business Intelligence, Transformation and Technology Adoption. Xoomworks had already worked closely with the company, most notably on a long-term and strategic project to design, develop and implement an enterprise‐wide data warehouse based around SAP BusinessObjects™ and SAP Business Warehouse for its service and technology divisions. Having reviewed the project objectives, Xoomworks decided to place a highly experienced SAP BusinessObjects™ consultant on‐site at the global oil company’s corporate data centre to manage and oversee the entire migration and upgrade programme as well as undertake the more complex programming and development aspects of the project.
“Although SAP continued to provide fixes, it was obvious that the platform had to be brought up to date and to a higher level, as supportability was getting close to impossible,” explained Xoomworks Principal Consultant, who arrived at the global oil company’s data centre in November 2010.
Jamie Holmes, Xoomworks Managing Director.
To minimise the risks of the upgrade and achieve a long-term and sustainable SAP BusinessObjects™ infrastructure, the existing landscape had to be upgraded to Service Pack 3 and FixPack 3.3. In addition to providing the global oil company with many of the new SAP BusinessObjects™ features that were only available in the full install version of SP3, the chosen upgrade would ensure ongoing support available for their new environment, including all of the LaFixes available.
A further issue was the consistency of the current Business Intelligence content stored in the CMS database and in the Input/Output filestore. “The Repository Scan tool, part of the SAP BusinessObjects™ Enterprise XI 3.01 toolset, listed these issues and we created custom scripts on the fly during the migration day to fix all of them (more than 100,000).” explained Xoomworks Principal Consultant.
Working extremely closely with the project team, (which included development and support specialists mainly from Wipro and T- Systems as well as other external contractors), and calling upon the internal resources of Xoomworks, the migration and upgrade programme commenced. To support the parallel landscape, new servers were installed as a parallel cluster. The entire CMS database and filestore contents were then copied across of the incumbent cluster and scanned and repaired using Reposcan – the SAP Enterprise XI 3.0 Repository Diagnostic Tool.
Xoomworks then reconfigured all Oracle/MS SQL server databases and Business Warehouse connectivity facilities that were already present in the existing landscape on the new server cluster, setup the same WinAD SSO and SAP SSO authentications, and configured the SAP BusinessObjects™ server parameters as the current landscape, configuring also the SSL encryption on all Tomcat 64 bit web-application servers.
Over the next six months, Xoomworks undertook intensive system testing, load testing and regression testing before being able to migrate all four virtual clusters (development, acceptance, quality and production) across to the new virtualised clusters over two weekends and in 4- ‐6 hours for
each cluster using the “big bang” migration technique. Once the related project teams had verified the same consistency, results, performance between the existing production system and the new parallel one, the new upgraded environments were released to end- ‐users and the old machines decommissioned.
Xoomworks is still based out of the global oil company’s data centre where they continue to work on the enterprise‐wide Business Intelligence and Global Production system, resizing and scaling the current distributed architecture, installing updates, reviewing the current support model, training the support team, introducing a quality checking on the existing and new Business Intelligence content (to drastically increase the performances of the platform and its usage), and custom developments to bring the solution even closer in line with their immediate and long term business critical objectives.
Xoomworks BI are a global leader in Business Intelligence solutions and services, supporting large enterprises and SMBs alike. We have over ten years experience in SAP BusinessObject™, SAP HANA, and many other SAP and BI solutions. More than 70% of our technical consultants have previously worked at SAP holding senior positions.
Our core competencies are implementations, integrations, migrations and optimisations, post go-live and managed services, crisis management, knowledge transfer, cloud BI and, of course, strategic advice.