eATM tManager ControlLogix

Connect ControlLogix PLC to SQL Databases and Cloud Applications

  • Upload Production Metrics from ControlLogix to Databases
  • Download Recipes from Databases to ControlLogix
  • Connect ControlLogix to databases like Microsoft SQL or Oracle
  • Connect ControlLogix to Cloud applications with MQTT protocol

tManager enables direct bi-directional data exchange between enterprise systems like Microsoft SQL databases and ControlLogix PLCs. tManager is a ControlLogix module inserted directly into the PLC chassis.  tManager eliminates a PC server, software application, or scripting sometimes used to orchestrate transactions between the PLC and SQL database. Using tManager to handle transactions instead of VB scripting or FactoryTalk Transaction Manager has the advantage of eliminating a server, eliminating software, increasing transaction speed, and decreasing project risk.

tManager allows downloading recipes and manufacturing instructions into the controller or uploading production tags for track and trace or monitoring in the database. Microsoft SQL databases are commonly used between MES applications and the production line.

Microsoft SQL and Oracle databases are supported.

Drivers are available to connect tManager in the ControlLogix rack via the front Ethernet port to additional Allen-Bradley PLCs, Siemens PLCs, Schneider PAC/PLCs, and Modbus PLCs.

tManager is part of the Rockwell Automation Encompass Product Partner program. As part of the Encompass Program, Softing designs ControlLogix in-chassis modules directly accessing backplane data and control tags. Also checkout eATM tManager for CompactLogix.

 

Overview

Faster Implementation

  • SQL transaction manager eliminates the transaction server/PC between ControlLogix and database server
  • "Configure & Go": No software coding or scripting for connecting ControlLogix to Microsoft SQL or Oracle databases
  • Automatic enumeration of PLC tags and database tables after insertion in ControlLogix rack and logging into database
  • Connectivity to Cloud using optional MQTT protocol

Easy to Operate and Maintain

  • Easily set-up and monitor your operation through extensive online help and unlimited installations of the configuration software
  • Data transfer and transactions are handled by tManager; no software or PC is required for transactions after initial set-up

Rock Solid Security

  • No anti-virus updates and on-going security patches required as needed for PC and software based connectivity solutions
  • Virus-resistant in-chassis module since PC is eliminated
  • It is only possible to edit configuration through the configuration software with assignable user privileges
  • IT approved: All SQL commands configured through menu selection.  SQL code is view only and not accessible.  There is no access to edit or create malicious SQL commands.

Robust Data Handling

  • Access to controller data using native backplane communication based on Rockwell Automation Encompass Product Partner program, resulting in increased transaction speed
  • No need to modify PLC logic for tag monitoring applications such as monitoring key performance indicators
  • Maximized data availability through optional use of store and forward (local buffering) and redundancy using failover server
  • Time-stamped data and logs saved of all transactions for audit
  • E-mail notifications for transaction status and system operation

Technical Details

Database Connectors
  • Microsoft SQL
  • Oracle
  • MySQL
  • AS/400 IBM DB2
Additional Connectors
  • MQTT (typically used for cloud connections)
  • Modbus (typically added to connect islands of PLCs to databases)
Communications Adapters
  • TCP/UDP  
  • FTP 
  • Bidirectional e-mail (SMTP outbound included with all adapters)

tManager Connects the ControlLogix PLC to:

  • ControlLogix backplane for access to PLC tags
  • Up to 16 controllers to connect islands of PLCs
  • ControlLogix bridge modules and then to Ethernet/IP, DH+, DH485, ControlNet to connect islands of PLCs
  • Via the tManager front Ethernet port to:
    • other ControlLogix PLCs
    • CompactLogix PLCs
    • PLC-5
    • SLC500
    • MicroLogix 1100, 1400, and 1500
    • Siemens S7-300
    • Siemens S7-400
    • Siemens S7-1200
    • Siemens S7-1500
    • Schneider Electric Quantum Modbus TCP/IP
    • other Modbus TCP/IP devices

Database Functions (via drop down menu)

  • Insert (used to insert a ControlLogix tag value into a new row in a database table, for example monitoring key performance indicators)
  • Update (used to read a ControlLogix tag and update an existing value in an existing row in a database table with that tag value)
  • Select (used to get data from a database table so it can be transfered to the ControlLogix PLC, for example download recipes)
  • Call stored procedures (database custom written programs)

Data Handling

  • Supports arrays, UDT, complex arrays, XML
  • 3GB onboard memory for store and forward if database connectivity is lost
  • Automatic database failover connectivity
  • Status tag for monitoring tManager health, store and forward state, successful transaction
  • Transaction logging, alarms/alerts, performance

System & Environmental

Two 10M/100M/1G Ethernet ports

ControlLogix single-slot module

Windows 7 Configuration Software

Temperature

Non-operating: 0°C to +80°C
Operating: 0°C to +60°C

Humidity

5 - 95% non-condensing

Vibration

2g @ 10 - 500Hz

Shock

Non-operating: 50g

Power Ratings

5 VDC

Power dissipation

7 W

Ratings

CE, RoHS

Downloads

Get access to our Downloads

You need a MySofting account to be able to access our Downloads. Register here or log in if you already have one.

    Videos