Skip to content

Connect an EBIC export to pgAdmin

pgAdmin is a powerful interface for writing and testing SQL queries against your EBIC export database. Use this guide to connect pgAdmin to your EBIC export, then run queries to troubleshoot data or explore your database structure.

Gather your connection details

First, you'll need the connection details from your EBIC export in Evergiving.

  1. In Evergiving, navigate to your EBIC export
  2. Scroll to EBIC CONNECTION DETAILS

  3. Note the following values — you'll use them in pgAdmin:

  4. Database Host

  5. Database Port
  6. Database Name
  7. Database User
  8. Database Password

Register the server in pgAdmin

Now you'll add this connection to pgAdmin.

  1. Open pgAdmin
  2. Right-click Servers in the left panel
  3. Select Register > Server...
  4. In the General tab, enter a Name for this connection (e.g., the database host name)
  5. Click the Connection tab

  6. Fill in the connection fields:

  7. Host name/address — Enter the database host

  8. Port — Enter 5432
  9. Maintenance database — Enter the database name
  10. Username — Enter the database user

  11. Password — Enter the database password from Evergiving

  12. Click Save

Open Query Tool and test your connection

Once the connection is saved, you can open the query editor to test it.

  1. In the left panel under Servers, find and expand your newly registered connection
  2. Expand Databases, then find the database that matches your database name from Evergiving
  3. Right-click that database and select Query Tool
  4. In the query editor, enter a test query (e.g., SELECT * FROM data;)
  5. Click the execute button (or press Ctrl+Enter) to run the query

If the query runs without errors, your connection is working. You can now write your own queries to troubleshoot your data and explore your database structure.

Tip

Save queries you run frequently by using the Scratch Pad tab in pgAdmin. This makes it easy to re-run them later without retyping.