Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Latest News
    • Storage

    App Frees Bottled-Up Info From Big Iron

    By
    Renee Boucher Ferguson
    -
    April 29, 2002
    Share
    Facebook
    Twitter
    Linkedin

      As the nations second-largest bottler implemented a supply chain automation system to streamline its operations and better manage production, it discovered that most of its inventory and transaction data was inaccessible to the software it deployed, Manugistics Group Inc.s Supply Chain Management suite.

      The solution for Coca-Cola Bottling Co. Consolidated, known as CCBCC, was to deploy data movement software from Decision Support Inc. that moved mountains of customer data locked up in mainframes so it could be linked to Manugistics information on Oracle Corp. and Microsoft Corp. databases.

      CCBCC, whose annual sales exceed $1 billion, has seen a 15 percent reduction in finished goods inventory since beginning deployment of Manugistics Supply Chain Management software last year. It has implemented several of the Rockville, Md., developers modules, including ones for supply and demand management, as well as modules for forecasting, planning and production scheduling.

      But because Manugistics software is not compatible with IBM mainframes—where CCBCC holds 90 percent of its legacy information—the company couldnt access millions of legacy sales transactions and merge them with real-time inventory data. Doing that was critical to fulfilling deliveries for retailers.

      “I needed to find middleware that could hook up a mainframe with an Oracle or a SQL database and go across platforms and deliver mainframe data to the Web and to users,” said Lisa Steves, IS project manager at CCBCC, in Charlotte, N.C.

      Steves did an exhaustive middleware search, starting with traditional vendors, but had difficulty identifying any that could promise what CCBCC required.

      The problem was that when CCBCC ran a Manugistics report that accessed VSAM (virtual sequential access method) mainframe files, every file would have to be read, causing the job to take “forever,” according to Steves. She was looking for software that would optimize the VSAM files and optimize the total delivery of reports.

      “Not that many vendors can take multiple VSAM files, find the primary key to all the data and make it look like its only hitting one data source,” Steves said.

      CCBCC ended up deciding between Decision Supports DQbroker product and Attunity Inc.s Attunity Connect offering, which provides integration with more than 30 data sources on 20 different platforms. While both products can access mainframe and other information, at the time CCBCCs plans were being finalized late last year, Decision Support was more financially stable.

      Steves was particularly drawn to DQbroker because it could hook up CCBCCs mainframe information to Manugistics data residing in Oracle and SQL Server databases.

      “Because of that fact alone, we are always going to have to do a batch load to get information out of the mainframe and into Manugistics,” Steves said. “Manugistics is meant to help a company forecast, and thats what it does. What we need out of Manugistics is reports, and that hasnt been a primary focus for them. Its the same with [Manugistics competitor] i2 [Technologies Inc.]. They concentrate on what they know, but when you want to get reports out of it, its information we have to pull out of Manugistics.”

      Decision Support, of Matthews, N.C., started out in 1984 developing reporting tools for Unisys Corp. computers. A decade ago, founder and CEO Herb Verbesey said he saw that the mainframe was not going away but still had to fit into the burgeoning distributed computing model. So he directed the company to design a data integration and reporting product that favored no one operating system or database, and could distinguish data and push it to individual databases.

      “Ten years ago, when we started developing [DQbroker], we assumed that people would jump on [the trend toward integrated systems] right away. Its really been a lot slower,” Verbesey said. “Now people are calling us, and you see a lot of head of steam.”

      Going forward, Steves would like to see better access to Manugistics proprietary files, as well as access to Oracle data, whether that comes through DQbroker or from Manugistics directly. “Any time software is proprietary, theres a reason,” Steves said. “But if there is a way to export out the information … it would be easier to access reports.”

      “This is big business,” Steves said. “There are companies that do nothing but try and get to Manugistics information. But what we have with DQbroker, we are ahead of the game.”

      Renee Boucher Ferguson
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×