Omron NJ101-9020 Sysmac NJ1 CPU Module with Database Connection

Apenas 2 item(ns) restante(s) em estoque

Fabricante: Omron
Nº do Produto: NJ101-9020
País de origem:Japão
Tipo de Produto: PLC CPU Modules
Pagamento: T/T, Western Union
Peso: 2000g
Dimensões: 90 mm x 90 mm x 90 mm
Porto de embarque: Xiamen
Garantia: 12 meses

Description

Designed for direct transactional synchronization between machine-level automation and enterprise SQL databases, the Omron NJ101-9020 functions as a high-performance central processing unit within the Sysmac NJ platform. This controller eliminates the need for intermediate PC-based middleware or gateway computers by hosting an integrated SQL client. It enables real-time data logging, quality tracking, and recipe retrieval directly from the CPU to database servers over standard Ethernet. Built on a unified Sysmac architecture, the unit combines sequence control, motion configuration, and IT connectivity into a single, cohesive processing core.

Features

Direct SQL Integration: Built-in instructions support direct connection to Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and Firebird.
Unified Control Platform: Execution of logic control, motion setup, and IT networking tasks within a single execution cycle.
Spooling Functionality: Automatically buffers SQL transactions to an industrial SD card in the event of an IT network failure, preventing data loss.
Secure Industrial Communications: Features isolated Ethernet ports for separate machine-level control (EtherCAT) and factory-level networking (EtherNet/IP).
Robust I/O Scalability: Supports expansion through the local CJ-series I/O bus and remote EtherCAT junctions.

Applications

Traceability and Serialization: Real-time storage of assembly metrics, barcode scans, and test results in pharmaceutical or automotive plants.
Recipe Management Systems: On-demand retrieval of product parameters and batch configurations directly from server-side ERP/MES databases.
Predictive Maintenance: Continuous logging of high-frequency machine variables, run-hours, and vibration profiles to central analytics databases.
Automated Warehousing: Direct communication with Warehouse Management Systems (WMS) for pallet routing and sorter control.

Technical Specifications

Manufacturer	Omron
Model Number	NJ101-9020
Series	Sysmac NJ1
Primary Task Cycle Time	1.0 ms
Variables Memory Capacity	0.5 MB
Program Capacity	5 MB
Supported Databases	Microsoft SQL Server, Oracle, MySQL, PostgreSQL, Firebird
Built-in Communication Ports	1x EtherCAT Master, 1x EtherNet/IP, 1x USB 2.0 (Type-B)
Max. EtherCAT Remote Nodes	64
Local Expansion Bus	CJ-series I/O Bus
Max. Local Expansion Units	40 (requires CJ-series Expansion Racks)
Operating Temperature	0 to 55 degC
Dimensions (H x W x D)	90 mm x 90 mm x 90 mm
Net Weight	550 g
Shipping Weight (Calculated)	2.0 kg

Connections and Interfaces

Port / Terminal	Interface Type & Purpose
EtherNet/IP Port	RJ45. Used for database connections, Sysmac Studio programming, tag data links, and generic TCP/IP messaging.
EtherCAT Port	RJ45. Dedicated master port for high-speed synchronous I/O, servo drives, and vision sensors.
USB Port	USB 2.0 Type-B. Direct local interface for system configuration, firmware updates, and offline diagnostics.
SD Card Slot	Supports SD/SDHC cards for database spooling buffer, database log storage, and user program backups.

Empirical Engineering Insights

Alternative Models & Compatibility

The NJ101-9020 is a specialized database variant. It differs from the standard NJ101-9000 by including built-in SQL middleware client structures. When replacing a standard NJ101 series processor, ensure that Sysmac Studio has the appropriate database connection license activated to compile the database function blocks (_DB_Insert, _DB_Select, etc.).

Application Pitfalls & Engineering Notes

When utilizing direct-to-database connections, you must install an industrial-grade SD memory card (such as Omron HMC-SD291) to serve as a spooling buffer. Standard commercial SD cards cannot handle the rapid write cycles required during network-offline spooling and will fail prematurely, leading to Event Code 0x14600000 (Spool Memory Overrun). Additionally, ensure that the current draw on the local CJ-series bus does not exceed the capacity of the power supply unit (e.g., NJ-PA3001).

Commissioning & Wiring Tips

Keep the EtherCAT and EtherNet/IP networks logically and physically isolated. Bridging them can lead to network jitter on the EtherCAT cycle, triggering synchronization faults. In Sysmac Studio, always pre-verify the database server credentials and port assignments using the built-in Connection Test Tool before executing program-level connect commands.

Installation Guidelines

CRITICAL WARNING

Isolate all electrical power sources from the control panel before mounting the CPU to the DIN rail or attaching CJ-series expansion modules. Touching active connections or live backplane terminals can result in severe shock or logic board destruction via electrostatic discharge.

Mount the CPU onto the DIN rail, ensuring the unit is securely locked in place with the bottom yellow slide locks engaged.

Connect the functional ground terminal of the adjacent power supply module to a dedicated class-D ground point (100 Ohm maximum ground impedance).

Ensure the power supply modules, CPU, and CJ end plate are locked tight using the integrated slider connectors on each unit.

Connect double-shielded Category 5e (or higher) STP cables to the EtherCAT master port and route them away from high-voltage motor cables.

Key Features:

#PLC CPU Modules #Sysmac NJ

Can the NJ101-9020 write data directly to an SQL database without a computer?

Yes. The NJ101-9020 has a built-in SQL client instruction set that establishes a direct connection to SQL databases like MS SQL, Oracle, and MySQL via the EtherNet/IP port, bypassing any PC middleware.

What happens to the database logs if the factory network drops out?

The module uses an internal spooling mechanism that automatically writes transactional SQL commands to an installed SD memory card. When the network connection is restored, the spooled data is queued and updated in the database.

Can I use standard CJ-series I/O modules with this CPU?

Yes. The NJ101-9020 includes a CJ I/O Bus port on its side, permitting direct backplane mounting of up to 40 CJ-series expansion units.

What software is required to program this CPU?

You must use Sysmac Studio Standard Edition. The database integration settings are configured under the Database Connection CPU Unit Settings section of the software.

Envio Expresso Global

Entrega Padrão: 4-6 dias úteis via DHL, FedEx e UPS.
Despacho Expresso: Envio no mesmo dia para pedidos em estoque realizados antes das 14:00 (GMT+8).
Cobertura Mundial: Atendendo mais de 150 países, incluindo entrega rápida para Arábia Saudita e Emirados Árabes Unidos.

Devoluções e Garantia

Garantia de 30 Dias: Devoluções aceitas para produtos em estoque na embalagem original, lacrada de fábrica.
Garantia de 12 Meses: Cada componente industrial é coberto pela nossa garantia técnica profissional.

Os pedidos são processados e entregues de segunda a sexta-feira (exceto feriados).

Para elegibilidade completa, taxas de reabastecimento e detalhes de devolução internacional, por favor, consulte nosso oficial Política de Reembolso e Devolução .

TECHNICAL SPECIFICATIONS

Country of origin

Omron NJ101-9020 Sysmac NJ1 CPU Module with Database Connection