Pitney Bowes MapXtreme - Manual (Page 214)

Accessing Data from a
DBMS
MapXtreme provides spatial server access. This is a powerful feature that
allows developers to connect to live data stored in spatial servers, such as
MapInfo's SpatialWare running on Microsoft’s SQL Server or the Oracle Spatial
databases. Spatial servers allow companies to host their map data in their
enterprise database for central management and security. Spatial servers like
SpatialWare offer advanced query processing and increased performance on
the server for an organization's spatial data.
In this chapter:
Š Accessing Remote Spatial Data . . . . . . . . . . . . . . . . . . . . . . . . . .222
Š Accessing Remote Tables Through a .TAB File . . . . . . . . . . . . .222
Š Accessing Remote Tables Without a .TAB File . . . . . . . . . . . . . .222
Š Mapping DBMS Data with X/Y Columns . . . . . . . . . . . . . . . . . . . .223
Š Accessing Data from Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . .223
Š Accessing Data from MS SQL Server. . . . . . . . . . . . . . . . . . . . . .226
Š DBMS Connection String Format . . . . . . . . . . . . . . . . . . . . . . . . .229
Š Defining Mappable Tables in Server Table Queries . . . . . . . . . .231
Š Accessing Attribute Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .233
Š Performance Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .233
Š Working with the Cache. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .234
Š The MapInfo_MapCatalog . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .236
Š Adding Rows to the MapInfo_MapCatalog. . . . . . . . . . . . . . . . . .239
Š Per-Record Styles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .243
Š Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .245
11