Talend Open Studio for all
December 12, 2018
Talend Open Studio for all
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Talend Open Studio
Talend is used by parts of my company mainly in the integration team. We use it to move data between various systems such as FTP, Oracle DB, DB2, MDM, CRM. We move data on a schedule and on demand. We use Talend Open Studio to sync data between various systems. We also use Talend jobs to backup some important files which are generated part of other ETL jobs.
- Talend runs fast and long without any issues to move millions of records as part of a single job run.
- Talend shows a good preview of the data counts moving between various systems.
- Using property files in Talend we can dynamically use various environment specific values seemlessly.
- Talend Open Studio does not have enough components to do Deduplication and fuzzy match using machine learning.
- Talend Open studio is not highly available and makes it tough to run Tier 1 applications.
- Talend Open Studio does not provide any good ways to do unit testing of the components.
- It was easy to quickly ramp up a team of ETL developers without prior knowledge on ETL jobs
- We could move millions of records into CRM systems within a span of a day as part of a large data migration project.
- We did not have a scheduler as part of the open studio. We had to build a quartz based scheduler to run the jobs on schedule and on demand
Talend Open studio is free and anybody can quickly ramp up and start working on it. We do not need to have strong ETL skills to start using it. Exploring the intricacies takes skill. Doing basic integrations is quite easy with Talend compared to Oracle Data Integrator or other ETL tools. We can deploy Talend applications/jobs on Weblogic or docker. Oracle Data Integrator is not easy to use compared to Talend.
Talend Open Studio Feature Ratings
Using Talend Open Studio
20 - It's mostly used by Integration developers and few architects. Developers use it to build ETL jobs for bulk data movement between disparate systems such as Data bases and files and FTP locations. Architects use it to quickly check data transformations and to move small set of data into target systems to check the functionality.
5 - Talend Open Studio is an open source software. We have support from middleware team to deploy the jobs into weblogic app servers and support from Systems team to support the jenkins build and the github repository. Talend Open Studio itself is not supported. We depend on the open source community for any issues.
- Quick data transformation
- Quick data migration
- Bulk and schedule data migration between disparate systems
- We never used Talend Open Studio for CRM systems. This has turned out really cool for us.
- We could ETL millions of records without any licence cost with free Talend Open Studio
- We could automate file backup using Talend Open Studio jobs
- We may use Talend for bigdata in the future
- We may use data preparation in future
- We might consider using Talend ESB
Evaluating Talend Open Studio and Competitors
Not Sure
- Price
- Product Features
- Analyst Reports
- Third-party Reviews
Cost is a very important factor for any software with great functionality. The free Talend Open Studio is a great starter for anybody with low to medium ETL requirement. We have tested and used it for few millions of records migration and it works great without any issues. Also, the stability of the product is very important for us. MAC users have some issues with older versions of Talend. It works great on Windows.
I do not see any reason for change of evaluation or selection process. Talend Open Studio fits all our requirements and data migration needs. Even when new systems are added to our kitty, we do not see any short of Talend Open Studio components to use. It's just great for what we need from it.