Informatica tool lets noncoders warehouse data
- By Patricia Daukantas
- Mar 05, 2003
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.