Common Business Intelligence Softwares

When choosing a business intelligence application, your goal is put an effective Business Intelligence (BI) solution into place, and you’re looking at processes and software. This list represents some of the more frequently used BI applications:

Source Data

  • Microsoft: SQL Server, Access


Oracle: Oracle 11g






Business Objects: N/A

ETL, Data Integration, Warehousing

  • Microsoft: Integration Services aka SSIS (formerly known as DTS)


Oracle: Warehouse Builder




IBM: DB2 Data Warehouse, Warehouse ManagerWebSphere DataStage (ETL) IBM Information Server


Business Objects: Business Objects XI R2: Data Integrator (ETL) Data Federator (virtualization) Rapid Marts (standard platform data marts)

Query and Analysis


Microsoft: SQL Server Analysis Services, Access, Excel


Oracle: Warehouse Builder, Oracle Hyperion Essbase


SAP: Netweaver BI


IBM: Various


Business Objects: Business Objects XI R2: Web Intelligence (query tool) Voyager (OLAP) Desktop Intelligence (query tool)

Reporting, Information

  • Microsoft: SQL Server Reporting Services, Access


Oracle: BI Suite Enterprise & Standard Editions: query, analysis, reporting, Siebel Answers, Interactive Dashboards


SAP: Netweaver BI


IBM: BIRT, Design Studio, Alphablox


Business Objects: Crystal Reports

Other Front-End Tools


Microsoft: Excel Pivot Tables, PerformancePoint 2007 (enterprise scorecarding)


Oracle: Oracle Data Mining


SAP: Netweaver BI


IBM: IBM Intelligent Miner (data mining)


Business Objects: Crystal Xcelsius (visualization tools), Crystal Vision (dashboard), InfoView (BI portal)

Specialty Apps


Microsoft: MS Sharepoint Server 2007 (report distribution)


Oracle: Business domain operational analytics applications, Hyperion System 9 Financial Management, Financial Planning


SAP: ERP Software, Financial Analytics (formerly Outlooksoft)


IBM: Websphere Content Discovery (unstructured search)


Business Objects: Information OnDemand (hosted BI solutions), Performance Management (Formerly Cartesis)

Source – dummies

Leave a Reply

Your email address will not be published. Required fields are marked *