Pitney Bowes MapMarker USA - Manual (Page 188)

Preparing to Geocode Remote Databases
188
MapMarker USA 25
Preparing to Geocode Remote Databases
Before you can geocode your remote table with MapMarker, you (or the database administrator)
must set up MapMarker and your database to handle the geocoding operation. In general, the
process follows these steps:
1. Create a data source for the RDBMS (see Creating a Data Source on page 188 ).
2. Prepare the remote table with the appropriate columns and spatial handling requirements (see
Preparing the Remote Table on page 188 ).
3. Create a Map Catalog for each remote database (see Creating a Map Catalog on page 189 ).
4. Make the remote table mappable (see Making a Remote Table Mappable on page 189 ).
See the following topics:
Creating a Data Source on page 188
Preparing the Remote Table on page 188
Creating a Map Catalog on page 189
Making a Remote Table Mappable on page 189
Creating a Data Source
After the drivers are installed, create a data source for your database. Use the ODBC Administrative
Tools in the Control Panel for this purpose.
L
Under Microsoft VISTA Ultimate Edition, you must have Administrator privileges to create an
ODBC data source.
To create an ODBC data source, follow these steps:
1. From Control Panel > Administrative Tools, double-click Data Sources (ODBC) to display the
ODBC Data Source Administrator dialog. Under the User DSN tab, click Add.
2. At the Create New Data Source dialog, choose the appropriate driver. Click Finish. The ODBC
Setup dialog is displayed. The dialog differs depending on your database.
3. Fill out the dialog per your needs and click OK. Select allows you to associate a specific
database with the data source.
4. Return to the ODBC Data Source Administrator dialog and click OK.
Preparing the Remote Table
You or your database administrator must add columns to the table to store the results of the
geocoding operation. For the X,Y spatial index type, there must be one column for longitude values
and another column for latitude values. The longitude and latitude columns should be decimal type
(11,6 or larger) or float. See
Output Column Type/Width Requirements .