Search TipsAbout Cadcorp SIS ETL
Cadcorp SIS ETL stands for Extract, Transform, Load.
ETL provides tools to manage and control the flow of data (files, PostGIS or SQL Server databases and SWDs) through servers.
This stream-lining process is useful to provide concurrent data for a cloud or remote data service (e.g. GeognoSIS).
The following operations and formats are supported:
|
Description |
|
| COPY |
Moves updated files from and to defined locations (supports BDS, FDB, ODB, SHP and TAB files)
|
| UPLOAD |
Pushes data from any of these files into a PostGIS or SQL Server database, replacing any existing tables (supports FDB, SHP and TAB files)
|
| UPLOAD (Using an SWD file) |
Uses all data layers in the SWD and pushes them into separate PostGIS or SQL Server tables. This replaces any existing table. All supported SIS vector formats can be included in the SWD.
|
| UPDATE (CSV files) |
Drops an existing PostGIS or SQL Server table and creates a new one with the CSV.
|
| MERGE (SHP or TAB files) | Merges multiple shape files so they can be uploaded into the same spatial table, e.g upload a shape file of points and merge shape files of line and polygons. Another example concatenating together multiple Esri Shapefiles into a single database table (Uploads and Updates should be done before Merges and Appends) |
|
APPEND (CSV files)
|
Allows CSV data to be added to an existing table.
|
| EXPORT (From PostGIS to SHP or TAB files) |
Regular exports from a database to GIS files. Useful when the database tables have been updated and are required by other systems.
|
These actions can be scheduled for a specific time. Individual operations can be paused/disabled.
The schedule can also include restarting GeognoSIS instances to ensure new files are picked up.