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
Cloud Expo & Virtualization 2009 East
Smarter Business Solutions Through Dynamic Infrastructure
Smarter Insights: How the CIO Becomes a Hero Again
Windows Azure
Why VDI?
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun's Incubation Platform: Helping Startups Serve the Enterprise
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,, Talend, Pervasive and Scribe.

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.

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
With more than 30 Kubernetes solutions in the marketplace, it's tempting to think Kubernetes and the vendor ecosystem has solved the problem of operationalizing containers at scale or of automatically managing the elasticity of the underlying infrastructure that these solutions n...
The deluge of IoT sensor data collected from connected devices and the powerful AI required to make that data actionable are giving rise to a hybrid ecosystem in which cloud, on-prem and edge processes become interweaved. Attendees will learn how emerging composable infrastructur...
When building large, cloud-based applications that operate at a high scale, it's important to maintain a high availability and resilience to failures. In order to do that, you must be tolerant of failures, even in light of failures in other areas of your application. "Fly two mis...
Machine learning has taken residence at our cities' cores and now we can finally have "smart cities." Cities are a collection of buildings made to provide the structure and safety necessary for people to function, create and survive. Buildings are a pool of ever-changing performa...
As Cybric's Chief Technology Officer, Mike D. Kail is responsible for the strategic vision and technical direction of the platform. Prior to founding Cybric, Mike was Yahoo's CIO and SVP of Infrastructure, where he led the IT and Data Center functions for the company. He has more...
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 Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)!

Advertise on this site! Contact advertising(at)! 201 802-3021

SYS-CON Featured Whitepapers