HCL Unica (acquired by HCL Technologies from IBM in late 2018) is a suite of enterprise marketing management tools including marketing automation with cross-channel campaign management, budgeting and forecasting, project workflow management, asset management, brand management and spend management.
N/A
IBM Cognos Analytics
Score 8.2 out of 10
N/A
IBM Cognos is a full-featured business intelligence suite by IBM, designed for larger deployments. It comprises Query Studio, Reporting Studio, Analysis Studio and Event Studio, and Cognos Administration along with tools for Microsoft Office integration, full-text search, and dashboards.
I think it is wel suited for a business with a lot of one on one relations in the database. For example a supermarket that sells products to a client and gives a reduction on that product. It is nice if the selection process is not to complex and does not involve to many calculations. It is also nice if it is very clear what you want to follow up. In our environment we have lots of many-to-many relations. for example one product is held by more then one client. And that client might have more of those products with other clients. These kind of situation demands for a lot of calculations with derived fields(*), and there things go far too slow. Unica is probably not such a good solution for us, because our environment is too complex, and so is to process of creating the selection, we often have to change things in the selection flows. Because of the complexity it is difficult to see what the flow is exactly doing afterwoods, it also takes to much time to modify existing campaigns. The interface is not handy to work with, if you have long lists of variables, of tables or derived fields(*) you have to scroll through trough them, you can not really search them or reorder them. You can not drag and drop fields or other objects like derived fields in the flow, what would be easy if you have to make frequent changes to the proces flow. When you copy objects something the content of the object changes because the links with other objects or lost. (*) derived field: field to calculate something
Our first and most basic scenario was to automatize the creation and publication/sharing of business reports that used to be created manually by employees throughout our organization. Using Cognos for that first use case worked well. The advanced analytics functionalities we used on the aggregated data were also as expected. However, the user interface is not always intuitive, and there is a steep learning curve, so I would recommend Cognos only to large organizations where there is a need for the most advanced functionalities (AI analysis/prediction).
Ability to translate Multiple SQL queries into a very easy to use visual GUI.
Provides the ability to pre-define segments, run them once in off hours, store them in their own system tables for quick youth and a significant reduction in CPU utilization on the database.
It’s use of Reusable objects. Including user variables to pre-define calculations one time, macros that you can create and pass values to parameterize the SQL code And the creation of templates to easily replicate work.
It’s ability to bring in external data on the fly that can very easily be mapped into any flowchart.
It’s flexibility and creating UNIX script via triggers to automate sending of files to multiple vendors with different FTP sites
It’s flexibility in the output layouts that it can create.
Greater integration of real time (Interact) capabilities with outbound channels, in particular IBM eMessage Email & SMS delivery.
Additional outbound channels to be integrated into eMessage, including Facebook Fanpage & Twitter DM broadcasts. At the moment these are possible only through custom additional integration.
Support for additional marketing database technology, e.g. MySQL, Exasol, ParAccel, WX2.
Provision of database technology with software purchase, as Web technology (IBM WebSphere Express) is supplied for free, but no database is supplied - since IBM also market DB2, which is a supported technology it seems a shame.
Sometimes there might be performance issues when dealing with large and complex data.
Although IBM provides full documentation but sometimes it's difficult to find answers to questions and connect with their customer support.
It relies on external tools for data cleaning, transformation and also for some integration tasks. It can also improve on providing wider range of data sources for integration.
There are three main factors to renew a licence: 1) Cost to migrate to another platform would be rather expensive and time consuming, plus the requirement of retraining employees to use a new tool 2) It has been proven time and time again that it is a market leader in the space (10 years +) 3) It can be built upon, with the addition of additional IBM EMM modules - despite theories it does have very strong digital capabilities.
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.
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.
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.
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
- We had to rebuild a part of the datamart afterwards to tighten up and simplify the selection process. But as it was too time consuming to rebuild all the existing campaigns, we no run campaigns on different versions of the datamart. - The response tracking of the campaigns never worked out well, it was impossible to implement a direct response where there is a link between the lead and the response in our operational process
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.
The contact history and the response history are so powerful. You can track whatever you want to help the call center to push relevant offers to our customer. In addition, predictive models can be built, with patience, in IBM Campaign. If you have some complaints from the call center about any campaigns, you can easily validate it into the contact or response history.
In the past Management had used Excel and Workiva capabilities to create the reporting dashboards that were being used to make decisions. Since switching to IBM Cognos Analytics the Company has been much more efficient and decision making has been streamlined. IBM Cognos Analytics was chosen due to its reputation and data visualization capabilities and neither have been wrong.
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.
