eATM tManager CompactLogix

Connect CompactLogix PLC to SQL Databases

  • Upload Production Metrics from CompactLogix to Databases
  • Download Recipes from Databases to CompactLogix
  • Connect CompactLogix to databases like Microsoft SQL or Oracle

eATM tManager enables direct bi-directional data exchange between enterprise systems like Microsoft SQL databases and CompactLogix PLCs. eATM tManager is a hardware solution directly integrated in the PLC and thus is better suited for data exchange than using PC-based software applications. Deploying eATM tManager over systems based on VB scripts or FactoryTalk Transaction, tManager has the advantage of eliminating the need for another hardware platform between the controller and the SQL database server.

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

Increasingly, manufacturing facilities are looking to connect PLCs directly to cloud applications such as AWS, Azure, Google, or IBM.  Connection from plant floor to cloud can be done securely with tManager because it has two Ethernet ports, which are electrically isolated, and supports two IP addresses.

tManager for CompactLogix is compatible with the 1769 CompactLogix and 5380 CompactLogix (5069).

Drivers are available to connect eATM tManager in the CompactLogix rack via the front Ethernet port to additional Allen-Bradley PLCs and  Siemens PLCs.

eATM tManager has been developed making use of the Rockwell Automation Encompass Product Partner program. It enables Softing to design CompactLogix in-chassis modules directly accessing control tags. The databases Microsoft SQL and Oracle are supported.


Also checkout eATM tManager for ControlLogix.

Overview

Simplified Implementation

  • Eliminates the PC in the middle.  tManager eliminates the PC between CompactLogix and your enterprise SQL database
  • No OPC protocol translation.  tManager understands SQL databases and makes direct databases calls.
  • No software coding or scripting required for connecting CompactLogix to databases.  All database commands are handled via drop down menu options.
  • No tag limit.  Automatic enumeration of PLC and database tags and structures after insertion in CompactLogix rack.

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

  • 2 front Ethernet ports.  Separate IP addresses.
  • No need to modify PLC logic for monitoring key performance indicators
  • Maximized data availability through optional use of store and forward (local buffering)
  • Time-stamped data and saving of all transactions for audit
  • E-mail notifications for following transactions and system operation

 

Technical Details

 

Database Adapters
  • Microsoft SQL   
  • Oracle
Cloud and PLC Connectors
  • MQTT for connection to AWS, Azure, Google, or IBM cloud applications
  • Modbus (typically added to connect islands of PLCs to databases)

tManager Connects CompactLogix to:

  • Up to 2 more CompactLogix controllers in addition to the chassis where tManager is inserted
  • 1 Siemens PLC such as
    • Siemens S7-300
    • Siemens S7-400
    • Siemens S7-1200
    • Siemens S7-1500

 

Database Functions

  • Insert, Update, Select
  • Call database custom written programs
  • Supports arrays, UDT, complex arrays, XML
  • 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

CompactLogix double-wide module

Windows 10 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, 313mA; 24VDC, 185mA

Power dissipation

7 W

Distance rating4

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.

    Distributors

    Softing Industrial Automation GmbH
    Richard-Reitzner-Allee 6
    85540 Haar
    Germany

     

    Phone:
    Fax:
    Contact:
    Orders:
    Web:
    +49 (89) 456 56-113
    +49 (89) 456 56-606
    info.automation@softing.com
    order.sia@softing.com
    https://data-intelligence.softing.com
       

    Videos