fhs
Volume 9, Number 35 -- September 29, 2009

Talend Helps British Housing Authority Integrate Windows and i5/OS Data

Published: September 29, 2009

by Alex Woodie

The Accent Group, a British association that provides housing to more than 50,000 residents, is successfully using Talend's open-source tools to solve data integration issues stemming from its use of disparate iSeries and Windows servers, Talend announced last week.

The Accent Group is a registered social landlord that provides nearly 20,000 homes across the UK through its three registered social landlords, called Accent Foundation, Accent Nene, and Accent Peerless.

The organization, which is based in Shipley, West Yorkshire, relies on a mix of IBM iSeries and Windows servers to keep track of business and to meet regulatory obligations. However, the use of different systems and data warehousing platforms has caused its share of headaches for the group, which funds a standing data integration project to deal with the differences in data types and their underlying incompatibilities.

Before implementing the Talend Integration Suite, it would take up to a month to create reports required by the Tenant Services Authority and the National Register of Social Housing, says Francois Mero, general manager of Talend's EMEA business unit.

Following the implementation of the product--commonly referred to as an extract, transform, and load (ETL) tool--the same work could be completed in a day. That has made the job of Andy Gowdy, Accent's legacy system manager, much easier.

"Talend Integration Suite will provide Accent Group with one common tool for managing its variety of disparate systems, such as its anti-social management system, or its rent collection application," Gowdy states in a press release.

A major selling point for Accent was that Talend is open source, "meaning that it can integrate with our IBM iSeries legacy systems and different platforms," Gowdy says. "It can also extract data from any file format and at a dramatically lower cost than proprietary software."

Talend--which develops core ETL functionality using the open source method but also sells licensees to higher-end versions of the software, as well as services--introduced support for i5/OS about two years ago. Since then, the software has been deployed in a handful of i OS shops.

Talend's product also provides ETL functionality for the Smart i, a pre-packaged business intelligence bundle based on IBM's DB2 Web Query software, and put together by Key Information Systems and Systech.


RELATED STORIES

Talend Goes Real Time with Data Integration Software

Talend Says Its Open Source Approach for Integration Tools Has Been Validated

A Bumblebee for BI--Now That's Just 'Smart'

Talend Adds i5/OS Support to Open Source ETL Tool



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


Sponsored By
S4i SYSTEMS

Document Management Case Study: Tankersley Food Service

S4i's document automation technology integrated with Retalix Power Enterprise eases fast-track food distributor's growing pains.

Speaking metaphorically, when a company grows faster than spinach, great computer technology can serve as a strong, supportive root system. Such is the story for Tankersley Food Service, LLC, the largest independent foodservice distributor in Arkansas, and Oklahoma.

Founded in 1928, Tankersley has accomplished something that seems rather improbable. It went from $8 million in annual sales in 1999, to yearly revenue of around $95 million in under eight years. This quantum expansion has been the product of a shift in business strategy, an increase in the number of field sales representatives, and a fervent commitment to technology.

In foodservice parlance, Tankersley is a broadliner, meaning they offer dry, frozen and refrigerated food items, fresh produce, meat, beverage service supplies and cleaning products to businesses and institutions. Early on, Don Tankersley, the company's CEO, decided to deploy powerful computing technology and licensed Retalix Power Enterprise, an ERP solution specially designed for the food industry. Their IT shop is using several important components in Power Enterprise including its web-based customer order entry portal and a voice recognition warehouse picking system. Here, Retalix Power Enterprise runs on a reliable IBM System i, model 520.

Tankersley's need for streamlined electronic document processing was a byproduct of its success. As an increasing number of independent, small regional chain, and non-commercial accounts partnered with them to satisfy their own foodservice requirements, what began as a small stack of daily, weekly and monthly reports that ran on impact printers, grew into an ungainly mountain of paper. According to Casey Carter, the company's director of information technology, "Problems like this start off small. You start by sending one report to one person and then it becomes a couple of pages and before you know it, you're spending a day printing, bursting, scanning, and emailing reports. As we grew the problem got bigger and we didn't even realize it. We thought we had to print all these documents to make the business work."

At one point, Retalix Power Enterprise would run end-of-day processes and 50 different reports would print. Many of these reports were referenced only periodically so the bulky 11" by 17" greenbar output was folded and stored. In an effort to eliminate waste, they started archiving report spool files on the System i but spool files take up a lot of disk space, and it was a hassle for users to find specific reports because searching for them involved scrolling through 2,000 documents.

In 2008, Carter attended a Retalix user conference in Dallas, and stumbled upon a solution from Retalix Business Partner, S4i. By then, he had already deployed a PC-based electronic document management solution that seemed to work, but had it's shortcomings. For one thing, it didn't have the ability to capture spool files, so System i reports would first run on a system printer, then get scanned into a PC-based system, and get emailed or faxed to hundreds of recipients. Carter also explains that the first document automation system was difficult to configure and maintain, and it was often necessary to hire a contractor to make changes. Finally, upgrades and additional modules were very expensive. "The total cost of S4i Express was less expensive than the cost of upgrading the other solution's scanning component," he says.

S4i Express is a complete document delivery system for IBM i that electronically captures, separates, indexes, bundles, and delivers or archives documents and reports. Output options include .pdf, .html, .csv, .rtf and other formats. It also supports automated report distribution to fax machines. At the Retalix conference, Carter discussed S4i Express with IT professionals from other foodservice companies and felt confident that it was a solution he could work with. His initial intention was to simply duplicate the level of reporting automation that he had with the previous system.

S4i Express was easy to implement because it captures spool files in defined outqueues, so programming is not necessary. Says Carter, "We started capturing spool files automatically, converting them to electronic reports and distributing them through distribution lists. This process was about as painless as it could be, and it eliminated a lot of unnecessary printing and labor. Honestly, the reporting process never operated this efficiently." Carter started by capturing 13 documents and is now doing roughly 200. Over a short period of time Carter says he acquired expertise with S4i Express and took off running. "It's a lot more useful than we thought it would be. Many times, when you license a product to do a specific task, and it does that task, you're satisfied. We thought we were going to replace our old system and trade apples for apples, but we got much more functionality at about the same cost of our old system. This has opened up new opportunities for us that we hadn't previously considered."

Carter is also using S4i express to place orders with vendors, a process that was once very paper-centric. Orders were once printed on roughly 1,000 pages of greenbar, and manually split. The segments were then mailed to dozens of vendors. "We don't have to spend a whole day going through these reports, labeling them, labeling the envelopes and mailing them," says Carter. "S4i creates PDF files and automatically emails them to our vendors."

Think document automation and then some. Since then, Carter has deployed S4i Express in ways that even S4i finds imaginative. As an example, some of the printed reports that Retalix Power Enterprise produced were difficult to read in places where the lighting was dim, so Carter configured S4i Express to grab specific spool files, increase the size of the type in critical areas of these reports, and send them to the printer. "When the end user tells it to print, the system handles all of these operations automatically and the report comes off a laser printer in a format that's much easier to read."

Tankersley attends two food shows every year, and meets with all of its vendors. Since Tankersley offers 12,000 different SKUs from 300 manufacturers, preparation for this event is intense, and up until this year, it has involved a great deal of printing. "Years ago, we would print a stack of reports that would stand about 24 inches high. Last year, the stack of reports was as tall as a man. It became a nightmare," says Carter.

Carter has different plans for the next food show: He is going to facilitate a shift to electronic documents. This will eliminate 90 percent of the paper used, and fewer temporary workers will be hired to help prepare for the show. "It's going to be phenomenal. It will also free up our buyers and sales managers who won't have to hand-deliver these documents. It will free much of their time so they can meet with our vendors."

Carter has also set up S4i Express' web-based document management portal to facilitate employee access to electronic documents. "Using their System i User ID and Password, employees can access the Portal and perform document searches in seconds. No training is necessary because it's very intuitive." Carter has set up indexes in S4i Express so users don't have to open documents to find the information they are looking for. Through database indexes and OCR, Carter's search mechanism can find specific values in column headers.

Has S4i Express eased Tankersley's growing pains? "There's no doubt about it," says Carter. "The number of processes needed to run our business has grown and is more complicated. Many of them involve reporting, so from every angle, S4i Express has been a good investment. It saves time and the expense associated with printing paper documents. We've gotten much more than we expected and it has helped us a great deal."

For more information visit: http://s4isystems.com/products/s4iexpress.asp


Editor: Alex Woodie
Contributing Editors: Dan Burger, Joe Hertvik,
Shannon O'Donnell, Timothy Prickett Morgan
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

System i Developer:  RPG & DB2 Summit in Minneapolis, October 13-15; 3 days of serious training
Manta Technologies:  Fall Sale on i training courses! Order by October 15 and SAVE 25%
Halcyon Software:  Automated operations software for IBM i i5/OS - for as little as $25 a day!


 

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


 
The Four Hundred
IBM to Mothball a Whole Bunch of Stuff with Power7

IBM, VMware Cooking Up vSphere 4.0 Support for i

What Apple Did That IBM Must Emulate

As I See It: After You're Gone (.com)

IBM Says Microsoft 'Grossly Exaggerated' Exchange Sales Data

Four Hundred Guru
WDSC vs. RDi

Let's Start Over from the Beginning

The Cost of Not Backing Up

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
September 26, 2009: Volume 11, Number 39

September 19, 2009: Volume 11, Number 38

September 12, 2009: Volume 11, Number 37

September 5, 2009: Volume 11, Number 36

August 29, 2009: Volume 11, Number 35

August 22, 2009: Volume 11, Number 34

August 15, 2009: Volume 11, Number 33

TPM at The Register
Novell forces customers to pay for maintenance

Mainframe emulator goes commercial

Fujitsu battles WMDs with online survey

Red Hat mocks Meltdown in Q2

Super Micro gets dense with blades

Citrix ships virtual NetScaler accelerator

Mellanox kicks off race to 40 Gigabit Ethernet

IBM slots 'Lynnfield' Xeons into System x

AMD chipsets: the feeds and speeds

SGI births smaller baby super

Dell plus Perot - It's a start

HP bundles up services for data centres

THIS ISSUE SPONSORED BY:

looksoftware
PowerTech
Patrick Townsend Security Solutions
East Coast Computer
S4i Systems


Printer Friendly Version


TABLE OF CONTENTS
LANSA Gives aXes Screen Modernization Tool a Makeover

JAMS Brings Scheduling and File Transfer Capabilities to i OS

Trucking News: TMW Brings More Applications to i OS

VAI Adds Desserts to Food Distribution Package

Lawson Finds Search Software a Good Fit for M3

News Briefs and Product Shorts:

FalconStor Touts Big VTL Win at Insurance Company . . . Friedman Expands Offerings for Windows Manufacturers Beyond i OS . . . CYBRA Inks Deal with Chinese Government for RFID Project . . . Retalix Taps S4i Systems for i OS Electronic Document Management . . . Talend Helps British Housing Authority Integrate Windows and i5/OS Data . . .

Four Hundred Stuff

BACK ISSUES




 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement