sh-notion/notion_data_team_no_files/Connecting to Core 6ecf68bb25bc489ea8f38ac971e1a2c1.md
Pablo Martin a256b48b01 pages
2025-07-11 16:15:17 +02:00

1.4 KiB
Raw Permalink Blame History

Connecting to Core

The Core database is the main database for Superhogs backend.

To access it:

  1. Make sure you are connected to the Data VPN.
  2. Fetch the reading user credentials from the Dev shared folder in Keeper. If you dont have access to it, ask Pablo.
  3. Use the following connection details:
    1. host: superhog.database.windows.net
    2. port: 1433
    3. database: live (if you want to read from production) or staging (if you want to read from staging).
    4. Authentication type: SQL Server Authentication

Be aware that this instructions are specific to Data team members. You might see different instructions elsewhere, feel free to ignore them.

The details above will grant you read access. If you need write access… you really shouldnt write there at all. Please check your needs with Pablo and Ben Robinson. Never connect to this database with the intention of writing into it unless you have crystal clear, explicit and documented approval from Ben R.

Also note that there are certain networking whitelist exceptions in place to allow Data team members to connect to it. These include our office locations and home IPs. Should your IP change or the office move, please get in touch with Ben Robinson to request an update in the whitelisting rules.