Extract, Transform, Load - Tools to manage and control the flow of data, usually between on premise and hosted servers, for data concurrency

Manage and control the flow of data between files, databases, and servers

Cadcorp SIS ETL (Extract, Transform, Load) is a data management tool that manages and controls the flow of data between files, databases, and servers. The applications include streamlining spatial data management and providing concurrent data for a cloud or remote data service.

The following operations and formats are supported:

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 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 PostGIS table and creates a new one with the CSV

SIS ETL can undertake regular exports from the PostGIS database to GIS files. This is useful for when the database tables have been updated and are required by other systems.

Operations can be scheduled for a specific time and if used alongside Cadcorp GeognoSIS, can include a restart of the service, to ensure that new files are picked up.

Cadcorp SIS ETL workflows

Installing SIS ETL on the GeognoSIS server allows it to monitor a designated folder where files for the scheduled operations can be copied. On a hosted or external server, this can be an FTP enabled folder.

For more information and to discuss your specific requirements, complete the 'Online Enquiry' form below or email info@cadcorp.com.