1. Home
  2. Docs
  3. Working with GeoGATE
  4. Connecting GeoGATE to Database

Connecting GeoGATE to Database

In this section, GeoGATE will connect to database (PostGIS) to add database table (GeoGATE supports Microsoft SQL Server and Oracle). For this purpose, you will use Database Connections page.

This example will target Parcels_Owners table imported to PostGIS database in previous section.

First of all, go to Data Connections page and select Add Data Connection.

Type a name for the connection, and choose the database type (Oracle client, PostgreSQL, or SQL client). In this example you will connect to PostgreSQL.

Enter connections details for the database: Server name, port, username, password, and click test in order to test the connection.

Select the targeted database from the list.

Now, the database is added successfully, and can be used to access the tables.

Click on “Data Tables List”

Type a Display Name for the table.

Choose the table from tables list.

Select the fields that will appear in the table, and also select the table’s primary key.

Customize fields appearance:

  • Click on edit icon to change field Alias (Display Name)
  • Use sort icon to change the display order of fields
  • Configure entry type and field format to set more display options

Finally, click on Entries icon to explore table data

Was this article helpful to you? Yes No

How can we help?