SYS-CON Events announced today that Ping Identity, the leader in Internet Identity Security, will exhibit at SYS-CON's 5th International Cloud Expo, which will take place on April 19-21, 2010, at the Jacob Javits Convent...| By Kris Lachor | Article Rating: |
|
| October 28, 2008 01:00 PM EDT | Reads: |
13,223 |
Openadaptor is a software toolkit that may be classified as a lightweight Enterprise Application Integration (EAI) solution. It provides a configurable component framework for connecting various systems and middleware implementations. In less technical parlance, the components are akin to Lego building blocks that users can snap together to build adaptors, which themselves are the metaphorical glue or plumbing between applications. Originally written in 1997 to help a large financial organization integrate its applications with Message Oriented Middleware (MOM), while avoiding vendor lock-in in the process, Openadaptor has since joined the open source community and evolved to become one of the better recognized systems integration tools.
Through years of usage, however, several shortcomings have emerged. The initial architectural concepts of legacy Openadaptor predated the popularity of XML, and a canonical data representation called DataObjects became an integral part of the framework introducing certain performance overheads and overly strict rules as to what can, and what cannot, be exchanged between an adaptor's components. The experience of developing and supporting legacy Openadaptor has also highlighted several other shortcomings, such as the proliferation of custom code that led to the support hurdles, poorly defined and unclear customization and interface points, and the inevitable tendency toward bloat-ware. This was compounded by the fact that some of the inherent functionalities with time became superseded by industry standard equivalents (the clumsy, though effective, proprietary transaction manager would serve as an example).
Published October 28, 2008 Reads 13,223
Copyright © 2008 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By Kris Lachor
Kris Lachor is a senior software developer at Dresdner Kleinwort.
![]() |
higginse 10/28/08 09:41:45 AM EDT | |||
Ismael, Having said that, with your comments in mind, we are looking at adding direct support for updates (and possibly 'upserts') with a view towards squeezing it into our upcoming 3.4.3 (November '08) release of openadaptor. Also it's worth noting that the RawSQLWriter can achieve the same effect - it uses actual SQL strings which get directly executed against the db, albeit with a performance penalty (overhead of constructing the SQL manually, and not being able to compile it). regards P.S. Note that www.openadaptor.org is the primary resource for openadaptor technical support. This affords the best visibility to the dev team, and other oa users. |
||||
![]() |
imatos 10/27/08 11:55:00 AM EDT | |||
Great article. Great tool. It seems a good fit to a new project I'm involved with. The project will require extracting data from a ERP system to load into a data warehouse. The ERP system uses a DB2 UDB database, while the data warehouse will be based on an Oracle database. On a daily basis, it is necessary to extract all the new or updated records from selected tables on our ERP database to load on the data warehouse. From the documentation and the samples, I found that it is very easy to INSERT data in a table, but could not find references to table UPDATES, or more specifically to the situation where an input record may be updating the corresponding record in the target table if it already exists, otherwise it will be inserted on the target table. What would be the best approach to resolve this "UPSERT" type of problem using Openadaptor? Many thanks for the help Ismael |
||||
- The Next-Generation of Business Intelligence
- Whatever the Apple iPad Is, It Apparently Leaks Like a Sieve
- Microsoft’s First Step Toward Cloud Computing
- Six Enterprise Megatrends to Watch in 2010
- Oracle Maps Its Cloud Computing Strategy During Cloud Expo Keynote
- Free Virtual Appliance for Cloud Computing
- Adobe Fiddles with its Web Apps
- How to Secure REST and JSON
- Oracle Sued for Fraud
- UPDATE: Adobe & IE Implicated as China’s Spy Holes
- Chrome Netbook OS; Tablet PCs; LBS; Open Source
- VMware Reportedly Buying Zimbra
- Kindle 2 vs Nook
- The Next-Generation of Business Intelligence
- Whatever the Apple iPad Is, It Apparently Leaks Like a Sieve
- Tactical Cloud Computing Panel at 1st Annual GovIT Expo
- Cloud Expo Show Prospectus Reaches 10,000 IT Marketing Managers
- Microsoft’s First Step Toward Cloud Computing
- Six Enterprise Megatrends to Watch in 2010
- Oracle Maps Its Cloud Computing Strategy During Cloud Expo Keynote
- Free Virtual Appliance for Cloud Computing
- Reflections on Java Command Line Options
- Adobe Fiddles with its Web Apps
- Instant Professionalism Online Despite Yourself...with Ulitzer
- Building a Drag-and-Drop Shopping Cart with AJAX
- What Is AJAX?
- Google Maps! AJAX-Style Web Development Using ASP.NET
- Flashback to January 2006: Exclusive SYS-CON.TV Interviews on "OpenAjax Alliance" Announcement
- AJAXWorld Conference & Expo to Take Place October 2-4, 2006, at the Santa Clara Convention Center, California
- AJAX Sponsor Webcasts Are Now Available at AJAXWorld Website
- How and Why AJAX, Not Java, Became the Favored Technology for Rich Internet Applications
- "Real-World AJAX" One-Day Seminar Arrives in Silicon Valley
- AJAXWorld University Announces AJAX Developer Bootcamp
- AJAX Support In JadeLiquid WebRenderer v3.1
- Where Are RIA Technologies Headed in 2008?
- Struts Validations Framework Using AJAX
SYS-CON Events announced today that Ping Identity, the leader in Internet Identity Security, will exhibit at SYS-CON's 5th International Cloud Expo, which will take place on April 19-21, 2010, at the Jacob Javits Convent...Feb. 8, 2010 06:45 PM EST Reads: 1,011 |
By Krisandra Russo Cloud Computing is receiving a lot of attention, and a number of companies see it as a key to increased agility and efficiency. The technology, however, is still at an early stage and many fundamental challenges need to ...Feb. 8, 2010 06:30 PM EST Reads: 1,630 |
By Pat Romanski What are some of the most important cloud platform strategies any IT executive should consider? The sooner you include these concepts into your cloud roadmap, the better. In his session at the 5th International Cloud Exp...Feb. 8, 2010 05:45 PM EST Reads: 837 |
By Yeshim Deniz SYS-CON Events today announced that Neustar, Inc. (NYSE: NSR), a leading provider of managed services that enable communication across networks, applications and enterprises, is confirmed as an exhibitor at SYS-CON's 5th...Feb. 8, 2010 04:00 PM EST Reads: 1,234 Replies: 1 |
By Pat Romanski SYS-CON Events announced today that R1Soft, a leading developer of Continuous Data Protection (CDP) Software, will exhibit at SYS-CON's 5th International Cloud Expo, which will take place on April 19-21, 2010, at the Jac...Feb. 8, 2010 03:30 PM EST Reads: 777 |










Cloud Computing is receiving a lot of attention, and a number of companies see it as a key to increased agility and efficiency. The technology, however, is still at an early stage and many fundamental challenges need to ...
What are some of the most important cloud platform strategies any IT executive should consider? The sooner you include these concepts into your cloud roadmap, the better. In his session at the 5th International Cloud Exp...
SYS-CON Events today announced that Neustar, Inc. (NYSE: NSR), a leading provider of managed services that enable communication across networks, applications and enterprises, is confirmed as an exhibitor at SYS-CON's 5th...
SYS-CON Events announced today that R1Soft, a leading developer of Continuous Data Protection (CDP) Software, will exhibit at SYS-CON's 5th International Cloud Expo, which will take place on April 19-21, 2010, at the Jac...

COLT, a European provider of business communications and managed services, today announced that the company has selected TIBCO's cloud software to provide organisations throughout Europe with the ability to deploy and manage enterprise applications across physical, virtual and cloud infrastructures ...
I published a link to my post "Choosing a SOA Consultant" in Ulitzer.
Ulitzer is a "new media" site.
The site provides a portal like page for every author. You can look at my page as an example.
Each article's page includes related articles. For example "Choosing a SOA Consultant" page incl...
The cloud crashes make major new stories. We've got two things occurring right now. We've got a massive move into the cloud. That was my first prediction. We have the cloud providers trying to scale up, and perhaps they’ve never scaled up to the levels that they are going to be expected to scale to ...
Frankly I’ve grown weary of the debates over the security of cloud computing. It’s not that I don’t appreciate that there are technical hurdles in front of us, but we have reached a point that a security vulnerability in a single offering, whether that offering is in the public or private cloud, res...


















