Welcome to GEUS' database gateway
This system was built to assist users within the "Fællesoffentlig JUPITER" collaboration.Contact us for plans: GEUS Geological Data Centre
The database gateway connects directly to our production databases through a secure channel.
Users must be registered in both firewall and database.
Users must be registered in both firewall and database.
Connection info
- Oracle (JUPITER): 194.182.159.176:1251, database: xe (SID)
- PostgreSQL (JUPITER + GERDA): 194.182.159.176:5678, database: postgres
We recommend the following software
- DBeaver (supports Oracle and PostgreSQL)
- SQL Developer (Oracle)
- PgAdmin (PostgreSQL)
Data models
| Database | Documentation | Diagram | Background | REST example |
|---|---|---|---|---|
| pcJUPITERxl | Reference | Visio | geus.dk | A borehole |
| pcGERDA | Reference | Visio | geus.dk | A project |
| MARTA | n/a | n/a | geus.dk | A survey |
Important notes
- JUPITER resides natively in Oracle, so use an Oracle client when possible
- GERDA resides natively in PostgreSQL, so use a PostgreSQL client (Oracle client won't work!)
- For large queries with more than one join, always use the native client
- You are allowed to perform queries running max 10 minutes
- You are NOT allowed to run scheduled scripts without consulting us first
- We might kill sessions with high CPU, I/O or memory usage
Last revision: 2024-07-08