Informatica tool lets noncoders warehouse data

The Informatica PowerAnalyzer business intelligence application has a dashboard-style browser interface with buttons, tabs and pull-down menus to convert tabular data into analytical graphics.

The vendor, Informatica Corp., also has a data warehouse application with preformatted, subject-specific modules, said Sanjay Poonen, the Redwood City, Calif., company's vice president of marketing.

PowerAnalyzer users can click a View SQL button to see the Structured Query Language code that produced the dashboard display, but they need not learn SQL commands.

Poonen said Informatica built PowerAnalyzer with two Java2 Enterprise Edition platforms, IBM WebSphere and WebLogic from BEA Systems Inc. of San Jose, Calif.

The tool runs in Microsoft Windows 2000 or Unix server environments. A software developer kit is included for customizing with Java or Extensible Markup Language.

Take your pick

The Informatica Warehouse comes in four versions: Customer Relationship Analytics, Financial Analytics, Human Resources Analytics and Supply Chain Analytics. Users can customize the warehouse with one or more subject-specific modules.

The warehouse is based on IBM DB2, Microsoft SQL Server 2000 or Oracle9i database management systems, Poonen said.

PowerAnalyzer lists for $50,000 per server CPU. Poonen estimated that a uniprocessor server running PowerAnalyzer could handle up to 500 accounts and 50 concurrent users.

The data warehousing software starts at $250,000 plus $75,000 per subject module.

Contact Informatica at 800-970-1179.


  • business meeting (Monkey Business Images/

    Civic tech volunteers help states with legacy systems

    As COVID-19 exposed vulnerabilities in state and local government IT systems, the newly formed U.S. Digital Response stepped in to help. Its successes offer insight into existing barriers and the future of the civic tech movement.

  • data analytics (

    More visible data helps drive DOD decision-making

    CDOs in the Defense Department are opening up their data to take advantage of artificial intelligence and machine learning tools that help surface insights and improve decision-making.

Stay Connected