Omron SYSMAC NJ Series User manual

Machine Automation Controller
NJ/NX-series
Database Connection CPU Unit
CPU Unit
User’s Manual
W527-E1-16
NX701-20
NX102-20
NJ501-20
NJ101-20

1. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in
any form, or by any means, mechanical, electronic, photocopying, recording, or otherwise, without the prior
written permission of OMRON.
2. No patent liability is assumed with respect to the use of the information contained herein.
Moreover, because OMRON is constantly striving to improve its high-quality products, the information contained
in this manual is subject to change without notice.
3. Every precaution has been taken in the preparation of this manual. Nevertheless, OMRON assumes no responsi-
bility for errors or omissions.
Neither is any liability assumed for damages resulting from the use of the information contained in this publication.
• Sysmac and SYSMAC are trademarks or registered trademarks of OMRON Corporation in Japan and other
countries for OMRON factory automation products.
• Microsoft, Windows, Excel, and Visual Basic are either registered trademarks or trademarks of Microsoft Corpora-
tion in the United States and other countries.
• EtherCAT®is registered trademark and patented technology, licensed by Beckhoff Automation GmbH, Germany.
• ODVA, CIP, CompoNet, DeviceNet, and EtherNet/IP are trademarks of ODVA.
• The SD and SDHC logos are trademarks of SD-3C, LLC.
Other company names and product names in this document are the trademarks or registered trademarks of their
respective companies.
Trademarks
Copyrights
NOTE
• Microsoft product screen shots used with permission from Microsoft.
• This product incorporates certain third party software. The license and copyright information associated with this
software is available at http://www.fa.omron.co.jp/nj_info_e/.

Introduction
Thank you for purchasing an NJ/NX-series CPU Unit.
This manual contains information that is necessary to use the Database Connection Service with the
NJ/NX-series CPU Unit. (Database may be referred to as DB hereinafter.) Please read this manual
and make sure you understand the functionality and performance of the NJ/NX-series CPU Unit be-
fore you attempt to use it in a control system.
Keep this manual in a safe place where it will be available for reference during operation.
Intended Audience
This manual is intended for the following personnel,
who must also have knowledge of electrical systems (an electrical engineer or the equivalent).
• Personnel in charge of introducing FA systems.
• Personnel in charge of designing FA systems.
• Personnel in charge of installing and maintaining FA systems.
• Personnel in charge of managing FA systems and facilities.
For programming, this manual is intended for personnel who understand the programming language
specifications in international standard IEC 61131-3 or Japanese standard JIS B 3503.
Applicable Products
This manual covers the following products.
• NX-series Database Connection CPU Units
a) NX701-1720
b) NX701-1620
c) NX102-1220
d) NX102-1120
e) NX102-1020
f) NX102-9020
• NJ-series Database Connection CPU Units
a) NJ501-1520
b) NJ501-1420
c) NJ501-1320
d) NJ501-R520
e) NJ501-R420
f) NJ501-R320
g) NJ501-4320
h) NJ101-1020
i) NJ101-9020
• Sysmac Studio
a) SYSMAC-SE2£££
NX701-££20: Version 1.21 or higher
NX102-££20: Version 1.24 or higher
NJ501-1£20, NJ501-4£20, or NJ101-££20: Version 1.14 or higher
NJ501-R£20: Version 1.44 or higher
Introduction
1
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Relevant Manuals
The following table provides the relevant manuals for the NJ-series CPU Units. Read all of the man-
uals that are relevant to your system configuration and application before you use the NJ-series CPU
Unit.
Most operations are performed from Sysmac Studio Automation Software. Refer to the Sysmac Studio
Version 1 Operation Manual (Cat. No. W504) for information on Sysmac Studio.
Manual
Basic information
Purpose of use
NX-series CPU Unit Hardware User’s Manual NX-series NX102 CPU Unit Hardware User’s Manual NJ-series CPU Unit Hardware User’s Manual NJ/NX-series CPU Unit Software User’s Manual NJ/NX-series Instructions Reference Manual NJ/NX-series CPU Unit Motion Control User’s Manual NJ/NX-series Motion Control Instructions Reference Manual NJ/NX-series CPU Unit Built-in EtherCAT Port User’s Manual
NJ/NX-series CPU Unit Built-in EtherNet/IP Port User’s Manual NX-series CPU Unit FINS Functions User’s Manual NJ/NX-series Database Connection CPU Units User’s Manual NJ-series Robot Integrated CPU Unit User’s Manual NJ/NX-series CPU Unit Troubleshooting Manual
Introduction to NX701 CPU Units ¡
Introduction to NX102 CPU Units ¡
Introduction to NJ-series Controllers ¡
Setting devices and hardware
¡ ¡ ¡
Using motion control ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
Using the database connection service ¡
Software settings
¡
Using motion control ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
Using FINS ¡
Using the database connection service ¡
Using robot control for OMRON robots ¡
Writing the user program
¡ ¡
Using motion control ¡ ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
Using FINS ¡
Using the database connection service ¡
Using robot control for OMRON robots ¡
Programming error processing ¡
Relevant Manuals
2NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Manual
Basic information
Purpose of use
NX-series CPU Unit Hardware User’s Manual NX-series NX102 CPU Unit Hardware User’s Manual NJ-series CPU Unit Hardware User’s Manual NJ/NX-series CPU Unit Software User’s Manual NJ/NX-series Instructions Reference Manual NJ/NX-series CPU Unit Motion Control User’s Manual NJ/NX-series Motion Control Instructions Reference Manual NJ/NX-series CPU Unit Built-in EtherCAT Port User’s Manual NJ/NX-series CPU Unit Built-in EtherNet/IP Port User’s Manual NX-series CPU Unit FINS Functions User’s Manual NJ/NX-series Database Connection CPU Units User’s Manual NJ-series Robot Integrated CPU Unit User’s Manual NJ/NX-series CPU Unit Troubleshooting Manual
Testing operation and debugging
¡
Using motion control ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
Using FINS ¡
Using the database connection service ¡
Using robot control for OMRON robots ¡
Learning about error management and correc-
tions*1 rrr¡
Maintenance
¡ ¡ ¡
Using motion control ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
*1. Refer to the NJ/NX-series Troubleshooting Manual(Cat. No. W503) for the error management concepts and an overview of the error
items. However, refer to the manuals that are indicated with triangles (r) for details on errors corresponding to the products with the
manuals that are indicated with triangles (r).
Relevant Manuals
3
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Manual Structure
Page Structure
The following page structure is used in this manual.
4-9
4 Installation and Wiring
NJ-series CPU Unit Hardware User’s Manual (W500)
s
t
i
n
U
gnitn
u
oM
3-4
4
s
t
ne
no
p
m
o
C
rel
l
o
r
t
n
oC
g
n
i
tc
e
n
noC
1
-
3-
4
4-3 Mounting Units
The Units that make up an NJ-series Controller can be connected simply by pressing the Units together
and locking the sliders by moving them toward the back of the Units. The End Cover is connected in the
same way to the Unit on the far right side of the Controller.
1Join the Units so that the connectors fit exactly.
2The yellow sliders at the top and bottom of each Unit lock the Units together. Move the sliders
toward the back of the Units as shown below until they click into place.
Precautions for Correct UsePrecautions for Correct Use
4-3-1 Connecting Controller Components
Connector
Hook Hook holes
Slider
Lock
Release
Move the sliders toward the back
until they lock into place.
Level 1 heading
Level 2 heading
Level 3 heading
Level 2 heading
A step in a procedure
Manual name
Special information
Level 3 heading
Page tab
Gives the current
headings.
Indicates a procedure.
Icons indicate
precautions, additional
information, or reference
information.
Gives the number
of the main section.
This illustration is provided only as a sample. It may not literally appear in this manual.
The sliders on the tops and bottoms of the Power Supply Unit, CPU Unit, I/O Units, Special I/O
Units, and CPU Bus Units must be completely locked (until they click into place) after connecting
the adjacent Unit connectors.
Special Information
Special information in this manual is classified as follows:
Precautions for Safe Use
Precautions on what to do and what not to do to ensure safe usage of the product.
Precautions for Correct Use
Precautions on what to do and what not to do to ensure proper operation and performance.
Additional Information
Additional information to read as required.
Manual Structure
4NJ/NX-series Database Connection CPU Units User’s Manual (W527)

This information is provided to increase understanding or make operation easier.
Version Information
Information on differences in specifications and functionality for Controller with different unit versions
and for different versions of the Sysmac Studio is given.
Precaution on Terminology
In this manual, "download" refers to transferring data from Sysmac Studio to the physical Controller
and "upload" refers to transferring data from the physical Controller to Sysmac Studio.
For Sysmac Studio, "synchronization" is used to both "upload" and "download" data. Here,
"synchronize" means to automatically compare the data for Sysmac Studio on the computer with the
data in the physical Controller and transfer the data in the direction that is specified by the user.
Manual Structure
5
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Manual Structure
6NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Sections in this Manual
Sections in this Manual
7
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
1 I
2
3
4
5
6
7
8
A
1 I
6
2
3
4
7
8
A
Introduction to the DB
Connection Service
Index
DB Connection settings
Basic Operations and Status Check
Programming the DB Connection Function
Other Functions
How to Use Operation Logs
DB Connection Instruction
Troubleshooting
Appendix
5

CONTENTS
Introduction .............................................................................................................. 1
Intended Audience...........................................................................................................................................1
Applicable Products .........................................................................................................................................1
Relevant Manuals..................................................................................................... 2
Manual Structure...................................................................................................... 4
Page Structure.................................................................................................................................................4
Special Information ..........................................................................................................................................4
Precaution on Terminology ..............................................................................................................................5
Sections in this Manual ........................................................................................... 7
Terms and Conditions Agreement........................................................................ 14
Warranty, Limitations of Liability ....................................................................................................................14
Application Considerations ............................................................................................................................15
Disclaimers ....................................................................................................................................................15
Safety Precautions................................................................................................. 17
Precautions for Safe Use ...................................................................................... 18
Precautions for Correct Use ................................................................................. 19
Regulations and Standards .................................................................................. 20
Versions .................................................................................................................. 21
Version Types ................................................................................................................................................21
Checking Versions .........................................................................................................................................21
Unit Versions of CPU Units and Sysmac Studio Versions .............................................................................23
Related Manuals..................................................................................................... 24
Terminology............................................................................................................ 26
Revision History..................................................................................................... 28
Section 1 Introduction to the DB Connection Service
1-1 Overview and Features..........................................................................................................1-2
1-1-1 Overview .....................................................................................................................................1-2
1-1-2 Features ......................................................................................................................................1-3
1-2 DB Connection Service Specifications and System...........................................................1-5
1-2-1 DB Connection Service Specifications........................................................................................1-5
1-2-2 DB Connection System .............................................................................................................1-11
1-3 Operation Flow of the DB Connection Service .................................................................1-14
Section 2 DB Connection Settings
2-1 Starting Sysmac Studio and Creating a New Project .........................................................2-2
CONTENTS
8NJ/NX-series Database Connection CPU Units User’s Manual (W527)