Skip to main content

Databases

EDM​

EDM is hosted on MS SQL Server and is accessiable via server sql.ad.openearth.io using Remote Desktop (RDP)

mstsc /v sql.ad.openearth.io

Admin consoles​

OEC

https://dsdata.oec-prod-dsif2.openearth.io/dsdataserver-console/faces/deployments.jsf

https://dsdsedmdwp.oec-prod-dsif2.openearth.io/dsdataserver-console/faces/home.jsf

AkerBP 242 represents the release name, so change this according to the env. you are working on

https://dsdsedmakerbp242.oec-prod-essav4.openearth.io/dsdataserver-console/faces/home.jsf

Postgres​

pgAdmin url Snowleopard/AkerBP​

https://postgres.oec-prod-essav4-admin.openearth.io/login?next=/

Login

Username: [email protected]

Password: See LastPass

If password in LastPass is outdated, we can find the password via K8S secret named aurora-postgres-master.

# remember to change the namespace
kubectl get secret aurora-postgres-master -ndsis-system-akerbp242 -oyaml
echo "<Password from the above command>" | base64 --decode

or

# remember to change the namespace
kubectl get secret aurora-postgres-master -n dsis-system-akerbp242 -o jsonpath='{.data.password}' | base64 -d

pgAdmin url RnD​

https://postgres.oec-prod-essav4-admin.openearth.io/login?next=/

Login

Username: [email protected]

Password: See LastPass

pgAdmin url Tiger​

This needs to be accessed via the jumpbox (jb) see Deploy to preprod

https://postgres.tiger-admin.dazlmkengdev02.ienergycloud.solutions/

Login

Username: [email protected]

Password: See LastPass

Configuration repos​

Object Hierarchy in EDM​

Companies

  • Projects
    • Sites (pads)
      • Wells (one well program for one well)
        • Wellbores
          • Designs (one PLAN and multiple PROTOTYPE)
          • One ACTUAL

Databases​

  • EDM (SQL Server)
  • dwp_db (postgres, dashboard information, workflow data)
  • dwp_workflowdata_db (postgres, stores DWP custom plugin data)
  • dsbpm_db (postgres, JBPM data)
  • dwp_akerbp_db (postgres, data of all AkerBP DWP customizations)

Example URL: https://dwp-webapp.dsif.dazlmkabpprd06.ienergycloud.solutions/report/1b8b99d0-5955-11ee-bb68-235d1ee56a48/establish/phase/DSDWPWorkflow.FeasibilityWorkflow/Design%20List

  • dsif.dazlmkabpprd06.ienergycloud.solutions - cluster URL
  • 1b8b99d0-5955-11ee-bb68-235d1ee56a48 - report_id (well program ID). Table is dwp_db.report
Connecting...