PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.
N/A
Wolters Kluwer CCH® Tagetik
Score 8.0 out of 10
N/A
Tagetik is a corporate performance management solution that unifies budgeting, financial planning, consolidation and management reporting. Tagetik is offered as SaaS, on a private cloud, or on-premise, and can migrate between deployments as needed.
PostgreSQL, unlike other databases, is user-friendly and uses an open-source database. Ideal for relational databases, they can be accessed when speed and efficiency are required. It enables high-availability and disaster recovery replication from instance to instance. PostgreSQL can store data in a JSON format, including hashes, keys, and values. Multi-platform compatibility is also a big selling point. We could, however, use all the DBMS’s cores. While it works well in fast environments, it can be problematic in slower ones or cause multiple master replication.
Scenarios where CCH Tagetik is suitable is when a company have large amounts of data and want to transform, consolidate, store and produce reporting in different year, period etc with complex calculations and allocation. Tagetik is the tool for you in this case and it's very flexible in terms of creating your own business rule, calculation and reporting options with a user friendly interface. I have not thought about scenarios where it is not appropriate to use tagetik yet as the tool covers small and large business financial needs
The stability it offers, its speed of response and its resource management is excellent even in complex database environments and with low-resource machines.
The large amount of resources it has in addition to the many own and third-party tools that are compatible that make productivity greatly increase.
The adaptability in various environments, whether distributed or not, [is a] complete set of configuration options which allows to greatly customize the work configuration according to the needs that are required.
The excellent handling of referential and transactional integrity, its internal security scheme, the ease with which we can create backups are some of the strengths that can be mentioned.
Processes are clearly described in CCH Tagetik ; users can easily find where they are and which action they have to make
Interaction with Excel is really fluid ; the Excel add-in is easy to deploy and to updgrade, in the hand of users. It is reliable provided the internet connection is fast.
Managing hierachies is obvious in CCH Tagetik. Hierarchies are fundamental for a good reporting ; CCH Tagetik has obviously a deep experience of this feature.
SaaS : our experience with CCH Tagetik is of only 1 year, but it technically performs well, the system is reponsive, no shut-down, and updates (every quarter) do not disturb production.
AIH seems to be able to manage very large quantity of data, and to provide advanced analysis functionalities. We did not have time to explore them.
The query syntax for JSON fields is unwieldy when you start getting into complex queries with many joins.
I wish there was a distinction (a flag) you could set for automated scripts vs working in the psql CLI, which would provide an 'Are you sure you want to do X?' type prompt if your query is likely to affect more than a certain number of rows. Especially on updates/deletes. Setting the flag in the headless(scripted) flow would disable the prompt.
Better documentation around JSON and Array aggregation, with more examples of how the data is transformed.
Because in my oppinion Wolters Kluwer CCH Tagetik is one of the most usable tools for consolidation, planning (controlling) and reporting. Its usability is quite easy and innovative. I like the data entry method for the customers with its workflow and tasks, quite easy way to implement a co pilot. And i like the reporting tool, with a lot of customization opportunities.
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
Surprisingly, this platform is a powerhouse ERP system. However, given time, when more and more organization is able to identify how powerful this tool can be, CCH Tagetik is able to stand as a competitive advantage to many of the Financial industry of today. Although, it needs time to understand the logic behind how CCH Tagetik is formed and setup, once it is known to the user, it is an easy day to day operations with minimal maintenance.
CCH Tagetik has alwyas been there in case we need help. In almost 20 years of commercial relationship, I have no evidence of times in which they were not available to answer a question or to solve an issue linked to their products, timely and efficiently.
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
As you can see, speed depends on the applications but also on the hardware that runs them. As far as CCH Tagetik improved, we saw the benefit of a cloud-based solution which could solve many speed performance issues.
There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.
But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.
I got very quick respons. After very little mail iterations, they decided to have online meeting to look together with me to the issue. They tried to solve it during the meeting. I had the impression that the customer care person really knew the system and was able to ask help from other colleagues when needed
The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
Online training is the only form of training we could deploy during the pandemic. This service has been nonethless delivered with the same standards and the same results of the traditional training procedures.
we did it in a coaching model. This allowed us to have 2 key advantages: we got to know the system very well and managed to save on the implementation cost. This worked well, was maybe a bit slower since we had to do this in our spare time. Nevertheless I strongly recommand
Postgres stacks up just [fine] along the other big players in the RDBMS world. It's very popular for a reason. It's very close to MySQL in terms of cost and features - I'd pick either solution and be just as happy. Compared to Oracle it is a MUCH cheaper solution that is just as usable.
I found the Excel piece of IBM Cognos TM1 to be easier to use than CCH Tagetik. It was much easier to customize the data being pulled and the feel of the reports because of that. Other than that, CCH Tagetik has been more user friendly than IBM Cognos TM1. Navigating within the application is much easier. IBM Cognos TM1 had a lot of issues with certain modules that could not be open concurrently; this would often lead to phantom data being entered in the system. I have not had these issues with CCH Tagetik.
A good and performing scalability both on a geographical and a legal entity scale. The link with MS Office suite allows an easy deployment of the application, especially for contributors.
The user-role system has saved us tons of time and thus money. As I mentioned in the "Use Case" section, Postgres is not only used by engineering but also finance to measure how much to charge customers and customer support to debug customer issues. Sure, it's not easy for non-technical employees to psql in and view raw tables, but it has saved engineering hundreds of man-hours that would have had to be spent on building equivalent tools to serve finance or customer support.
It provides incredibly trustworthy storage for wherever customer data dumped in. In our 6 years of Postgres existence, we have not lost a byte of customer data due to Postgres messing up a transaction or during the multiple times the hard-drives failed (thanks to ACID compliance!).
This is less significant, but Postgres is also quite easy to manage (unless you are going above and beyond to squeeze out every last bit of performance). There's not much to configure, and the out of the box settings are quite sane. That has saved us engineers lots of time that would have gone into Postgres administration.
Gave us a tool that can absolutely grow with us to help multi phase implementations.
A significant time savings in terms of the amount of time we used to spend running reports vs. the time we spend now. Unbelievable improvement.
Gives us the option to use CCH Tagetik to solve business problems that perhaps we didn't have when we implemented CCH Tagetik. It gives us options without the possibility of implementing a whole other software package.
