Alation Data Catalog vs. IBM Cognos Analytics vs. IBM InfoSphere Information Server

Alation is well suited to helping a user find a column or even a query using a business term search. In this regard Alation is excellent because it's easy to not only associate these items with each other, but there are also many ways to link the column and/or query to that business term/concept

IBM Cognos Analytics has great scheduling capabilities. A single report can be parameterized (e.g., “Store Manager ID”) and burst to thousands of recipients with their slice of data.IBM Cognos Analytics is a good fit for highly complex, multi-level calculations which can be handled by Report Studio. For example Monthly balance sheet that requires multi step calculation

Incentivized

Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

• Ability to link objects using the @ symbol. It allows us to easily provide a way to get more information or context. So if the business concept is part of a hierarchy, we can link to the other terms in that hierarchy.
• The customization is really helpful. Most object types have robust customization options. Others are less so, but it is improving. We've created multiple custom fields to support our data governance framework.
• The search feature with filtering is helpful in narrowing down what you're looking for.

Incentivized

• We can make dozens of dispatchers all focusing on different types of workloads.
• Friendly user interface, without the need for coding or complicated editing.
• Highly functionality reporting tools.
• We can easily create trigger when a certain threshold are met sending reports or alerts to needed parties.

Incentivized

• IIS best for ETL ,not ELT , and many and diffrent source systems.
• It also can process big data , unstuctured data
• It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems

Incentivized

• The lineage UI is not ready for primetime. I would not recommend this feature for my users at this time because it's too complex to understand and is visually difficult to track down specific paths.
• The underlying infrastructure of the on-premise version of the software is fragile and unnecessarily complicated, using too many modules and technologies.
• The license model of the on-premise version contains too many add-ons. I would like to pay one price and get all of the features.

Incentivized

• IBM Cognos Analytics enables customer data segmentation, which is essential for marketing, improving and streamlining purchasing behavior and preferences. This helps companies create more targeted and effective marketing campaigns.
• Our clients Through data analysis, we can identify and observe trends in the behavior of other clients, allowing us to anticipate needs and adjust strategies to avoid consequences.

Incentivized

• I would be nice to have a new web development environment for DataStage.
• Connectivity Packs such as Pack for SAP Application are a little pricey.
• It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.

Incentivized

For an existing solution, renewing licenses does provide a good return on investment. Additionally, while rolling out scorecards and dashboards with little adhoc capabilities, to end users, cognos is very easily scalable. It also allows to create a solution that has a mix of OLAP and relational data-sources, which is a limitation with other tools. Synchronizing with existing security setup is easy too.

• Scale of implementation
• IBM techsupport

Incentivized

Mostly because the search feature is case sensitive. This causes issues when users are searching for an industry standard acronym. These acronyms exist as attributes in thousands of places across our data ecosystem. Alation allows stewards to endorse attributes so that these endorsed items rise to the top of search results. The problem is no one types acronyms in caps in a search field. Alation returns results matching the case (lower-case) and in several instances the endorsed attributes don't even appear on the first page of results

We have a strong user base (3500 users) that are highly utilizing this tool. Basic users are able to consume content within the applied security model. We have a set of advanced users that really push the limits of Cognos with Report and Query Studio. These users have created a lot of personal content and stored it in 'My Reports'. Users enjoy this flexibility.

Reports can typically be viewed through any browser that can access the server, so the availability is ultimately up to what the company utilizing it is comfortable with allowing, though report development tends to be more picky about browsers and settings as mentioned above. It also has an optional iPad app and general mobile browsing support, but dashboards lack the mobile compatibility. What keeps it from getting a higher score is the desktop tools that are vital to the development process. The compatibility with only Windows when the server has a wide range of compatibility can be a real sore point for a company that outfits its employees exclusively with Mac or Linux machines. Of course, if they are planning on outsourcing the development anyways, it's a rather moot point

Overall no major complaints but it doesn't handle DMR (Dimensionally Modeled for Relational) very well. DMR modelling is a capability that IBM Cognos Framework Manager provides allowing you to specify dimensional information for relational metadata and allows for OLAP-style queries. However, the capability is not very efficient and, for example, if I'm using only 2 columns on a 20-column model, the software is not smart enough to exclude 18 columns and the query side gets progressively larger and larger until it's effectively unusable.

From the RightStart Program to the Customer Success team to technical support, Alation has it all covered. They respond quickly and expertly to answer my questions and fix my problems.

Incentivized

Why is their web application not working as fast as you think it should? They never know, and it is always a a bunch of shots in the dark to find out. Trying to download software from them is like trying to find a book at the library before computers were invented.

Incentivized

Onsite training provided by IBM Cognos was effective and as expected. They did not perform training with our data which was a bit difficult for our end-users.

The online courses they offer are thorough and presented in such a way that someone who isn't already familiar with the general design methodologies used in this field will be capable of making a good design. The training environments are provided as a fully self contained virtual machine with everything needed already to create the environments. We've had some persisting issues with the environments becoming unavailable, but support has been responsive when these issues arise and straightening them out for us

Make sure that any custom tables that you have, are built into your metadata packages. You can still access them via SQL queries in Cognos, but it is much easier to have them as a part of the available metadata packages.

Alation provided the right balance of connection with systems in use, trusted reputation and affordability. The product integrates with current ways of working and does not require reorganisation within other lines of business.

Incentivized

My company selected IBM Congos Analytics because of its advanced features and data representation for data analysis. Its row and column features are very effective for creating dashboards and reports to visualize data. It's chart representation and view format are very attractive and useful for representation.

Incentivized

DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS

The Cognos architecture is well suited for scalability. However, the architecture must be designed with scalability in mind from day one of the implementation. We recently upgraded from 10.1 to 10.2.1 and took the opportunity to revamp our architecture. It is now poised for future growth and scalability.

• Provides a place where people can go to find things
• When we first implemented, someone was concerned that people would now see what a mess our data environment was. I consider that a feature. We can't clean up if we can't see what we have.

Incentivized

• We use the tool for data modeling as it helps in predictive data analysis for complex data, which is very similar to real-life scenarios.
• Options of customizing & scheduling reports as per our requirements basis.
• Has mobile application which works seamless.
• API integration is not upto the mark with very limited options.
• Licensing & Maintenance can go from cheap to expensive depending on the scope.

Incentivized

• Productivity of the development of integration processes.
• Better documentation and governance.
• Reduce training costs of various technologies.