Understanding Cadcorp SIS ETL

There are three components to the SIS Extract, Transform, Load (ETL) tool.

  1. Configuration file – an Access database
  2. A desktop application to manage customer and file records in the configuration file
  3. A windows service to look for and process files defined by the configuration file at specified intervals.

1. Configuration

The Access database is Cadcorp.SIS.ETL.Database.mdb.

This is automatically installed with the ETL desktop application. This means the desktop application can be uninstalled separately from the database Related Topics Link IconRelated Topics

See Troubleshooting if you experience any issues with opening the database.

2. Desktop Application

After successful installation, you can access the service from the Cadcorp menu. (Start > Cadcorp)

3. Windows Service

During installation, Cadcorp SIS ETL is added as a Windows service Related Topics Link IconRelated Topics

You can easily check this inside Windows Services.

Note: The ETL service is set to start automatically when the server is started.