Real Time Visualization with Dash Python and Microsoft SQL Server

(Near) Real-Time data visualization with Dash Python and Microsoft SQL Server

Real-time setup for visualizing MSSQL Server data with use of Dash application as client server and little Python code to get the Dash framework started.

Cloning the repository

You can follow the steps below to clone the repository.

git clone https://github.com/tomaztk/Real_Time_Visualization_with_Dash_Python_and_SQLServer.git

Quickstart

1. Clone the repository
2. In your local Microsoft SQL Server run the file: Real-Time Stats Visualization.sql
3. Run your Python environment and {sudo} pip install dash
4. When Dash is installed, run the file: Real_TimeStatsVisualizationWithDash.py
5. Change connection string in Python file, pointing to your local database server.

    sql_conn = connectSQLServer('ODBC Driver 13 for SQL Server', 'MyMSSQL\Database', 'UserName', 'Pa$$w0rd') 
    cursor = sql_conn.cursor()

6. Open your web browser pointing to your localhost.

Blogpost

Originally posted on (blog). Read blogpost for additional information.

Video