Comments
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 Expo on Google News
SYS-CON.TV
Cloud Expo & Virtualization 2009 East
PLATINUM SPONSORS:
IBM
Smarter Business Solutions Through Dynamic Infrastructure
IBM
Smarter Insights: How the CIO Becomes a Hero Again
Microsoft
Windows Azure
GOLD SPONSORS:
Appsense
Why VDI?
CA
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
ExactTarget
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun
Sun's Incubation Platform: Helping Startups Serve the Enterprise
POWER PANELS:
Cloud Computing & Enterprise IT: Cost & Operational Benefits
How and Why is a Flexible IT Infrastructure the Key To the Future?
Click For 2008 West
Event Webcasts
Unleashing the True Power of Cloud Computing
Integrating systems creates synergy and power that exceeds that of traditional paradigms

The first generation of cloud computing was revolutionary in that it added business value to organizations by reducing development time, eliminating the need to procure infrastructure, providing massive scaling potential, establishing scale through multi-tenancy and by allowing IT people to focus on solving business problems versus technical ones. As cloud-based applications grew in prominence, they fought to achieve parity with legacy on-premise software solutions that were feature/functionality rich. These goals were achieved in short order, and thus the new generation of cloud solutions was born.

Web 2.0 goes far beyond parity with legacy systems and leverages the power of information sharing, collaboration and the social grid to achieve value that would be impossible with a paradigm of pushing information out from a single location. The new age cloud applications are powerful because they break down silos and simplify the process of converting data into information. As Web 2.0 systems in the consumer space evolve, companies are taking notice and looking to unleash the same power in their enterprise applications.

Enterprises face a unique challenge when adopting a cloud strategy. They do not have the benefit of starting with a blank slate and building their applications from the ground up, but they want to take advantage of the efficiency gains and collaborative benefits. Instead, they must find the best way to harvest the investment they have made in existing databases and applications, while realizing a magnitude of change from the cloud. The secret to Web 2.0 - whether it be the development of new applications from scratch, or the marriage between new and legacy applications - is integration.

Systems integration comes in several forms, each of which has validity based on a particular use case. The goal is to establish awareness of the major types of integration such that they can be appropriately applied as the cloud presents possibilities that we previously thought were impossible. With no one-size-fits-all solution, the synergy between these approaches is where the power is unleashed. For the purposes of this article, the major types of integration are data integration, interoperability and UI mash-ups.

Data Level Integration
Data level integration is the traditional means of migrating data from end point to end point. This type of integration requires data replication, either real time, or on a defined interval. The migration of data is done using custom-developed code or through ETL (Extract Transform Load) technologies that simplify the process of mapping data points and transforming disparate data sets from source to target. There are countless permutations and topologies that exist for this approach, but consistent are the key benefits that make this solution attractive.

First, end-user access to data in the cloud-based system is accomplished through a single secured connection that aids in both performance and complexity. By avoiding the need to make calls to an external system (possible an on-premise one), there is no need for call outs or remote access through a firewall.

An additional benefit is that replicating data maximizes the control that the target system has over the data. The data can be manipulated in the transformation process so that it meets the schema of the target system to ease reporting and data manipulation activity at the application layer. This means that just the right amount of normalizing or de-normalizing of the data can be done at transfer time to meet the application's needs.

There are some inherent disadvantages of replicating data across systems. By definition, the duplication of data requires that the target system and the system of record be synchronized at some interval to close the gap on having "two versions of the truth" exist for end users. In most cases, this is not real time, so each use case needs to be evaluated to balance latency with the overhead of synchronization. By replicating data to a new data store, there is also the need to re-define security rules in the target environment; it would be a design misstep to allow users a workaround by making information available in one environment that is not available in another, but that means replicating security rules. Finally, there is a cost to the development and maintenance of data replication solutions in the form of ETL tools, custom code maintenance, additional storage and, of course, duplicity of data management.

In the cloud space, there are many options for implementing data layer integrations that are not only powerful but also cost-effective when compared to their on-premise counterparts. Some players include Informatica, Cast Iron, Boomi.com, Talend, Pervasive and Scribe.

Interoperability
Leveraging interoperability as part of an integration strategy unleashes the power of the cloud. Interoperability provides systems with the power to establish synergies by talking with one another through web services interfaces. Architected appropriately, interoperability between systems is a superior strategy over traditional data integration because it eliminates the need to manage duplicate data sets, eliminates the synchronization challenges, allows data to be accessed in real time and quickly aggregates data from multiple systems into information.

Integration through interoperability is lightweight and contextual because your cloud application is only accessing the data that it needs from an external service when it needs it. Service calls are made to services to return information to the end user who is shielded from the actual source of the data. For example, suppose a cloud-based application holds a list of customers and it would be useful to aggregate as much data as possible on this customer. One option would be to subscribe to market data, load it into a local data store, and display it as part of your application. With the interoperability of the cloud, it's possible to simply make calls to a third-party NASDAQ, Hoovers, or D&B service to bring back real-time customer data that you don't have to maintain. There are countless services available in the cloud that are more comprehensive and robust than anything we could develop ourselves.

Interoperability is not limited to external services; it can (and should) be leveraged internally as well. In the same cloud-based customer database, it might be useful to aggregate sales information that is sourced in the ERP system. Instead of duplicating the sales history in the cloud, a preferred solution would be to expose sales history data through a service that can be called to return contextual sales information for a customer. From an end-user standpoint, the experience is seamless because the data is displayed to them in the context of the customer application, but there is no replication, synchronization issues or latency.

The potential of interoperability goes far beyond these simple examples. In fact, it is interoperability that is helping to define Web 2.0. Social networking sites like LinkedIn, Facebook and Twitter have services that are consumed in countless other applications to provide information about people, their networks and personal preferences. Furthermore, some of the fast-growing and most popular services today like Groupon, Living Social and Foursquare leverage interoperability with other services to market to individuals rather than demographics, and have unleashed the potential of crowd-sourcing.

UI Mashups
In the cloud, a special type of interoperability is UI mashups. A UI mashup is a web interface that combines the presentation of two or more sources to create a new one. For example, Google, Yahoo and Bing all have feature-rich mapping applications for location and direction. End users understand the paradigm of these applications because they use them heavily in both their personal and professional lives. That being the case, these mapping applications are used all over the web as mashups to enrich other applications like location finders and routing systems and for location plotting.

The significance of the mashup comes down to reuse and end-user experience. There is a benefit to the cloud developer to be able to tap into and reuse other services (even user interfaces) because doing so drastically reduces development time. It is also a benefit to the end user to work within a familiar context that they already enjoy.

Conclusion
New entrants into the cloud computing space need to understand the full benefit of a cloud solution is not merely in eliminating on-premise hardware. Integrating systems creates synergy and power that exceeds that of traditional paradigms. The vast cloud service community has done much of the hard work already, but businesses need to be smart about how they connect the dots to ensure that cloud applications are Web 2.0 enabled.

About Bill Kalma
Bill Kalma is VP of Technical Services with Model Metrics, an enterprise cloud computing services company. He focuses on the effective scoping, management and delivery of CRM projects from a technical perspective. In his role, Bill works as both the engagement manager to develop projects with Model Metrics’ clients as well as the project manager once the cloud implementation is under way.

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

Register | Sign-in

Reader Feedback: Page 1 of 1

Latest Cloud Developer Stories
In his session at 21st Cloud Expo, Raju Shreewastava, founder of Big Data Trunk, provided a fun and simple way to introduce Machine Leaning to anyone and everyone. He solved a machine learning problem and demonstrated an easy way to be able to do machine learning without even cod...
The past few years have brought a sea change in the way applications are architected, developed, and consumed—increasing both the complexity of testing and the business impact of software failures. How can software testing professionals keep pace with modern application delivery,...
Cloud Expo | DXWorld Expo have announced the conference tracks for Cloud Expo 2018. Cloud Expo will be held June 5-7, 2018, at the Javits Center in New York City, and November 6-8, 2018, at the Santa Clara Convention Center, Santa Clara, CA. Digital Transformation (DX) is a major...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices ...
"Evatronix provides design services to companies that need to integrate the IoT technology in their products but they don't necessarily have the expertise, knowledge and design team to do so," explained Adam Morawiec, VP of Business Development at Evatronix, in this SYS-CON.tv in...
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 News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021



SYS-CON Featured Whitepapers
ADS BY GOOGLE