Category Archives: Data Integration

What Is So Different about BI Today?

The days have changed forever as far as the user interfaces are concerned. In the past, instead of developing user-friendly systems, the technologists had to look for “system-friendly” users. Because of new “consumer-friendly” interfaces, many more people are using computers not only in their workplaces, but also in their personal lives, day in and day out. Since the interfaces developed for the consumers by Lands’ End, L.L Bean, Costco, WebMD and the like are much friendlier, the same consumers – when they function as employees in their jobs – have come to expect similar ease of use and interactivity.

The businesses are aware of it, and if they are not, they should be. They have to not only provide friendly interfaces, but they also have to provide access to information to the right people, at the right time and at the right price so that the employees can make sound business decisions. That is business intelligence in a nutshell.

From a well thought about article on B-Eye Network by Shaku Atre.

Informatica Positioned In Leaders Quadrant In Data Quality Tools

From Informatica Press Release, this is an important win for Informatica.

Informatica Corporation (NASDAQ: INFA), the leading independent provider of data integration software and services, today announced that it has been positioned by Gartner, Inc. in the leaders’ quadrant in the 2008 Magic Quadrant for Data Quality Tools report.

Ted Friedman and Andreas Bitterer, authors of the report state, “leaders in the market demonstrate strength across a complete range of data quality functionality, including profiling, parsing, standardization, matching, validation and enrichment. They exhibit a clear understanding and vision of where the market is headed, including recognition of noncustomer data quality issues and the delivery of enterprise-level data quality implementations. Leaders have an established market presence, significant size and a multinational presence.”

According to the report, “growth, innovation and volatility (via mergers and acquisitions) continue to shape the market for data quality tools. Investment on the part of buyers and vendors is increasing as organizations recognize the value of these tools in master data management and information governance initiatives.” The complete report, including the quadrant graphic, is available on the Informatica web site at

SmartStream Banks on Informatica to Accelerate Customer ROI

From the Press Release -

Informatica Corporation (Nasdaq: INFA), the leading independent provider of data integration software, today announced that SmartStream Technologies, a leading provider of software to the financial services industry, is OEMing the Informatica PowerCenter data integration platform as part of its flagship Transaction Lifecycle Management (TLM) solutions.

In making Informatica PowerCenter the foundation of its SmartStream TLM Business Integration (TLM BI) offering, SmartStream is empowering those customers with complex data environments to accelerate the return on investment of their TLM deployments through the high-performance and cost-effective integration of data involved in transaction cycles.

“The increasing drive to streamline global banking practices means our software needs to manage highly complex and rapid transactions across platforms and different banks. By using Informatica, rather than continually creating bespoke data interfaces, we can enable a faster ROI while freeing our professional services teams to provide more value to customers,” said Neil
Vernon, head of SmartStream’s Product Management Group. “We selected Informatica to power TLM BI following an evaluation where they scored highest against our key criteria of usability, reusability and performance. In addition, it was critical that TLM BI have the focus and support of a recognized best-of-breed vendor such as Informatica.”

Teradata Improves Analytics for Business Users

By Anshu Shrivastava of TMCNet, an article on the new Teradata Warehouse Miner.

The technology of data mining discovers patterns in customer, financial and operational data that can provide valuable business insights, according to Teradata.

The newest enhancements to Teradata Warehouse Miner are supported by the recently announced SAS (News – Alert) Scoring Accelerator for Teradata. Keith Collins, CTO at SAS, said that Teradata’s new functionality, and the recently released SAS Scoring Accelerator, are integrated and complementary solutions.

Teradata’s officials pointed out that the an initial benchmark of the SAS Scoring Accelerator for Teradata demonstrated the ability to process the number of records “45 times faster” than the traditional scoring method.

Moreover, the SAS Scoring Accelerator for Teradata also eliminates the need for manual translation of the SAS scoring code into SQL, or structured query language.

ETI Does Hassle-Free Data Integration

One data integration veteran may be worth a second look. Evolutionary Technology International (ETI) was founded 18 years ago, and unlike many of its data integration competitors, ETI markets its own (homegrown) legacy connectivity solutions.

Getting at mainframe data, after all, is ETI’s bread-and-butter business: its ETI Solution V6 boasts connectors to a wide range of data sources, including legacy platforms of all kinds (e.g., MVS and VSE on the mainframe side, OS/400 and VMS in the minicomputer segment), Unix, Windows, Linux, and all major relational database management systems.

ETI Solution V6 bundles data profiling, data cleansing, and data monitoring facilities, along with change-data-capture capabilities.

ETI’s special sauce, says Wyatt Ciesielka, vice-president of North American sales, is its code-generation engine, which produces extracted, cleansed, and transformed data in the form of an executable compiled in a variety of languages — including C, Java, and COBOL.

Read more at ESJ.