• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Equipment Dealer Lauds Attunity for Speedy DB2/400 Replication

    December 1, 2009 Alex Woodie

    Atlantic Detroit Diesel Allison (Atlantic DDA), a distributor of heavy equipment in the Northeast, has benefited from the use of Attunity data collection and replication software, which captures changes made to a DB2/400 database and forwards them to an Oracle-based system. According to the customer, revenues in the service department have doubled as the result of the improvements in application response times.

    From its headquarters outside of New York City, Atlantic DDA sells and services a full line of Detroit Diesel, Mercedes-Benz, and MTU engines, as well as Allison transmissions. The company operates eight locations, employs more than 200 technicians, and maintains more than $15 million in replacement parts and inventory as it services trucks, busses, tractors, and generators in the NYC metro region.

    While the company knows how to keep heavy equipment running smoothly, it wasn’t entirely happy with how its customer service applications were running. Specifically, the company did not feel that it was providing information to customers fast enough. This included work-completion estimates and passing information over the Web.

    Atlantic DDA needed to change how the information flowed in its service department. The company didn’t want to rip and replace whole applications, including its core System i-based customer service app and an Oracle-based Service Repair Order System developed and installed by Fadel Partners. Instead, it needed a way to streamline how the information flowed between the i5/OS customer service system and the Oracle repair order system, and that meant faster DB2/400 access.

    According to Attunity, Atlantic DDA looked at a variety of solutions, but eventually settled on its Operation Data Replication (ODR) offering, which offers change data capture (CDC) functionality for DB2/400.

    Attunity says its ODR is unique because it employs log-based CDC capabilities that monitor the DB2/400 database journals and captures only the changes made to the required tables. By using CDC technology and offloading the changes as soon as they are captured, the vendor says, it’s able to minimize the impact to DB2/400, while still providing real-time data feeds from DB2/400 into Atlantic DDA’s Oracle-based repair order system and the Web.

    Attunity’s DB2/400 capabilities exceeded the expectations of Atlantic DDA IT director Will Ortiz. “During the proof of concept process, we were very impressed with the Attunity ODR solution’s ‘stress test’ results, which included throughput measurements handling thousands of tables and over a terabyte of data with ease,” Ortiz says in a press release. “This level of performance combined with the expert advice and service we received from Attunity throughout the three-month trial process exceeded our expectations.”

    After installing the Attunity ODR solution in the heavy equipment service department, Atlantic DDA’s order processing times decreased from about 20 minutes to about three minutes, and its revenues doubled, Ortiz says. The company is now looking to introduce Attunity’s software to the parts, generator, and marine departments.

    RELATED STORIES

    Attunity Delivers New Data Replication Agent for DB2/400

    Music Company Picks Attunity to Help Connect Bricks with Clicks

    Attunity Web Services Gateway Extends ‘Legacy’ OS/400 Apps



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Maxava

    Migrate IBM i with Confidence

    Tired of costly and risky migrations? Maxava Migrate Live minimizes disruption with seamless transitions. Upgrading to Power10 or cloud hosted system, Maxava has you covered!

    Learn More

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Profound Logic Software:  FREE OnDemand Webinar. Learn how to easily build and extend i apps
    LANSA:  Take your apps to a new dimension with RAMP. FREE Webinar!
    Manta Technologies:  Your complete source for IBM i training

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    AMD Taps IBM Chiphead for Board of Directors Retrieving and Storing SQL Source for DB2 Database Objects

    Leave a Reply Cancel reply

Volume 9, Number 43 -- December 1, 2009
THIS ISSUE SPONSORED BY:

Help/Systems
Bytware StandGuard Security
Vision Solutions
ARCAD Software
East Coast Computer

Table of Contents

  • Simply Continuous Aims to Narrow ‘Recovery Gap’ with DR Solution
  • ManageEngine Adds i OS Support to Application Performance Tool
  • User Activity Monitoring from PacketMotion to Support i OS
  • Single-Platform, Technology-Focused Security Unwise Says Ex-IBMer Botz
  • NGS Adds PDF and Excel Report Generation to BI Suite
  • TMW to Give EGL a Chance for i OS App Modernization
  • System i Hosting Firm Taps CCSS for Systems Management
  • Steel and Lace: Lawson Upgrades M3 for Equipment and Fashion Industries
  • Equipment Dealer Lauds Attunity for Speedy DB2/400 Replication
  • First Option Goes SaaS with iSeries Watchdog

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • POWERUp 2025 –Your Source For IBM i 7.6 Information
  • Maxava Consulting Services Does More Than HA/DR Project Management – A Lot More
  • Guru: Creating An SQL Stored Procedure That Returns A Result Set
  • As I See It: At Any Cost
  • IBM i PTF Guide, Volume 27, Number 19
  • IBM Unveils Manzan, A New Open Source Event Monitor For IBM i
  • Say Goodbye To Downtime: Update Your Database Without Taking Your Business Offline
  • i-Rays Brings Observability To IBM i Performance Problems
  • Another Non-TR “Technology Refresh” Happens With IBM i TR6
  • IBM i PTF Guide, Volume 27, Number 18

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle