Python Industrial Automation Manual

Practical Python manual for industrial automation reporting, SQL historian data, Excel/PDF generation, email alerts, REST API and scheduled plant reports.

Request Manual / Training Details

What this page covers

SQL Data Reading

Connect Python with SQL Server and read SCADA/plant historian values.

Excel & PDF Reports

Generate shift, daily, batch and breakdown reports using Python.

Industry 4.0 Workflow

Prepare REST API, JSON, dashboard and ERP/MES data exchange logic.

Practical Learning Sequence

Practical 01: Install Python, VS Code and required reporting libraries

Practical 02: Connect Python with SQL Server using connection string

Practical 03: Read tag values, alarms and production data from historian table

Practical 04: Create Excel report with formatted rows, headings and totals

Practical 05: Generate PDF report and send by email automatically

Practical 06: Schedule report script for daily or shift-wise execution

Practical 07: Prepare REST API JSON payload for dashboard or ERP integration

Enquire Now

For syllabus, manual PDF, corporate batch or online training details, contact Softwell Automation.