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.