Skip to content

Connect to a database server

To get access to database server for configurating and handling databases, login to the database server is required.

Click on the Server button, select the type of database server to connect to.

The following database types are supported. MIKE OPERATIONS offers limited support for spatial data when used with some database types.

  • PostgreSQL: PostgreSQL databases support storing and displaying spatial data, including raster data.

  • SQLite: For SQLite, vector GIS data can be stored and displayed. Raster data are not supported.

  • MSSQL Server: For MS SQL Server, vector GIS data can be stored and displayed.

Note

Note that raster and mesh data are not supported for MSSQL Server.

Please refer to the FAQ for more information about selecting a database type.

PostgreSQL

  • Database host

    • Name: The name of the database server.

    • Port: Port used by the database server. Default for PostgreSQL installations are 5432. If more versions of PostgreSQL are installed, different port numbers are used for every PostgreSQL database version. By default, PostgreSQL are using the proceeding port numbers as default during installation (5432, 5433, 5434 etc.).

  • User Credentials

    • Name: Name of the user to be used for logging on to the database server. The user should have administrator rights. It is recommended to use the "postgres" user for login.

    • Password: Password of the database user.

  • Database tools folder: The folder containing tools for doing command line execution of SQL Scripts in PostgreSQL.

SQLite

  • Database folder: Folder containing SQLite database files.

  • Database tools folder: SQLite tools folder. MIKE OPERATIONS contain required files for doing database operations on SQLite.

MS SQL Server

  • Database host

    • Name: Specify the server name. Localhost can be used in case the server has the default name and installed on the same server as MIKE OPERATIONS.

    • Port: The TCP Port specified in the TCP/IP Properties of the SQL Server.

  • User Credentials: Login to SQL Server from MIKE OPERATIONS, supports SQL Server Authentication only. This means that the user has to be a SQL Server user able to create, update and delete databases and able to create users. It is recommended to use the "sa" user of SQL Server for database maintenance in the Database Manager Utility.

    • Name: The name of the user SQL Server user.

    • Password: The password of the user.

  • Database tools Folder: Folder containing the SQL Server command line tools (SQLCMD.EXE).