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.
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 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 |
|
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 | |
| 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 rating | 4 | |
Downloads
Distributors
Softing Industrial Automation GmbH
| 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