Welcome!

Agile Computing Authors: Yeshim Deniz, Pat Romanski, Elizabeth White, ManageEngine IT Matters, Liz McMillan

Related Topics: Agile Computing, Microsoft Cloud

Agile Computing: Article

Will Office 365 Redefine Enterprise Applications?

How Office 365, Azure, and NoSQL can work together to improve business productivity

There is a of excitement in the air about Microsoft's Office 365 offering. Apart from the traditional view of reduction in licensing cost and no Upgrade issues which the SaaS basically offers, we can also derive some enterprise benefits from it if all the partners and ISV support the same. This one is one such pattern.

Office 365

Office 365 provides anywhere access to email, documents, contacts, and calendars so you're always up-to-date. From scheduling to interactive online meetings to sharing files, you're uniting cloud-based services with the productivity tools people use every day.

At this time , Office 365 will be Microsoft's flagship SaaS offering with :

  • Office Professional Plus
  • Exchange Online
  • Sharepoint Online
  • Lync Online

Windows Azure

The Windows Azure platform is poised to radically change the way Microsoft architects and developers think about building and managing applications. The Windows Azure platform provides an Internet-based cloud computing environment for running applications and storing data in Microsoft data centers around the world. In many ways, you can think of it as Windows in the cloud.

NoSQL

In computing, NoSQL is a term used to designate database management systems that differ from classic relational database management systems in some way. These data stores may not require fixed table schemas, and usually avoid join operations and typically scale horizontally. Academics and papers typically refer to these databases as structured storage, a term that would include classic relational databases as a subset.

Windows Azure & NoSQL

While SQLAzure is a robust relational database platform as a Service,  but yet Windows Azure do provide  lot of capabilities to host and run NoSQL databases. The following are the  typical NoSQL options within Windows Azure apart from third party providers.

  • The simplest way to store data in Windows Azure storage is to use blobs. A blob contains binary data, each container can contain one or more blobs. Blobs can be big-up to a terabyte-and they can also have associated metadata, such as information about where a JPEG photograph was taken or who the singer is for an MP3 file
  • Blobs are just right for some situations, but they're too unstructured for others. To let applications work with data in a more fine-grained way, Windows Azure storage provides tables. These aren't relational tables. The data each one holds is actually stored in a group of entities that contain properties

Business Processing With Traditional SQL Database

  • Most of the business process initiation is carried out through unstructured documents like Microsoft Office, Adobe documents .
  • However due to the lack of validation of the document data with the enterprise information systems (EIS), the document data is shredded (de-normalized) into relational databases
  • Duplication in terms of data entry and reporting
  • End to end integration is achieved only by storing the storing the unstructured documents in relational form and again assembling them back to unstructured form to be passed on to downstream systems
  • Data validation is done through the customized forms and not from the unstructured documents
  • Search capabilities on Unstructured documents are limited or non existing and hence big effort on custom development is spent on Enterprise Reporting Tools to query relational tables
  • The below diagram shows the business processing with Traditional SQL Databases

Transformation Into [Office 365, NOSQL] Cloud Environment

With the proposed offerings on Office 365 along with the NOSQL offerings that currently exist on Azure PaaS platform,  we are into a  new world of seamless integration between the unstructured documents and  Cloud, so that the LOB (Line Of  Business) applications can perform efficient  business process work flow without the over whelming conversion to relational format and  consolidating it again for reporting.

  • Utilize the advanced features of the OBA (Office Business Applications) to integrate the business processes
  • Utilize the unlimited storage options available as part of NOSQL storage offerings as part of Azure Cloud Platform
  • Integrate with other tools that enable the business process orchestration, like
  • o Exchange Online
  • o Sharepoint Online
  • Integrate with human intervention and collaboration with Lync Online.

Summary

Traditionally   Office business applications have always been preferred  in various enterprise,  high number of Excel and MS-Access based applications is a testimony.

Mostly these applications have so far restricted by the  scalability, space and multi user needs and hence enterprises migrated them to other platforms  like .net or J2EE.

However availability of Office 365 as a SaaS on a PaaS platform like Azure along with the unlimited storage potential of NOSQL  databases like BLOB makes it very extensible and a truly enterprise business process platform.

We expect the  ISVs to come up with several  glue applications for data acquisition, validation , storage and reporting enhancements to make the best out of this platform, and it looks like  it is already on that course.

More Stories By Srinivasan Sundara Rajan

Highly passionate about utilizing Digital Technologies to enable next generation enterprise. Believes in enterprise transformation through the Natives (Cloud Native & Mobile Native).

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@ThingsExpo Stories
SYS-CON Events announced today that GrapeUp, the leading provider of rapid product development at the speed of business, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Grape Up is a software company, specialized in cloud native application development and professional services related to Cloud Foundry PaaS. With five expert teams that operate in various sectors of the market acr...
SYS-CON Events announced today that Enzu will exhibit at SYS-CON's 21st Int\ernational Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to focus on the core of their ...
New competitors, disruptive technologies, and growing expectations are pushing every business to both adopt and deliver new digital services. This ‘Digital Transformation’ demands rapid delivery and continuous iteration of new competitive services via multiple channels, which in turn demands new service delivery techniques – including DevOps. In this power panel at @DevOpsSummit 20th Cloud Expo, moderated by DevOps Conference Co-Chair Andi Mann, panelists examined how DevOps helps to meet the de...
SYS-CON Events announced today that Cloud Academy named "Bronze Sponsor" of 21st International Cloud Expo which will take place October 31 - November 2, 2017 at the Santa Clara Convention Center in Santa Clara, CA. Cloud Academy is the industry’s most innovative, vendor-neutral cloud technology training platform. Cloud Academy provides continuous learning solutions for individuals and enterprise teams for Amazon Web Services, Microsoft Azure, Google Cloud Platform, and the most popular cloud com...
We build IoT infrastructure products - when you have to integrate different devices, different systems and cloud you have to build an application to do that but we eliminate the need to build an application. Our products can integrate any device, any system, any cloud regardless of protocol," explained Peter Jung, Chief Product Officer at Pulzze Systems, in this SYS-CON.tv interview at @ThingsExpo, held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA
SYS-CON Events announced today that IBM has been named “Diamond Sponsor” of SYS-CON's 21st Cloud Expo, which will take place on October 31 through November 2nd 2017 at the Santa Clara Convention Center in Santa Clara, California.
In his session at Cloud Expo, Alan Winters, an entertainment executive/TV producer turned serial entrepreneur, presented a success story of an entrepreneur who has both suffered through and benefited from offshore development across multiple businesses: The smart choice, or how to select the right offshore development partner Warning signs, or how to minimize chances of making the wrong choice Collaboration, or how to establish the most effective work processes Budget control, or how to ma...
With major technology companies and startups seriously embracing Cloud strategies, now is the perfect time to attend 21st Cloud Expo October 31 - November 2, 2017, at the Santa Clara Convention Center, CA, and June 12-14, 2018, at the Javits Center in New York City, NY, and learn what is going on, contribute to the discussions, and ensure that your enterprise is on the right path to Digital Transformation.
SYS-CON Events announced today that CA Technologies has been named "Platinum Sponsor" of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business - from apparel to energy - is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
Multiple data types are pouring into IoT deployments. Data is coming in small packages as well as enormous files and data streams of many sizes. Widespread use of mobile devices adds to the total. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists looked at the tools and environments that are being put to use in IoT deployments, as well as the team skills a modern enterprise IT shop needs to keep things running, get a handle on all this data, and deliver...
In his session at @ThingsExpo, Eric Lachapelle, CEO of the Professional Evaluation and Certification Board (PECB), provided an overview of various initiatives to certify the security of connected devices and future trends in ensuring public trust of IoT. Eric Lachapelle is the Chief Executive Officer of the Professional Evaluation and Certification Board (PECB), an international certification body. His role is to help companies and individuals to achieve professional, accredited and worldwide re...
Amazon started as an online bookseller 20 years ago. Since then, it has evolved into a technology juggernaut that has disrupted multiple markets and industries and touches many aspects of our lives. It is a relentless technology and business model innovator driving disruption throughout numerous ecosystems. Amazon’s AWS revenues alone are approaching $16B a year making it one of the largest IT companies in the world. With dominant offerings in Cloud, IoT, eCommerce, Big Data, AI, Digital Assista...
"When we talk about cloud without compromise what we're talking about is that when people think about 'I need the flexibility of the cloud' - it's the ability to create applications and run them in a cloud environment that's far more flexible,” explained Matthew Finnie, CTO of Interoute, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
No hype cycles or predictions of zillions of things here. IoT is big. You get it. You know your business and have great ideas for a business transformation strategy. What comes next? Time to make it happen. In his session at @ThingsExpo, Jay Mason, Associate Partner at M&S Consulting, presented a step-by-step plan to develop your technology implementation strategy. He discussed the evaluation of communication standards and IoT messaging protocols, data analytics considerations, edge-to-cloud tec...
IoT solutions exploit operational data generated by Internet-connected smart “things” for the purpose of gaining operational insight and producing “better outcomes” (for example, create new business models, eliminate unscheduled maintenance, etc.). The explosive proliferation of IoT solutions will result in an exponential growth in the volume of IoT data, precipitating significant Information Governance issues: who owns the IoT data, what are the rights/duties of IoT solutions adopters towards t...
With the introduction of IoT and Smart Living in every aspect of our lives, one question has become relevant: What are the security implications? To answer this, first we have to look and explore the security models of the technologies that IoT is founded upon. In his session at @ThingsExpo, Nevi Kaja, a Research Engineer at Ford Motor Company, discussed some of the security challenges of the IoT infrastructure and related how these aspects impact Smart Living. The material was delivered interac...
The Internet giants are fully embracing AI. All the services they offer to their customers are aimed at drawing a map of the world with the data they get. The AIs from these companies are used to build disruptive approaches that cannot be used by established enterprises, which are threatened by these disruptions. However, most leaders underestimate the effect this will have on their businesses. In his session at 21st Cloud Expo, Rene Buest, Director Market Research & Technology Evangelism at Ara...
When growing capacity and power in the data center, the architectural trade-offs between server scale-up vs. scale-out continue to be debated. Both approaches are valid: scale-out adds multiple, smaller servers running in a distributed computing model, while scale-up adds fewer, more powerful servers that are capable of running larger workloads. It’s worth noting that there are additional, unique advantages that scale-up architectures offer. One big advantage is large memory and compute capacity...
Artificial intelligence, machine learning, neural networks. We’re in the midst of a wave of excitement around AI such as hasn’t been seen for a few decades. But those previous periods of inflated expectations led to troughs of disappointment. Will this time be different? Most likely. Applications of AI such as predictive analytics are already decreasing costs and improving reliability of industrial machinery. Furthermore, the funding and research going into AI now comes from a wide range of com...
Internet of @ThingsExpo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devic...