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. |
|
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.
The schedule can also include restarting GeognoSIS instances to ensure new files are picked up.