Download

NJ-series Machine Automation Controller
Database Connection CPU Unit
NJ501-1□20 / NJ101- □□20
Aiming for zero defect, non-stop production
D
e
ir
ct
Database
Databas
• Direct access to databases
• Real-time data collection and analysis
• Reliable traceability
See the Database Connection CPU Unit in the video
You can watch the promotional video by scanning the 2D code
using the bar code reader on your smartphone or tablet.
http://www.fa.omron.co.jp/njdb_e/
2
Merit
Facts visualized using data bring changes
Productivity
Improvement
Supported database
•M
Mic
Microsoft
ccro
oso
o
oft SQL
o
S server
• Oracle
O a e Data
Da
Database
• IBM DB2
• MySQL
• PostgreSQL
• Firebird
Visualized quality and productivity
Operating status can be displayed in real time using
familiar software such as Microsoft® Excel.
Direct
connection
Easily leveraging big data
The CPU Unit can directly access databases
without a separate computer.
Function Blocks allow PLC engineers to
smoothly introduce the CPU Unit.
Data collection
Database
Quality
Inspection results
Production conditions
New
Ne
ew
w eentry model NJ101 with
database
d
da
ttab
ab
ba connection NEW
TThee da
Th
d
database
aataba
a aas connection model is added to the
NJ101 that is ideal for machines with or without
a low number of axes.
Real-time data collected from various machines
and production lines helps improve the quality
and productivity.
NJ-series Database Connection CPU Unit
NJ101-1020/9020 NEW
NJ501-1□ 20
3
to factories
Predictive
Maintenance
Fast data collection
Ethernet
Data is sampled every millisecond and written to the database.
Machine behavior can be monitored more accurately.
Error detected
Image files
Vision System
FH Series
Quality
Traceability
Manufacturing traceability
Data, such as production conditions,
production results, and inspection results,
can be managed at the individual product level.
Saving data and images together
The process data is linked to inspection images and
saved together with the images.
This improves the level of quality management.
Application: Increased productivity by 30%
The logs, which are collected from devices on a
production line and linked with each product, are
consolidated into the database. Visualization of the
entire process leads to effective improvements,
boosting productivity by 30% a year.
For details visit
http://www.fa.omron.co.jp/dbo_e/
4
Applications
Data can further improve manufacturing
Facts visualized using data can change manufacturing.
Demand for leveraging manufacturing data is increasing.
Start small with big data for your system
Database
Just install an additional unit to
collect data via Ethernet
Direct
NJ-series Database Connection CPU Unit
NJ501-1□ 20
NJ101- □□ 20
Example: Automotive parts production line
Ethernet
Existing
production
line
PLC of machine
PLC of machine
Processing machine
Assembly machine
Add to existing system
Simple configuration
The data in the PLC used for each
machine can be stored in a database.
Even if you are using other company's
PLC, consult your Omron representative.
Direct access eliminates the need to
connect a separate computer. Function
Blocks allow PLC engineers to smoothly
access the database from the CPU Unit.
PLC of machine
Vision system
Inspection machine
Data visualization
Data collected in the database can be visualized
using familiar software such as Microsoft® Excel.
You can easily identify improvement points,
quickly making improvements.
5
Omron factories have proven the benefits of using big data
Improving operating efficiency thanks to high-speed data collection
The system to visualize the productivity of the PCB surface mounting line in time series was built in Kusatsu
Factory, and overseas factories are also using this system. The systems in each factory are connected via the
cloud to share the data. This will help share the know-how between factories and improve productivity and
Productivity
Improvement
Benefits
• 6 times faster to identify
improvement points*
• Increased productivity by 30%*
Cloud
Sharing data
• Omron Kusatsu Factory
• Omron Shanghai Factory
Omron Kusatsu Factory
Omron Shanghai Factory
Improving analysis accuracy aiming for a failure rate of 1 ppb
The system implemented in the PCB surface mounting line obtains the inspection data in addition to the
object passing time and analyzes the correlation between the process and causes of failure. This system will
obtain more data and increase the analysis accuracy, aiming for extraordinary quality innovation.
Quality
Innovation
PC
Big data system
Benefits
• Collected about 6 times
the amount of data*
• Failure rate of 1 ppm*
Direct
• Omron Kusatsu Factory
Statistical/event
processing
Mounting process data
Correlation analysis tool
Inspection/measurement data
Improving maintenance by leveraging big data
The system to collect machine data and visualize operating status was built for the high-efficiency coupling element alignment machines.
The workflow where the vacuum nozzle is washed when a measured value exceeds the specified threshold is achieved by collecting the
data from the process and analyzing it. Efficient and timely, not periodic, checks will lead to improvement of operating efficiency.
Predictive
Maintenance
• Omron Ayabe Factory
SQL Server
PC
Tablet
Benefits
Time to wash
Flow volume (l /min)
• Improved productivity by
avoiding intermittent stops
• Reduced cost due to
timely parts replacement
Suction error
Suction impossible
Feb.1 8
Alignment machine No. 1
15
22 Mar.1
8
15
Alignment machine No. 2
* In-house comparison. Based on Omron investigation in November 2015.
NJ-series Database Connection CPU Units
NJ501-1@20/NJ101-@@20
Controller Directly Connectable to
Database
The NJ-series Machine Automation Controller supports the
Database Connection function.
Machine data can be quickly stored in a database by
connecting the Controller directly to the database.
NJ101-@@20
NJ501-1@20
Features
• The Controller can be directly connected to a database. No special Unit, software, nor middleware is required.
• Special instructions (function block) in the Controller make access to the database easy.
• Various functions (Spool function and Operation Log function) are available when an error occurred.
From <Via gateway>
Connection via computer
To <Direct
connection>
High-speed direct connection
between Controller and database
Database
Database
(SQL Server etc.)
File
Direct
connection
Data
Sysmac is a trademark or registered trademark of OMRON Corporation in Japan and other countries for OMRON factory automation products.
Microsoft, Windows, Windows Vista and SQL Server are registered trademarks of Microsoft Corporation in the United States and other countries.
Oracle and Oracle Database are trademarks or registered trademarks of Oracle Corporation and/or its affiliates in the United States and other
countries.
IBM and DB2 are trademarks or registered trademarks of International Business Machines Corp., registered in the United States and other
countries.
EtherCAT® is a registered trademark of Beckhoff Automation GmbH for their patented technology.
EtherNet/IPTM, DeviceNetTM are trademarks of the ODVA.
Other company names and product names in this document are the trademarks or registered trademarks of their respective companies.
6
NJ501-1@20/NJ101-@@20
Ordering Information
International Standards
• The standards are abbreviated as follows: U: UL, U1: UL (Class I Division 2 Products for Hazardous Locations), C: CSA, UC: cULus, UC1:
cULus (Class I Division 2 Products for Hazardous Locations), CU: cUL, N: NK, L: Lloyd, and CE: EU Directives, RCM: RCM mark and KC: KC
Registration.
• Contact your OMRON representative for further details and applicable conditions for these standards.
NJ-series CPU Units
Current
consumption (A)
Specifications
Product Name
I/O capacity / maximum Model
Standards number of
configuration Units
(Expansion Racks)
NJ-series
CPU Units
Program
capacity
Memory
capacity for
variables
20 MB
2 MB:
Retained during
power
interruption
4 MB:
Not retained
during
power
interruption
2,560 points / 40 Units
(3 Expansion Racks)
3 MB
Number of
motion axes
Model
5 VDC
64
NJ501-1520
32
NJ501-1420
16
NJ501-1320
1.90
0.5 MB:
Retained during
power
interruption
2 MB:
Not retained
during
power
interruption
Standards
24 VDC
−
2
NJ101-1020
0
NJ101-9020
UC1, N, L,
CE, RCM,
KC
Automation Software Sysmac Studio
Please purchase a DVD and required number of licenses the first time you purchase the Sysmac Studio. DVDs and licenses are available
individually. Each model of licenses does not include any DVD.
Product name
Specifications
Number of
licenses
The Sysmac Studio provides an integrated development environment to set
up, program, debug, and maintain NJseries Controllers and other Machine
Automation Controllers, as well as EtherCAT slaves.
Sysmac Studio
Standard Edition
Ver.1.@@
−
(Media only)
Media
DVD
Model
Standards
SYSMAC-SE200D
−
SYSMAC-SE201L
−
Sysmac Studio runs on the following OS.
Windows XP (Service Pack 3 or higher, 32-bit version)/Windows Vista(32bit version)/Windows 7(32-bit/64-bit version)/Windows 8(32-bit/64-bit
version)/Windows 8.1(32-bit/64-bit version)/Windows 10(32-bit/64-bit
version)
The Sysmac Studio Standard Edition DVD includes Support Software to set
up EtherNet/IP Units, DeviceNet slaves, Serial Communications Units, and
Support Software for creating screens on HMIs (CX-Designer).
For details, refer to the Sysmac Integrated Catalogue (P072).
1 license *
−
* Multi licenses are available for the Sysmac Studio (3, 10, 30, or 50 licenses).
Recommended EtherCAT and EtherNet/IP Communications Cables
For the Recommended EtherCAT and EtherNet/IP Communications Cables, refer to the Machine Automation Controller NJ/NX-Series Datasheet.
Accessories
The following accessories come with the CPU Unit.
Item
Battery
Specifications
CJ1W-BAT01
End Cover
CJ1W-TER01 (necessary to be connected to the right end of the CPU Rack.)
End Plate
PFP-M (2 pcs)
SD Memory Card
HMC-SD291
(Flash Memory 2 GB)
7
NJ501-1@20/NJ101-@@20
General Specification
For the common specifications of the NJ-series, refer to the Machine Automation Controller NJ/NX-Series Datasheet.
Performance Specifications
NJ501-
Item
Programming
1520
Memory for CJ-Series
Units (Can be Specified
with AT Specifications
for Variables.)
EM Area
NJ101-
1420
1320
32,768 words ✕ 25 banks *
(E0_0 to E18_32767)
1020
9020
32,768 words ✕ 4 banks *
(E0_0 to E3_32767)
* When the Spool function of the NJ501-1@20 is enabled, the DB Connection Service uses E9_0 to E18_32767.
When the Spool function of the NJ101-@@20 is enabled, the DB Connection Service uses E1_0 to E3_32767.
Furthermore, for the common specifications of the NJ-series, refer to to the Machine Automation Controller NJ/NX-Series Datasheet.
Refer to the specifications of the NJ501-@5@0 for those of the NJ501-1520, the NJ501-@4@0 for the NJ501-1420, the NJ501-@3@0 for the NJ5011320, the 101-1020 for the NJ101-1@@0 and the 101-9020 for the NJ101-9@@0.
Function Specifications
NJ501-1@20
Item
Debugging
Data Tracing
Ver.1.07 or ealier
Maximum number of
simultaneous data
traces
4
NJ101-@@20
Ver.1.08 or later
2
2
Furthermore, for the common specifications of the NJ-series, refer to the Machine Automation Controller NJ/NX-Series Datasheet.
Functions Supported by NJ501-@@20 or NJ101-@020
Besides functions of the NJ501-1@00 or NJ101-@@00, functions supported by the NJ501-@@20 or NJ101-@020 are as follows.
Description
Item
NJ501-1@20
NJ101-@@20
Supported port
Built-in EtherNet/IP port
Supported DB
Microsoft Corporation: SQL Server 2008/2008 R2/2012/2014 *1
Oracle Corporation: Oracle Database 10g /11g/12c *1
MySQL Community Edition 5.1/5.5/5.6 *2
International Business Machines Corporation (IBM):
DB2 for Linux, UNIX and Windows 9.5/9.7/10.1/10.5
Firebird Foundation Incorporated: Firebird 2.1/2.5
The PostgreSQL Global Development Group: PostgreSQL 9.2/9.3/9.4 *1
Number of DB Connections (Number of databases that can
be connected at the same time)
3 connections max. *3
Instruction
1
Supported operations
The following operations can be performed by executing DB Connection Instructions in the NJ-series
CPU Units.
Inserting records (INSERT), Updating records (UPDATE), Retrieving records (SELECT), and
Deleting records (DELETE)
Number of columns in an INSERT
operation
SQL Server: 1,024 columns max.
Others: 1,000 columns max.
Number of columns in an UPDATE
operation
SQL Server: 1,024 columns max.
Others: 1,000 columns max.
Number of columns in a SELECT
operation
SQL Server: 1,024 columns max.
Others: 1,000 columns max.
Number of records in the output of a
SELECT operation
65,535 elements max., 4 MB max.
Run mode of the DB Connection Service
Operation Mode or Test Mode
• Operation Mode: When each instruction is executed, the service actually accesses the DB.
• Test Mode: When each instruction is executed, the service ends the instruction normally without
accessing the DB actually.
Spool function
Used to store SQL statements when an error occurred and resend the statements when the
communications are recovered from the error.
Spool capacity: 1 MB *2
Spool capacity
1 MB *4
192 KB *4
Operation Log function
The following three types of logs can be used.
• Execution Log: Log for tracing the executions of the DB Connection Service.
• Debug Log: Detailed log for SQL statement executions of the DB Connection Service.
• SQL Execution Failure Log: Log for execution failures of SQL statements due to a DB-caused
factor.
DB Connection Service shutdown function
Used to shut down the DB Connection Service after automatically saving the Operation Log files into
the SD Memory Card.
*1. SQL Server 2014, Oracle Database 12c and PostgreSQL 9.2/9.3/9.4 are supported by DBCon version 1.02 or higher.
*2. The supported storage engines of the DB are InnoDB and MyISAM.
*3. When two or more DB Connections are established, the operation cannot be guaranteed if you set different database types for the connections.
*4. Refer to "NJ-series Database Connection CPU Units User's Manual(W527)" for the information.
8
NJ501-1@20/NJ101-@@20
Unit Versions
Units
Models
NJ-series Database
Connection CPU
Units
Unit Version
NJ501-1@20
NJ101-@@20
DBCon Version
Unit version 1.11
Unit version 1.10
DBCon Ver.1.03
DBCon Ver.1.02
DBCon Ver.1.01
Unit version 1.09
Unit version 1.08
DBCon Ver.1.01
Unit version 1.07
Unit version 1.05
DBCon Ver.1.00
Unit version 1.10
DBCon Ver.1.02
Unit Versions, DBCon Versions and Programming Devices
The following table gives the relationship between unit versions of CPU Units and the corresponding Sysmac Studio versions.
Unit version of CPU Unit
DBCon Version
1.11
Corresponding version of Sysmac Studio
1.15
1.02
1.14
1.10 *
1.13
1.12
1.01
1.09
1.11
1.10
1.09
1.08
1.08
1.07
1.00
1.05
1.07
1.06
* For NJ101-@@20, Supported only by the Sysmac Studio version 1.14 or higher.
Functions That Were Added or Changed for Each Unit Version
and Sysmac Studio Version
For the common specifications of the NJ-series, refer to the Machine Automation Controller NJ/NX-Series Datasheet.
External Interface
For the External Interface, refer to the Machine Automation Controller NJ/NX-Series Datasheet.
Dimensions
For the Dimensions, refer to the Machine Automation Controller NJ/NX-Series Datasheet.
Related Manuals
The following manuals are related to the DB Connection Service. Use these manuals for reference.
Manual name
Cat. No.
Model numbers
Application
NJ-series Database Connection
CPU Units User's Manual
W527
NJ501-@@20
NJ101-@@20
Learning about the functions and
application procedures of the NJ-series
DB Connection Service.
Sysmac Studio Version 1
Operation Manual
W504
SYSMAC -SE2@@@
Learning about the operating procedures
and functions of the Sysmac Studio.
Description
Describes the functions and application
procedures of the NJ-series DB
Connection Service.
Describes the operating procedures of the
Sysmac Studio.
For the Related Manuals about the common specifications of the NJ-series, refer to the Machine Automation Controller NJ/NX-Series Datasheet.
9
Note: Do not use this document to operate the Unit.
OMRON Corporation
Industrial Automation Company
Tokyo, JAPAN
Authorized Distributor:
Contact: www.ia.omron.com
Regional Headquarters
OMRON EUROPE B.V.
Wegalaan 67-69-2132 JD Hoofddorp
The Netherlands
Tel: (31)2356-81-300/Fax: (31)2356-81-388
OMRON ELECTRONICS LLC
One Commerce Drive Schaumburg,
IL 60173-5302 U.S.A.
Tel: (1) 847-843-7900/Fax: (1) 847-843-7787
OMRON ASIA PACIFIC PTE. LTD.
No. 438A Alexandra Road # 05-05/08 (Lobby 2),
Alexandra Technopark,
Singapore 119967
Tel: (65) 6835-3011/Fax: (65) 6835-2711
OMRON (CHINA) CO., LTD.
Room 2211, Bank of China Tower,
200 Yin Cheng Zhong Road,
PuDong New Area, Shanghai, 200120, China
Tel: (86) 21-5037-2222/Fax: (86) 21-5037-2200
© OMRON Corporation 2014-2016 All Rights Reserved.
In the interest of product improvement,
specifications are subject to change without notice.
CSM_8_1_0316
Cat. No. P088-E1-04
0416(1214)