Global Mapper is a great GIS software that supports many GIS formats as well as spatial databases. On this article, I am going to show you how to create a new spatial database connection on Global Mapper. I am using Global Mapper 20 full version on this tutorial. Before we can open or export spatial datasets to a spatial database, we need to create the connection first. Global Mapper supports the following databases:
- Microsoft SQL Server
- PostGIS (PostgreSQL)
- MySQL Spatial database
- Oracle
- ESRI ArcSDE
If you don’t have Global Mapper, you can use the free ogr2ogr tool to export spatial datasets to spatial database. But unfortunately, ogr2ogr uses a command line and there is no GUI tool that is reliable.
Steps to create a new Spatial Database Connection on Global Mapper
First, go to Tools | Connection Manager. Here you can see the connections that you have, or you can create a new one.
As you can see, I have several connections already. To create a new connection, click the New button. A new window will open up. Select the spatial database type from the list. In this example, I want to create a new MySQL Spatial Database connection.
Next, enter the database credentials such as ip-address, port, username, password, and the database name. Click Test Connection to make sure the connection is working. Hit OK and you are done.