The purpose of this project is to provide a web-based, user-friendly, useful and nice looking SQL Server Integration Services Dashboard and a set of REST API to monitor execution of SQL Server Integration Services Packages.
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
- SSIS on Azure Data Factory V2 (https://docs.microsoft.com/en-us/azure/data-factory/)
SSIS Dashboard has been built using:
- Python 3.6: https://www.python.org/
- Flask 0.12.2: http://flask.pocoo.org/
- PyODBC 4.0.17: https://github.com/mkleehammer/pyodbc
- SB Admin 2 Template: http://startbootstrap.com/template-overviews/sb-admin-2/
The IDE used to build the project is Visual Studio 2017 (that's why you can see the runserver.py
file), though now I'm also using Visual Studio Code