Tag Archives: ROI

Saving the world, one spreadsheet at a time

How many times have we needed to format some data quickly and reached for our favorite spreadsheet application? I am just as guilty of this as you are.  Or maybe we needed to send data to someone, but weren’t sure what capabilities they had to parse out a flat file. The spreadsheet has been the Swiss Army knife in our IT toolboxes for years.

As our businesses drive us to leverage integration to reduce costs, we typically look to the large implementations for ROI. However, there is some low-hanging fruit that just requires us to think a little differently about an age-old problem; dealing with customers that eschew technology.  These are the customers that are still faxing orders to you.  They do email, hopefully, but one thing they do know how to use is a spreadsheet.

Spreadsheets do have valuable integration use cases, both inside the business and externally. An application example that comes to mind is mining shipment data from a database and producing the data in a format suitable for business end-users. Dumping the data to a comma-separated-values (CSV) file is quite limiting in presentation control. Yes, the data is all there, but the end-user is still going to spend time “prettying up” the contents.  Printing a report to PDF also gets the job done, but it’s still just a report. Wouldn’t it be useful to query the data and easily put it into a spreadsheet that encourages user interaction? This approach takes the data publishing paradigm one step further, enabling the end-user to interact with the data and empowering them to draw new insights that are beneficial to the business.

Continue reading

Where is my service-oriented ROI?

There are a number of blogs, discussion groups, podcasts, etc. talking about Service-oriented Architecture (SOA) and Service-oriented Integration (SOI). Instead of focusing on them individually, this blog focuses on using them together for better ROI results.

Service-oriented Integration (SOI) is the practice of using XML over HTTP (e.g. Web Services) to achieve interoperability between applications and services – for example, wrapping a legacy application function and exposing it to other applications, services, and business partners. Service-oriented architecture (SOA) encompasses architecture principles and best practices that guide the design and implementation of SOI, including methods that minimize coupling, complexity, and functional overlap. Most SOA initiatives start with the need to integrate an application; I believe the reason why companies fail and overspend on SOA initiatives is due to the lack of consideration for SOI and SOA together.

Continue reading