The virtual grocer

Walking down the aisles of the warehouse of the Mississauga, Ont.-based grocery chain Longo’s, everything from salt and catfood to orange juice and soup is, ultimately, taken care of by the granddaddy hub at the middle of the company’s IT strategy – Microsoft’s BizTalk Server 2006. Its implementation was helped along by Toronto-based software design and consultancy firm Whitecap, an experience that former Longo’s IT staffer Zico Sarmento enjoyed so much that he joined Whitecap soon thereafter. BizTalk
Back in 2006, Longo’s was in dire need of a technology upgrade. “We wanted to develop something simple, stable and scaleable,” said John Charleson, director of information technology and supply chain management for Longo’s. “So we wanted to move to SOA to support our (Salt Lake City-based Tomax’s Retail.net) ERP system.”

Labouring with a tiny team of four developers, Charleson found that his group spent 40 per cent of their time trying to get their disparate systems to talk to each other. The goal was to be able to pass information on a real-time basis from one application to another. “That way, if you make a change in one ERP system, it gets passed down to all the other systems.

From a data integrity position, it gives the right information at each level,” Charleson said.

Longo’s already had a significant investment in Microsoft technologies (both in terms of software and IT department expertise), so they turned to BizTalk Server 2006. They got in on the beta testing six months out so that they could get a quick start once the product was released. Since the server software would sit at the centre of a complex Web of nine separate programs that contained about 75 different interfaces, Longo’s called in Whitecap.

Said Sarmento, Whitecap’s solutions architect/business project manager: “We had six months and it was a very small development shop with only one person well-versed in BizTalk, so we needed help. It was a good fit culturally, and (Whitecap was) flexible and worked on-site with us.” (Whitecap declined to name the amount of the contract, saying only that it was a time-and-materials arrangement with a very attractive price in the interest of future partnerships).

Working together allowed for a helpful exchange of knowledge, with Longo’s picking up BizTalk tricks and Whitecap familiarizing themselves with Longo’s operations to aid with future co-projects. “BizTalk is fairly new, and we wanted to develop our expertise, too,” said Dallas Nairne, Whitecap’s vice-president of finance and administration.

Together, they crafted the many interfaces during the beta period, so that when the product became available, they were able to go live the next day, according to Sarmento.This process was helped along by the program’s many adaptors. Said Chris Brakel, Microsoft Canada’s eBusiness product manager: “BizTalk has adaptors right out of the box, so you’re not worried about what will talk to each other.” The system currently contains about 30 adaptors, but, said Brakel, new releases every two years will keep the ranks fresh and any gaps would most likely be filled by an ISV.

The system has now been running smoothly for a year, passing information between applications seamlessly. An example would be store sales data. The front-end transaction would be fed into the ERP system in real time, said Charleson. “And then we can see what we’re doing at store level,” said Charleson. Real time action also comes in handy with the warehouse management system (WMS), too. When the produce comes into the warehouse, it’s entered right away into the WMS, which then sends it through BizTalk into the ERP system so that the stores can see what’s in the warehouse in real-time.

This comes courtesy of XML standards, which translate the different data into workable information for each unique program. “We push them through as standards, so it’ll be agile,” said Sarmento.

Here lies the benefit of SOA, according to Charleson. He said that adding new applications is a breeze due to the flexibility factor. “It’s much easier to bring in new apps because you don’t have to rewrite the interfaces, just the piece that installs it,” he said.

SOA on sale
One might blanch at everything running through a single hub, but Charleson and his team have embraced another hot new bit of IT there, too – virtualization. In case of disaster, Charleson runs everything on a cloned and clustered virtual environment, with a copy of the production box stored away safely. “Because of the volume of transactions, we are getting a second box that is load-balanced,” he said.

Proposed new box and all, Longo’s clearly has been enjoying the benefits of interoperability for over a year now, and is enjoying the time freed to work on other key IT projects. Said Charleson:

“For example, we can further integrate (acquired online grocery system) Grocery Gateway into other systems. The Grocery Gateway order goes back to the ERP system through BizTalk and sends the order to the appropriate store and then to you.”

BizTalk’s easing the application’s integration – and freeing up the IT team’s time to work on it – has been one of the major benefits for Longo’s, since, said Charleson.

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

Related Tech News

Featured Tech Jobs

 

CDN in your inbox

CDN delivers a critical analysis of the competitive landscape detailing both the challenges and opportunities facing solution providers. CDN's email newsletter details the most important news and commentary from the channel.