SAP Accelerator Tool – AI Consulting

SAP Accelerator Tool for Large Financial Institution

Sep 16, 2020

Share to |

Data Migration and Management

Machine learning methods are now our reality – one we can apply to any business to transform their day-to-day operation. We worked with a large financial institution with worldwide locations. They needed a solution to manage the thousands of reports and queries received with Oracle Business Object SAP. The client wanted to migrate these reports from Oracle to a Microsoft solution, while also moving the Oracle Solution to a SQL Server solution.

Case Details

Client: Financial Institution

Category: Finance

Period: 6 months

Tech: SQL

The SAP Accelerator Tool

The first step in our approach involved taking the Application Programming Interface (API) from SAP and the API from Microsoft. This allowed us to build an automated solution where we could migrate Oracle to SQL, and Business Objects to Microsoft Reporting Services.

We created a solution using a representational state transfer (REST) API to access all the metadata of the reports and complex enquiries and compile them into a structured meta database. There, we transformed the database into a Microsoft equivalent and used the API to generate reports, based on the extracted metadata.

We built the SAP Accelerator Tool to test the reports against each other programmatically – the tool would migrate, translate, and rebuild each report in Microsoft technology, and then run the new report and original SAP Business Object report simultaneously and compare the results.

If the tool detected discrepancies, these would be flagged and entered into the backlog of manual reports for review, allowing us to see what went wrong and improve the product. The root of most of these issues was an error in translation from Oracle to SQL, which were fixed and thrown back into the system to be tested again.

Thousands of reports migrated in one day

The SAP Accelerator Tool was created 6 months ahead of schedule. By implementing the SAP tool, we were able to migrate thousands of reports to the new system in one day.

With the human workforce alone, it would have taken years to migrate all reports, with only one report translated every two days. Our solution exterminated this unnecessary delay, giving our client the power of time and ability to make the most of their resources and staff.