Talend Open Studio Reviews

We use the Professional version of Talend for data integration between our IBM mainframe and Oracle to populate the Enterprise data warehouse.

It handles feeds from heterogeneous sources such as MS SQL, PostgreSQL, and flat files.

This solution has improved our overall time to value for data ingestion.

The most valuable features of this solution are slowly changing dimension components, ELT support, and Bulk loading support.

Inter-version compatibility is a problem, and migration projects between versions are required. The migration between version 5 and 6 was particularly painful for us as numerous components we had used were "end of life" in 5 and not present in 6, because of Java version upgrade issues, I think.  We had not re-generated the executable from previous upgrades, so had to put some code through what effectively was a two version upgrade, to ensure we cleared the Java version issue.

We have been using this solution for twelve years.

We use this solution for data integration, especially in our big data projects.

For the past year, we have also been using Talend Open Studio for process automation. Some of the operations done by human beings are now automated. We also deliver this solution to our customers. 

Currently, all of the solutions that we deliver to our customers are on-premises.

This product is going to replace any engagement with human beings. For example, we have integrated with several systems but we do not do the integration manually. Another example is that we track lots of servers and our scheduled workflow checks functionality and performance related to our systems. Talend sends us notifications via email, and can also update our database. This means that we don't need to have somebody sitting in front of a PC, monitoring processes and behavior. 

We also use this solution for metadata management and for data quality management.

The interface is very user-friendly.

The solution's API and integration are very important to us.

We most often use the ETL features, and then export to, for example, chart files. We also use functions related to connectors, for example, integrating with relational database management in SQL.

A helpful feature for us is the integration with NoSQL databases. We use less integration with other kinds of technologies such as file management, control, orchestration, and mapping. All of the features are here and all of them are important to us. 

The price for Talend Data Integration should be less expensive.

In the past year that I have been working with Talend, I haven't found any problems in terms of stability. Some of my colleagues have had problems, but they have been fixed.

We have never had issues in terms of scalability. In fact, we have not had requirements from any customer that the solution is horizontally scalable.

We have never used any kind of support from Talend, as a vendor. All of the problems that we have encountered, we have fixed ourselves. We did, of course, make use of their knowledge base.

We use different solutions depending on the needs of the customer, including budgetary considerations. We try to use Talend as much as possible but there are some cases where it does not fit. For example, we cannot provide a solution with Talend when we use Kafka.

Another example is that sometimes when a customer is using Oracle, rather than Talend we use Oracle Data Integrator. Again, it depends on the customer requirements.

The initial setup ranges from simple to complex. 

For the average customer, we are able to deliver solutions between two and six months. Sometimes, this is only part of the solution that we integrate for our clients. Something other than data integration may be covered by another product. One of the products that integrate well with Talend is Vertica. Together, it makes for a small setup.

Normally, one or two people are required for the deployment of this solution. It is a small team, and it covers more than just Talend.

Maintaining this solution should be the job or four or five people because you're sharing these resources. These people sometimes represent different levels of support and have varying levels of experience.

We perform the implementation of this solution for our customers.

We are totally satisfied with this product. We have not found any problems. It is an open-source, platform-independent, and pretty stable.

My only complaint is that the commercial version is very expensive. There are some limits, but the commercial version is unlimited.

I would rate this solution a ten 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.

I'm currently doing the research and testing it on my machine. Our use case is to extract or manipulate data from one database to another one in a structured form.

I am just testing this solution. It is too early to say whether it is helpful for our company. I am currently assessing it, and I will report my assessment to our management. If it is useful for our project, we will buy a license and use it in our projects.

I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields.

It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool.

In terms of features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM.

I have been using this solution for two weeks.

I didn't open any cases with technical support. I would need a license from Talend to get support.

It was easy and user-friendly. Its deployment took around 20 to 30 minutes.

I didn't use a consultant.

The cost for one year for the ETL tools, not for the big data, is 6K per year. It is a good price.

I'm also assessing the Oracle Data Integrator (ODI) solution. I have to assess both Talend and ODI, and management will decide which one will be used. It seems like we can use both of these solutions. For example, for Oracle Database, we can use ODI, and for other databases, we can use Talend Open Studio.

It is good for connecting to more than one source. I can manipulate the data from multiple sources. I can manipulate the data from different databases such as SQL Server or Oracle Database.

I would rate Talend Open Studio an eight out of ten.

We have been using Talend for ETF functions in connection with our RDBMS system.

We are in the process of moving from RDBMS to Big Data, so we may not be using Talend in the future.

This is a user-friendly solution that is easy to use.

We need to use a more complete solution that includes data governance, data quality, data lineage, data classification, and data security. At a minimum, they should include some data quality rules and functionality, and perhaps some login features.

Technical support and customer service need to be improved.

There is no log available.

We have been using Talend Open Studio for about two years.

We have had no issues with stability.

Scalability hasn't been a problem.

We have never received responses to our queries from the company, so we are totally unsatisfied with the support.

We are using the Community version of Talend, which has some limited functionality.

The paid version of this solution has a very high price, but even with the limitations, the Community version works fine.

Overall, this is a good solution. Of course, there is lots of room for improvement.

I would rate this solution a seven out of ten.

We use this product for broader data synchronization, data storage, data transformation, data integration, and other data processing.  

The feature I like most of all in Talend Studio is the ability to use it to ensure data quality. I like the product because it presents an easy and understandable way to implement data quality features. I license the product specifically because of its ability to handle that type of routine.  

I do not have so many issues with the product itself but when I do and I contact technical support, the technical support has not always been very good. At times I have had to wait too long to get a solution from them — sometimes even months rather than days. Technical support should definitely be improved.  

I think the user interface is an advantage in Talend Open Studio because it is really very good. However, while I am working I sometimes notice a bunch of very minor faults or omissions in the functionality. I see them while working and I don't keep a list so I can not go into many details. But there are a lot of very minor glitches and functional inconsistencies that do not affect the results very much, but if they can be fixed it will improve the system and utility. For example, if I make an FTP connection, I can not use a context variable to define parameters. This feature is just not available and it should be. If such minor gaps are fixed, it would be a much better product and quicker and easier to use.  

One other thing that can be improved is that it would be good to have more information on the internet for users to assist with problem-solving and use. I think that there is a lot of information out there but at the same time, it seems like a lot of the information is not the most relevant to what a user really needs. I would advise people coming to the product as new users to read the documentation thoroughly and as much as possible, but I would also hope that the standard and quality of that documentation will be improved by Talend.  

 I have been working with this product for approximately six months.  

We currently have approximately 10 users who are using this solution in our company. In the future we may have plans to increase this usage but that depends on how our needs grow. It does not seem like scaling usage will be an issue.  

The customer support is one of the biggest issues I have with the product. The support itself is not always very quick to resolve issues, and that itself is a problem. But also the available information for the product needs to be improved. There is a lot of information, but not all of it is very good.  

The initial setup for Talend Open Studio is pretty straightforward. The deployment of any particular job does not take too long. It would be approximately one month in almost every situation.  

On a scale from one to ten where one is the worst and ten is the best, I would rate this solution as an eight out of ten. To give the product a higher score they would have to improve several things. This would start with improving technical support.  

As far as advice that I have for people considering this solution, I think that this is a very good product which will be able to resolve most peoples' business needs. I recommend it for use depending on your business needs and situation.  

It is a powerful tool for data integration: You can simply drag & drop components and draw lines to connect them together for building your ETL job.

There is a list of +900 components available OOTB.

If you are a data integrator or system integrator, your work will be much easier using Talend Open Studio.

It is an Eclipse-based application; therefore, any developer which has used Eclipse before is able to build jobs and run them.

The open-source version does not include the parallel execution; neither the source code versioning or the project collaboration features.

I have used it for three years.

I have not encountered any deployment issues. You download the compressed file from the Talend website (ZIP or TAR.GZ) and extract it to your local machine.

I have not encountered any stability issues; probably the MAC OS X version is less stable than the others.

Scalability is not applicable since it is a desktop application.

It is an open-source application; you do not have the customer service. You can refer to the community forum instead.

It is an open-source application, you do not have technical support. You can refer to the community forum instead.

I did not use a different solution; I have started with Talend.

Initial setup is pretty much straightforward: you have to install the JAVA JDK 1.8 and set the "JAVA_HOME" variable.

The Talend Open Studio is free; there is also the Talend Data Fabric Platform, which requires a license.

The license is per developer, not per CPU.

Before choosing this product, we did not evaluate other options.

It provides the power of an ETL tool but packaged as a Java app without needing any custom product setup. This has helped us handle several of our data integration/migration needs (including the ones needed for our in-house products), without worrying about alignment to our clients' tech infrastructure as long as they are fine to run a Java app.

Its data integration features are as powerful as any other leading product in this space.

It improved productivity compared to lot of custom SQL data integrations done before, and at a very low cost. Its HTML document generation feature has helped us ensure documentation of all the ETL code.

The open-source version has obviously fewer features compared to the enterprise edition. Specifically, the scheduler, rules engine, etc., are really not available, but these are nice-to-have's for a general ETL development where organizations could address these with other tool sets.

Developers need some experience to gain optimal performance and, being a Java application, tuning knowledge of Java apps helps, which is sometimes difficult for a pure ETL developer.

I have used it for more than a year now.

Version 5.6 works best with Java 7 and quite unstable with 8. I encountered a few issues with the multi-threading function leading to DB connection issues.

I have encountered scalability issues; it requires a bit of tuning before we get to optimal performance.

I have not used customer service that much.

Being open source, technical support is through the Talend forum, which is quite good.

I previously used a different solution., and switched because it offered comparable product features at a lower cost.

Initial setup was not difficult.

An in-house team implemented it.

Most of the features are available in the open source version. Only if used in a large enterprise with distributed teams, would we need the licensed version with collaborative development features (repository), schedulers, etc.