Omron, NJ-DB Series

Productivity improvement

Visualized quality and productivity

Operating status can be displayed in real time using familiar software such as microsoft® excel.

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.

New entry model NJ101 with database connection

The database connection model is available 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.

Supported database

✔ Microsoft SQL server
✔ Oracle Database
✔ IBM DB2
✔ MySQL
✔ PostgreSQL
✔ Firebird

Predictive Maintenance

Fast data collection

Data is sampled every millisecond and written to the database.
Machine behavior can be monitored more accurately.

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.

Reliable data transfer

Direct access and spooling enable the CPU unit to efficiently and reliably transfer all collected data to databases.

last update: June 26, 2017

Item		NJ501-[][][][]
Enclosure		Mounted in a panel
Grounding method		Ground to less than 100 O
Dimensions (heightdepthwidth)		90 mm * 90 mm * 90 mm
Weight		550 g (including the end cover)
Current consumption		5 VDC, 1.90 A (including SD memory card and end cover)
Power consumption		---
Operation environment	Ambient operating temperature	0 to 55℃
	Ambient operating humidity	10% to 90% (with no condensation)
	Atmosphere	Must be free from corrosive gases.
	Ambient storage temperature	-20 to 75℃ (excluding battery)
	Altitude	2,000 m or less
	Pollution degree	2 or less: Conforms to JIS B3502 and IEC 61131-2.
	Noise immunity	2 kV on power supply line (Conforms to IEC 61000-4-4.)
	Overvoltage category	Category II: Conforms to JIS B3502 and IEC 61131-2.
	EMC immunity level	Zone B
	Vibration resistance	Conforms to IEC 60068-2-6. 5 to 8.4 Hz with 3.5-mm amplitude, 8.4 to 150 Hz Acceleration of 9.8 m/s² for 100 min in X, Y, and Z directions (10 sweeps of 10 min each = 100 min total)
	Shock resistance	Conforms to IEC 60068-2-27. 147 m/s², 3 times in X, Y, and Z directions (100 m/s² for Relay Output Units)
Battery	Life	5 years at 25℃
Battery	Model	CJ1W-BAT01
Applicable standards		Conforms to cULus, NK, LR, EU directives, RCM and KC registration*.

* Supported only by the CPU Units with unit version 1.01 or later.

Performance specifications

Item				NJ501			NJ101
Item				[]5[]0	[]4[]0	[]3[]0	1[][]0	9[][]0
Processing time	Instruction execution times	LD instruction		1.1ns (1.7ns or less)			3.3ns (5.0ns or less)
Processing time	Instruction execution times	Math instructions (for Long Real Data)		24ns or more *1			70 ns or more
Program- ming	Program capacity *2	Size		20 MB (400 KS)			3 MB (60 KS)
		Number	POU definition	3,000			450
		Number	POU instance	Using Sysmac Studio Ver. 1.05 or lower: 6,000 Using Sysmac Studio Ver. 1.06 or higher: 9,000			1,800
	Variables capacity	No retain attribute *3	Size	4 MB			2 MB
		No retain attribute *3	Number	90,000			22,500
		Retain attribute *4	Size	2 MB			0.5 MB
		Retain attribute *4	Number	10,000			5,000
	Data type	Number		2,000			1,000
	Memory for CJ-Series units (Can be specified with AT specifications for variables.)	CIO area		6,144 words (CIO 0 to CIO 6143)
		Work area		512 words (W0 to W511)
		Holding area		1,536 words (H0 to H1535)
		DM area		32,768 words (D0 to D32767)
		EM area		32,768 words * 25 banks (E0_00000 to E18_32767) *5			32,768 words * 4 banks (E0_00000 to E3_32767) *5
Unit config- uration	Maximum number of connectable units	Maximum number of CJ/ NX unit per CPU rack or expansion rack		10 Units
		Maximum number of CJ unit on the system		40 Units
		Maximum number of NX unit on the system		4,096 (on NX series EtherCAT slave terminal)			400 (on NX series EtherCAT slave terminal)
	Maximum number of expansion racks			3 max.
	I/O Capacity	Maximum number of I/O Points on CJ-series units		2,560 points max.
	Power supply Unit for CPU rack and expansion racks	Model		NJ-P[]3001
		Power OFF detection time	AC power supply	30 to 45 ms
		Power OFF detection time	DC Power supply	22 to 25 ms
Motion control	Number of Controlled Axes	Maximum number of Controlled Axes		Maximum number of axes which can be defined. The number of controlled axes = The number of motion control axes + The number of singleaxis position control axes				--
		Maximum number of Controlled Axes		64 axes	32 axes	16 axes	6 axes
			Motion control axes	Maximum number of motion control axes which can be defined. All motion control function is available.
			Motion control axes	64 axes	32 axes	16 axes	6 axes
		Maximum number of used real axes		Maximum number of used real axes. The number of used real axes includes following servo axes and encoder axes.
		Maximum number of used real axes		64 axes	32 axes	16 axes	2 axes
			Used motion control servo axes	Maximum number of servo axes which all motion control function is available. The number of used motion control servo axes = The number of motion control axes whose axis type is set to servo axis and axis use is set to used axis.
			Used motion control servo axes	64 axes	32 axes	16 axes	2 axes
		Maximum number of axes for linear interpolation axis control		4 axes per axes group
		Number of axes for circular interpolation axis control		2 axes per axes group
	Maximum number of Axes Groups			32 groups
	Motion Control Period			The same control period as that is used for the process data communications cycle for EtherCAT.
	Cams	Number of Cam Data Points	Maximum Points per Cam Table	65,535 points				--
		Number of Cam Data Points	Maximum Points for All Cam Tables	1,048,560 points			262,140 points
		Maximum number of Cam Tables		640 tables			160 tables
	Position Units			Pulses, millimeters, micrometers, nanometers, degrees or inches
	Override Factors			0.00% or 0.01% to 500.00%
Peripheral USB port	Supported Services			Sysmac Studio connection
	Physical Layer			USB 2.0-compliant B-type connector
	Transmission Distance between Hub and Node			5 m max.
Built-in EtherNet/IP Port	number of port			1
	Physical Layer			10Base-T or 100Base-TX
	Frame length			1514 max.
	Media Access Method			CSMA/CD
	Modulation			Baseband
	Topology			Star
	Baud Rate			100 Mbps (100Base-TX)
	Transmission Media			STP (shielded, twisted-pair) cable of Ethernet category 5, 5e or higher
	Maximum Transmission Distance between Ethernet Switch and Node			100m
	Maximum number of cascade connections			There are no restrictions if Ethernet switch is used.
	CIP service: Tag Data Links (Cyclic Communi- cations)	Maximum number of connections		32
		*Packet interval 7**		1 to 10,000 ms in 1.0-ms increments *8 Can be set for each connection. (Data will be refreshed at the set interval, regardless of the number of nodes.)
		Permissible communications band		3,000 pps 9 10 (including heartbeat)
		Maximum number of Tag Sets		32
		Tag types		Network variables, cio, work, holding, dm, and em areas
		number of tags per connection (i.e., per tag set)		8 (7 tags if controller status is included in the tag set.)
		Maximum Link data size per Node (total size for all tags)		256
		Maximum number of tag		19,200 bytes
		Maximum data size per Connection		600 bytes
		Maximum number of registrable tag sets		32 (1 connection = 1 tag set)
		Maximum tag set size		600 bytes (Two bytes are used if Controller status is included in the tag set.)
		Multi-cast Packet Filter *11		Supported.
	Cip Message Service: Explicit Messages	Class 3 (number of connections)		32 (clients plus server)
		UCMM (non- connection type)	Maximum number of clients that can communicate at one time	32
		UCMM (non- connection type)	Maximum number of servers that can communicate at one time	32
	Maximum number of TCP socket service			30 *12			30
Built-in EtherCAT Port	ommunications standard			IEC 61158 Type12
	EtherCAT master specifications			Class B (Feature pack motion control compliant)
	Physical layer			100BASE-TX
	Modulation			Baseband
	Baud rate			100 Mbps (100Base-TX)
	Duplex mode			Auto
	Topology			Line, daisy chain, and branching
	Transmission media			Twisted-pair cable of category 5 or higher (double-shielded straight cable with aluminum tape and braiding)
	Maximum transmission distance between Nodes			100m
	Maximum number of slaves			192			64
	Range of node address			1-192
	Maximum Process data size			Inputs: 5,736 bytes Outputs: 5,736 bytes (However, the maximum number of process data frames is 4.)
	Maximum Process data size per Slave			Inputs: 1,434 bytes Outputs: 1,434 bytes
	communications Cycle			500/1,000/2,000/4,000 μs *13			1,000/2,000/4,000 μs
	Sync Jitter			1 μs max.
Internal Clock				At ambient temperature of 55℃ : -3.5 to +0.5 min error per month At ambient temperature of 25℃ : -1.5 to +1.5 min error per month At ambient temperature of 0℃ : -3 to +1 min error per month

1. When the hardware revision for the Unit is A.
2. This is the capacity for the execution objects and variable tables (including variable names).
3. Words for CJ-series Units in the Holding, DM, and EM areas are not included.
4. Words for CJ-series Units in the CIO and Work areas are not included.
5. When the Spool function of the NJ501-1[]20 is enabled, the DB Connection Service uses E9_0 to E18_32767(NJ501-1[]20).When the Spool function of the NJ101-[][]20 is enabled, the DB Connection Service uses E1_0 to E3_32767 (NJ101-[][]20).
6. This number of axes is achieved in a combination of a CPU Unit with unit version 1.06 or later and Sysmac Studio version 1.07 or higher.In other combinations, the maximum number of controlled axes is 8 axes (NJ301-1200) or 4 axes (NJ301-1100).
7. Data is updated on the line in the specified interval regardless of the number of nodes.
8. The Packet interval of the CPU Unit version 1.02 or earlier is 10 to 10,000 ms in 1.0-ms increments.
9. Means packets per second, i.e., the number of communications packets that can be sent or received in one second.
10.The Permissible communications Band of the CPU Unit version 1.02 or earlier is 1,000 pps.
11.An IGMP client is mounted for the EtherNet/IP port. If an ethernet switch that supports IGMP snooping is used,filtering of unnecessary multicast packets is performed.
12.The Maximum number of TCP socket service of the CPU Unit version 1.02 or earlier is 16.
13.The Maximum communications Cycle of the NJ301 CPU Unit version 1.02 or earlier is 1,000/2,000/4,000 μThe EtherCAT communications cycle of NJ501-4[][]0 for robot control is 1 ms or more.
Note: For robot control by NJ501-4[][]0, use the G5 series/1S series AC Servo Drive with built-in EtherCAT communications,absolute encoder, and brake.

Function Specifications

Item				NJ501-[][][][]	NJ101-[][][][]
Tasks	Function			I/O refreshing and the user program are executed in units that are called tasks. Tasks are used to specify execution conditions and execution priority.
		Periodically executed tasks	Maximum number of primary periodic tasks	1
		Periodically executed tasks	Maximum number of periodic tasks	3
		Conditionally executed tasks *1	Maximum number of event tasks	32
		Conditionally executed tasks *1	Execution conditions	When activate event task instruction is executed or when condition expression for variable is met.
	Setup	System Service Monitoring Settings		The execution interval and the percentage of the total user program execution time are monitored for the system services (processes that are executed by the CPU Unit separate from task execution).
Program- ming	POU (program organization units)	Programs		POUs that are assigned to tasks.
		Function blocks		POUs that are used to create objects with specific conditions.
		Functions		POUs that are used to create an object that determine unique outputs for the inputs, such as for data processing.
	Programming languages	Types		Ladder diagrams *2 and structured text (ST)
	*Namespaces 3**			A concept that is used to group identifiers for POU definitions.
	Variables	External access of variables	Network variables	The function which allows access from the HMI, host computers, or other Controllers
	Data types	Data types	Boolean	BOOL
			Bit strings	BYTE, WORD, DWORD, LWORD
			Integers	INT, SINT, DINT,LINT, UINT, USINT, UDINT, ULINT
			Real numbers	REAL, LREAL
			Durations	TIME
			Dates	DATE
			Times of day	TIME_OF_DAY
			Date and Time	DATE_AND_TIME
			Text strings	STRING
		Derivative data types		Structures, unions, enumerations
		Structures	Function	A derivative data type that groups together data with different variable types.
			Maximum number of members	2048
			Nesting maximum levels	8
			Member data types	Basic data types, structures, unions, enumerations, array variables
			Specifying Member Offsets	You can use member offsets to place structure members at any memory locations.*3
		Unions	Function	A derivative data type that groups together data with different variable types.
			Maximum number of Members	4
			Member Data Types	BOOL, BYTE, WORD, DWORD, LWORD
		Enumer- ations	Function	A derivative data type that uses text strings called enumerators to express variable values.
	Data Type Attributes	Array specifi- cations	Function	An array is a group of elements with the same data type. You specify the number (subscript) of the element from the first element to specify the element.
			Maximum number of Dimensions	3
			Maximum number of Elements	65535
			Array Specifications for FB Instances	Supported.
		Range Specifications		You can specify a range for a data type in advance. The data type can take only values that are in the specified range.
		Libraries		User libraries
Motion Control	Control Modes			position control, velocity control, torque control
	Axis Types			Servo axes, virtual servo axes, encoder axes, and virtual encoder axes
	Positions that can be managed			Command positions and actual positions
	Single-axis	Single-axis Position Control	Absolute Positioning	Positioning is performed for a target position that is specified with an absolute value.
			Relative Positioning	Positioning is performed for a specified travel distance from the command current position.
			Interrupt Feeding	Positioning is performed for a specified travel distance from the position where an interrupt input was received from an external input.
			Cyclic synchronous absolute positioning *1	The function which outputs command positions in every control period in the position control mode.
		Single-axis Velocity control	Velocity control	Velocity control is performed in Position control Mode.
		Single-axis Velocity control	Cyclic Synchronous Velocity Control	A velocity command is output each control period in velocity control mode.
		Single-axis torque control	Torque Control	The torque of the motor is controlled.
		Single-axis synchro- nized control	Starting cam operation	A cam motion is performed using the specified cam table.
			Ending cam operation	The cam motion for the axis that is specified with the input parameter is ended.
			Starting Gear operation	A gear motion with the specified gear ratio is performed between a master axis and slave axis.
			Positioning gear operation	A gear motion with the specified gear ratio and sync position is performed between a master axis and slave axis.
			Ending gear Operation	The specified gear motion or positioning gear motion is ended.
			Synchronous positioning	Positioning is performed in sync with a specified master axis.
			Master axis phase shift	The phase of a master axis in synchronized control is shifted.
			Combining axes	The command positions of two axes are added or subtracted and the result is output as the command position.
		Single-axis manual operation	Powering the servo	The servo in the servo drive is turned on to enable axis motion.
		Single-axis manual operation	Jogging	An axis is jogged at a specified target velocity.
		Auxiliary functions for single-axis control	Resetting axis errors	Axes errors are cleared.
			Homing	A motor is operated and the limit signals, home proximity signal, and home signal are used to define home.
			Homing with parameter *1	Specifying the parameter, a motor is operated and the limit signals, home proximity signal, and home signal are used to define home.
			High-speed Homing	Positioning is performed for an absolute target position of 0 to return to home.
			Stopping	An axis is decelerated to a stop at the specified rate.
			Immediately Stopping	An axis is stopped immediately.
			Setting override Factors	The target velocity of an axis can be changed.
			Changing the Current Position	The command current position or actual current position of an axis can be changed to any position.
			Enabling external Latches	The position of an axis is recorded when a trigger occurs.
			Disabling External Latches	The current latch is disabled.
			Zone monitoring	You can monitor the command position or actual position of an axis to see when it is within a specified range (zone).
			Enabling digital cam switches *4	You can turn a digital output ON and OFF according to the position of an axis.
			Monitoring Axis Following Error	You can monitor whether the difference between the command positions or actual positions of two specified axes exceeds a threshold value.
			Resetting the Following Error	The error between the command current position and actual current position is set to 0.
			Torque Limit	The torque control function of the Servo Drive can be enabled or disabled and the torque limits can be set to control the output torque.
			Command position compensation *5	The function which compensate the position for the axis in operation.
			*Start velocity 6**	You can set the initial velocity when axis motion starts.
	Axes Groups	Multi-axes coordinated control	Absolute linear interpolation	Linear interpolation is performed to a specified absolute position.
			Relative Linear interpolation	Linear interpolation is performed to a specified relative position.
			Circular 2D Interpolation	Circular interpolation is performed for two axes.
			Axes Group cyclic synchronous absolute positioning	A positioning command is output each control period in Position Control Mode.*3
		Auxiliary functions for multi-axes coordinated control	Resetting axes group errors	Axes group errors and axis errors are cleared.
			Enabling Axes Groups	Motion of an axes group is enabled.
			Disabling axes groups	Motion of an axes group is disabled.
			Stopping Axes Groups	All axes in interpolated motion are decelerated to a stop.
			Immediately stopping axes groups	All axes in interpolated motion are stopped immediately.
			Setting axes group override factors	The blended target velocity is changed during interpolated motion.
			Reading axes group positions	The command current positions and actual current positions of an axes group can be read.*3
			Changing the axes in an axes group	The Composition axes parameter in the axes group parameters can be overwritten temporarily.*3
	Common Items	Cams	Setting Cam Table Properties	The end point index of the cam table that is specified in the input parameter is changed.
			Saving Cam Tables	The cam table that is specified with the input parameter is saved in non-volatile memory in the CPU Unit.
			Generating cam tables *7	The cam table that is specified with the input parameter is generated from the cam property and cam node.
		Parameters	Writing MC Settings	Some of the axis parameters or axes group parameters are overwritten temporarily.
		Parameters	Changing axis parameters *7	You can access and change the axis parameters from the user program.
	Auxiliary Functions	Count Modes		You can select either Linear Mode (finite length) or Rotary Mode (infinite length).
		Unit Conversions		You can set the display unit for each axis according to the machine.
		Acceler- ation/ Deceleration Control	Automatic Acceleration/ Deceleration Control	Jerk is set for the acceleration/deceleration curve for an axis motion or axes group motion.
		Acceler- ation/ Deceleration Control	Changing the Acceleration and Deceleration Rates	You can change the acceleration or deceleration rate even during acceleration or deceleration.
		In-position Check		You can set an in-position range and in-position check time to confirm when positioning is completed.
		Stop Method		You can set the stop method to the immediate stop input signal or limit input signal.
		Re-execution of Motion Control Instructions		You can change the input variables for a motion control instruction during execution and execute the instruction again to change the target values during operation.
		Multi-execution of Motion Control Instructions (Buffer Mode)		You can specify when to start execution and how to connect the velocities between operations when another motion control instruction is executed during operation.
		Continuous Axes Group Motions (Transition Mode)		You can specify the Transition Mode for multi-execution of instructions for axes group operation.
		Monitoring Functions	Software Limits	Software limits are set for each axis.
Following Error			The error between the command current value and the actual current value is monitored for an axis.
Velocity, Acceleration Rate, Deceleration Rate, Torque, Interpolation Velocity, Interpolation Acceleration Rate, And Interpolation Deceleration Rate			You can set and monitor warning values for each axis and each axes group.
Absolute encoder support		You can use an OMRON G5-Series or 1S-Series Servomotor with an Absolute Encoder to eliminate the need to perform homing at startup.
*Input signal logic inversion 6**		You can inverse the logic of immediate stop input signal, positive limit input signal, negative limit input signal, or home proximity input signal.
External interface signals			The Servo Drive input signals listed on the right are used. Home signal, home proximity signal, positive limit signal, negative limit signal, immediate stop signal, and interrupt input signal
Unit (I/O) Manage- ment		EtherCAT Slaves	Maximum number of Slaves		192	64
		CJ-Series units	Maximum number of units		40
	Basic I/O units	CJ-Series units	Load Short- circuit Protection and I/O Disconnection Detection	Alarm information for Basic I/O units is read.
Communi- cations	Peripheral USB Port			A port for communications with various kinds of Support Software running on a personal computer.
	Built-in Ether- Net/IP port internal port	communications protocol		TCP/IP, UDP/IP
		CIP Communi- cations Service	Tag Data Links	Programless cyclic data exchange is performed with the devices on the EtherNet/IP network.
		CIP Communi- cations Service	Message communications	CIP commands are sent to or received from the devices on the EtherNet/IP network.
		TCP/IP functions	CIDR	The function which performs IP address allocations without using a class (class A to C) of IP address.
		TCP/IP functions	*IP Forwarding 5**	---
		TCP/IP applications	Socket services	Data is sent to and received from any node on Ethernet using the UDP or TCP protocol. Socket communications instructions are used.
			*FTP client 7**	File can be read from or written to computers at other Ethernet nodes from the CPU Unit. FTP client communications instructions are used.
			FTP server	Files can be read from or written to the SD Memory Card in the CPU Unit from computers at other Ethernet nodes.
			Automatic clock adjustment	Clock information is read from the NTP server at the specified time or at a specified interval after the power supply to the CPU Unit is turned ON. The internal clock time in the CPU Unit is updated with the read time.
			SNMP agent	Built-in EtherNet/IP port internal status information is provided to network management software that uses an SNMP manager.
	EtherCAT Port	Supported services	Process data communications	Control information is exchanged in cyclic communications between the EtherCAT master and slaves.
		Supported services	SDO communications	A communications method to exchange control information in noncyclic event communications between EtherCAT master and slaves. This communications method is defined by CoE.
		Network Scanning		Information is read from connected slave devices and the slave configuration is automatically generated.
		DC (Distributed Clock)		Time is synchronized by sharing the EtherCAT system time among all EtherCAT devices (including the master).
		*Packet monitoring 8**		The frames that are sent by the master and the frames that are received by the master can be saved. The data that is saved can be viewed with WireShark or other applications.
		Enable/disable Settings for Slaves		The slaves can be enabled or disabled as communications targets.
		Disconnecting/connecting Slaves		Temporarily disconnects a slave from the EtherCAT network for maintenance, such as for replacement of the slave, and then connects the slave again.
		Supported Application Protocol	CoE	SDO messages of the CAN application can be sent to slaves via EtherCAT.
	communications instructions			The following instructions are supported. CIP communications instructions, socket communications instructions, SDO message instructions, no-protocol communications instructions, protocol macro instructions, and FTP client instructions 7, and Modbus RTU protcol instructions 9
Operation manage- ment	RUN Output Contacts			The output on the Power supply Unit turns ON in RUN mode.
System manage- ment	Event Logs	Function		Events are recorded in the logs.
	Maximum number of events	System event log		1,024	512
		Access event log		1,024	512
		User-defined event log		1,024	512
Debugging	Online Editing	Single		Programs, function blocks, functions, and global variables can be changed online. Different operators can change different POUs across a network.
	Forced Refreshing			The user can force specific variables to TRUE or FALSE.
		Maximum number of forced variables	Device Variables for EtherCAT slaves	64
		Maximum number of forced variables	Device Variables for CJ-series units and variables with at specifications	64
	*MC Test Run 10**			Motor operation and wiring can be checked from the Sysmac Studio.
	Synchronizing			The project file in the Sysmac Studio and the data in the CPU Unit can be made the same when online.
	*Differentiation monitoring 1**			Rising/falling edge of contacts can be monitored.
		*Maximum number of contacts 1**		8
	Data Tracing	Types	Single Triggered Trace	When the trigger condition is met, the specified number of samples are taken and then tracing stops automatically.
		Types	Continuous Trace	Data tracing is executed continuously and the trace data is collected by the Sysmac Studio.
		Maximum number of simultaneous data trace		4 *11	2
		Maximum number of records		10,000
		Sampling	Maximum number of sampled variables	192 variables	48 variables
		Timing of sampling		Sampling is performed for the specified task period, at the specified time, or when a sampling instruction is executed.
		Triggered traces		Trigger conditions are set to record data before and after an event.
			Trigger conditions	When BOOL variable changes to TRUE or FALSE Comparison of non-BOOL variable with a constant Comparison Method: Equals (=), Greater than (>), Greater than or equals (=), Less Than (<), Less than or equals (=), Not equal (?)
			Delay	Trigger position setting: A slider is used to set the percentage of sampling before and after the trigger condition is met.
	Simulation			The operation of the CPU Unit is emulated in the sysmac studio.
Reliability functions	Self-diagnosis	Controller errors	Levels	Major fault, partial fault, minor fault, observation, and information
		User-defined errors		User-defined errors are registered in advance and then records are created by executing instructions.
			Levels	8 levels
Security	Protecting Software Assets and Preventing Operating Mistakes	CPU unit names and serial ids		When going online to a CPU Unit from the Sysmac Studio, the CPU Unit name in the project is compared to the name of the CPU Unit being connected to.
		Protection	User Program Transfer with No Restoration Information	You can prevent reading data in the CPU Unit from the Sysmac Studio.
			CPU unit write protection	You can prevent writing data to the CPU Unit from the sysmac studio or sd memory card.
			Overall Project file protection	You can use passwords to protect .smc files from unauthorized opening on the sysmac studio.
			Data protection	You can use passwords to protect POUs on the sysmac studio.*3
		Verification of operation authority		Online operations can be restricted by operation rights to prevent damage to equipment or injuries that may be caused by operating mistakes.
			Number of groups	5 *12	5
		Verification of user program execution ID		The user program cannot be executed without entering a user program execution ID from the Sysmac Studio for the specific hardware (CPU Unit).
SD memory card functions	Storage type			SD memory card, sdhc memory card
	Application	Automatic transfer from sd Memory Card *1		The data in the autoload folder on an SD memory card is automatically loaded when the power supply to the Controller is turned ON.
		Transfer program from SD Memory Card *9		The user program on an SD Memory Card is loaded when the user changes system-defined variable to TRUE.
		SD memory card operation Instructions		You can access SD memory cards from instructions in the user program.
		File Operations from the sysmac studio		You can perform file operations for controller files in the sd memory card and read/write standard document files on the computer.
		SD memory card life expiration detection		Notification of the expiration of the life of the SD memory card is provided in a systemdefined variable and event log.
Backup functions *1	SD memory card backup functions	Operation	Using front switch	You can use front switch to backup, compare, or restore data.
			Using system- defined variables	You can use system-defined variables to backup, compare, or restore data. *13
			Memory Card operations dialog box on sysmac studio	Backup and verification operations can be performed from the sd memory card operations dialog box on the sysmac studio.
			Using instruction *7	Backup operation can be performed by using instruction.
		Protection	Prohibiting backing up data to the sd memory card	Prohibit SD memory card backup functions.
	Sysmac studio controller backup functions			Backup, restore, and verification operations for units can be performed from the sysmac studio.

*1. Supported only by the CPU Units with unit version 1.03 or later.
*2. Inline ST is supported. (Inline ST is ST that is written as an element in a ladder diagram.)
*3. Supported only by the CPU Units with unit version 1.01 or later.
*4. Supported only by the CPU Units with unit version 1.06 or later.
*5. Supported only by the CPU Units with unit version 1.10 or later.
*6. Supported only by the CPU Units with unit version 1.05 or later.
*7. Supported only by the CPU Units with unit version 1.08 or later.
*8. For NJ301, Supported only by the CPU Units with unit version 1.10 or later.
*9. Supported only by the CPU Units with unit version 1.11 or later.
*10.Cannot be used with the NJ101-9000.
*11.Maximum number of Simultaneous Data Trace of the NJ501-1[]20 CPU Unit with unit version 1.08 or later is 2.
*12.When the NJ501 CPU Units with unit version 1.00 is used, this value becomes two.
*13. Restore is supported with unit version 1.14 or later.

Function Specifications of DB connection function

Besides functions of the NJ501-[][][][] or NJ101-[][][][], functions supported by the NJ501-[][]20 or NJ101-[]020 are as follows.

Item		Description
Item		NJ501-1[]20	NJ101-[]020
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	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. Oracle: 1,000 columns max.
	Number of columns in an UPDATE operation	SQL Server: 1,024 columns max. Oracle: 1,000 columns max.
	Number of columns in a SELECT operation	SQL Server: 1,024 columns max. Oracle: 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 *4	192 KB *4
Operation Log function		The following three types of logs can be recorded. ✔ 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 in the DB.
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.

Unit versions

Units	Models	Unit version
NJ-series Database Connection CPU Units	NJ501-[][]20	Unit version 1.05 From unit version 1.07 to 1.15
NJ-series Database Connection CPU Units	NJ101-[]020	From unit version 1.11 to 1.14

Unit versions, DBCon versions and Programming Devices (NJ-series Database Connection CPU Units)

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	Corresponding version of Sysmac Studio
1.15	1.02	1.19
1.14		1.18
1.13		1.17
1.12		1.16
1.11		1.15
1.10 *		1.14
1.10 *	1.01	1.13 1.12
1.09		1.11 1.10
1.08		1.09
1.07	1.00	1.08
1.05	1.00	1.07 1.06

Note:
If you use a lower version of the Sysmac Studio, you can use only the functions of the unit version of the CPU Unit that corresponds to the Sysmac Studio version.
If you use a CPU Unit with an earlier version, select the unit version of the connected CPU Unit or an earlier unit version in the Select Device area of the Project Properties Dialog Box on the Sysmac Studio. You can use only the functions that are supported by the unit version of the connected CPU Unit.
* 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

Additions and Changes to Functional Specifications

The following table gives the unit version of the CPU Units and the Sysmac Studio version for each addition or change to the functional specifications.

Function				Addition/ change	Unit version	Sysmac Studio version
Tasks	Function	Conditionally executed tasks		Addition	1.03	1.04
Programming	Namespaces			Addition	1.01	1.02
	Data types	Structure data types	Specifying member offsets	Addition	1.01	1.02
	Data types	Structure data types	Specifying member offsets	Change	1.01	1.03
	Libraries			Addition	1.01	1.02
Motion control	Single axes	Single-axis position control	Cyclic synchronous absolute positioning	Addition	1.03	1.04
		Auxiliary function for single-axis control	Homing with specified parameters	Addition	1.03	1.04
			Enabling digital cam switches	Addition	1.06	1.07
			Command position compensation	Addition	1.10	1.12
			Start velocity	Addition	1.05	1.06
	Axes groups	Multi-axes coordinated control	Axes group cyclic synchronous absolute positioning	Addition	1.01	1.02
		Auxiliary functions for multi-axes coordinated control	Reading axes group positions	Addition	1.01	1.02
		Auxiliary functions for multi-axes coordinated control	Changing the axes in a group	Addition	1.01	1.02
	Common items	Cams	Generating cam tables	Addition	1.08	1.09
	Common items	Parameters	Changing axis parameters	Addition	1.08	1.09
	Auxiliary functions	Input signal logic inversion		Addition	1.05	1.06
Unit (I/O) management	NX Units			Addition	1.05	1.06
communications	EtherNet/IP port	TCP/IP applications	FTP client	Addition	1.08	1.09
	EtherCAT port	Packet monitoring * (NJ301-[][][][]????)		Addition	1.10	1.12
	communications instructions			Change	1.08 1.11	1.09 1.15
Debugging function	Differential monitoring			Addition	1.03	1.04
Reliability functions	Self diagnosis	Controller errors	Changing levels	Addition	1.03	1.04
Security	Asset protection and preventing incorrect operation	Protection	Data protection	Addition	1.01	1.02
Security	Asset protection and preventing incorrect operation	Operation authority verification	Number of groups	Change	1.01	1.02
SD Memory Cards	Application	Automatic transfer from SD Memory Card		Addition	1.03	1.04
SD Memory Cards	Application	Transfer program from SD Memory Card		Addition	1.11	1.15
Backing up data	SD Memory Card backups	Operating methods	CPU Unit front-panel DIP switch	Addition	1.03	1.04
			Specification with system-defined variables	Addition	1.03	1.04
			SD Memory Card Window in sysmac studio	Addition	1.03	1.04
			Special instruction	Addition	1.08	1.09
		Protection	Disabling backups to SD memory cards	Addition	1.03	1.04
	Sysmac studio controller backups			Addition	1.03	1.04

* This addition applies only to an NJ301-[][][][] CPU Unit. The NJ501-[][][][] and NJ101-[][][][] CPU Units support packet monitoring with all versions.