Supported Data Sources
The Location Intelligence Module supports spatial and non-spatial tables from a variety of data sources:
Data Source |
Spatial Table |
Non-Spatial Table |
XY Table |
---|---|---|---|
JDBC | n/a | Read/Insert/Update/Delete | Read/Insert/Update/Delete |
SAP HANA | Read/Insert/Update/Delete | Read/Insert/Update/Delete | Read/Insert/Update/Delete |
Oracle | Read/Insert/Update/Delete | Read/Insert/Update/Delete | Read/Insert/Update/Delete |
MS SQL Server | Read/Insert/Update/Delete | Read/Insert/Update/Delete | Read/Insert/Update/Delete |
PostGreSQL/PostGIS | Read/Insert/Update/Delete | Read/Insert/Update/Delete | Read/Insert/Update/Delete |
GeoPackage | Read/Insert/Update/Delete | Read/Insert/Update/Delete | n/a |
View | Read | Read | Read |
Table Formats (file-based data sources) | |||
ESRI Shapefile | Read | n/a | n/a |
MapInfo TAB | Read | n/a | n/a |
Specialty tables include raster, grid, and seamless versions of .TAB. View tables are also supported. A view table is a subset of information from one or more data sources, including other view tables. Views are created with an MI SQL Select statement.
The Location Intelligence Module also supports an extensible data provider API for accessing custom data sources. This can be downloaded from the Spectrum Spatial section of the Welcome page, under Sample Applications..