eATM tManager CompactLogix

Connect CompactLogix PLC to SQL Databases

eATM tManager CompactLogix| Softing
  • 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.

 

Encompass Product Manager| Softing

Overview

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 enumaration 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
Communications Adapters
  • TCP/UDP  
  • FTP 
  • Bidirectional e-mail (SMTP outbound included with all adapters)

 

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.idi@softing.com
    order.idi@softing.com
    https://data-intelligence.softing.com    		   

    Videos