Why would a company buy Cognos software on top of Oracle reporting?
According to experts, Oracle has built in a number of reporting facilities, but they are not as mature as Cognos or Business Objects (BO). Find out if you need Cognos software on top of Oracle reporting.
I am not technical but am reviewing BI tools, including Cognos, on a data warehousing project for a client that makes extensive use of Oracle. Their main requirement is to enable senior management to carry out complex sales analysis. They are a global FMCG company. My questions are: Why would a company buy software such as Cognos or Business Objects when you already have built-in reporting/ETL functionality within Oracle 9i/10G (OLAP, Discoverer, BI and so on)? Are there any significant limitations with Oracle?
While it is quite true that Oracle has built in a number of reporting facilities, they are not as mature as Cognos or Business Objects (BO). These tools have been built to provide end users with the simplest possible interface possible, while still allowing for very complex analysis. These tools are very robust and their future is very bright.
The questions you need to answer are: What does your organization want to do that they cannot with the Oracle tools? What are your internal limitations? Realize most of these tools do pretty similar things, and you need to define what you need in your environment. I have been working in environments that only required static reporting, and in that case we built reports with SQL*Plus and the users were happy. I have also worked in companies that used Cognos or BO. These companies needed to provide users with more than just static reports and wanted them to have tools that empower them to create and design their own reports.
All I can say here is that each software has its benefits and limitations, but you need to define what you want out of a tool before you decide it's right. Just because you want to drive a Rolls-Royce does not mean that a Lexus won't do what you want. Everyone has different needs, but you need to understand these before deciding to change. Do not change for the sake of change; change to improve your reporting capabilities.
Dig Deeper on Business intelligence technology platform
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Data Management/Data Warehousing experts
View all Data Management/Data Warehousing questions and answers
Join the conversation
1 comment
-ADS BY GOOGLE
SearchBusinessAnalytics
Easy-to-use coding tools a new opportunity for BI vendors
In a Q&A, Yellowfin CTO Brad Scarff talks about why analytics software vendors have recently introduced low-code tools for ...
Low-code tools serve BI customer needs
With easy-to-use tools for application development a growing trend among BI vendors, Yellowfin CTO Brad Scarff discusses the ...
Augmented analytics tools: Business uses, benefits and barriers
This guide examines the capabilities and potential benefits of augmented analytics technologies and offers guidance on how to use...
SearchAWS
AWS seeks niche in the cloud UC market
AWS could play a bigger role in the cloud UC market in 2020 and beyond by targeting developers and existing AWS customers.
National Australia Bank cashes in on AWS training and certification
Structured training got nearly 1,000 National Australia Bank employees certified on AWS, while AWS-honed tactics such as ...
Overcome these VMware Cloud on AWS migration challenges
Plan ahead for a VMware-to-AWS cloud migration with this breakdown on common challenges organizations face during the move to ...
SearchContentManagement
Acquia acquisition of AgilOne CDP signals CX platform expansion
Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...
Personalization engines help engage and retain customers
Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...
New capabilities added to Alfresco Governance Services
The updates are intended to secure electronically stored information residing across different locations in light of recent ...
SearchOracle
Oracle Autonomous Database shifts IT focus to strategic planning
This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...
Oracle Autonomous Database features free DBAs from routine tasks
Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...
Oracle co-CEO Mark Hurd dead at 62, succession plan looms
Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...
SearchSAP
Understand and fight potential SAP exploits
Without taking the right steps to secure SAP systems, you're creating vulnerabilities for potential exploits. Here's a look at ...
Partners need to target SAP SMB market for cloud transition
In this Q&A, SAP executive Claus Gruenewald discusses how SAP partners are instrumental in servicing the SMB market and how they ...
S/4HANA Cloud integrates Qualtrics for continuous improvement
The latest version of SAP S/4HANA Cloud embeds Qualtrics XM capabilities that provide a way for users to give direct feedback ...
SearchSQLServer
SQL Server database design best practices and tips for DBAs
Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...
SQL Server in Azure database choices and what they offer users
SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...
Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL
In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...