Creating a Data Source Connection to PostGIS - MapInfo_Pro - 2023

Before you begin, you need a PostgreSQL Unicode ODBC driver (psqlODBC) installed on your machine. Check with your database administrator to install the driver for your database. Ensure that your database administrator adds your machine IP address to the pg_hba.conf file for the database you want to connect to.

You need to know the database name, server name, username and password to the database, and whether or not you need a specific SSL Mode or Port number.

To create a new PostgreSQL PostGIS data source connection:

1. On the HOME tab, in the File group, on the Open list, click Database Table. This can also be done on the TABLE and MAP tabs.
2. If the Open DBMS Connection dialog box opens, select ODBC from the list and then click New.
   
   

   

   
   
3. In the Select Data Source dialog box, select either the File Data Source or the Machine Data Source tab and then click New.

   You can share the connection information for a file data source with other users on the network if they have the necessary drivers, because it is stored in a file. You cannot share the connection information for a machine data source, because it is stored in the registry on the local computer.

   
   

   

   
   
4. In the Create New Data Source wizard:
   1. Select the type of data source to create: User Data Source or System Data Source. Make a selection to display the description for it in the wizard. Click Next to continue.
   2. From the driver name list, select the PostgreSQL Unicode driver and then click Next.
   3. Click Finish.
5. In the PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box, set the following. If you are unsure of the settings to use for your database, consult with your database administrator.
   • Data Source - Provide a name for this data source. This is the name you will see after setting up this connection in the Select Data Source dialog box.
   • Database - The name of the PostGIS database that you want to connect to.
   • Server - The name of the machine where PostGIS is installed.
   • User Name - The username for accessing the database.
   • Password - The password for accessing the database.
   • Description - Optionally, type a description if you plan on connecting to more than one database and would like a description for this connection.
   • SSL Mode - Use the default value.
   • Port - Use the default value.
     
     

     

     
     

     Click Test to ensure that your connection works.

     Click Datasource (or Connection depending on the PostGIS driver).

6. In the Advanced Options dialog box, select the Use Declare/Fetch check box and then click OK.

   Selecting this option improves the processing time when connecting to larger databases.

7. In the PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box, click Save to set your connection.
8. In the Select Data Source dialog box, under the Machine Data Source tab, your new PostGIS connection displays in the list of available data source connections. Click OK.

You must now create a map catalog for the database, continue to Creating a Map Catalog Table Using MapInfo EasyLoader.