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 Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..

2008 West
DIAMOND SPONSOR:
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
GOLD SPONSORS:
Appsense
User Environment Management – The Third Layer of the Desktop
Cordys
Cloud Computing for Business Agility
EMC
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Intel
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Sensedia
Return on Assests: Bringing Visibility to your SOA Strategy
Symantec
Managing Hybrid Endpoint Environments
VMWare
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
PLATINUM SPONSORS:
Appcelerator
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
GOLD SPONSORS:
ICEsoft
How Can AJAX Improve Homeland Security?
Isomorphic
Beyond Widgets: What a RIA Platform Should Offer
Oracle
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
SYS-CON.TV
Data - SOA's Last Mile
Maximize the business value of SOA using data services

The Need for a Data Delivered as a Service to SOA
Applications and business processes interconnected as services for flexibility aren’t worth anything if the data in them is inaccurate, inconsistent, or not available exactly when needed. If the data stuck inside siloed applications is bad, imagine the calamity when, through an application and business process integration technology, the silos disappear and data from many different applications is commingled.

Without a complementary, standards-based, and flexible technology that delivers holistic, accurate, and timely data as a service to an SOA, typical end-user challenges may include:

  • Implementers that embark on an SOA path, quickly realize that SOA presents the following data-centric challenges that can’t be handled by their SOA platform providers:
  • Varying data volumes and data movement latencies
  • Semantic and syntactic inconsistency of data
  • Poor data quality that is often difficult to measure or monitor
  • Lack of agreement or visibility (single-view) into critical information assets
  • Heterogeneous data silos distributed across the enterprise and beyond
  • Little to no reuse of data integration logic and skills across projects

Therefore, far from making data issues irrelevant, the underlying IT infrastructure poses an actual risk to enterprises that lack a right-time data integration strategy. SOA provides a flexible framework by breaking down barriers between silos of applications and enabling the orchestration of business processes using flexible and reusable application-level or business services. If SOA’s inherent capabilities for flexibility, responsiveness, and reuse are enhanced with the holistic, accurate, and timely information, business agility can definitely be achieved.

What’s needed is a scalable data services technology built on a sophisticated data integration platform that can provide a standards-based data abstraction layer to an SOA, and deliver holistic, accurate, and timely data as a service (see Figure 2). A data service is a modular, reusable, well-defined, business-relevant service that enables the access, integration, and right-time delivery of enterprise data throughout the enterprise and across corporate firewalls. However, unlike application-level or business services, data services are specialized services that are more granular, enable loose-coupling with data sources, are data-centric, and are purpose-built to enable right-time data integration in an SOA.

The data services technology should also be capable of orchestrating or sequencing atomic data services to enable flexible combinations and reuse of sophisticated data integration tasks across projects. As shown in Figure 3, atomic data services must enable sophisticated data integration tasks such as access, profiling, cleansing, transformation, and delivery of data that can be sequenced in various combinations to support the entire data integration lifecycle in an enterprise.

Ideally, a data services technology needs to deliver these sophisticated capabilities to an SOA:

  • Broad access to all complex data contained in any data source in the enterprise
  • Easy and rapid creation of sophisticated, scalable, and reusable data services
  • Orchestration of atomic data services to cover the entire data integration lifecycle
  • Provisioning data in right-time to applications and business processes over a variety of protocols
  • Upfront or proactive data-quality treatments to all data across all data sources
  • Tools for data lineage to support change management and impact analysis
  • Seamless integration with existing IT infrastructure, the cornerstone in an SOA

Finally, as performance and scalability are at the heart of any mission-critical operation, the data services technology should also be able to handle high concurrency and large data volumes that are typical requirements of such demanding environments.

SOA & Integration Competency Centers
An Integration Competency Center or ICC is an infrastructure of people, technology, policies, best practices, and processes focused on rapid, repeatable, and cost-effective deployment of data integration projects critical to meeting organizational objectives. Organizations have found that there’s a direct connection between the caliber of their ICC and their ability to respond quickly to dynamically changing business models, intense competition, and demanding customers. In short, the ICC is the infrastructure responsible to deliver trustworthy data flexibly and at the speed of the business.

Data services technology encourages the creation and management of ICCs by standardizing development processes on common technology standards for greater reuse, supporting a shared services environment, supporting a centralized services environment, and enabling the governance processes of data services and data architecture so that definitions, semantics, and SLAs are maintained by the appropriate parties.

An ICC enabled by a data services technology is thus the perfect enabler for data integration in an SOA since it provides the adaptive architecture and technology foundation required to access and deliver holistic, accurate, and timely data throughout the enterprise (see Figure 4). It also delivers the collaboration tools necessary to align cross-functional teams through a single technology, increasing responsiveness to the changing needs of the business. Finally, it provides a secure, scalable, and responsive platform to guarantee access to mission-critical information to support various projects across the enterprise.

Conclusion
As we’ve seen in this article, a sophisticated and enterprise-grade data services technology can address SOA’s last mile by providing the cornerstone in an SOA for ensuring the availability of holistic and accurate business-critical information at the speed of business.

Resources

About Ash Parikh
Ash Parikh is responsible for driving Informatica’s product strategy around real-time data integration and SOA. He has over 17 years of industry experience in driving product innovation and strategy at technology leaders such as Raining Data, Iopsis Software, BEA, Sun and PeopleSoft. Ash is a well-published industry expert in the field of SOA and distributed computing and is a regular presenter at leading industry technology events like XMLConference, OASIS Symposium, Delphi, AJAXWorld, and JavaOne. He has authored several technical articles in leading journals including DMReview, AlignJournal, XML Journal, JavaWorld, JavaPro, Web Services Journal, and ADT Magazine. He is the co-chair of the SDForum Web services SIG.

About David Lyle
David Lyle is VP of product strategy at Informatica. He helped found and grow Influence Software from 1996 to 1999 as a pioneering company in the development of packaged analytic applications. After Informatica bought Influence in 1999, David?s ideas and leadership following his role as VP of R&D for the Informatica Applications led to the development of Informatica?s innovative cross-vendor metadata lineage capabilities and other patented technologies. In 2005, David co-authored the book Integration Competency Center: An Implementation Methodology with John Schmidt. His current areas of focus include SOA, data services, user experience for enterprise software, and data governance.

About Wei Zheng
Wei Zheng is the principal product manager responsible for Informatica's products and offerings around real time data integration and data services. Before joining Informatica, Wei was the co-founder and CTO of Blazent, an enterprise software start-up focused on operational and BI reporting for enterprise IT assets.

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

Register | Sign-in

Reader Feedback: Page 1 of 1

SOA World Latest Stories
In his session at 20th Cloud Expo, Mike Johnston, an infrastructure engineer at Supergiant.io, discussed how to use Kubernetes to set up a SaaS infrastructure for your business. Mike Johnston is an infrastructure engineer at Supergiant.io with over 12 years of experience designing, dep...
SYS-CON Events announced today that DatacenterDynamics has been named “Media Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY. DatacenterDynamics is a brand of DCD Group, a global B2B media and publ...
Most DevOps journeys involve several phases of maturity. Research shows that the inflection point where organizations begin to see maximum value is when they implement tight integration deploying their code to their infrastructure. Success at this level is the last barrier to at-will d...
DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. Digital Transformation (DX) is a major focus with the introduction of DXWorldEXPO within the program. Successful transformation requires a laser focus ...
"We do one of the best file systems in the world. We learned how to deal with Big Data many years ago and we implemented this knowledge into our software," explained Jakub Ratajczak, Business Development Manager at MooseFS, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8...
Adding public cloud resources to an existing application can be a daunting process. The tools that you currently use to manage the software and hardware outside the cloud aren’t always the best tools to efficiently grow into the cloud. All of the major configuration management tools ha...
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