TrustRadius: an HG Insights company

Talend Open Studio (discontinued)

Score9 out of 10

51 Reviews and Ratings

What is Talend Open Studio (discontinued)?

Talend Open Studio was an open source integration software, used to build basic data pipelines or execute simple ETL and data integration tasks. Qlik and Talend discontinued the service in early 2024, and it is no longer available.

Categories & Use Cases

Top Performing Features

  • Testing and debugging

    Tool to debug and tune for optimal performance

    Category average: 7.2

  • Connecto to Big Data and NoSQL

    Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases

    Category average: 7.6

  • Complex transformations

    Complex data transformations are data normalization, advanced data parsing, etc.

    Category average: 7.4

Areas for Improvement

  • Business rules and workflow

    Ability to define and manage business rules and workflows

    Category average: 8.2

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.9

  • Integration with data quality tools

    Integration with tools for cleansing, parsing and normalizing data according to business rules

    Category average: 7.4

Talend: agile and simple integration

Pros

  • Easy of use.
  • Compatibility with data sources.
  • Open source

Cons

  • Installation and drivers/settings
  • Use in enterprise mode
  • Scheduling and automation

Return on Investment

  • Speed in development and debugging.
  • Ability to connect with different realities.
  • Low costs.

Alternatives Considered

IBM InfoSphere DataStage, KNIME Analytics Platform, Informatica Integration Cloud and SAS Data Integration Studio

Other Software Used

KNIME Analytics Platform, IBM InfoSphere DataStage, Qlik Sense, Qlik Analytics Platform, SAS Enterprise Data Integration Server, SAP HANA, Oracle Application Express

Talend Open (your eyes) Studio

Pros

  • Infographics
  • UI
  • Simplicity

Cons

  • There is a lot of problem with setting up Talend for the first time and downloading the libraries
  • Bad support from Talend. Sometimes the technical support is not able to respond, and after several emails, they stop answering
  • Bad understanding or explanation of errors. Sometimes the error pops up and you don't know why

Return on Investment

  • We are losing days of our project having to setup it.
  • Not compatible with Big Data or inconsistent support.

Usability

My point of view of Talend Open Studio: Great!

Pros

  • Your developers will be able to design SOA services graphically, and it is very easy to document and implement the code.
  • Talend Open Studio is based on Eclipse IDE, so your developers will be very comfy using it
  • Open is Key in Talend Open Studio = Open Source

Cons

  • Since it is an Eclipse-Based IDE, sometimes it can be a little slow.
  • You cannot setup your artifact repository using the same credentials as for other modules within the TOS.

Return on Investment

  • Being Open Source, your costs on the IDE side are zero.
  • There are a lot of programmers with knowledge in Eclipse, they will be comfy using TOS. The development process will be faster.
  • Once you develop your Service Bus using TOS, you can connect easily with other Talend products, like DTS, Big Data analysis tools, etc.

Other Software Used

JBoss Enterprise Service Bus, Oracle BPEL Process Manager, Mule ESB

Great tool for data migration

Pros

  • It does provide a lot of predefined functionality out of the box along with providing the facility to use complex java code for developers.
  • Mainly like it for small data utilities. It does provide a lot of control for developers.
  • Pricing is, of course, a major plus :)

Cons

  • Experienced few bugs sometimes. It behaves a little strange sometimes giving random code errors which go away just by restarting Talend Open Studio.
  • Developers with java background are needed for complex development.

Return on Investment

  • Overall a very good tool when comparing the pricing, features, and flexibilities provided together.

Other Software Used

Salesforce Analytics Cloud, Salesforce Commerce Cloud

Step-by-step, Talend helps you build your integration flows

Pros

  • Talend provides pre-built widgets to integrate with databases, web services, and FTP for example, which saves time and quality issues in building basic functionalities that are needed to create a full workflow.
  • Using any tool, such as Talend, encourages a consistent mindset and approach for processing steps, rather than being 100% free-form logic based on the mood of the developer. This makes it easier to understand the workflow that is implemented, even if you are working with many different processes.
  • Using Talend allowed me to work on a project to the point where the client needed to review it, pause development for a week or even 3 weeks if key people were very busy, and to resume work without much trouble at all. If I had been developing without such a tool, my custom code base would have been much larger, and I would have had more difficulty resuming work after such a break.

Cons

  • Standard source control practices do not work the way you would expect them to when using Talend. The intermediate items that Talend creates in the workspace are not simply a set of .java files, so you must take extra care of managing your workspace directory. This means you must backup your entire workspace directory prior to upgrading the version of Talend you are using for active development. Granted, we should do this even when upgrading a basic Eclipse environment, but it is far easier to get back where you started if Eclipse gets messed up, than if Talend gets corrupted somehow. This is a key concern for developers, and gaining comfort with this is a matter of time committment to a single tool, which developers are hesitant to commit. There are options to help this in the team and enterprise versions of the tool, but those have their own barriers to adoption, money and agreement across a development team.
  • It could take 2-3 weeks for an seasoned Java developer to gain comfort in how to best implement processes using Talend. It is worth it if you have a lot of projects that start, go on back-burner, then resume, or if you are switching between integration processes and wanting a standard way to build your programs

Return on Investment

  • I delivered projects the client did not believe were possible, and I provided intermediate value by providing visibility to hidden data problems in their systems they could not detect before.
  • I was able to work 3 projects at a time, pausing gracefully in one while switching to the other, with minimal effort.

Other Software Used

Eclipse Luna