As a solution to their challenge, GSPANN’s team created Business Object Data Structure (BODS) jobs that enabled loading of the ENOVIA data into tables within the SAP HANA database. We also developed customized Enterprise Views for downstream application owners to help them run queries and fetch the data as they required. These SAP HANA analytical views are now also being used to generate reports through downstream applications, such as Tableau, Power BI, MS Access, MS Excel, and .NET.
Our experts also developed ‘Stored Procedures’ that are now used to apply different transformations to the data in MS Excel and .NET applications. The new unified solution replaced the client’s existing reporting system.
Team GSPANN took care of three aspects:
- ETL Process: It required the design and implementation of data extraction and storing it in the client’s internal data warehouse.
- Active Integration: The active integration team developed and implemented a process that enabled real-time data transfer from the reports created by the products' supplier to the newly implemented solution and vice versa.
- Passive Integration: During solution implementation, the passive integration team was involved in analyzing and identifying different applications that use the SAP HANA database,ensuring that all necessary data fields are available in the internal data warehouse. They also provided all application owners with respective data access capabilities to ensure a smooth transition.