Extract the difficulty out of your data gathering workflows, transform your time into meaningful utilization, and load up on your returns.
Overall Satisfaction with Talend Open Studio
We use Talend Open Studio to extract and transform data from our Mongo database into our Microsoft SQL Server database to allow for better reporting options for our end-users.
- Installation and deployment are very rapid.
- The user interface allows for quick builds and the testing.
- The build and deployment of your applications into production are simplified allowing for a shorter development lifecycle.
- More tutorials and examples of utilization of each component would be helpful. There are plenty of forums to gather this information but best practices and examples from the manufacturer always welcome in my book.
- By using Open Studio to migrate information from our Mongo database into a traditional RDBMS, SQL server, we saved about 75% of our time gathering information to build reporting.
- By gathering more accurate data through the ETL process we have been able to capture between 5 and 10% more revenue through better reporting on utilization which bolsters our opportunity for add-on business.
I prefer to use Talend Open Studio over SQL Server Integration Services because of the ease of use and wider connection library opportunities. By leveraging Talend Open Studio we are able to connect to a much wider set of source data as well as rapidly designing and deploying solutions for ETL.