VERIFIED SOLUTION i

How to Setup a PostgreSQL Server and then upload MapInfo .tab files using MapInfo EasyLoader within MapInfo Pro

Product affected: MapInfo Pro™

MapInfo Pro lets can access data wherever it resides, such as on a local machine or on the network. File types can be, Microsoft Excel files, CSVs or  MapInfo Pro native (.tab) files, or stored in a Database Management System (DBMS), or from a web service.
 
This article addresses the special circumstances that surround accessing data from a PostgreSQL database for use with MapInfo Pro, which requires setting up the database connection.

 The series of screen shots provide a clear idea of how to go about setting up a Postgres database.

User-added image

User-added image

User-added image


This creates a database with spatial extensions for postgis to hold geometry/spatial objects.
 
Once the data base is set up, use the tool EasyLoader to upload MapInfo tables into Postgress.
Load the tool under Home>Tool Extensions>Registered.  Check the box to Autoload for MapInfo EasyLoader and click the icon to the right of the word Autoload to run the tool.

Then go to Home>Tool Extensions>Running and right-click to run the tool.

MapInfo EasyLoader

User-added image

User-added image

User-added image

User-added image

User-added image

User-added image

User-added image

User-added image

If the ODBC driver is not listed in the ODBC connection list,
Download ODBC driver for postgress from https://www.postgresql.org/ftp/odbc/versions/msi/
Install ODBC driver.
Once installed, the driver will be visible and used to make the connection.

 
User-added image

User-added image

User-added image

User-added image

User-added image

User-added image

User-added image

User-added image

User-added image

An error may occur as shown in the screen shot.

User-added image

View Log for error details.

User-added image
Open the log file to view the errors.

Open file in MapInfo and then perform upload again. This error will be rectified.

User-added image

If ERROR STILL PERSISTS, open Map Catalog option once and then close. Select table and then upload. Initially there may not be any entries here, but once table is uploaded, the table list can be viewed here.

User-added image
The MapInfo catalog is now created in Postgres
The Table is created under the default public schema
Now tables in database are ready for use. The created table holds information on style and geometry and can be retrieved while downloading table in MapInfo Pro.
UPDATED:  April 4, 2018