March 18, 2008 - Haggen, Inc., a U.S. food and grocery retailer, deployed GoldenGate real-time data integration solution to improve the quality and timeliness of its data integration process.


The retailer uses GoldenGate solutions for real-time data feeds to facilitate downstream reporting and business intelligence (BI), which significantly reduces the latency of the data and transmission errors.


With millions of point of sale (POS) transactions every week, Haggen relies on the GoldenGate solution to integrate its transactional data from the StoreNext ISS45 POS system into an interim Microsoft SQL Server 2005 Operational Data Store (ODS). Every few minutes, data is delivered to the Teradata enterprise data warehouse (EDW). Information is readily available for business-wide reporting and analysis such as revenue and margin by store and for any given product.


"Prior to implementing the solution, there was a lag time of as much as 24 hours before we had visibility to information on margin and revenue" said Harrison Lewis, CIO at Haggen. "With GoldenGate in place, we have not only seen a dramatic decrease in data latency and errors, but also now have complete visibility throughout the sales day in record time. This allows us to make important decisions about the business that have a positive effect on that day's sales and operations."


GoldenGate worked with the Haggen IT team to augment the GoldenGate Capture component, enabling data to be pulled from the StoreNext POS system. Access to fresh data allows Haggen to report on a range of business metrics such as sales by store, by department or by lane for any given item across the grocery chain network. This BI can be used for decisions, including which items to mark up or mark down and also to determine which promotional marketing campaigns to run and when.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access