SOA-enablement of spreadsheets - is it feasible?
SOA transformation is all very fine, but does is apply to all situations? For example, how do you apply SOA principles to organizations where the multitude of desktop users love the spreadsheet interface and swear by it? Perhaps a better question is, how should you apply SOA principles to environments where users are not looking to share information between desktops, where the ultimate flexibility of your own personal spreadsheet is inherently the differentiator between your product and your competition's, and where SOA is looked on as "Simply Over Ambitious?"
The finance world lives in spreadsheets. And, to give Microsoft due credit, they have marketed a whiz-bang product with Excel. A large percentage of financial models exist in spreadsheets, and they drive the financial products offered by multinational financial institutions. Sharing of information is primarily a matter of sharing a common repository of large files.
So where is the nail for which we have the SOA hammer? While the complex logic of modeling risk and other aspects of financial products is addressed by Excel, the volume of files is becoming an isurmountable problem. Plus, there is no real security for access. This was not a problem when the entire spreadsheet was handled by a small select team; but that is not applicable anymore. Errors and bugs are very hard to track. And cut and paste errors abound.
I faced this very situation at one of our financial clients. The client originally engaged another consulting firm to provide a solution to these problems. A grand SOA vision was drawn up. After about a year, the client lost patience, and were especially peeved when they saw the first deliverable about 12 months away. So they scaled back and asked for something small. That was when they engaged us.
SOA in the small? It is a kind of paradox. However, the real question to ask is, where is it truly applicable in this scenario? The answer is - "data management." Data from several disparate systems makes its way into the spreadsheets. This data needs to be standardized, cleansed, and integrated through common meshanisms. But wait a minute. Is this not an EAI problem? Where does SOA come in?
The very basic services under the SOA umbrella are foundation services. These basically include data gateways and the like to enable consumption and querying of data. Providing these services as a layer above the native integration with systems like Bloomberg allows the middle tier systems to make them available for consumption by spreadsheets. Once the services are built, they can be shared by trading systems that need the data for transactions.
This is definitely "SOA in the small." And it doesn't even go into the aspects of organizational governance. Nevertheless, it prepares the framework for departments to participate in the larger SOA initiatives that are already in inception across the whole organization.


