Fivetran vs. Talend Open Studio (discontinued)

[Fivetran is] very well suited when you are using popular and common data sources, such as the major ad platforms, and SaaS platforms such as Salesforce. If the majority of your data sources are custom internal applications or databases, may be less value as you aren't leveraging the delivered connectors.

Incentivized

It is certainly suitable for agile and innovative projects. For developments that require particular steps and with a simple debug. On the other hand, it is not very suitable for producing flows that move large amounts of data and that require a lot of resources and great stability.

Incentivized

• Simplified ETL from a wide range of data sources
• Stable and painless data pipeline
• Granular control over what parts of the data source are loaded

Incentivized

• 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 :)

Incentivized

• Doesn't include support for a Kinesis stream as a data source so couldn't be used for some use cases under consideration
• Doesn't support the use of "BEFORE DELETE" triggers
• No support for serverless Aurora

Incentivized

• The community is not that up to date and forum is not that great in response. Probably we should make people aware of the tool more on how to use and its implementations.
• Talend crashes when transforming a lot of data (millions of rows).
• Proper training documentation is a must for talend which is currently lagging. This will help users to learn more about Talend and use it effectively.

Incentivized

There is no licence requirement for Talend Open Studio. So, this is not relevant question. However, if you are asking whether we will use Talend in future. Yes. We will continue to use it. It's very powerful free tool which caters to all our extra, transform, load capabilities. We just love Talend for it's great functionality and ease of use.

Incentivized

Very easy and intuitive to setup and maintain as there usually are not that many options. Very well documented (e.g. how to setup each connector, how the schema looks like, any specific features of this connector etc.). Also the operation is intuitive, e.g. you have status pages, log pages, configuration pages etc. for each connector.

Incentivized

Talend Open Studio is based on Eclipse and is full of redundant procedures to do one thing, like when installing libraries. Sometimes I cannot manually download the libraries that it can't find.

It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.

Incentivized

Many times, Talend freezes. When you give a cancel command, it takes several minutes to stop. It also takes a great toll on our PC with 16 GB of ram and I7 CPU, even in idle status. If you are downloading Maven Jar/Libraries, you cannot do anything and have to wait until the task is finished.

There is only one support staff on a forum created by Talend, which hides behind a nickname and does not show his name. They only ask base questions like: -Talend version - Are you in a proxy? -Do you have all the libraries installed? -It is a Jar missing? (how could I know?) -Follow this link on our site or "please ask your administrators" They then wash their hands of my issues.

Fivetran came well with the connectors' availability and updates with the source changes. We had an idea on data requirements in our case which helped us to work out on cost implication and take a decision for Fivetran as a data provider for our organization. These were 2 places where Fivetran out-performed, other vendors.

Incentivized

Informatica has a limited number of components that you can use. This places a heavy limitation on the capabilities of Informatica. On the other hand, Talend allows you to create your own custom components using Java. For businesses that need to perform a wide variety of data operations, it can be quite useful to have the option of creating your own custom components to satisfy business needs.

Incentivized

• Saved a lot of manual development days (unable to quantify)
• Accelerated the time to add a new source to the data warehouse a lot

Incentivized

• 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.

Incentivized