Data Integration and ETL News

News from SugarCRM! The company introduced Sugar Data Center Edition (DCE) – a new product line for SugarCRM partners and enterprise customers, a set of provisioning and monitoring tools enabling service providers and large organizations to deploy and manage multiple instances – distinct versions of SugarCRM – from a centralized management console. Sugar DCE will be delivered in two versions – one for partners and one for customers. Sugar DCE for Partners allows SugarCRM resellers and hosting providers to deliver SugarCRM in a Software-as-a-Service (SaaS) model to their customer base. Sugar DCE for Enterprises allows large companies to manage multiple versions of SugarCRM within their company from a single location.

Is SugarCRM already deployed in your company? Do you keep important customer information in a database or legacy CRM and want to migrate that data to your new SugarCRM account? Ever thought of integrating it, or your SalesForce.com customer list with that in your SugarCRM? Working with SugarCRM on a corporate level becomes more and more attractive.

Apatar, Inc., the provider of open source software tools for the data integration market, today officially announced connectivity to IBM DB2, a family of relational database management system products from IBM that are widely used in enterprise ...

Savio Rodrigues has posted a brief review of Apatar in his InfoWorld Open Source weblog.

The really cool thing is that Apatar provides a visual designer and mapping tool in order to hide the complexity of ETL and data integration from the typical (business) user.

Yep, that’s the idea. Apatar was primarily created and designed as a business user-oriented tool. On top of visualization that Apatar provides, most of the things the user has to do manually is drag-and-drop icons to the visual integrator. That is, no coding whatsoever. And yet another of Apatar’s corporate user-oriented features is the connectivity itself. Apatar provides connectivity to corporate aplications like SalesForce, SugarCRM, GoldMine, etc. and can be used by pretty much any business user not familiat with development at all.

Master data management is sneaking up on SOA as the most overused IT buzzword. CIOs call the transformation a brutal combination of bridging technological silos and managing turf battles.

A 'hidden benefit' of a successful MDM strategy is the contribution it can make to your enterprise's move toward a SOA.

The short answer is, “yes,” but I believe it is conditional to certain changes that have to happen first. Let me focus on what prevents mashups from evolving into the enterprise space right now. According to Gartner, corporate developers spend approximately 65 percent of their effort building bridges between applications. Think about information that’s stored [...]

IBM (NYSE: IBM) today announced open client and partner testing of the new IBM Optim Data Privacy Solution for use with SAP solutions, which provides advanced enterprise data management and data privacy capabilities in support of SAP applications. ...

SAS is organizing a subsidiary to better serve the growing data integration and analysis needs of the federal government, particularly the homeland security and intelligence communities. ebizQ received the following: SAS has been used ...

Dion Hinchcliffe wrote an article discussing the recent mashups’ popularity boost.

“Penetration of mashups in the enterprise is just beginning as their benefits begin to be understood.”

Mashup Tools and Platforms Circa 2008 (The diagram by Dion Hinchcliffe from the article mentioned above)

Well, I couldn’t agree more. Mashup technologies are the next generation approach to infromation integration and management.

The figure above illustrates the mashup market distribution very well, But! =) For some reason Apatar is placed in the code mashup section for developers, which isn’t exactly right. Apatar is a strictly data mashup tool designed for business users. It can, of course, be used by developers, but with the sole purpose of simplifying their work and avoiding writing code. Apatar positions itself as a No-Coding tool aimed at making mashups easy and available for consumers and power users (not developers). So, Apatar should’ve been somewhere in the upper left side of the diagram. =)

By Brad Kenney, May 16, 2008

According to analyst firm Aberdeen Group, 52% of organizations consider the "verification of data accuracy or completeness" to be one of the biggest customer data management challenges. Indeed, the principle of "garbage in, garbage out" is one with which many manufacturing IT managers continually struggle.