ETL solution(windows service) for scheduled reports compilation and sending
Technology stack: Autofac, Dapper.Contrib, Monik, NCrontab, protobuf-net
Input data formats
- SQL Database
- Excel file
- CSV file
- SFTP server(file transfer)
Output report formats
- E-mail(Excel/Json attachements, message body as HTML table)
- Telegram message
- Database(raw data transfer into table/compressed reports)
- FTP/SFTP server(file transfer, CSV,Excel,Json)
- Via Consul (needs to have working Consul instance with AppService file configured) or
- Via appsettings