UPDATE ......From Tuesday 8 April 2025 we have changed the way that Single Sign-on works on this wiki. Please see here for more information:
Update
The data warehouse is a MySQL Enterprise Edition instance located on two servers: prod-dwarehouse01.geant.net (62.40.122.84 - Sofia PoP) and prod-dwarehouse02.geant.net (62.40.122.132 - Athens PoP)
There are Test and UAT versions of the data warehouse, but these only have the MySQL Community Edition installed on them.
Access to the databases is via two user accounts either WhseUser or WhseAdmin (Passwords stored in KeyPassPassword Manager.)
Currently, data from our core corporate systems are manually exported and imported into the respective databases:
...