Analyzing non-rsbizware data, Create an external data source – Rockwell Automation FactoryTalk Metrics User Guide User Manual

Page 236

Advertising
background image

Chapter 7 Advanced Reporting Topics

Filter. For scheduled report objects only. The name of the

filter that was applied to the RSBizWare report object when
it was scheduled.

Schedule Description. The name that the user gave to the

task when it was scheduled.

Log Message. A message from FactoryTalk Metrics

indicating the status of the task (e.g.,

Scheduled Item

Created, Scheduled Item Dispatched, Scheduled Item Failed).

Run Results. An additional description of the task results.

For example, if your task failed, the run results may contain
the reason of the task failure.

Log Date. The date and time when the application

attempted to perform the scheduled task.

The reporting features of the Configuration Console can be applied
to tables or views that exist in non-RSBizWare databases. This is
useful if you have data from other software packages or legacy
systems that you want to analyze in the Configuration Console.

To analyze non-RSBizWare data in the Configuration Console, you
need to create an external data source describing the external
database to the Information Services Manager, and a report data

source describing the table or view from the external database to the
Configuration Console.

An external data source is the ODBC connection to the SQL Server

or Oracle database. The external data source provides a link between
the non-RSBizWare database and the Information Services
Manager. External data sources are configured in the Service
Console. For information on how to create a new external data
source, refer to the

Administration Guide, section "Administering

RSBizWare servers”.

Analyzing Non-RSBizWare
Data

Create an External Data
Source

236

Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014

Advertising