This document list the expected usage of this application, and the associated constraints.

Description

Spanish government requires us to provide data on water quality in the river Saja before and after we extract the water. Solvay signed a contract with Sinfin to use the water from the river.

Hence, we need to extract the data on Water Quality from:

• Sinfin through sFTP connection - water quality before extraction by Solvay
• MES - water quality after the water is returned to the river

The data must be provided to the Spanish government every hour. Therefore, the ETL scenario is triggered every hour.

The data is loaded to sFTP connection as files.

The criticality is HIGH.

Application Stakeholders

Key users are representatives from Spanish Government

End users

End users are representatives from Spanish Government

GBU Soda Ash & Derivatives

Developers

Rafael Truan Cacho

Eldiias Dzhamankulov

Maintainers

Permanent Squad

Eldiias Dzhamankulov

Providers

Sinfin

• imuniz@itresa.com
• fgonzalez@itresa.com
• fcasielles@sinfinenergy.com
• fjcovarrubias@sinfinenergy.com

WebMethods

• sneh.anshu-ext@solvay.com
• bhanuteja.korpathi@solvay.com
• vinod.velineedi-ext@solvay.com
• prateek.bhatnagar-ex@solvay.com

• Jc.Braswell@solvay.com - owner of the webmethods project. Could be contacted in critical issues. 

Constraints

Expected scheduling

• Main flow: Every hour. Data retrieval is done every 10 minutes.
• River data extraction: Every 15 minutes.

Legal constraints

Normally no

Expected Service Level Agreement (SLA)

Level of avaibliliy (every day at fix time, 24/7, ...)

Not sure what to indicate...

Unavaibliliy impacts / consequences

Potential fines from Spanish government