Pitney Bowes MapInfo Professional - Manual (Page 163)

7
Working with Data in a
DBMS
MapInfo Professional lets you access data where it lives, on your machine or on
the network, in flat files, such as Microsoft Excel files or MapInfo Professional
native (.tab) files, in a Database Management System (DBMS), or from a web
service.
This section addresses the special circumstances that surround accessing data
from a SQL Server, Oracle Spatial, or PostgreSQL with PostGIS database for
use with MapInfo Professional, which requires setting up a database connection.
This section also discusses how to set up your connection to Microsoft Access.
For database versions that MapInfo Professional supports, see the MapInfo
Professional Install Guide.
In this section:
• Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .164
• Creating a Data Source Connection . . . . . . . . . . . . . . . .165
• Reconnecting to your Data Source after Startup . . . . .172
• About Supported DBMS Data Types . . . . . . . . . . . . . . . .175
• Creating a Map Catalog in the DBMS to Work with Data .177
• Adding a Spatial Primary Key to a DBMS Table . . . . . . .179
• Making a DBMS Table Mappable to Display it on a Map .181
• Deciding to work with Linked or Live Access Tables . .183
• Opening a DBMS Table in MapInfo Professional . . . . . .185
• Working with Remote Tables from Specific Databases .193