luni, 3 septembrie 2007

IT opens warehouses to external users

Corporate Express US Inc. this fall hopes to enable 1,000 of its largest customers to run reports and analyze purchasing patterns using data stored in the office supply company’s internal data warehouse.

The company is one of many that have turned to a variety of technologies over the past couple of years to let external users securely access selected corporate data.

IT executives say such projects can improve customer service, streamline supply chains and let offsite employees access internal business intelligence (BI) applications.

Matt Schwartz, director of business analysis at Corporate Express, said the company moved quickly early this year to select a technology that can provide its top customers with access to purchasing data after its hand was forced by similar efforts at key rivals Office Depot Inc. and Staples Inc.
Customers started “coming to us and saying, ‘We want this. Your competitors are offering it, [and] for me to stay loyal to you, you need to offer this,’” he said.

The Broomfield, Colo.-based company decided earlier this year to use a data warehouse appliance that would allow 10,000 users at 1,000 customers to keep track of their purchases, Schwartz said.

Data warehouse appliances bundle high-performance hardware, software and storage devices together in a device that is preconfigured to run a specific task, such as strategic analysis.

Corporate Express, which now uses an Oracle 10g-based enterprise data warehouse, plans to use Netezza Corp.’s Performance Server appliance to power a new data mart that will let customers run Web-based queries about their purchasing history, Schwartz said.

The company will continue to use the Oracle Corp. database internally as the company’s enterprise data warehouse, he noted.

The appliance from Framingham, Mass.-based Netezza will provide procurement information to customers through dashboards and standard reports, and by drilling down to transaction-level data, he said.

Schwartz said the company turned to the appliance technology for its ease of use features and performance capabilities.

“With our Oracle platform, the performance across thousands of customer wasn’t sufficient for sub-10-second response times,” he said.

Sales personnel at Corporate Express. which also uses business intelligence software from MicroStrategy Inc., are testing the Netezza appliance this summer. The software from MicroStrategy, in McLean, Va., authenticates the users and encrypts all the data to be presented outside the company’s firewall, he added.

The company hasn’t encountered any challenges yet in the testing process, he said.

The Hillman Group, a Cincinnati-based manufacturer and supplier of hardware like nuts, bolts and key engraving systems, took a different approach to providing salespeople working outside of the office with access to internal systems, said CIO Jim Honerkamp.

About two years ago the company created a so-called virtual data warehouse to let 800 remote employees access internal BI applications over the Web, he said.

Instead of moving data from transactional systems to a database for analysis, Hillman uses adapters from Information Builders Inc. subsidiary iWay Software to get direct access to transactional systems without having to physically integrate underlying data, he said.

Honerkamp said the virtual data warehouse has allowed the company to avoid having to build a multi-million dollar physical data warehouse for the external users.

Hillman uses the WebFocus BI software from New York City-based Information Builders to let users view sales reports and drill down into BI reports overlaid with GIS data, Honerkamp said.

“We’ll use this technology to map out the most efficient route for a sales rep to follow on a daily basis,” he said.

“We’re trying to provide to them with a driving sequence that minimizes the miles …fuel costs and other expenses,” he said. “We also use this to try to optimize the assignment of territories.”

The company also has married BI with GIS maps to optimize which distribution center ships products to customers to ensure the most cost effective route is used, he noted.

Canvas Systems, which sells used and refurbished IT equipment to businesses, a year ago built a portal to give customers that provide it products on consignment an “open-kimono view into our business,” said Steve Hyser, the company’s IT lifecycle manager.

Norcross, Ga.-based Canvas moves data from its transactional systems to a Microsoft SQL Server database that then allows those customers to log into the portal – which is updated every 10 to 15 minutes - to track their IT equipment as it is refurbished and made available for sale.

“They can see each individual item what we intend to sell it for,” Hyser said. “They can see what their proceeds are. They basically have a soup to nuts tracking mechanism.”

As a result, he added, there are no surprises, and thus no time-consuming calls from customers questioning a bill or looking to find out where an item is in the sales pipeline.

Colin White, president of BI Research in Ashland, Ore., noted that many companies that retrenched to focus on internal enterprise data access following the dot com bust now are beginning to eye making data available outside the firewall again.

“If I’m a funds investor buying funds and I can see information about my funds and how well they’re doing …that makes me a happier customer,” White noted.

“Companies get improved customer satisfaction and retention. They also [reduce] the number of calls coming into their call center,” he said.

The informatics division of Premier Inc. a San Diego-based health care alliance owned by 200 hospitals, this spring ousted the system that provided data analysis to 400 hospitals, said Chris Stewart, senior architect in the informatics division.

The division replaced its IBM Red Brick Warehouse SQL-based relational database with a Netezza data warehouse appliance for the core analysis it offers to the hospitals, he said.

The older system would run the required reports for the hospitals, but it could not inform users whether the query would take several hours or several minutes, he said. “[Using the appliance], you can get that analysis back to the customers in a much more predictable fashion,” Stewart added.

The new system speeds the analysis and provides an estimated completion time to queries by hospital administrators, such as like how their facility’s treatment of elderly patients with pneumonia compares to other hospitals, Stewart said.

The company first installed a Netezza warehouse appliance in 2003 to analyze selected pharmacy data, he said. It moved to broadly expand its use this year after gaining confidence in its functionality and performance, Stewart added.

Strong performance is especially important to Premier because the company places very strong security demands on the 3 TB data warehouse, Stewart said.

For example, he said, Premier added rules to the analysis process to verify whether each component of a query has data from enough hospitals so that the identity of the facility making the query isn’t obvious.

This verification takes place while the query is running, thus significantly increasing the load on the database, he added.

Niciun comentariu: