.avif)
Customer & challenge
Constantia Services has set itself the task of driving forward the digital transformation in the parent company Constantia Industries AG. Around 60 employees at five locations in Austria support the group companies Isosport, Isovolta and Fundermax in all areas of the IT world and combine the requirements of an industrial group with the latest IT technologies.In order to simplify their digital technology adoption strategy, Constantia Services desired to keep all three businesses’ data stored in a central location. Employees from various parts of the organization would then able to create reports and analyses based on uniform data. A Microsoft Azure SQL DWH was chosen as the storage solution, with Power BI as the reporting tool.
With Gregor Uhl, Constantia Services brought an experienced DWH and BI architect on board to set up suitable DWH structures as the heart of its new BI landscape. His plan was to implement a Microsoft Azure SQL DWH and connect the various ERP, CRM, and MES systems of the three group companies using interface technology.
Gregor Uhl evaluated various software solutions for extracting SAP ERP data to MS Azure DWH, including Xtract Universal from Theobald Software: He recalled, “The implementation was very simple. I contacted the support service with three or four technical questions and then everything was clear. I didn’t need any training on how to use it: the solution is lean, and the learning curve is very steep.” The performance was also convincing, and the DWH architect also received complete approval when the overall solution was presented to the group management.
After the two-week test phase, there was a seamless transition to live operation.
With Xtract Universal, we managed to go live with a central data warehouse within a few weeks and offer stable reporting.
Solution with Xtract Universal
Gregor Uhl explained, “We are currently using Xtract Universal to write data streams from an SAP S/4HANA system and an SAP R/3 system to an MS Azure SQL DWH. Due to the age of the version, one of the R/3 systems had problems with the table function module. I opened a support ticket, got a response in a few hours, and the solution was implemented the next day. The extraction process runs flawlessly from both systems.”
