Best Open Source Data Integration Tool
June 01, 2021

Best Open Source Data Integration Tool

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Talend Data Integration

We use the commercial Talend Data Integration and some open studio versions of their various tool sets. We primarily use it to consolidate data from several different databases. We are up to 30 across the four subject areas we refresh daily in our data lake / warehouse. The tools allow ease of access to various databases, including Oracle, SQL Server, Postgres, and Snowflake while providing access to blob storage on AWS and Google Cloud Platform.

Pros

  • Talend Data Integration allows us to quickly build data integrations without a tremendous amount of custom coding (some Java and JavaScript knowledge is still required).
  • I like the UI and it's very intuitive. Jobs are visual, allowing the team members to see the flow of the data, without having to read through the Java code that is generated.
  • Dynamically table creation from new source.

Cons

  • Using contexts with both connections and variables causes some troubles. CLOBs and dates with timestamps have issues.
  • The server-side should be completely revamped. 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.
  • Consumes more CPU and Memory. I feel it's bit less efficient.
  • Implementation time is less. Enhance business decision making. Drive growth and innovation.
  • Talend Data Integration lacks support for providing connectors to services like InforM3.
  • Talend Data Integration helped us to simplify the migration process and we were able successfully upgrade our legacy application to Talend in the short span of 6 months.
Data Preparation is something which can improved and connectivity with more visualization tools are few factors which can be improved.
As Talend Data Integration becomes more cloud focused, the gap in features / functionality widens between on-premise functionality and the cloud. The move in creating a new product like pipeline designer only emphasis this gap.

Do you think Talend Data Integration delivers good value for the price?

Yes

Are you happy with Talend Data Integration's feature set?

Yes

Did Talend Data Integration live up to sales and marketing promises?

Yes

Did implementation of Talend Data Integration go as expected?

Yes

Would you buy Talend Data Integration again?

Yes

The same way you design data integration job can be used to design services. It is easy to enhance by custom components and can adapt to all requirements. Talend Data Integration connects to [a] multitude of data sources and streaming service. Very easy interface to design complex applications without spending much time on coding. Easy to learn and master. Talend constantly strives to better itself by adding more features and functionalities.

Talend Data Integration Feature Ratings

Connect to traditional data sources
8
Connecto to Big Data and NoSQL
8
Simple transformations
8
Complex transformations
8
Data model creation
8
Metadata management
8
Business rules and workflow
8
Collaboration
8
Testing and debugging
8
Integration with data quality tools
8
Integration with MDM tools
8

Comments

More Reviews of Talend Data Integration