Your data must include X and Y point data (a Z column is optional). To display your data on a map the X and Y data must be coordinate data, such as Latitude/Longitude. If your data does not include coordinate information, then consider geocoding (adding the coordinate information) using a Precisely product, such as MapMarker or Spectrum.
To make a DBMS table mappable for geocoding purposes:
- Add two numeric columns in the table on the database server to hold the X and Y coordinates.
- In MapInfo Pro, on the TABLE tab, in the Maintenace group, click Database, and Make DBMS Table Mappable. Select the table you want to make mappable. The Make Table Mappable dialog box displays.
- Choose XY Coordinates for the Index Type, X column for the X Coordinate and the Y column for the Y Coordinate.
If your MapInfo_MapCatalog has the capability to support styles, you can set up the table to use per row styles. Select the Per Row Styles check box and choose the column that you want to obtain the style attributes. The only column types available for use with the Per Row Styles option are character or varchar columns. This option is only available when the MapInfo_MapCatalog has the structure to support styles. It must contain the columns: RENDITIONTYPE, RENDITIONCOLUMN, and RENDITIONTABLE.
- Open the remote table in MapInfo Pro; go to the HOME tab and click Open. You will get a blank Map window. On the SPATIAL tab click Create to geocode your records.
- Once you have completed geocoding, on the TABLE tab, click Save Table to save the changes to the remote database.
- Answer "Yes" to Refreshing the table in order to see your points.