Omron NJ101-9020 Sysmac NJ1 CPU Module with Database Connection

Остался только 2 товар(ы) на складе

Производитель: Omron
Номер продукта: NJ101-9020
Страна происхождения:Япония
Тип продукта: PLC CPU Modules
Оплата: Т/Т, Western Union
Вес: 2000г
Размеры: 90 mm x 90 mm x 90 mm
Порт отгрузки: Сямынь
Гарантия: 12 месяцев

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.

Глобальная экспресс-доставка

Стандартная доставка: 4-6 рабочих дней через DHL, FedEx и UPS.
Экспресс-отправка: Отправка в тот же день для заказов со склада, сделанных до 14:00 (GMT+8).
Мировое покрытие: Обслуживаем более 150 стран, включая быструю доставку в Саудовскую Аравию и ОАЭ.

Возвраты и гарантия

30-дневная гарантия: Принимаются возвраты товаров со склада в оригинальной, заводской запечатанной упаковке.
12-месячная гарантия: Каждый промышленный компонент поддерживается нашей профессиональной технической гарантией.

Заказы обрабатываются и доставляются с понедельника по пятницу (кроме государственных праздников).

Для полной информации о праве на возврат, сборах за пополнение запасов и международных возвратах, пожалуйста, ознакомьтесь с нашим официальным Политика возврата и возврата средств .

TECHNICAL SPECIFICATIONS

Country of origin

Недавно просмотренные товары

Технические знания

Advanced Boolean Logic with FBD PLC Programming: Practical Industrial Applications Beyond Basic Logic

Продвинутая булева логика в программировании ПЛК с использованием FBD: практические промышленные применения за пределами базовой логики

В статье объясняются несколько продвинутых функций булевой логики, используемых в программировании ПЛК, помимо базовых операций AND, OR и NOT. Рассматривается, как такие инструменты, как таблицы...

19 июнь 2026 г.

Omron NJ101-9020 Sysmac NJ1 CPU Module with Database Connection