Informatica promises speedier report development

Informatica 9.6 borrows a few techniques from agile development to hasten the delivery of business intelligence

Informatica 9.6 provides interfaces for the business and the IT department.

Informatica 9.6 provides interfaces for the business and the IT department.

Informatica hopes to save business analysts time by allowing them to build their own queries and reports, without requiring the IT department to do all the assembly work.

Borrowing from agile programming methodology, the newly released Informatica PowerCenter 9.6 "allows business analysts to do virtual integration of data quickly so they can see the results," said Todd Goldman, Informatica vice president and general manager of enterprise data integration. "The whole development process is accelerated as a result."

Informatica predicts that use of this new approach can speed the delivery of business analysis products such as reports and dashboards by five times.

With this new release, a business analyst can connect to the data sources directly from his or her Web console, and build a working prototype of the desired product.

The analyst can pull specific data columns of interest, using the software's data virtualization capabilities to merge multiple sources of data. The software will present to the analyst a prototype with the data included, allowing the analyst to make additional changes. Only when the analyst has finished designing the work product is it sent to the developers to finalize.

"It allows the data analysts to do virtual integration quickly, and see the results. When they pass it off to the developers they know they are getting exactly what they expected," Goldman said.

Goldman noted with earlier versions of Informatica, development could take time because business analysts had no way of viewing the results from the specifications they provided to developers.

As a result, the analyst wouldn't get to see the end product until the developer had finished the design. If anything needed to be changed -- such as adding another column -- the analyst would have to task the developer with further modification.

The new approach reduces this back and forth between the analyst and the developer.

"Business analysts are able to self-correct earlier in the process because they can see the results up-front," Goldman said.

Informatica has offered this prototyping capability before through a combination of two add-on products, namely the company's ETL (extract, transform and load) software, and its data visualization product. Informatica PowerCenter 9.6, which is the core Informatica data integration product, now offers this capability natively.

The Informatica 9.6 suite offers a number of other new capabilities as well.

The company's Informatica Data Quality software provides a new way to handle dirty data, which is to say data that has not been formatted correctly. Dirty data may include, for instance, a person's name that was not capitalized.

The Data Quality software has long had the ability to do data correction. Now the software includes the ability to set up processes to route questionable data to a specific individual. Before, all the exceptions were just compiled in a file, which then had to be parsed by the IT staff. Now a single individual can be appointed to inspect and correct the data. Informatica calls this feature "holistic data stewardship."

"It provides a business process to allow people to remediate exceptions that aren't automatically fixed," Goldman said.

Informatica PowerCenter 9.6 comes in three editions: standard, advanced, and a new premium edition. The premium edition offers process monitoring, which can assure that a processing task completes within a required time, and can send alerts when the task may not complete in this timeframe. Informatica declined to provide pricing information for the new product, citing variability in costs from customer to customer

The company also offers a free trial version of Informatica PowerCenter for exploring use of the technology for big data styled deployments.

With this release, Informatica also provides a software development kit (SDK) for adding new data sources. The Informatica software can connect over 100 data sources, but the SDK can be used to build connectors to other data sources.

About 2,000 organizations used the Informatica software to analyze more than two billion records a day. The company also offers a hosted version of its software, Informatica Cloud.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is

Join the PC World newsletter!

Error: Please check your email address.

Tags applicationsinformaticasoftwarebusiness intelligence

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Cool Tech

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

D-Link PowerLine AV2 2000 Gigabit Network Kit

Learn more >

ASUS ROG Swift PG279Q – Reign beyond virtual world

Learn more >

D-Link TAIPAN AC3200 Ultra Wi-Fi Modem Router (DSL-4320L)

Learn more >

Xiro Drone Xplorer V -3 Axis Gimbal & 1080p Full HD 14MP Camera

Learn more >

Crucial® BX200 SATA 2.5” 7mm (with 9.5mm adapter) Internal Solid State Drive

Learn more >

Gadgets & Things


Learn more >

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

Lexar Professional 2000x SDHC™/SDXC™ UHS-II cards

Learn more >

Family Friendly

Lexar Professional 2000x SDHC™/SDXC™ UHS-II cards

Learn more >

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

ASUS VivoPC VM62 - Incredibly Powerful, Unbelievably Small

Learn more >

Stocking Stuffer

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

Lexar Professional 2000x SDHC™/SDXC™ UHS-II cards

Learn more >

Christmas Gift Guide

Click for more ›

Most Popular Reviews

Best Deals on PC World

Latest News Articles


GGG Evaluation Team

Kathy Cassidy


First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.

Anthony Grifoni


For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.

Steph Mundell


The Fujitsu LifeBook UH574 allowed for great mobility without being obnoxiously heavy or clunky. Its twelve hours of battery life did not disappoint.

Andrew Mitsi


The screen was particularly good. It is bright and visible from most angles, however heat is an issue, particularly around the Windows button on the front, and on the back where the battery housing is located.

Simon Harriott


My first impression after unboxing the Q702 is that it is a nice looking unit. Styling is somewhat minimalist but very effective. The tablet part, once detached, has a nice weight, and no buttons or switches are located in awkward or intrusive positions.


Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?