• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Insurance Company Chooses Attunity for DB2/400-to-SQL Server Replication

    March 23, 2010 Alex Woodie

    The Taiwan subsidiary of New York Life Insurance has achieved substantial savings and eliminated much manual programming by using Attunity‘s log-based changed data capture (CDC) software to replicate data from an i/OS server to the Windows applications used by its customer service representatives, the software vendor announced last week.

    With assets of almost $1.9 billion and more than 300,000 policyholders, New York Life Insurance Taiwan Corporation (NYLITC) is one of the largest life insurance companies in Taiwan. Like many large insurance companies, NYLITC’s IT department uses a mix of different platforms and databases to keep the business running.

    However, the heterogeneous computing environment complicated data integration tasks, especially with multiple Asian languages and double byte character sets (DBCS) in the mix. NYLITC employed a team of programmers to keep the different databases as up-to-date as possible.

    Just the same, it commonly took the programmers up to two days to refresh NYLITC’s databases with the latest, freshest data. This resulted in customer service agents having less-than-fresh data in front of them when speaking with customers–a less-than-ideal situation.

    When NYLITC embarked upon a project to automatically integrate its data, it evaluated several data replication offerings. But the quest ended when it looked at Attunity and its Operational Data Replication (ODR) offerings, which have been adopted by a number of i/OS shops over the years.

    Specifically, NYLITC purchased and implemented Attunity’s Stream product to keep DBCS data flowing from an i/OS-based server to a SQL Server database that’s used to generate reports and Web interfaces used by NYLITC’s customer service agents.

    According to NYLITC project manager Sebastian Ma, the software works in near real-time, and gives customer service agents access to fresher data. But perhaps more importantly, the software has alleviated the back-office burden on programmers, he says.

    “It’s hard to put a price tag on the value of the countless hours of effort we’ve been able to save on custom programming by using Attunity’s ODR Solution,” Ma says in a press release, “but it’s estimated that we’ve been able to cut as much as 70 percent from the end-to-end process time, with a 30 percent overall cost-savings on the related labor and overhead.”

    Those are impressive figures, and they tend to support the claims made by other Attunity customers that have implemented Attunity on DB2/400, including Atlantic Detroit Diesel Allison (Atlantic DDA), a distributor of heavy equipment in the northeastern United States, and EMI Music North America, the music distributor.

    RELATED STORIES

    Equipment Dealer Lauds Attunity for Speedy DB2/400 Replication

    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
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Help/Systems:  Robot/CONSOLE monitors System i resources automatically
    Northeast User Groups Conference:  20th Annual Conference, April 12 - 14, Framingham, MA
    COMMON:  Join us at the annual 2010 conference, May 3 - 6, in Orlando, Florida

    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

    Companies Say Software Support Is Satisfactory Using UNION for Data Analysis

    Leave a Reply Cancel reply

Volume 10, Number 12 -- March 23, 2010
THIS ISSUE SPONSORED BY:

Databorough
Bytware StandGuard Security
RevSoft
Patrick Townsend Security Solutions
WorksRight Software

Table of Contents

  • CoralTree Toolkit Streamlines CGIDEV2 Web App Development
  • Info Builders Updates Dashboarding Solution
  • Unitrends Adds Cloud-Based Storage to Backup Offering
  • HiT Bolsters Data Synchronization Tool
  • LTO Tape Drives: More than 3 Million Served
  • Fly Doc, Fly: Esker Updates Online Mail and Fax Service
  • Insurance Company Chooses Attunity for DB2/400-to-SQL Server Replication
  • IBM and Assurant Unveil ‘RAMP’ for Intelligent CSR Call-Routing
  • Vision Touts High Availability Install at Food Distributor
  • Construction App from CGC Gets a Web Portal

Content archive

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

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

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