Talend Open Studio [EOL] Reviews

Our client wanted an open-source ETL tool to load data from his ERP to PostgreSQL Data Warehouse. Our company usually uses Microsoft technologies, but since the client wanted an open-source product, we used Talend and Postgres based on the client's requirements. So they just used it to pull data from the ERP source to PostgreSQL Data Warehouse.

You can do pretty advanced tasks, like using a code generator at times. You can even go to the Java code, and Talend Open Studio can be customized as much as you want. With other products, like Microsoft SQL Server Integration Services, you are limited to the UI interface, because of which you cannot do a lot of customization. The community of Talend Open Studio is very large, and it's an open-source tool to which others can add features.

When speaking of the ETL capabilities of Microsoft, I would say that the documentation of Microsoft is very much better than Talend.

Usually, I go to the community of Stack Overflow to check answers to my doubts or queries, so Microsoft provides all details since its documentation is great. The graphical interface of Microsoft is much better than Talend. Talend Open Studio's interface does not provide a good experience, especially when compared to Microsoft products.

In the future, I would like to see better documentation and a more enhanced graphical interface in Talend Open Studio.

The performance of Talend Open Studio compared to Microsoft is weak, and I think it is because Talend Open Studio runs on Java. Java is slow compared to Microsoft, which uses C-Sharp in the backend. Performance-wise, Talend Open Studio is a bit slow.

Microsoft products are usually used in Microsoft's environment, and maybe because it's a native environment where everything is integrated, causing the performance to be better. In general, I cannot clearly state whether Microsoft or Talend offers better performance. With my experience, I believe Microsoft's products are better in terms of performance than Talend Open Studio.

The installation process of Talend Open Studio can be improved. Suppose you download Talend Open Studio during the installation process. In that case, Talend should check if Java exists in the user's system, and if it doesn't, it should take you to the link where you can download Java's compatible version with Talend.

I have been using Talend Open Studio for approximately two to three years. I currently use Talend Open Studio Version 8.

Stability-wise, I rate the solution an eight out of ten.

Five users, including engineers, business intelligence developers, data management consultants, and developers in my company, are using the solution.

I don't have a clear idea about the scalability of Talend Open Studio. I think Microsoft's scalability is better since you can install it on a cluster.

I did not use certain aspects of scalability to check how much I can distribute the tool in the architecture and find where we can have multiple nodes around the same ETL. I worked with one server and could run just one instance using it.

Regarding Talend Data Management Platform, I want to communicate with the support team of Talend because the installation media is not available on their website, and I have to order it. It's not good for a developer who wants to start with their product since there is no trial version.
One has to first purchase a license and start learning about it. If Talend wants to have new clients, it's not a good idea not to provide a client version. Microsoft does provide developer versions, so anyone can install them as a developer, and it is in the production phase, they push out the license.
I rate the technical support a seven out of ten.

Previously, I used Microsoft SQL Server Integration Services, Microsoft Active Directory, along with Microsoft's business intelligence stack, consisting of SQL Server Database, MDM integration services, OLAP cubes, and Power BI for its dashboards. I have also used Pentaho Data Integration.

Talend Open Studio is deployed on-premises.

Talend Open Studio's installation process is easy. One just needs to install Java before installing the product.

It is an open-source tool which means it is a free solution.

The cloud-based version of the product is paid.

The additional costs of the solution would be the operation systems, servers, and hardware. If the OS is Linux, you can use the tool directly without a server from Windows. Some costs might be attached to the infrastructure after the tool's deployment, which is mostly applicable to all products. All ETL tools require a team to support the project after they go live.

Maintenance is required not because of Talend, so there is a team to help each client adapt to the ETL account and change the data source.

There is a team of two members for handling the solution's maintenance of our clients. It is not that there is always a change in the data source, but when it happens, our clients contact us and ask us to edit the ETL according to the changes.

I would recommend the solution to those planning to use it.

When comparing Talend Open Studio, I saw many other products with better documentation and UI that are more scalable.

I rate the solution a seven and a half to eight out of ten.

We are currently using the free version. We use the solution to extract loads from the source system into the entire house. We are also doing API and data integrations from TXT or XML files.

Though we are not currently using it for big data, there is a plan to extract data from MongoDB.

The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB. This is an excellent tool for big data and API integration.

Comparing Talend Open Studio with SSIS, Informatica, or Data Services, I think the overall workspace concept can be improved since these other solutions have workflows and data flows.

I have been using Talend Open Studio for the past three months.

The solution is stable enough. It's a mature tool. It is a bit complex in a few areas, such as when writing your ETL Jobs, because tLoop is slightly confusing.

I have used SSIS, SAP Data Services, and Informatica to a small extent in my previous companies. My current company uses Talend.

We currently use the free version, where we don't get the built-in scheduler. We had to deploy the job on the server as a file and, using the CRON jobs, schedule the batch or shell file. We can deploy the solution and the ETL jobs in ten or 15 minutes.

We are using the tool's free version because the enterprise version is a little expensive.

You would need three enterprise servers if you are going for a full-scale lifecycle, like development, quality, and production. That would be expensive because the servers have yearly costs.

We can only have one user in the free version. We are now wondering whether we should go for the enterprise version or switch to a different platform, like the HANA platform, HANA cloud, or Datasphere. Or another platform called Encarta. There are multiple technologies we are exploring.

It's a good tool overall, but that depends on whether you have the enterprise version. The free version is not for a team in which you have more than one member. In this case, you have to go for the enterprise version, which is a bit expensive.

Likewise, you do not get support with the free version, so you won't speak with tech support. There is, however, a community with a knowledge base in forums.

You also get the scheduler, the deployment, and everything with the enterprise version. You could deploy the solution on the server and then schedule the jobs. Likewise, you get logging and an audit trail of your jobs. Currently, we maintain these jobs manually.

They should make purchasing the servers for the enterprise version a one-time payment, where you buy the server, and that should be it. The yearly cost is what makes Talend not a great tool.

Talend is fine if you are only using it for the ETL tools. However, there are other options, such as SSIS, Informatica, and SAP Data Services, which are not promising for Talend Open Studio. Some things are easier with other tools. Talend is logical, but a few things are not very straightforward. If there is an option to choose from other ETL tools, I would rate Informatica number one, in second place, maybe SSIS, and then maybe Talend.

If Talend Open Studio is cheaper than other solutions, you can go for it.

I use the open-source version of this solution. It's data integration-related. Right now, I'm doing some legacy TL into a new enterprise data repository.

When the tool has an error, the error-handling is not that user-friendly. It might just be my inexperience with the tool, but I struggle a lot with finding my layers sometimes. I think my biggest problem with the tool is that the errors are very hard to debug.

Our special need is geospatial data, so that could be included as part of the tool and not only as an add-on. It's always hard to do add-ons and tools when it's a third party, and every time there's going to be an upgrade, you don't know if it will keep working. It would be great if they were included as part of the main tool, like FME. That would be my main concern about the Talend tool right now.

I have been using this solution for about a month. 

The solution is stable. 

The solution has add-ons that you can add. I'm dealing with geospatial data, and you have to have add-ons to do that, but I haven't gotten a chance to add them yet. The first add-on I tried didn't work, but I think it might just be outdated and not compatible with the version of the product that I have.

There are two of us using this solution, my colleague and myself, but in the next month or so we are going to get the Professional version in a private cloud environment. We're exploring the tool to decide if it's going to become our tool of choice for the data repository and data warehouse. Right now, we're working locally with the open-source version of it, but we're trying to decide if Talend is the right tool for us and in order to do that, we want to have the proper version of Talend in the proper environment and then do all the tests.

FME has been used for a long time at my company, strictly for managing geospatial data. Now, we're creating an enterprise repository, and we need to deal with the regular data plus the geospatial data together, so we're trying to find a tool that will be able to handle both of these types of data, and manage all of the enterprise requirements that we have. We have used solutions like FME, but I don't believe there was any other tool that was used on the scale that we're trying to use Talend now.

The initial setup was pretty straightforward. I didn't have many problems installing it. It seemed very straightforward to me. 

Deployment can take a few hours, depending on your environment, because it requires some things that you may need to install if you're missing them. I think it took me probably under an hour to do it.

I did the deployment myself on my local workstation. 

Right now, because we're using the open-source version, there's no cost. However, down the road when we use the Professional version, there will be costs. I don't know what the cost will be because I'm not involved in that, but I know that there is a license at that point.

I would rate this solution as a seven out of ten. 

I am using Talend Open Studio for ETL. I extra data from APIs and transform it for the data warehouse.

The most valuable feature of Talend Open Studio is the tMap component. There is a lot of functionality in one component.

The stability of the solution could improve when running jobs. There can be errors when running projects but in the end, it works well and the errors do not impact the result.

I have been using Talend Open Studio for approximately one month.

There are times in our usage when the solution crashes. When we are running jobs that are more than one or two it can crash or not work well.

I rate the stability of Talend Open Studio a five out of ten.

We have approximately eight people using this solution in my company.

The solution is scalable.

I have used Informatica before Talend Open Studio and when comparing the two, the interface is more intuitive in Talend Open Studio.

The setup of Talend Open Studio is simple. The process took approximately two hours and it was my first experience.

I rate the initial setup of Talend Open Studio a ten out of ten.

I implemented the solution.

I am using the open-source version and it is free.

The solution does not require any maintenance.

I recommend this solution to beginners. It is free and the interface is intuitive and has a lot of helpful components.

I rate Talend Open Studio an eight out of ten.

I primarily use the solution for integration. I consolidate data from several different databases and spreadsheets and merge systems into Amazon Redshift.

The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily.

We have a good integration with Artifactory and a good integration with GitHub. 

I don't see the need for anything. At the moment, Talend is a good complete product while at the same time not being overwhelming.

What I really don't like is the TAC, which is the Talent Administration Console. It's currently slow, old technology. It's obsolete and ugly to use. The studio is great, whereas TAC is on the other side of the spectrum. Actually, in AWS, in many cases, we are ditching the TAC and we are using Amazon-provided services, like Lambda functions, to code the Talend files produced by Talend Studio.

The server-side should be completely revamped.

I've been dealing with the solution for more than three years.

There are two pairs of version keys that parallelize, which is not available in the free version. However, when you can parallelize your jobs you can achieve a good degree of scalability. This is one of the points where Talend shines compared to, for example, Informatica. Informatica is designed to do one record at a time. It requires expert support and general competence in the product.

Talend, by default, can be very efficient, especially using the bulk load and bulk insert components, which, at the moment we are using. We are moving to approximately 10 terabytes of data daily. Notwithstanding the load, we had to tweak very, very little. Using standard components we could achieve our overall needs.

The fact that the technical support is out of China means that sometimes the engineers don't have a good command of the English language. That could hinder the overall experience. Apart from that, most of the incidents were resolved in 48 hours. Therefore, we're pretty satisfied with the level of service we've received.

I have previously worked with Informatica and TIBCO. I still believe Talent is superior. 

Obviously, being on AWS, we're using Linux AMI machines or vertical machines, using two machines. The setup was very easy. The only difficult part was to set up to the current time zone, however, this is nothing to do with Talend. We were having issues when Talend jobs were reporting the wrong date when they arrived because the set up was ETC rather than the local time zone.

Setting up Talend and setting up the administration console at the Tac server was very, very easy for somebody with a Linux System Administration skillset.

I set up the solution on my own.

I don't deal with corporate and pricing. I am just an IT Consultant. I honestly don't know the costs to run the solution. I don't know the price. I know people in the finance department are often complaining about the price, however, I don't know what the exact number is. 

It's all relative, after all. I have a very strong Oracle background and the Oracle price is totally outrageous. I don't believe that Talend prices are in the same ballpark as Oracle. I don't understand why people are complaining. That said, I don't deal with signing contracts and processes so I really don't know.

I am an IT Consultant. I use it currently in my job. I'm providing services to a company in Australia, using Talend.

I would advise others to use the Studio. If you have to pay for some license to use the key parallelize component, it's a good idea to do it. However, don't use the TAC. Use the other orchestration services like Control-M or AWS functions such as AWS Lambda. Don't use the TAC. The TAC is really ugly.

Overall, I'd rate the solution eight out of ten. I'd rate it higher, however, the TAC is unreliable. It's a big part of the solution, and, while I do really appreciate Talend Studio and the ability to link into a producer to make a Java code, which is ugly, I don't care because the job is done anyway. The fact that the orchestration is creating execution plans, from the TAC it's fine. However, when the running of the execution plan, sometimes there are issues. The job remains stuck on the actual server. I've had a lot of issues with TAC. 

We use the solution for integration, warehousing, and enterprise service costs.

The technical team uses media resources from Facebook and other social media platforms for ETL.

It is easy to use and covers most of the functions needed. We can use the code without any extra effort. The open source is very good. They have the same commercials with additional connectors. The graphical design environment is also very easy.

The solution needs more integrations.

I have been using Talend Open Studio for two or three years.

The product is very stable.

The solution’s scalability is good. We have five users and are building ETL integration and design to implement with another system. We have three licenses for developers.

We worked with the SSI, but it had very few primitive integrations and was hard to use. We switched to Talend because of the integration of two-way communication. You can add components for that warehouse for the quality. It is a complete platform for integration.

The initial setup is very efficient and takes about a half day to complete with configuration and needed components.

Talend gives you what you want without hiring new people and offers extra services. They train mid-senior developers to use it perfectly.

The product’s pricing is reasonable. It has an annual subscription.

I recommend the solution because it has a huge community in which to get support. We have additional connectors from the community and support.

Overall, I rate the solution a nine out of ten.

My company uses Talend Open Studio to support ETL processes.

The most valuable feature of the solution is that it is an open-source tool. For all the components of the tool, you can work on the desktop version, and later on, once the component and ETL transformation are completed, we can move to the cloud. With other tools, trial versions are available only for one month. Talend makes available an open-source community version, which is helpful for ETL transformation.

Talend Open Studio is in Java language, and right now, you can only use the debug functionality in Java. I see that people who know programming languages other than Java currently face difficulties. The aforementioned area can be of concern where improvements can be considered to help non-Java users.

I have been using Talend Open Studio for a year. I use the solution's latest version. I work as a system integrator in my company.

Stability-wise, I rate the solution an eight out of ten.

Scalability-wise, I rate the solution an eight out of ten.

Four people in my company, consisting of data engineers, data analysts, and data scientists, use the solution.

I haven't communicated with the solution's technical support since one can quickly grab any information from the product's documentation.

Informatica and Azure are some of the products I have used in the past. Based on clients' requirements, my company chose Talend Open Studio over Informatica.

The initial setup of the product was very easy.

The solution is deployed on an on-premises model.

Based on the log file and how the transformation and aggregation work, within five three to five minutes, the transformation happens.

There is no maintenance required for the product in my company.

I recommend the product to those who plan to use it.

I rate the overall solution a seven out of ten.

I use Talend for different projects as I am studying business intelligence. 

I am using Talend for data integration and integrating Oracle and SQL Server, specifically using it for collecting data from Oracle and charging it to SQL Server.

The rapidity of integration with data may be one of the valuable features. Talend is easy to use due to its interface, which has helped in working with columns and data integration.

I faced a problem with the connection between Oracle and SQL Server due to a port issue.

I have been using it for two years.

Talend Open Studio is a scalable solution.

The initial setup is easy.

I am using the open-source version of the solution, so there are no extra costs for any feature.

Overall, I would rate it an eight out of ten.

I use Open Studio for the day-to-day management of our data architecture warehouse. 

Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement.

Open Studio's pipelines could be improved. It's also lagging behind as the market moves toward the cloud and needs to provide better serviceability. In the next release, Open Studio should include cloud storage as an input.

I've been using Open Studio for four to five years.

Open Studio's stability isn't great - it seems to need a patch every month and has a lot of security issues.

Talend's technical support isn't very good and not worth the money we spend on it.

Neutral

The initial setup is pretty easy.

Open Studio has a basic license and additional costs for services, including customer support and technical assistance.

I would recommend Open Studio for data operations, but potential customers should be aware of the lack of support and technical expertise Talend provides. I rate Open Studio as six out of ten.

The ease to use is great. You've got a lot of functionalities in there. The kind of connectors that you have within Talend is actually quite good. If you look at Talend, it has got more than 900 plus connectors that you can work with. You basically can work with a variety of data sources. There's no limit to it. That is one of the key benefits of Talend.

The initial setup is easy.

The solution is stable.

It's a scalable product.

Technical support is helpful.

It is user-friendly and the interface is good. 

The integration capabilities have been fine. 

Nothing comes to mind in terms of areas of improvement. 

Multiple products are there within the product suite. That can be actually trimmed down. Instead of having multiple products, what they can do is they can have a smaller set of products. That would be better.

You need a Java virtual machine, version 11. Anything below that is not going to work.

Technical support could answer queries a bit faster. 

I just installed the solution two or three weeks ago. 

The stability is very good. There are no bugs or glitches and it doesn't crash or freeze. The reliability is good.

It can scale as needed. That's not a problem.

We have four or five users using the solution in our company. They are developers. 

Technical support has been quite good. We are very happy with them so far.

Of course, they could always be more responsive.  

Positive

It's quite simple to set up. It's all about the installation. Just you need to click on the main file, and then it's just next, next, next. That's it. The one thing that you need to make sure of is that you have a JVM of version 11. It's just a standard installation. However, after that, the main thing that you need to make sure of is that you have a Java virtual machine, version 11. Anything below that will not work.

The pricing is reasonable. 

I'd rate the pricing on offer a five out of five. they make it very affordable. 

We also looked at Informatica. That is one of the leading platforms in the data integration space. Both solutions have got the same capabilities, however, the good thing about Talend is that is the cost. It's a bit cheaper.

The solution is deployed on my personal laptop.

I'd rate the solution nine out of ten.