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.

Featured

  • Records management: Look beyond the NARA mandates

    Pandemic tests electronic records management

    Between the rush enable more virtual collaboration, stalled digitization of archived records and managing records that reside in datasets, records management executives are sorting through new challenges.

  • boy learning at home (Travelpixs/Shutterstock.com)

    Tucson’s community wireless bridges the digital divide

    The city built cell sites at government-owned facilities such as fire departments and libraries that were already connected to Tucson’s existing fiber backbone.

Stay Connected