Talend Open Studio OverviewUNIXBusinessApplication

Talend Open Studio is the #5 ranked solution in top Data Integration Tools. PeerSpot users give Talend Open Studio an average rating of 7.6 out of 10. Talend Open Studio is most commonly compared to SSIS: Talend Open Studio vs SSIS. Talend Open Studio is popular among the large enterprise segment, accounting for 68% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a computer software company, accounting for 19% of all views.
Talend Open Studio Buyer's Guide

Download the Talend Open Studio Buyer's Guide including reviews and more. Updated: November 2022

What is Talend Open Studio?

Talend Open Studio is a free, open source ETL tool for data integration and Big Data. The solution enables you to extract diverse datasets and normalize and transform them into a consistent format which can be loaded into a number of third-party databases and applications.

Talend Open Studio Features

Talend Open Studio has many valuable key features. Some of the most useful ones include:

  • Automatic identification of data types and potential errors
  • tMap module
  • Graphical conversion tools
  • Charts
  • Database SCD Tools
  • Business intelligence formats (Jasper, OLAP, SPSS, Splunk)
  • ETL and ELT support
  • Eclipse-based development tooling
  • Versioning
  • Large library of connectors
  • Data flow orchestration
  • File management without scripting
  • Data transformations

Talend Open Studio Benefits

There are several benefits to implementing Talend Open Studio. Some of the biggest advantages the solution offers include:

  • Reduces the time taken to develop the integration.
  • Provides a wide selection of source and target connectors.
  • Monitor and manage problematic deployments with ease.
  • Allows developers to have the lowest cost of ownership for any solution.
  • Improves collaboration between different teams who need access to data.
  • Automated data integration process synchronizes the data and eases real time and periodic reporting, which would be time-consuming if done manually.
  • Achieve better data quality because data matures and improves over time.

Reviews from Real Users

Below are some reviews and helpful feedback written by PeerSpot users currently using the Talend Open Studio solution.

Elio B., Data Integration Specialist/CTO at Asset messages, says, "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."

A Practice Head, Analytics at a tech services company mentions, “The data integration aspect of the solution is excellent. The product's data preparation features are very good. There's very useful data stewardship within the product. From a technical standpoint, the solution itself is pretty good. There are very good pre-built connectors in Talend, which is good for many clients or businesses, as, in most cases, companies are dealing with multiple data sources from multiple technologies. That is where a tool like Talend is extremely helpful.”

Prerna T., Senior System Executive at a tech services company, comments, “The best thing I have found with Talend Open Studio is their major support for the lookups. With Salesforce, when we want to relate our child objects to their parent object, we need to create them via IDs. Then the upsert operation, which will allow you to relate a child object to the event, will have an external ID. That is the best thing which keeps it very sorted. I like that.”

An Implementation Specialist, Individual Contributor at a computer software company, states, “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.” He also adds, “It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool.”

PeerSpot user Badrakh V., Information System Architect at Astvision, explains, "The most valuable features are the ETL tools."

Talend Open Studio was previously known as Open Studio.

Talend Open Studio Customers

Almerys, BF&M, Findus

Talend Open Studio Video

Talend Open Studio Pricing Advice

What users are saying about Talend Open Studio pricing:
  • "Right now, because we're using the open-source version, there's no cost."
  • "There are many versions available and one is open-sourced which is free."
  • "The cost for one year for the ETL tools, not for the big data, is 6K per year. It is a good price."
  • "Talend Open Studio is priced too high."
  • Talend Open Studio Reviews

    Filter by:
    Filter Reviews
    Industry
    Loading...
    Filter Unavailable
    Company Size
    Loading...
    Filter Unavailable
    Job Level
    Loading...
    Filter Unavailable
    Rating
    Loading...
    Filter Unavailable
    Considered
    Loading...
    Filter Unavailable
    Order by:
    Loading...
    • Date
    • Highest Rating
    • Lowest Rating
    • Review Length
    Search:
    Showingreviews based on the current filters. Reset all filters
    Azhagarasan Annadorai - PeerSpot reviewer
    Founder at Kaizentric Technologies
    Real User
    Top 5Leaderboard
    Popular open-source ETL tool in Singapore/ South East Asia; Connects to Big Data; Easy to spot errors with generated Java code
    Pros and Cons
    • "The main differentiator that I have seen between Talend and other data integration tools is the ability to view the data pipeline in the form of a program."
    • "It doesn't have the ability to keep the repository of the source code (visual pipeline). It can be integrated with Git."

    What is our primary use case?

    We have used the solution for a real estate agency in Singapore to stream their data on a more or less real-time basis to a mobile app. Their backend system is primarily built on SAP. They used a combination of Kafka message querying and Talend to stream the data into a NoSQL environment, which is MongoDB. The solution basically streams the data from SAP backend systems, all the way to a NoSQL MongoDB database, to support a real-time or near real-time data flow into a mobile app. 

    This mobile app will be a consumer-facing app. The end consumers will be able to look at the status of their real estate space. Users are mostly the tenants who either rent or lease commercial or residential spaces. The status of their leased property will be made available via a mobile app. The data solution comprised of technology such as Kafka for message queuing, Talend for data flow streaming, and MongoDB for storing the data. That's one use case.

    The second problem solved using Talend is to build the data lake for internal data analytics at a government organization, again based in Singapore. Their backend systems are primarily supported by Sybase databases. From the Sybase databases, selective data is brought into a staging area via Qlik Attunity, which is a real-time data synchronization tool that uses the change data capture mechanism. Once the data comes to the staging environment through Attunity, then Talend takes over. Talend pulls that data and moves it to Cloudera's big data solution, the big data platform. Then, Tableau is used for data analytics and data visualization. This solution is set up for internal data analytics within the government organization.

    How has it helped my organization?

    The tool offered essential connectors to connect to various data sources and our big data platform. Our data sources were SAP/ MS SQL and Sybase. The Hadoop/ hive connectors are used to connect to the Cloudera-based big data platform. The components available to loop and dynamically pass source/target connections helped us to stream data based on source tables' metadata. This helps us to onboard new data sources quickly, rather than building a custom data pipeline for each new data source.

    What is most valuable?

    The main differentiator that I have seen between Talend and other data integration tools is the ability to view the data pipeline in the form of a program/ code. The other tools hide the backend code behind the scene, however, Talend shows the backend code that gets generated from the UI (user interface) components used for creating a data pipeline. I.e., In most of the data integration tools, all we do is, leverage certain UI components meant for data processing such as reading, selection, filtering, sorting, writing et cetera to build data pipelines. The tools such as Pentaho or Informatica, will convert the pipeline into a backend code, which is written probably in C++ or java program. This is not transparent to the developer or the programmer. But in the case of Talend, the tool converts the pipeline into a programmatic format and shows it to the user. This helps in debugging errors. 

    If somebody has a passion and interest in software programming, they will like this feature. Of course, we can do without it, however, this additional feature available in Talend helps the data engineer to understand the code better, understand how to better tune for performance, and so on. The differentiation is the ability to view the data pipeline in the form of a traditional software program.

    What needs improvement?

    Comparing the plus and minus of other tools and will try and suggest what can be improved in Talend based on how other tools implemented certain features. 

    Both Talend and Pentaho leverage open-source plugins. There are lots of open-source committees that build solutions as per their requirement;  Say, for example, someone may have had a need to create a Tableau data extract from a certain database for the purpose of data visualization in Tableau. They may have created a plugin for this purpose and shared it with the market. We can always go into the market and search for a plugin that someone else created (for ex., to generate TDE files) when we have similar needs. Both Talend and Pentaho offer the 3rd party plugins in their market. This plugin market feature automatically extends/improves the tool capability. If somebody needs a particular feature, they can always build one and publish it for the other developers to use. 

    Other than this, maybe if Talend had a few components, it's easier to deploy solutions; job scheduling is one. Currently, the job scheduler is a separate component within Nexus and is accessible over browser. It can be integrated within TOS (Talend Open Studio) so that we dont need to switch between the two. Nexus holds the repository of compiled program code. However, Nexus doesn't have the ability to keep the repository of the source code programs. That can be improved. 

    Currently, Talend has a versioning feature, meaning the previous version can be named as 0.1 or 1.0 and the subsequent minor/major versions can be increased with incremental version numbers, however, it is not that great as a version control repository (such as VSS, CVS, Git, etc). If a Nexus-like tool can be used for maintaining versions of the underlying source code (not just for the compiled code), that would be great. Basically, version control can be improved.

    Buyer's Guide
    Talend Open Studio
    November 2022
    Learn what your peers think about Talend Open Studio. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
    655,113 professionals have used our research since 2012.

    For how long have I used the solution?

    I've been using the solution since 2019.

    What do I think about the stability of the solution?

    The stability of the solution is mainly based on the server architecture behind the scenes. We have seen some instability issues on other tools around the Talend platform. For ex., Qlik Attunity had been throwing some exceptions every now and then, however, in the case of Talend, we haven't seen many. At times the server would run out of memory. Based on the capacity we have, we may have to go and clean up a few logs and other systems’ data before resuming the processes manually. 

    The system's stability is okay, especially in the case of our data warehouse. Users do understand that a data warehouse is less critical when compared to operational systems. The users' reports are normally generated at the end of the day for their availability, the next day. We have a workable level of stability, which is good enough. We don't see any instability issues.

    What do I think about the scalability of the solution?

    Talend operates on a clustered job server setup, available in both Linux & windows. The clusters can be scaled up with additional nodes as per demand. In the case of an on-premise setup, we assess the load and define clusters based on the load. We did not have auto-scaling.

    How are customer service and support?

    Talend has a support portal and we can get access to the support portal. The initial process could be a little difficult, to get into the support. The initial access provisioning could be improved. It took about a week's time to get a support login created. Once that is done, then you will get quality answers to the support questions.

    There are two ways to get technical support, either from the dedicated support team from Talend, or from the open-source community. The dedicated team provides an answer for sure, however, we may not get answers to all our questions from the open-source forums.

    How would you rate customer service and support?

    Neutral

    Which solution did I use previously and why did I switch?

    We are aware of the other solutions such as Pentaho. But, there was no switching. For most of the customers, I do the evaluation of tools, over one to two months and then finalize on one particular tool. They don't really move around from one ETL tool to another ETL tool, unless the tool itself is getting obsolete or if it is no longer supported. In the case of Talend, from what I have seen, there is no switching. They must have initially evaluated a few tools and finalized with one. The main reason could be that Talend supports a big data environment. Talend has the ability to integrate with market solutions. Third-party integration is possible. Talend is also becoming popular in Southeast Asia, so skilled resources are readily available in the market if we need people to maintain the environment. Those could be some of the factors that influence the selection of Talend.

    How was the initial setup?

    Initial setup requires a systems engineer, who has knowledge in Linux/ Windows OS, depending on the server type, to work with Talend support. It takes about 2-3 weeks for the basic setup. For additional plugins/ components, guidance from Talend support team is required.

    After the initial setup, most of the ETL data pipelines take about a week at the minimum to build. Typically, we reap the benefits after a month or two from a particular data stream. Of course, it is based on the different use cases and depends on the number of data pipelines involved in solving that particular use case, however, smaller scoped items can be delivered in one to three months' time. 

    After development and testing, the time required for the deployment varies, depending on the process we adopt and depending on the version control tools that we have as well. Certain tools will easily integrate into the Talend environment. In those cases, I mean, it would be a medium-complexity deployment. We can't say it's very simple, we can't say it's too complex either. There is a medium level of difficulty involved in deployment.

    The time it takes depends on the processes a particular organization follows in terms of change management and deployment. Some will require at least one week of review with the change management board. In certain organizations, the approval processes may take up to three weeks to get something deployed. If the process is a little simpler, if the developer has a fair level of control, it could be just one week.

    What about the implementation team?

    A vendor team was in charge of the server maintenance and their scope of service included deployment as well, as developers do not have access to production networks in established firms. Developers normally provide a step by step instructions in a word document that the vendor team will follow. Some familiarity with the tool is enough, but the vendor personnel we worked with had the reasonable experience to an extent where they recommended code improvements. 

    What was our ROI?

    Typically before embarking on a project, we analyze the return on investment, which could be over two to three years. It could be as quick as three months, depending on the scope of the data integration project, however, in the case of a data warehousing solution, it could be two to three years. 

    The real estate company we worked with, must have already seen the return on investment. Their mobile apps should be live with the data integrated at the backend. 

    For the internal data analytics use case, they would've also seen the benefits, as the data is already available in the data lake. The users will be able to do the analysis with the integrated data pool in the data lake. 

    Both the companies have seen the returns.

    What's my experience with pricing, setup cost, and licensing?

    Pricing is competitive in comparison with Pentaho. Both are at par. Solutions such as Informatica could be more expensive. Certain packaged solutions that use Talend as ETL may be available, if you are looking for a pre-built data warehouse model.

    Which other solutions did I evaluate?

    Yes, Apache NiFi was evaluated. Based on the POC (proof of concept) results, we chose Talend.

    What other advice do I have?

    Some of my comments are based on my limited understanding of the tool. Please do due diligence before selecting the tool. I recommend a POC over 1-2 months on shortlisted tools, before finalizing one.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    Flag as inappropriate
    PeerSpot user
    Practice Head, Analytics at a tech services company with 201-500 employees
    Real User
    Top 5Leaderboard
    Useful data stewardship and data preparation features but lacks documentation
    Pros and Cons
    • "The data integration aspect of the solution is excellent."
    • "The documentation is lacking within the product. They need to get better at all aspects of describing how it works and how to use it."

    What is our primary use case?

    One use case for Talend Data Management is using it for data integration from multiple data sources and then to build our customer's golden record.

    What is most valuable?

    The data integration aspect of the solution is excellent.

    The product's data preparation features are very good.

    There's very useful data stewardship within the product.

    From a technical standpoint, the solution itself is pretty good.

    There are very good pre-built connectors in Talend, which is good for many clients or businesses, as, in most cases, companies are dealing with multiple data sources from multiple technologies. That is where a tool like Talend is extremely helpful. 

    What needs improvement?

    While I can't really speak to technical aspects that need improvement, I can say that the marketing of the solution is not the best. They need to really improve how they present the solution to potential clients.

    The documentation is lacking within the product. They need to get better at all aspects of describing how it works and how to use it.

    For example, if you see all the other modern products - like Snowflake or Cloudera - and go to their sites, you will have various types of documentation, including data charts and other things you can get readily access. However, if you go to the Talend site, you won't get this kind of marketing material, which is always required.

    It's especially difficult when you're writing a proposal. You need to have the technical specifications. All of these modern solutions are quite advanced in terms of their documentation. You go to their site, and you will get a lot of brochures, reports, and other items. This gives you a detailed understanding of the solutions, and all of the specifications, and technicalities, and other things. For Talend, unfortunately, there's a lag in that aspect. 

    From a data management or data engineering perspective, they could stabilize their new features more. 

    It would be ideal if they could consider adding prescriptive or predictive models into their components, such as an alternate data IQ.

    For how long have I used the solution?

    We don't use the solution directly per se. We're a solutions provider.

    What do I think about the stability of the solution?

    The solution offers very good stability. We haven't really had any issues with glitches or bugs. There aren't problems with the solution crashing or freezing on clients. It's been good.

    What do I think about the scalability of the solution?

    The solution is good at scalability With their big data integration products, they're actually handling a huge data set and the scalability of it is good. They're well-positioned to scale for the client.

    How are customer service and technical support?

    Technical support is pretty good. I would rate them at an eight out of ten. We've been satisfied with the level of support provided overall.

    How was the initial setup?

    The initial setup was straightforward. It was not complex at all.

    Deployment times vary according to the size of the client or their needs. If it's for a big client and big project, it could be six months of implementation time. Smaller jobs may only take one month of implementation. It all depends.

    What about the implementation team?

    We tend to implement this solution for our clients.

    Which other solutions did I evaluate?

    I've briefly looked at Azure Data Factory and have been seeking out comparisons between these two options.

    What other advice do I have?

    We are the solution provider. We are the company that implements such solutions as Talend. We are not the user of the solutions themselves necessarily. We are the reseller as well as implementation partners and the implementing partner of Talend. We have resources who work on these tools and who implement solutions for our customers. 

    The version of the solution we use varies from client to client, especially for Talend. They have multiple products, including Talend Data Management and Talend's Data Integration Pipeline. A lot of our customers are using the open-source version of Talend. Some are using the licensed version. From those, some are using it for the data stewardship. 

    We deploy both cloud and on-premises models as required.

    Overall, we've been happy with the product. From a data management perspective, the data preparation, data stewardship and the other features that Talend has, including the MDM, are all extremely important for today's organization.

    Overall, I would rate the solution at a seven out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Talend Open Studio
    November 2022
    Learn what your peers think about Talend Open Studio. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
    655,113 professionals have used our research since 2012.
    Prerna Tiwary - PeerSpot reviewer
    Senior System Executive at a tech services company with 201-500 employees
    Real User
    Top 20
    Good platform for keeping your data well sorted
    Pros and Cons
    • "The best thing I have found with Talend Open Studio is their major support for the lookups."
    • "In terms of what can be improved, the scheduling is not there in the sister version, while it is there in the cloud one, which is a paid version. If all kinds of scheduling could be available on the Open Studio that we generally use and practice on, that would be great. The scheduling of the data migration is currently not available in the sister version of Talend Open Studio that we are working on. It is available in the advanced version of the Talend. This is the one thing that can be improvised."

    What is most valuable?

    The best thing I have found with Talend Open Studio is their major support for the lookups. With Salesforce, when we want to relate our child objects to their parent object, we need to create them via IDs. Then the upsert operation, which will allow you to relate a child object to the event, will have an external ID. That is the best thing which keeps it very sorted. I like that.

    What needs improvement?

    In terms of what can be improved, the scheduling is not there in the sister version, while it is there in the cloud one, which is a paid version. If all kinds of scheduling could be available on the Open Studio that we generally use and practice on, that would be great. The scheduling of the data migration is currently not available in the sister version of Talend Open Studio that we are working on. It is available in the advanced version of the Talend. This is the one thing that can be improvised.

    Overall, I would like to see better scheduling for multiple, simultaneously running processes.

    For how long have I used the solution?

    I have been using Talend Open Studio for almost five plus years.

    What do I think about the stability of the solution?

    The stability is good. Since I have worked on a quite number of ETLs, Talend is a better approach or at least the better choice for me. Every time, it is the better choice to go for.

    What do I think about the scalability of the solution?

    Scalability is a good feature here.

    Whether we increase usage depends on the requirements. When I started, it was the basic requirement. Now, as time passes, I'm working on competencies and the new personalities of the Talend and there are some components which are not available here which I have to download from the AppExchange. For example, there is a kind of drill component which we get from AppExchange. With the experience of five years, I have worked multiple competencies and multiple scenarios. It is scalable and customizable, but one issue we have faced individually and as a team on Talend, is the errors which are not completely recognizable. Other than that, in terms of handling, in terms customization, in terms of the UI, it is quite responsive and quite easy to use. Other than the logs.

    Which solution did I use previously and why did I switch?

    I have used cloud apps, such as the dataloader.io or the Informatica cloud, but I have not worked on the Talend cloud version. I now work on the Talend Open Studio, which is the desktop version.

    When I started this data thing, where we handle the data, Talend Open Studio was the first solution which I worked on and I'm still working on it. I have worked on the different details of the scheduling events and of the client comments. These are the two issues because of which I switched to Informatica, the DataBank, and cloud dataloader. Otherwise, we mostly focus on Talend Open Studio.

    How was the initial setup?

    Initial setup was not very easy because when I started I didn't have any background on the data integration. But there is a class to start. When I started with Talend Open Studio, it was an average, good experience. Not very easy, nor very complicated.

    What other advice do I have?

    I would say it is a good platform. Give it a start to work on. It actually handles the freshers very nicely. The only drawback as a fresher is lacking the experience which makes it difficult to understand the error message that gets generated on the execution of the job, not in the file. That has been tricky. Because you need to have experience to understand why that error appears in the execution of the job. Otherwise, it's a good platform to have a start on.

    On a scale of one to ten, I would give Talend Open Studio an 8 to 9. It would be 9 if they added the scheduling of multiple processes. Without that, it is an 8.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Architect at Elections Canada | Elections Canada
    Real User
    Top 20
    A stable solution that is easy to install and works well so far, but the error-handling is not user-friendly and it needs a built-in tool for geospatial data
    Pros and Cons
    • "I didn't have many problems installing it. It seemed very straightforward to me."
    • "I think my biggest problem with the tool is that the errors are very hard to debug."

    What is our primary use case?

    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.

    What needs improvement?

    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.

    For how long have I used the solution?

    I have been using this solution for about a month. 

    What do I think about the stability of the solution?

    The solution is stable. 

    What do I think about the scalability of the solution?

    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.

    Which solution did I use previously and why did I switch?

    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.

    How was the initial setup?

    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.

    What about the implementation team?

    I did the deployment myself on my local workstation. 

    What's my experience with pricing, setup cost, and licensing?

    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.

    What other advice do I have?

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

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    Flag as inappropriate
    PeerSpot user
    Practice Head, Analytics at a tech services company with 201-500 employees
    Real User
    Top 5Leaderboard
    Superior data integration, handles large data sets, documentation needs improvement
    Pros and Cons
    • "The most valuable features are definitely data integration, data preparation, and data stewardship."
    • "he overall marketing and documentation of this product need to improve a lot."

    What is our primary use case?

    One of our clients' use case was for data integration from multiple sources and then to build our customer golden record.

    What is most valuable?

    The most valuable features are definitely data integration, data preparation, and data stewardship. Additionally, on a technical standpoint, the solution itself is pretty good.

    What needs improvement?

    The overall marketing and documentation of this product need to improve a lot. For example, if you see all the modern products such as Snowflake or Cloud ETL and go to their site, you will have various advanced documentation, brochures, reports and data charts. You can get prepared from all the information available. However, on Talend's site, you will not get this kind of marketing materials, which should be required. It is especially important If you are writing a proposal, you need to have these technical specifications documents. This documentation gives you a detailed understanding of the solution on top of the specification, technical information and other important information. Talend, unfortunately, is lagging on that aspect, they should work on it.

    In the future, they could improve on stabilizing existing features and adding more prescriptive and predictive models as part of their components.

    What do I think about the stability of the solution?

    In my experience It is stable. They have developed a lot and have kept up to date.

    What do I think about the scalability of the solution?

    The solution is scalable. We did a big data integration that actually handling huge data sets, and the scalability of it is good.

    How are customer service and technical support?

    I would give technical support of Talend open studio an eight out of ten.

    How was the initial setup?

    The installation was straightforward, it was not complex.

    What about the implementation team?

    We do the implementation for the customers and some can take six months while others can take far less. It is all dependant on the customer's needs.

    What's my experience with pricing, setup cost, and licensing?

    There are many versions available and one is open-sourced which is free.

    Which other solutions did I evaluate?

    I have evaluated Snowflake and Cloud ETL. 

    What other advice do I have?

    There are many different version of this solution that fits into the customer's needs. We have supplied versions best suited for data management, data integration, pipeline and many others. The version varies from customer to customer and some are using the Open Source Talend. Some are using the licensed version and others for the data stewardship.

    For those wanting to purchase this solution, there are some important things to consider. This solution has better multiple pre-built connectors than competitors, which is good for any client or any business, because today, in most of the cases, they are dealing with multiple data sources from multiple technologies. Data integration from multiple data sources, I find Talend is extremely helpful.

    The features in this solution are very important for today's organization.

    I rate Talend open studio a seven out of ten.

    Which deployment model are you using for this solution?

    Hybrid Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    SuhailFaraaz - PeerSpot reviewer
    Principal Consultant at a tech services company with 1,001-5,000 employees
    Reseller
    Top 20
    Easy to use with a nice user interface and good reliability
    Pros and Cons
    • "It is user-friendly and the interface is good."
    • "Multiple products are there within the product suite. That can be actually trimmed down."

    What is most valuable?

    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. 

    What needs improvement?

    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. 

    For how long have I used the solution?

    I just installed the solution two or three weeks ago. 

    What do I think about the stability of the solution?

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

    What do I think about the scalability of the solution?

    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. 

    How are customer service and support?

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

    Of course, they could always be more responsive.  

    How would you rate customer service and support?

    Positive

    How was the initial setup?

    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.

    What's my experience with pricing, setup cost, and licensing?

    The pricing is reasonable. 

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

    Which other solutions did I evaluate?

    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.

    What other advice do I have?

    The solution is deployed on my personal laptop.

    I'd rate the solution nine out of ten.

    Disclosure: My company has a business relationship with this vendor other than being a customer:
    Flag as inappropriate
    PeerSpot user
    Implementation Specialist, Individual Contributor at a computer software company with 201-500 employees
    Real User
    Top 20
    User-friendly, good price, and useful for connecting to different databases
    Pros and Cons
    • "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."

    What is our primary use case?

    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.

    How has it helped my organization?

    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.

    What is most valuable?

    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.

    What needs improvement?

    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.

    For how long have I used the solution?

    I have been using this solution for two weeks.

    How are customer service and technical support?

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

    How was the initial setup?

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

    What about the implementation team?

    I didn't use a consultant.

    What's my experience with pricing, setup cost, and licensing?

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

    Which other solutions did I evaluate?

    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.

    What other advice do I have?

    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.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Sivanandam Krishnan - PeerSpot reviewer
    Practice Lead at GainInsights Solutions
    Reseller
    Top 5Leaderboard
    Customizable, integrates well, and reliable
    Pros and Cons
    • "The most valuable features of Talend Open Studio are customization and integration."
    • "Talend Open Studio has a lot of capabilities, but there is some restriction. For example, if we want to connect to an SAP system, Open Studio cannot do it. We need to go with an enterprise version. Additionally, the monitoring features could improve."

    What is our primary use case?

    The solution can be deployed on the cloud and on-premise.

    What is most valuable?

    The most valuable features of Talend Open Studio are customization and integration.

    What needs improvement?

    Talend Open Studio has a lot of capabilities, but there is some restriction. For example, if we want to connect to an SAP system, Open Studio cannot do it. We need to go with an enterprise version. Additionally, the monitoring features could improve.

    In the next release of the solution, there should be some sort of reporting. If you compare Open Studio with the enterprise version, the enterprise is giving us the usage reports, a lot of in-built reports are available. That feature is not available in the open-source, which can be increased. However, that's not a major show stopper or a concern, but it would be nice to have those features.

    For how long have I used the solution?

    I have been using Talend Open Studio for approximately eight years.

    What do I think about the stability of the solution?

    Talend Open Studio is stable.

    What do I think about the scalability of the solution?

    We did some testing with the enterprise version and we did not encounter any problems with the scalability of the solution. There are scalable features available. However, the documentation could be better.

    How are customer service and support?

    Talend Open Studio needs to improve on its documentation and support.

    How was the initial setup?

    The initial setup of Talend Open Studio was straightforward for Windows. However, when it comes to Linux, it is a bit complicated but it's manageable.

    What about the implementation team?

    The implementation of Talend Open Studio was done in-house.

    What's my experience with pricing, setup cost, and licensing?

    Talend Open Studio is priced too high.

    What other advice do I have?

    The cost involved is high, we need to select which solution to use, the Open Studio version or the enterprise version. If there is scope for SAP or some paid connectors, we can go with the enterprise version, or the Open Studio version is capable enough to manage the data integration part.

    I rate Talend Open Studio an eight out of ten.

    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
    Flag as inappropriate
    PeerSpot user
    Buyer's Guide
    Download our free Talend Open Studio Report and get advice and tips from experienced pros sharing their opinions.
    Updated: November 2022
    Product Categories
    Data Integration Tools
    Buyer's Guide
    Download our free Talend Open Studio Report and get advice and tips from experienced pros sharing their opinions.