Location Intelligence Module stages, services, and operations require named tables to access various types of data. Named tables are resources that reference data in various formats (see table below). This section describes how to add Location Intelligence Module named table resources. Named tables are stored in the Spectrum Spatial repository, and can be used by all spatial services.
For each type of supported data sources we support three types of tables: Spatial (table with Geometry column), XY (table with X and Y columns), and Non-Spatial (table without geometry column and no column hints specified that reference X and Y columns). Each of these types of tables are supported using a different data provider resulting in a different type of named table. When creating named tables you must specify the correct type. This is important for operations such as inserting, updating, or reading data to and from a table. The following table outlines the supported data sources and the type of table required for read and insert operations:
|MS SQL Server||Read/Insert/Update/Delete||Read/Insert/Update/Delete||Read/Insert/Update/Delete|
|Table Formats (file-based data sources)|