- Knowledge Base
- Software
- Visualization / SCADA
How to Acquire Data with Dream Report From a SQL Server
The tutorial demonstrates connecting Dream Report to a SQL Server database.
This tutorial demonstrates how to use Dream Report to visualize data from a SQL Server database without the need for complex SQL queries. It guides viewers through setting up a DSN in DSN Manager for easy configuration within Dream Report. The process involves creating a DSN definition, connecting to a SQL Server instance using SQL Server authentication, and selecting a database. The video then shows how to create a report with a single data point and an item table, pulling data from the SQL Server as if it were tags within Dream Report. The demonstration highlights the simplicity of connecting to a relational database and generating a report without writing SQL queries.