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 Manager 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.

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.


Simplified Implementation

  • SQL transaction manager eliminates the need for PC between CompactLogix and enterprise SQL database
  • "Configure & Go": No software coding or scripting required for connecting CompactLogix to databases
  • Automatic enumeration of PLC and database tags and structures after insertion in CompactLogix rack

Easy to Operate and Maintain

  • Easy set-up and monitor of operation through extensive online help and unlimited installations of configuration software on multiple computers
  • Handling of all data transfer and transactions by eATM tManager hardware itself without connecting configuration software after 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
  • Only possible module access through the configuration software with adjustable user privileges
  • All SQL coding handled through menu selection, not providing means to edit malicious SQL commands

Robust Data Handling

  • Access to controller data using separate front port Ethernet connection
  • No need to modify PLC logic
  • 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

Computer Adapters

Database Adapters
  • Microsoft SQL   
  • Oracle


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


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


5 - 95% non-condensing


2g @ 10 - 500Hz


Non-operating: 50g

Power Ratings

5 VDC, 313mA; 24VDC, 185mA

Power dissipation

7 W

Distance rating4


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.


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


    +49 (89) 456 56-113
    +49 (89) 456 56-606