Friday, September 25, 2009

Business Intelligence (BI) tools list

1.
Oracle Enterprise BI Server


2.
Business Objects Enterprise


3.
SAP NetWeaver BI


4.
SAS Enterprise BI Server


5.
IBM Cognos TM/1 & Executive Viewer


6.
BizzScore Suite


7.
WebFocus


8.
Excel, Performance Point, Analysis Server


9.
QlikView


10.
Microstrategy


11.
Hyperion System


12.
Actuate


13.
IBM Cognos Series 8





source
www.businessintelligencetoolbox.com

List of ETL tools

ETL tools are widely used for extracting, cleaning, transforming and loading data from different systems, often into a data warehouse. The following ETL tools were thoroughly examined on 80 criteria considered important for attaining high productivity Business Intelligence systems that actually add value to your organization. In random order.


1.
Oracle Warehouse Builder (OWB)
11gR1
Oracle 
2.
Data Integrator & Services 
XI 3.0
Business Objects, SAP
3.
IBM Information Server (Datastage)
8.1
IBM
4.
SAS Data Integration Studio
4.2
SAS Institute
5.
PowerCenter
8.5.1
Informatica 
6.
Elixir Repertoire
7.2.2
Elixir
7.
Data Migrator
7.6
Information Builders
8.
SQL Server Integration Services
10
Microsoft 
9.
Talend Open Studio
3.1
Talend
10.
DataFlow Manager
6.5
Pitney Bowes Business Insight
11.
Data Integrator
8.12
Pervasive
12.
Transformation Server
5.4
IBM DataMirror
13.
Transformation Manager
5.2.2
ETL Solutions Ltd.
14.
Data Manager/Decision Stream
8.2
IBM Cognos
15.
Clover ETL
2.5.2
Javlin 
16.
ETL4ALL
4.2
IKAN
17.
DB2 Warehouse Edition
9.1
IBM
18.
Pentaho Data Integration
3.0
Pentaho 
19
Adeptia Integration Server
4.9
Adepti

source
http://www.etltool.com/etltoolslist.htm

Cognos BI

The main objective of Business Intelligence is to bring the right information at the right time. Usually, the data is pulled from several sources and transformed into accurate and consistent information which is stored in the Data Warehouse.

Cognos Business Intelligence solutions help understand, monitor and manage business performance which includes business reporting & analysis, profitability measurement, budgeting, forecasting optimization and cost management.

Cognos is a fast and efficient technique to deliver multidimensional business intelligence data.Building a Data Warehouse and a complete and well performing Information Management system in an organization is a challenge both for the business and technical experts. The most important thing to have in mind is that Business Intelligence is not an IT driven area and it needs to come out as a need from the business and require tight and constant cooperation.That is why in order to deliver valuable information to the business and perform efficiently it is required to understand end-users needs and cooperate closely with the business before implementing Cognos applications.