	The Business Intelligence Guide
	BI Strategy \| BI Program \| BI Projects \| BI Data \| BI Infrastructure \| BI User Tools \| BI Vendors \| Articles \| BI Blog

Get a FREE Sample of the The Total BI Guide THE LOGICAL ORGANIZATION and receive the TLO NEWSLETTER Just enter your details below
Email:
Name:

Comparing Business Intelligence Solutions

Comparisons between business intelligence solutions include:

Applix TM1
BusinessObjects
Information Performance Management
JetReports
ProClarity [now owned by Microsoft]
iQ4Bis
QlikView
SAS
Targit

Solution	Applix TM1	Business Objects	Information Performance Management
User Rev. P.a. (min)	$10m+	$5m+	$50m+
Multidimensional Analysis	Y	Y	Y
Flat file Reporting	Y	Y	Y
Enterprise Performance Management
Budgeting	Y	Y	Y
Key Performance Indicators	Y	Y	Y
Ready build reports	Y	Y	Y
Customised reports	Y	Y	Y
Forecast Planning	Y	Y	Y
Predictive Analysis	Y	Y	Y
Scorecarding	Y	Y	Y
Dashboards	Y	Y	Y
Advanced Visualisation Techniques	Y	Y	Y
Web Enabled
Web based read/write	Y	Y	Y
Web based reporting	Y	Y	Y
Mobile Enabled	Y	Y	Y
Metadata Management	Y	Y	Y
Data integration/ETL	Y	Y	Y
Microsoft Data Centre Certified	A	Y, BusinessObjects is the only BI tool to have received the MS Data Centre Certification of 99.9% reliability	Microsoft Gold Certified
Database independent	Y	Y	Y
Databases Supported	Microsoft SQL Server, Oracle, Informix, DB2, Sybase	Oracle, MS SQL Server, IBM DB2, Sybase, Access	SQL, Oracle, SQL Analysis Services, Other ODBC compliant
Applications Supported	Navision, SAP R3 & BW, Oracle Financials, Axapta, JDEdwards, PeopleSoft, ACCPAC, MYOB, Greentree, Quanta, AS400, Baan	SAP , Oracle, PeopleSoft, J D Edwards, Siebel, AS 400	Infor Open SOA provides integration to any backend system
Operating Systems Supported	Windows, UNIX, Linux	AIX, Solaris, Windows (XP, 200X), Linux, HP-UX	Windows
Connectivity
ASCII	Y	Y	Y
ODBC	Y	Y	Y
OLEDB	Y	Y	Y
JDBC	Y	Y	Y
Other?	sss	XML, MDX, TXT, CSV, XLS etc.	AAA
Supported Integrated Security Models	Active Directory, LDAP, and can inherit security from other applications such as SAP and Oracle	NT Authentication, LDAP, Active Directory, BusinessObjects Enterprise Security	Active directory, NT Authentication, LDAP

Solution

Jetreports

ProClarity

iQ4bis

User Rev. P.a. (min)

$5m+

$1m+

$50m to $500m

Case studies

Faber Blinds, Scooterbug

Benjamin Moore,

Whitcoulls, Bell Tea, Frucor, Burger King, Konica Minolta, Mitre 10, Merck Sharpe & Dohme, Charles Parsons

Multidimensional Analysis

Y

Y

Y

Flat file Reporting

Y

Y

Y

Enterprise Performance Management

Budgeting

Y

Y

N

Forecast Planning

Y

Y

N

Predictive Analysis

Y

Y

N

Key Performance Indicators

Y

Y

Y

Scorecarding

Y

Y

Y

Dashboards

Y

Y

Y

Advanced Visualisation Techniques

Y

Y

N

Ready build reports

Y

Y

Y

Customised reports

Y

Y

Y

Web Enabled

Web based read/write

N

Y

Y

Web based reporting

Y

Y

Y

Mobile Enabled

N

N

N

Metadata Management

N

Y

Y

Data integration/ETL

Y

Y

Y

Microsoft Data Centre Certified

Jetreports International is Microsoft Gold Certified Partner

Y, ProClarity is owned by Microsoft

Y

Database independent

Y

Y

Y

Databases Supported

C/side, SQL, Access, any ODBC/OLE Compliant database

MS SQL Server 2000/2005, Oracle, Informix, Sybase, AS/400

SQL Server 2000, SQL Server 2005, DB2, Oracle, Any ODBC or OLEDB Compliant RDBMS

Applications Supported

Specific functionality for Microsoft Dynamics NAV & GP, Application independent

Any ODBC or OLE DB complient application databases are supported

Microsoft Dynamics AX, Microsoft Dynamics NA, SAP, JDE, IBM AS400, DB2, Peoplesoft, IScala, Syspro

Operating Systems Supported

Windows

Windows

Windows

Connectivity

ASCII

N

Y

Y

ODBC

Y

Y

Y

OLEDB

N

Y

Y

JDBC

Y

AAA

N

Other?

C/Side

AAA

AAA

Supported Integrated Security Models

C/Side, SQL, Active directory

Windows and SQL integrated security

Active Directory, NT Authentication

Solution

QlikView

SAS

Targit

User Rev. P.a. (min)

$1m+

$10m+

$10m to $50m

Case studies

Northpower, Paint Aids Limited,

Multidimensional Analysis

Y

Y

Y

Flat file Reporting

Y

Y

Y

Enterprise Performance Management

Ready build reports

Y

Y

Y

Customised reports

Y

Y

Y

Budgeting

Y

Y

Y

Forecast Planning

Y

Y

Y

Predictive Analysis

Y

Y

Y

Key Performance Indicators

Y

Y

Y

Scorecarding

Y

Y

Y

Dashboards

Y

Y

Y

Advanced Visualisation Techniques

Y

Y

Y

Web Enabled

Web based read/write

Y

Y

Read only

Web based reporting

Y

Y

Y

Mobile Enabled

Y

Y

Y

Metadata Management

Y

Y

N

Data integration/ETL

Y

Y

Y

Microsoft Data Centre Certified

Y

N

Y

Database independent

Y

Y

Y

Databases Supported

All

SAS, DB2, Oracle, SQL Server, Teradata, SAP, ODBC

Microsoft SQL server, Oracle, DB2

Applications Supported

Application independant. Off the shelf templates available for JDE, SAP, Greentree, Navision, AccPac, Jiwa, SalesLogix,Movex,BPCS and more

Peoplesoft, SAP (R3 & BW), Oracle Apps, Siebel

Pre-built business analytics for Microsoft Dynamics AX and Dynamics NAV, SAP Business One

Operating Systems Supported

Windows (Web clients - Windows,Unix,Linux)

UNIX, LUNIX, Windows, Mainframe

Windows

Connectivity

ASCII

Y

Y

Y

ODBC

Y

Y

Y

OLEDB

Y

Y

N

JDBC

N

Y

N

Other

QlikView SAP Connector, XML, XLS, CSV, HTML, TXT

XML, CSU, TXT

AAA

Supported Integrated Security Models

Multilevel role based internal security, Active directory, NT authentication

LDAP, HOST LDAP, Active Directory

Windows authentication

NEXT: BusinessObjects

Get Clear About BI With This Comprehensive Guide To BI Strategy, Program & Technology

NOW AVAILABLE!

The Logical Organization
A Strategic Guide To Corporate Performance Using Business Intelligence

THE ULTIMATE BI REFERENCE
FOR MANAGERS & CONSULTANTS

Buy NOW! on Amazon

Feature Articles

Using BI To Drive Corporate Performance

Pervasive BI - The Next Step in BI Excellence

The Executive Guide to BI Tools and Solutions

The Executive Guide To Understanding Corporate Data

Using Business Intelligence To Power Boost Corporate Performance