Rockwell Automation FactoryTalk Report Expert User Guide - Manual (Page 26)

Chapter 4 Getting Started
26 Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014
The Report Expert architecture is a scalable, multi-tiered,
distributed architecture consisting of the following main
components:
Item Description
Report Expert client (One or more.) A laptop or workstation running Internet Explorer.
Report Expert web
site
A server computer running Microsoft SQL Server with SQL Server
Reporting Services (SSRS) and Internet Information Server (IIS).
Database server A server computer running Microsoft SQL Server. This computer
contains the RSBizWare database with the FactoryTalk Metrics data
from which the content of Report Expert report templates are
derived.
The Report Expert components can be configured to run on a single
computer, or it can be distributed across multiple computers. In the
simplest case, the Report Expert web site can be installed on the
same machine as the database server and a user can access the Report
Expert client on the same server computer. In a distributed setting,
these components may reside on separate computers.
The Report Expert client connects to the Report Expert service to
view an HTML report, while it connects directly to the SQL Server
Reporting Services (SSRS) to generate a PDF or an Excel version of a
report or to print a report. The scalability of the Report Expert
architecture allows many clients to connect to a single Report Expert
web site.
The Report Expert web application interacts with the SSRS web
application. The SSRS web application uses the FactoryTalk Metrics
Data Provider (a SSRS Data Processing Extension) to retrieve
FactoryTalk Metrics data.
To generate FactoryTalk Metrics-related Report Expert report
templates, the Report Expert Service must have a connection to the
RSBizWare database containing the FactoryTalk Metrics tables and
views. In addition, SSRS need access to its own separate database at
run time.