This is one of 4124 IT projects that we have successfully completed with our customers.How can we support you?
Migration of Data storage of the gas storage management from Excel to Snowflake database
Project duration: 5 months
Brief description
For the reporting of the gas storage capacity, a global power plant operator uses Excel with VBA. In order to improve the application performance and user acceptance, the data storage is migrated to Snowflake and additional business logic is implemented.
Supplement
The Excel VBA application is replaces by a Snowflake database on Azure. Data from different data sources are integrated in Snowflake as data warehouse using different services (Azure Function App, Azure Webjobs, Sharepoint API). The ETL tool Talend is used to start an Azure Batch Account, which is calling Python scripts. The Python scripts are running SQL statements to transform the data on Snowflake and also insert the transformed data back into Snowflake. The transformed data on Snowflake can be used for reporting on Power BI.
Subject description
The customer used Excel for capacity management of gas storages. In the application, technical and business data from external systems are imported. The available capacity of the gas storage is calculated and used for capacity planning and trading.
Overview
- Industries energy
- Specialist tasks B2B, business intelligence, data warehouse, documentation, gas storage, operative planning, software development, time series management
- DV tasks customised software new development
- System environment Business Intelligence, Enterprise Application Integration (EAI), Platform as a Service (Paas)
- Procedure model agile software development
- Databases Snowflake
- Development/ test tools Azure DevOps, Azure Functions, DBeaver, MS Visual Studio Code,
Project period10.06.2021 - 19.11.2021
Have we sparked your interest?
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
