Tuesday, September 12, 2006

Mapinfo Professional Geocode with Oracle

I have been working on project that integrates MapInfo, oracle and .Net web development.

How to import MapInfo tables to Oracle.

1.- In your oracle database, create a table space "MapInfo", user: MapInfo password:MapInfo

2.- Create a ODBC Machine Data source pointing to your Oracle Database "MapInfo Oracle" . Make sure the user name has access to your "MapInfo" Table space.

3.- Open MapInfo

4.- go to --> Tools --> Easy loader

5.- click on ODBC, select the machine source tab and select your "MapInfo Oracle" connection

Username: mapinfo
password: mapinfo

6.- Select the mapinfo source directory which would usually be at C:\Program Files\MapInfo Data\US_ExchangeInfoPlus or where ever map info was installed.

7.- You have to select one table at the time:

usnpaxx
uswcpt
uswcreg

on the server table select the appropiate processing option to create the table, append or replace.

8.- Click on update.

Your Oracle database will be updated with MapInfo tables.

No comments: