Ibm

IBM Cognos Review
Gave our organisation more insight in its data, and also in the gaps which were there (and still are).

1,697
3

Valuable Features:

The jobstreams and the ways SQL-scripts can be effectively organized behind icons.

Improvements to My Organization:

  • It gave the organization a better insight in the quality of the data, which in many ways was poor.  
  • It gave the call center the possibility to monitor its effectiveness and efficiency a lot better.

Room for Improvement:

  • The Cognos Data Manager is very datamart/Kimball oriented, and it should be made more flexible, so that it can be used for architectures like Inmon’s or a data vault.
  • Some of its components are not very stable (for instance the lookups).
  • The prescribed working order (dimensions and hierarchies, then fact-tables) makes implementing design adaptations a complex and risky operation: loosen one thread, and a lot more go with it, and this should me made more flexible.

Use of Solution:

I've used it roughly for more than a year.

Stability Issues:

The stability of the Cognos Data Manager is quite good. It doesn’t crash very often, but of course making daily backups of your work is a wise thing to do, as with any tool.

Scalability Issues:

No issues encountered.

Customer Service:

We only had a company provide digital training. Their communication was poor, and they worked with a call center which was totally uneffective.

Technical Support:

I had to make do with what could be found on websites and the internet. The information IBM gives here is solid, but very technical and hard to read. Other websites have to be handled with care as many contributions are more enthusiastic then useful.

Previous Solutions:

I started using Cognos Data Manager because the company I worked for already used it.

To start with SSIS:

  • SSIS is a lot more flexible than the Cognos Data Manager. In the latter, the user is pushed into the direction of a Kimball datamart architecture (data marts, which in a later stage are to be integrated into a integrated solution). SSIS leaves a lot more room to the user to make his or her own decisions (and suffer the consequences of these)
  • The user interface is a lot more user friendly in SSIS, while Cognos Data Manager is somewhat outdated (but can in capable hands still be used very effectively)

In comparison with large scripts in Oracle and SQL Server:

  • The Cognos Data Manager provides a comparison of large scripts for a real and substantial improvement. The icons and jobstreams provide a lot of structure, and are a lot easier to read and interpret than large scripts which can be hundreds of pages long
  • Functions like lookups are very nice, but not always enterily stable (which is a serious drawback in their use)
  • Combining Oracle and SQL Server databases with each other is a definite strong point of the Cognos Data Manager (although no longer a unique selling point)
  • The SQL-scripts are pasted behind the icons. It makes tracing errors and the logic of processes a lot easier

Implementation Team:

It had already been installed, and I got a lot of support from other people in the company. I have no experience with a vendor team.

ROI:

The company I worked for got a better understanding of its poor data quality, and many inefficiences in its operations. But in their mindset, speed is everything, and precision is often regarded as something of a luxury. They got more insights, made a lot of noise about it, but made no structural efforts for improvement.

Other Advice:

  • Consider carefully if you want a Kimball architecture with datamarts for your datawarehouse. If so, the Cognos Data Manager is a good option. If not, I think you should reconsider
  • Consider what exactly you want to achieve with your datawarehouse. For having a historical database, it can be quite effective. For daily control, in most cases a datawarehouse architecture is unsuitable and unwieldy. Direct reports on source systems are than a better option
  • If your organisation has issues with data qualities, a datawarehouse won’t solve these. It can only make these visible (and there are probably a lot of cheaper ways to do that)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
2 visitors found this review helpful
Reviewer75321 li?14143298855bf3770f dddd 4be2 b558 4b20e41f35c7 avatar?1435350167

3 Comments

Anonymous avatar x30

Joop,

I agree that Data Manager has been a great product. Just in case you, and others aren't aware, it reaches End-of-Support by IBM on Sept 30 2015 (this year). Version 10.1.0 was the last version to be released or supported.

IBM has a program, I think, to help you protect your investment when you convert to DataStage, which is their strategic ETL offering. going forward.

It is very sad that Data Manager has been designated as reaching its end-of-life, as it had some unique capabilities not found in other ETL tools.

Regards
Mike

Like (1)19 August 15
A6ef27dc fbdc 430a ac8f 7cbf172934eb avatar?1436196205
Joop MoerkensReal UserTOP 5POPULAR

Hello Mike
Well, modernized or not, I think that the Cognos datamanager is simply reaching the end of the road. Its look and feel are somewhat outdated, and not that much has been done to fix that. I hope Datastage will be an improvement. Especially when an organisation has invested quite a lot in Cognos, shifting to another tool is large and potentially risky operation. By the way: which are the features you most like, and consider unique, of the Cognos Datamanager?
Kind regards
Joop

Like (0)19 August 15
Anonymous avatar x30

Hi Joop

I agree, Data Manager is now dated because there hasn't been significant R&D investment in a while. It was tagged for "end-of-life" some years ago.

I liked that it modeled "the world" in terms of dimensions and facts, unlike most ETL tools, which just think of tables and you get to decide what is a fact or a dimension. There are good things and bad about this approach, which I think you referred to briefly, but on balance I think it was a major strength.

Mike

Like (0)19 August 15

Have A Question About IBM Cognos?

Our experts can help. 204,145 professionals have used our research on 5,524 solutions.
Why do you like it?

Sign Up with Email