PortAventura World has opted for a hybrid systems architecture, combining on-premise systems such as its transactional SAP with cloud applications "where it makes sense," explains the CIO. This is the case of the ETL system (information loading, transformation and extraction), for whose development it opted for the Amazon Web Services (AWS) public cloud platform, with Linke, a Syntax company, as a technological partner.
“AWS offered us the high availability we needed for the business intelligence system, it guaranteed scalability and the constant evolution of services, and it offered us more choice in the different components of the infrastructure needed for the project compared to other solutions. Linke seemed like the right choice because of its experience with this cloud platform, the resources it had and the value it could bring”.
The project, which was coordinated by Albert Mellado, Project Manager of the company, and carried out by the Linke team, consisted of the implementation of an ETL solution that collects various data sources and, through AWS serverless Services, homogenizes the data that is consumed and analyzed in the Board advanced analysis platform.
PortAventura World now has an infrastructure that allows it to upload information from any on-premises data source to the Amazon S3 storage service. These are handled through the AWS Lambda service and are debugged. Once normalized, in addition to making a backup of the correct data, it is entered again in a Redshift database, which is the source of the analysis and reporting Board platform.
Currently, the data for many of the main transactional systems is already in the AWS cloud, such as the hotel management system or the sales (systems) of restaurants and shops, and data from the ticketing and access system are being transferred. "We have a lot of consolidated information at the accounting, logistics and management control level already in AWS, and by combining all this data, it enriches the information and increases the level of detail”, Mellado summarizes.
Such an initiative requires prior preparation work and a lot of coordination between the IT team and the business units and in turn with the partner, to get a complete picture of the key information that the company needs. Still, the bulk of the project was carried out in two months, with staff working remotely due to lockdowns in the most severe months of the pandemic. "Once we defined the data and did the technical design, the project was done quickly using Linke's 'agile' methodology based on sprints, and we all got on very well," he adds.