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.

Online Enquiry

We endeavor to reply to all messages within 24 hours. If you don't hear back from us, check your spam folder and add info@cadcorp.com to your list of approved senders. You must complete all fields.