MapInfo Pro supports SQLite databases through OSGeo FDO Data Access Technology, so that you can work with spatial data stored in SQLite database files. This means that:
- you can display your existing SQLite data on a map in MapInfo Pro;
- you can save your MapInfo tables to your existing SQLite database to take advantage of the capabilities provided by a transactional SQL database engine;
- you can create a new SQLite database from MapInfo Pro;
- you can share spatial data with other applications, such as Autodesk products: AutoCAD Map 3D, Civil 3D, and Autodesk Infrastructure Modeler.
To start working with your data stored in a SQLite database, see Opening SQLite Tables.
FDO (Feature Data Objects) is an interface for storing, retrieving, updating, and analyzing spatial data. MapInfo Pro installs an FDO Provider for SQLite (spatial), so that you can work with SQLite database files. The OSGeo FDO Data Access Technology stores geometry data to a SQLite database as FGF (Feature Geometry Format) objects. For more information about FDO, see http://fdo.osgeo.org.
For information on how MapInfo objects map to FGF objects for SQLite database connections, see Mapping FGF Objects in a SQLite Database to MapInfo Objects.
MapInfo Pro works with data created in Autodesk products, such as AutoCAD Map 3D, Civil 3D, and Infrastructure Modeler, that has been stored in SQLite database format. You can view this data in MapInfo Pro, save changes made to the data, and then continue to work on the data in the Autodesk products.
Note that there are some limitations reading and writing text layers created in AutoCAD Map 3D, which are outlined under Sharing Data with Autodesk's AutoCAD Map 3D.
For background information:
- about SQLite, see http://www.sqlite.org
- about FDO, see http://fdo.osgeo.org