Cadcorp SIS ETL
Manage and control the flow of data between files, databases, and servers
Cadcorp SIS ETL (Extract, Transform, Load) provides tools to manage and control the flow of data (files, PostGIS or SQL Server databases and SWDs) through servers.
The application
Create a workflow that streamlines spatial data management and provides concurrent data for a cloud or remote data service
SIS ETL supports the following operations and formats:
- COPY – Moves updated files (BDS, FDB, ODB, SHP, and TAB) from and to defined locations
- UPLOAD – Pushes data from FDB, SHP, TAB or SWD project files into a PostGIS or SQL Server database, replacing any existing tables. When using the project file option, all supported Cadcorp SIS vector formats can be included
- APPEND – Allows CSV data to be added to an existing table
- UPDATE – Drops an existing database table and populates a new one with the CSV
This streamlining process is useful to provide concurrent data for a cloud or remote data service.
SIS ETL can also undertake regular exports from the spatial database (PostGIS or SQL Server) to GIS files. This is useful when the database tables have been updated and are required by other systems.
Contact us
Get in touch
Give us a call or complete the form. We endeavour to answer all enquiries within 24 hours on business days. We will be happy to answer your questions.
Contact us