160 / 413
5/26
Functions
(
continued)
Modicon Premium automation
platform
Transparent Ready, system approach
FactoryCast HMI active Web services
Specialized HMI services
(
continued)
Connection to relational databases
The FactoryCast HMI module can be connected directly and completely
autonomously to the following remote relational databases:
b
SQL Server
b
MySQL
b
Oracle
This connection enables all process or internal data to be archived directly in the
FactoryCast HMI module without any intermediate system (hardware or software).
The data can be archived (written) periodically and/or on a specific event. These
variables can be either from PLCs (I/O bits, internal bits, internal words and
registers) or local to the module.
The FactoryCast HMI Roll Over function controls the size of tables by managing the
maximum number of records.
This circular data archiving function automatically deletes the oldest data and can be
accessed by simply setting parameters in the FactoryCast HMI software.
Characteristics
b
Number of databases that can be connected: 3
b
Number of tables that can be written per database: 10 maximum
b
Number of columns per table: 50 maximum
b
Type of database supported: Oracle, SQL Server and MySQL
b
Automatic table creation: the FactoryCast HMI server creates a table in the
database if one does not already exist
Data Logging
FactoryCast HMI modules can log data in the internal flash memory periodically or
on an event.
This logging is done in a CSV file, which can be:
b
Automatically exported via FTP
b
Attached to an e-mail
This function is particularly useful for standalone installations, or stations that are not
connected to an Intranet, or for local traceability of data.
Connection to databases
Data Logging
Premium
Data
server
Quantum
MySQL
ORACLE
Microsoft
SQL Server
Web server
Web server
@
Premium
Quantum
Internet
Web server
Web server
.
csv data
files
.
csv data
files
FTP
2
1
3
4
5
6
7
8
9
10