yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..

2008 West
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
Red Hat
The Opening of Virtualization
User Environment Management – The Third Layer of the Desktop
Cloud Computing for Business Agility
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Return on Assests: Bringing Visibility to your SOA Strategy
Managing Hybrid Endpoint Environments
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
How Can AJAX Improve Homeland Security?
Beyond Widgets: What a RIA Platform Should Offer
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
British American Tobacco - In the driver's seat with Web services-based dashboards
British American Tobacco - In the driver's seat with Web services-based dashboards

With brands sold in 180 markets around the world, British American Tobacco, the world's most international tobacco company, was looking for a way to access and analyze data to improve supply-chain performance. The IT department was charged with finding a new approach that would provide significant improvements over the traditional approach of gathering and storing data, transforming it into information, and generating reports. The complexity of report generation, married with the inability to easily connect disparate information sources, makes this a costly information technology problem.

Critical supply-chain information at British American Tobacco is stored in applications from SAP and i2 Technologies. The problem that the company faced was that the data and information contained in the enterprise was difficult to get at, couldn't be easily created or administered, and was not updated in a timely fashion. Conventional wisdom suggested traditional business intelligence tools on top of a standard data warehouse were the only option to effectively access the data and run complex, technically administered reports. However, building a data warehouse would take months, and British American Tobacco wanted to demonstrate business results in a much shorter timescale.

With the dawn of Web services, there had to be an innovative new technology concern that was applying the principles of "distribution" to that of intelligence or data for large global corporations. British American Tobacco identified CXO Systems, a two-year-old startup that had applied the same principles of distribution to business intelligence that leading technology companies such as Cisco and Sun had applied to the network and computing before them.

Fueling BAT's Web Services Initiative
The technology standards movement brought on by Web services has enabled organizations to attain new levels of business visibility that will allow companies to more nimbly react to market and business changes, and more profitably serve their employees, customers, and shareholders.

Having recently embarked on a Web services initiative, which included Librados Enterprise Integration Component Server and Infravio's Web service management tool, IT managers at British American Tobacco were compelled by the idea of implementing a Web services-based dashboard that would extract and integrate information from operational and analytical systems, providing executives with direct access to the information they need to make important business decisions without new investments in data warehousing, business intelligence, or EAI tools.

Working with executive dashboard specialists CXO Systems as its partner in executing the next step in the company's Web services strategy, the company created a pilot dashboard for a major part of British American Tobacco's European business that extracts information from legacy SAP systems and i2 supply planning applications to create interactive reports that show metrics on average lead time for product delivery, forecasting metrics, and other manufacturing capabilities that help to ensure demand can be met. The product, CXO System, consumes Web services and processes the data, which is displayed as a dashboard interface. Now the supply-chain team within that part of the business can view one portal screen with a series of tabs, each showing metrics for different groups.

Dashboards: Outside Looking In
The concept of dashboards is simple - they provide a straightforward, consistent way for decision makers to view up-to-date data from every enterprise system. Dashboards allow companies to view and monitor business processes in real time. Applied to the supply chain, dashboards allow workers to make critical business decisions based on forecasted market demand, product inventory, and the varying lead times within different global markets.

Web services are a natural solution for dashboards. They allow British American Tobacco to integrate the information from multiple sources, providing the company with a seamless view of supply and demand factors for a fraction of the cost of creating a data warehouse. Not only was creating a Web services-based dashboard less expensive than creating a data warehouse, but it took only eight weeks. And while most large enterprises have point solutions for each piece of production information (logistics, delivery, etc.) and a degree of integration across some applications, most enterprises still cannot look at supply and demand in real time, in one place, at one time, the way that parts of British American Tobacco now can.

Now it is possible to monitor the performance of the supply and demand chain from one place without relying on alerts from multiple systems or phone calls from the field. Additionally, each local portion of the supply chain can be given a customized view into the chain, showing exactly the information they need to manage their operation.

.NET and Java: Fork in the Road?
While the great debate about the supremacy of .NET and Java continues, the British American Tobacco implementation is further proof that the two technologies can coexist. CXO is a .NET-based application, but products based on J2EE were used in the project to enable integration with back-end business systems.

The Road Ahead
British American Tobacco plans to spread the dashboard concept across its business, not just in the supply chain arena but into other areas of the business too. With the core foundation for distributed intelligence in place, the company can now activate dashboards within weeks in any business segment for a fraction of the price and time of the traditional data warehouse-based method. Additionally, due to Web services, once the dashboards are active they can stream data in "right time," based on the users' needs.

Together, British American Tobacco and CXO Systems think they have found the "holy grail" of Web services - the ability to solve the age-old data problem in a seamless and cost-effective manner, by treating the enterprise and all the data stored in any application or file as the data warehouse.

About Kevin Poulter
Kevin Poulter is the application technology manager at British American Tobacco and is charged with defining global strategy for application infrastructure.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

SOA World Latest Stories
"I focus on what we are calling CAST Highlight, which is our SaaS application portfolio analysis tool. It is an extremely lightweight tool that can integrate with pretty much any build process right now," explained Andrew Siegmund, Application Migration Specialist for CAST, in this SYS...
As many know, the first generation of Cloud Management Platform (CMP) solutions were designed for managing virtual infrastructure (IaaS) and traditional applications. But that's no longer enough to satisfy evolving and complex business requirements. In his session at 21st Cloud Expo, ...
SYS-CON Events announced today that Synametrics Technologies will exhibit at SYS-CON's 22nd International Cloud Expo®, which will take place on June 5-7, 2018, at the Javits Center in New York, NY. Synametrics Technologies is a privately held company based in Plainsboro, New Jersey tha...
DevOps promotes continuous improvement through a culture of collaboration. But in real terms, how do you: Integrate activities across diverse teams and services? Make objective decisions with system-wide visibility? Use feedback loops to enable learning and improvement? With technolog...
There is a huge demand for responsive, real-time mobile and web experiences, but current architectural patterns do not easily accommodate applications that respond to events in real time. Common solutions using message queues or HTTP long-polling quickly lead to resiliency, scalability...
"We started a Master of Science in business analytics - that's the hot topic. We serve the business community around San Francisco so we educate the working professionals and this is where they all want to be," explained Judy Lee, Associate Professor and Department Chair at Golden Gate...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)!

Advertise on this site! Contact advertising(at)! 201 802-3021

SYS-CON Featured Whitepapers