In terms of valuable features, when comparing PMC to TAC, TAC is more centered around the user configuration than the project configuration. If you look at the Talend framework as a whole, you need your Talend administration center, you need a Studio and you need job servers. But there are a few things with respect to job rules, profiling, and project creation which are more advanced in PMC versus TAC. When I say more advanced, in the normal Talend administration center you do not have a super admin and you can have multiple admins who can control their own application. Today, if Talend is used by 10 different applications on TAC, one admin can create those projects for those teams and all other elements which are on-premise. There, you can create multiple admin rules where each application can have its own admins and they can take care of their deployment and they can manage their own environments, etc.... But on the on-premise solution you do not have that, which is a disadvantage.

Let's say in an organization there are multiple applications using Talend. If you run on TAC, you have one admin who has to manage all these projects - assigning projects, creating user rules, providing them access to different environments, you have a dev test and fraud environment. All those things have to be managed by a single admin or maybe one or two admins who have access. But in TMC, which is the Talend management console, you can create sub-admins.

One would be a super admin and you can create those sub-admins who take care of all these things. If I have five applications that are using this solution and I am the admin I don't have to understand their use case and how they want to deploy and all those things. I just give the rules to that admin and that admin takes care of everything. The super admin gives it to those application admins and the application admins can take care of their environment, their deployment process, and creating user rules, etc...

Another thing about the cloud solution is that you don't have to worry about any upgrades. On-premise you have to upgrade your TAC and then you have to upgrade your Studio, which is an effort and time consuming. But on cloud there are automated upgrades, where they get automatically pushed. Then with the Studios, you have to just upgrade that. That is a backwards compatibility. For example, if your Studio is on 7.1 and then the remote engine is on 7.3, that is a backward compatibility. But it's advisable to upgrade your Studios as soon as your cloud instances get upgraded.

The product's integration with PostgreSQL and Jira has been helpful for us. Its performance is good. However, we do not use it for large data sets. 

The transformations are built in and come as a package for us to drag and drop and complete in one go. The main platform of this tool is Java and if you know how to use Java, it will be a very easy tool to use.

Talend Data integration has a wide library of connectors.