. Unity"> So how do we provide a tool that delivers both autonomy and innovation to end users while maintaining a single version of the truth, near-real-time loading and more? The list of issues inherent in trying to make an individual productivity tool scale would be too long for this column.Furthermore, spreadsheets are positional (A22:A54) in access versus the relative (Select Name from Customer ) access offered by a database, making them much more difficult to maintain. In addition, unlike actual application code, which can be stepped through logically, spreadsheets, especially complex ones, are much more difficult to follow, let alone maintain the logic driving the results. Will slapping Microsoft Excel on top of SQL Server address that issue? Admittedly, I do not have the details yet as to how, specifically, the server edition of Microsoft Excel will work in Office 12. I dont know if Microsoft Excel functions and formulas will be converted into SQL or T-SQL, or if that logic is maintained separately. What I do know is that the real IT organizations better start looking at this seriously. If done correctly, this could hold the answers to dramatically improving organizations overall data management processes. But it will take some close scrutiny. I am, shall we say, skeptical of Microsofts commitment to improving the state of the analytic infrastructure. Not because the company doesnt want to, but simply because it is difficult for a product or company that has focused on individual productivity to reposition itself as a shared collaborative tool. I fear that old habits will be difficult to overcome, but overcome them we must. Somehow a balance must be struck between allowing users to use and manage data as they see fit, and providing a solid, scalable, secure and auditable infrastructure on which to do that. It will take planning. After all, we have had BI tools for years that could sit on top of a relational database and provide all the power and ease of use that Microsoft Excel has. Of course, they were not pervasive enough on users desktops to make a difference. It will be up to the organization itself to address the costs and risks inherent in the very existence of the stealth IT organization. We have to start by recognizing that any information that is part of a process that is beyond the scope of a single individual is probably not a job for which a tool like Microsoft Excel should be used. Perhaps the server edition will address that, but there will be no long term-solution until the front-end BI tool of choice is accessing a single source of corporate truth, an enterprise data warehouse. Click here to read more commentary on enterprise data warehouses. More importantly, this should be an active enterprise data warehouse that is updated where appropriate on a real-time or near real-time basis. Only then do we begin to address the issues of accuracy, security and availability. As for what tool should be used, a Web-based version of Microsoft Excel does sound promising, but it better sit on top of more than just SQL Server. It would need to support Teradata, DB2 and others that are more likely to be the infrastructure on which the data warehouse is based. For users of Oracle 10g, I would check out HTML DB, a Web-based declarative development tool that comes bundled with every edition Oracle offers. Its easy enough for the average user to pick up, but can be leveraged by heavy duty development types as well, and its Web-based approach makes it instantly ubiquitous. I would also consider existing reporting tools such as Cognos Inc.s or Business Objects products as well. Given some time, I think end users will find there are other tools that can offer the same power as the desktop tools but with added benefits like scalability and maintainability. In the end, however, its about planning for proper analytic infrastructure. We want users to have autonomy. We need them to create and innovate. But autonomy alone can actually hurt an organizations ability to adapt because our processes are based on fragile, unsustainable infrastructure. Now is the time to open the dialogue between stealth IT and official IT and solve this problem. Charles Garry is an independent industry analyst based in Simsbury, Conn. He is a former vice president with META Groups Technology Research Services. He can be reached at email@example.com. Check out eWEEK.coms for the latest database news, reviews and analysis.
One example of the problems with the heretofore disconnected spreadsheet world was the lack of control over how a metric is calculated.