FlexLink YOUTILIZE - Manual (Page 30)

Providing production efficiency
Page 30 of 125
SQL Server (If Applicable)
If you are deploying the system using Option ‘B’ (distributed) or are not using the iMonitor Express
Installation Wizard. You may also be deploying a new SQL Server or using an existing one. As with
Microsoft Operating System Patches/Updates it is best to install all Service Packs and updates that
are available. However it is understood that a single SQL Server can host a number of databases and
it may not be possible to apply updates without internal review/approval. However it is
recommended to have all updates complete before deployment.
Installation
Deployments requiring the installation of Microsoft SQL Server will likely follow two paths. The first
would include the use of an existing Microsoft SQL Server and therefore the only process would be
to create a Database and DSN along with updating the database with the iMonitor Express database
schema. The alternative would be a dedicated SQL Server which would require the installation of
Microsoft SQL Server and the configuration of database and DSN along with the updating the
database with the iMonitor Express database schema. This guide assumes that users are capable of
deploying Microsoft SQL Server and if any assistance is required should seek the assistance of Aegis
Technical Support.
Youtilize Solution
The Youtilize solution is comprised of several components. The components are broken into two
groups, sever side and client. Generally speaking the server side components are responsible for
interfacing with the Matrikon software which in turn interfaces with the PLC(s). The data is provided
to xLink which in turn processes/distributes/records the collected data. In further detail xLink
processes the collected data, distributes it to the Real-Time Service, and records the data into the
SQL database. The Real-Time service then takes the data provided by xLink and sends it to gauges
arranged on dashboard(s) via a subscription that is created when dashboard(s) are loaded.
Additionally the Alarm Service is responsible for executing configured Alarms while the Report
Scheduling Service is responsible executing scheduled reports. For license control we have the Aegis
Enterprise License Manager and finally, the Fusion Server Manager is used to configure the Real-
Time, Report Scheduler, Alarm, and Enterprise License services.
The client side consists of two components, iMonitor Express and iMonitor Express Viewer. iMonitor
Express is used to build or design Dashboards with a variety if gauges as well as to run Dashboards.
Whereas the iMonitor Express Viewer is merely a tool for viewing previously designed Dashboards.
There are two ways to install the Youtilize solution. The first and simplest method only applies to
customer installing using Option ‘A’ (consolidated). In a consolidated deployment the database is
installed on the same system as iMonitor Express. During the installation process the installer will
install SQL Server 2008 R2 Express (if it is not already installed), create a new database, load the
database schema, setup a user account with the appropriate permissions, install and configure all
Youtilize Solution components and initiate a configuration wizard that will allow you to specify one
or more FlexLink configuration files used to populate the database with the appropriate data. This
will be referred to as the iMonitor Express Wizard Install and a procedure including screenshots
follows later in this section. The iMonitor Express Viewer is installed manually on stations as
needed.