Feeds

More Excel madness

Sod's Law strikes again!

Top 5 reasons to deploy VMware with Tegile

Comment Recently I wrote that Mobius has the best solution I have seen for spreadsheet management. And, wouldn’t you know it, just a week or two later, I run into another, rather different but equally valid, way of doing much the same thing. Worse, I already knew the product supported Excel (and StarOffice for that matter) but I hadn’t put two and two together.

The product I refer to is Informatica PowerCenter and, specifically, its unstructured option. I was well aware that it supported the ability to read Excel data though I am not sure that I knew that it can also write (or write-back) to Excel spreadsheets. In other words, you could use the data lineage, impact analysis and similar facilities of PowerCenter to track changes to your spreadsheets and you could use the product’s transformation capabilities to consolidate, merge and otherwise manipulate spreadsheet information.

Actually, this isn’t quite as broad a capability as that of Mobius since you can still play around with the spreadsheets outside of the PowerCenter environment and, even within it, you wouldn’t have features such as cell-level locking, but it is powerful nevertheless.

In practice, this unstructured option competes with DataStage TX in terms of semi-structured data, but it also does a lot more than IBM’s solution in terms of its support for unstructured data. Bearing in mind also that PowerCenter is in the process of being integrated with Composite Software’s EII (enterprise information integration) solution then it also potentially competes with WebSphere Information Integrator. However, it is some way off being a fully-fledged competitor to the latter. For example, it doesn’t have any search capabilities and it does not have native access to content repositories—you can access them but there is no comparable facility to, say, the VeniceBridge product that IBM acquired and merged into Information Integrator.

Of course, you can see the point towards which both companies are converging: a single data integration platform that provides all the sorts of facilities that have been mentioned (plus, of course, data quality). However, I don’t think it ends there. While it is a topic for another day, I also think that it makes sense for data integration platforms to include the facilities you need for non-persistent MDM (master data management). That is, where either you just want to build a view across the relevant data or where you simply want to store pointers that reference source systems, but in either case you do not want a master copy of the data. If you go beyond this you start to get very close to being in the applications space and then you are competing with the likes of SAP, which Informatica at least is clear that it does not want to do.

Once you have put all of the above in place then you basically have a data services bus, information services bus, call it what you like. IBM is initially targeting this market with its Information Server while Informatica will be building out from PowerCenter. Notice the different stances—integrated point solutions from IBM, a more monolithic approach from Informatica (the company’s basic method is that everything should, ultimately, be integrated at the engine level not just the metadata level), but that too is a discussion for another day.

Copyright © 2006, IT-Analysis.com

Choosing a cloud hosting partner with confidence

More from The Register

next story
Microsoft to bake Skype into IE, without plugins
Redmond thinks the Object Real-Time Communications API for WebRTC is ready to roll
Mozilla: Spidermonkey ATE Apple's JavaScriptCore, THRASHED Google V8
Moz man claims the win on rivals' own benchmarks
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
FTDI yanks chip-bricking driver from Windows Update, vows to fight on
Next driver to battle fake chips with 'non-invasive' methods
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Ubuntu 14.10 tries pulling a Steve Ballmer on cloudy offerings
Oi, Windows, centOS and openSUSE – behave, we're all friends here
Apple's OS X Yosemite slurps UNSAVED docs into iCloud
Docs, email contacts... shhhlooop, up it goes
Was ist das? Eine neue Suse Linux Enterprise? Ausgezeichnet!
Version 12 first major-number Suse release since 2009
prev story

Whitepapers

Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
Getting ahead of the compliance curve
Learn about new services that make it easy to discover and manage certificates across the enterprise and how to get ahead of the compliance curve.