The evolution of integration platforms

MDM + DIP = IMP


Comment Once upon a time there were ETL (extract, transform and load) tools and then, quite separately, products for data cleansing and matching started to appear.

However, it took some time before the vendors of the former realised the synergies that existed with the latter. The (partial) exception was Prism, which developed its Quality Manager product as a tool primarily for monitoring the process of data cleansing as opposed to the actual activity of cleansing. However, when Ardent bought Prism, it did so to get its hands on what is now DataStage TX, rather than for Quality Manager.

Nevertheless, it was the descendants of Ardent (subsequently Informix, then Ascential and now IBM) that were the first to recognise the benefits of an integrated platform comprising both ETL and data quality capabilities, which by this time had been augmented by data profiling and analysis.

This trend has continued ever since with, in turn, SAS, Informatica and Business Objects all acquiring major data quality vendors. These companies have been relatively late to follow what is now IBM's lead, but they have done so for a reason in that SAS and Informatica, in particular, have concentrated on metadata management and a unified (as opposed to merely integrated) environment in the first instance and then acquired complementary software, whereas Ascential/IBM did it (is doing it) the other way around.

However, this isn't the end of the story, because data integration has also expanded into, first, support for semi-structured data (SWIFT messages, EDI and so forth) and, more recently, unstructured data. In addition, EII (enterprise information integration) and federated query capability has been added into the mix, with Informatica embedding source code from Composite Software, Business Objects acquiring Medience (recently launched as BusinessObjects Data Federator), IBM integrating with WebSphere Information Integrator, Synopsis building its own facilities, and so on.

This is, effectively, the state of play today (or soon will be) in terms of data integration platforms: ETL, EII, data quality and metadata management in a unified platform. However, things do not stand still and the next step will be to include master data management (MDM) within this platform. As usual, some vendors (notably IBM and SAS) will include their own capabilities while others, at least initially, will partner with third parties. For example, Purisma already runs in conjunction with Business Objects' platform.

Now, if you include MDM along with data integration I think that extends beyond what most people think of as data integration and we might prefer to call that an Information Management Platform (IMP). So, I believe that we will see the extension of data integration platforms (DIP) into IMPs.

Having come to this conclusion, I am planning research for the remainder of this year that will mirror this trend: we have already published an ETL report this year, and an MDM report (written by Harriet Fryman) will shortly be available, while I am starting work on a Data Quality report, which I will follow with a renewed look at the EII/Data Federation market. Finally, I will put all of that together into a Platforms report that will cover both DIPs and IMPs.

Copyright © 2006, IT-Analysis.com

A short biography of Phillip Howard is here.


Other stories you might like

  • Will this be one of the world's first RISC-V laptops?
    A sneak peek at a notebook that could be revealed this year

    Pic As Apple and Qualcomm push for more Arm adoption in the notebook space, we have come across a photo of what could become one of the world's first laptops to use the open-source RISC-V instruction set architecture.

    In an interview with The Register, Calista Redmond, CEO of RISC-V International, signaled we will see a RISC-V laptop revealed sometime this year as the ISA's governing body works to garner more financial and development support from large companies.

    It turns out Philipp Tomsich, chair of RISC-V International's software committee, dangled a photo of what could likely be the laptop in question earlier this month in front of RISC-V Week attendees in Paris.

    Continue reading
  • Did ID.me hoodwink Americans with IRS facial-recognition tech, senators ask
    Biz tells us: Won't someone please think of the ... fraud we've stopped

    Democrat senators want the FTC to investigate "evidence of deceptive statements" made by ID.me regarding the facial-recognition technology it controversially built for Uncle Sam.

    ID.me made headlines this year when the IRS said US taxpayers would have to enroll in the startup's facial-recognition system to access their tax records in the future. After a public backlash, the IRS reconsidered its plans, and said taxpayers could choose non-biometric methods to verify their identity with the agency online.

    Just before the IRS controversy, ID.me said it uses one-to-one face comparisons. "Our one-to-one face match is comparable to taking a selfie to unlock a smartphone. ID.me does not use one-to-many facial recognition, which is more complex and problematic. Further, privacy is core to our mission and we do not sell the personal information of our users," it said in January.

    Continue reading
  • Meet Wizard Spider, the multimillion-dollar gang behind Conti, Ryuk malware
    Russia-linked crime-as-a-service crew is rich, professional – and investing in R&D

    Analysis Wizard Spider, the Russia-linked crew behind high-profile malware Conti, Ryuk and Trickbot, has grown over the past five years into a multimillion-dollar organization that has built a corporate-like operating model, a year-long study has found.

    In a technical report this week, the folks at Prodaft, which has been tracking the cybercrime gang since 2021, outlined its own findings on Wizard Spider, supplemented by info that leaked about the Conti operation in February after the crooks publicly sided with Russia during the illegal invasion of Ukraine.

    What Prodaft found was a gang sitting on assets worth hundreds of millions of dollars funneled from multiple sophisticated malware variants. Wizard Spider, we're told, runs as a business with a complex network of subgroups and teams that target specific types of software, and has associations with other well-known miscreants, including those behind REvil and Qbot (also known as Qakbot or Pinkslipbot).

    Continue reading

Biting the hand that feeds IT © 1998–2022