Pitney Bowes MapInfo Professional - Manual (Page 170)

4. In the Create New Data Source wizard:
a. 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.
b. From the driver name list, select the PostgreSQL ANSI driver and then click Next.
c. Click Finish.
5. In the PostgreSQL ANSI 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 ANSI 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
EasyLoader .
MapInfo Professional 12.5 170
Creating a Data Source Connection