TrustRadius Insights for Talend Data Integration are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Business Problems Solved
Talend has been widely used in various industries for a range of data-related tasks. In the Telecom industry, Talend has been instrumental in extracting and transforming data from mediation systems, enabling the creation of reports such as Prepaid recharge master and credit limit enhancement. Users have also integrated Talend with Tableau to generate region-wise revenue dashboards for senior management, providing valuable insights into business performance.
Talend Cloud has served as a comprehensive data mart solution, facilitating data migration and providing cloud extension capabilities. Users have praised the data pipeline visualization feature of Talend Cloud, which has made it easier to understand and manage complex data flows. Additionally, Talend has been employed to implement an Enterprise Data Warehouse for Supply Chain information, enabling the creation of an evolved reporting system. The flexibility of Talend has been particularly valuable in extracting and processing data, including running data science algorithms for predicting selling forecasts and raw materials supply.
Organizations have successfully consolidated data from multiple databases using Talend, including Oracle Database, Salesforce, Sugar CRM, SQL DB, FTP, Netezza, and Files. Users have found it useful in integrating data between different departments with varying data structures, improving overall efficiency and identifying bottlenecks. Talend has also been effective in building corporate data warehouse solutions by centralizing company intelligence from different sources and databases.
The ease of use, debug, and deployment of Talend have been prominently praised by users, along with its compatibility across different operating systems. Its versatility in handling ETL processes has resulted in its widespread adoption across organizations for integrating various systems and migrating data. Furthermore, Talend Product Intelligence has proven valuable for consolidating user research data and providing analytics metrics for product teams.
Some users have expressed frustration with the limitations of the free version of Talend, particularly regarding source control and functionality in the Eclipse environment. However, overall feedback highlights that Talend is known for its readability, ease of use, and the ability to interact more with data. Users have migrated from other ETL tools to Talend and trained their employees to use it. Its robustness and versatility have made it a go-to choice for transforming data from non-relational databases into relational databases.
In summary, Talend's use cases span various industries and tasks, including data extraction and transformation, data migration, building data warehouses, integrating systems, and providing valuable analytics capabilities. Its compatibility across different operating systems and ease of use make it a popular choice among users.
Data integration is a key to our organization's analytics needs. After applying business logic and transformation, we integrate data from multiple applications and store that in a typical data warehouse. So, Talend Data integration helps us solve this use case. Also, we integrate data between applications for business use cases; this is also taken care of by Talend.
Pros
End-to-end ETL flow with transformation.
It is easy to create a pipeline with available in-built components.
Connectors are available for many applications.
Data quality checks are made simple.
Manual data transformation can be done using Java coding.
Cons
Connectors for new applications in the market.
Default template jobs for a quick start.
More default data quality components.
Likelihood to Recommend
This tool fits all kinds of organizations and helps to integrate data between many applications. We can use this tool as data integration is a key feature for all organizations. It is also available in the cloud, which makes the integration more seamless. The firm can opt for the required tools when there are no data integration needs.
VU
Verified User
Employee in Information Technology (Telecommunications company, 5001-10,000 employees)
We use Talend to transform data from non-relational databases into relational databases. Talend is extremely robust and versatile, so much so that we have even migrated from other ETL tools and trained employees in order to use Talend. It is versatile in the sense of readability, it can read many more types of files and you are able to interact much more with the data.
Pros
Being robust
Versatile
Usability
User Interface
Cons
Speed
Likelihood to Recommend
If you are ingesting heavy data, Talend is the right tool for you. If you are just casually transforming data, then a less high-end tool would be better suited. Talend does a really good job of taking heavy data from multiple sources and allowing you to manipulate it easily.
VU
Verified User
Analyst (Media Production company, 1001-5000 employees)
Talend Product Intelligence is mainly used as a data integrator for user research on all our internal products. As a part of the product team, I tend to receive feedback on different products from different users at different life stages. It was getting increasingly inefficient to keep track of user research data in an isolated way. Talend Product Intelligence helps us put it all together in one place.
Pros
Compatibility with and conversion among data formats
Compatibility with BI solutions
Community support
Cons
Lack of documentation on some part of the product
Could be resource-light, needs more processing power
Pricing can be improved
Likelihood to Recommend
Talend Product Intelligence is recommended for managing end-to-end intelligence around the entire product suite, not just in research but also from the products that are actively used. From UX research to customer experience measurement for products across the lifecycle. From user logs to product surveys, Talend Product Intelligence helps manage the data repository and seamlessly connects with your cloud, data sources, as well as BI front-ends like Tableau, Power BI, Google Looker, etc.
VU
Verified User
General Manager (Music company, 1001-5000 employees)
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.
Likelihood to Recommend
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.
VU
Verified User
Engineer in Engineering (Internet company, 5001-10,000 employees)
We use Talend Data Integration in Data Engineering and Profiling departments to develop ETL. We use it to move data from relational data bases to mongodb.
Pros
Data Transformation
Integration of various sources
It can use multiple type of data
Cons
More modules to integrate to more sources
Help from [the] Community
Likelihood to Recommend
To develop ETL processes it is great if you want to have almost complete control on what happens to your data.
We use the big data edition of Talend Integration Suite. It is used by the Business Intelligence department for extract transform load (ETL). There are more than 400 jobs that pull data or push data from various sources. Talend is used to load data into the enterprise data warehouse. (EDW). I use the big data edition to pull data from hive cluster. There are complex sources like highly nested JSON and XML that can be easily parsed using Talend components. The best thing I like about Talend is the ease of use/debug and ease of deployment. Behind the scenes it uses Java coding, so whatever you do in the interface can be easily visible under code. Packaging and deployment of code is easy too in any environment (Windows or Mac or Linux) with any version of Java compatibility.
Pros
JSON parsing, if you are into highly nested JSON object parsing Talend has the ability to display the structure of JSON and allows you to define the extraction logic in the metadata. Same with XML source.
Customization, For mostly all ETL work you will have a component in Talend. And in case you have a very specific requirement you can end up easily designing a custom component that you can code and reuse and share with others.
Talend has a connectivity option to almost all the databases (relational or NOSQ)L and sources available. It also has generic JDBC/ ODBC drivers in case you need it.
I like the ease of deployment across environment (DEV and PROD) with the use of context variables.
Cons
The Talend Administration Console TAC is a great place to schedule and monitor your jobs. Probably the interface can be improved.
Likelihood to Recommend
Talend as an ETL tool is robust and flexible because of the transparency of the behind the scene Java code. Developers can debug and optimize the code easily because of visibility. The big data component of talend makes it the IDE for working with file formats like JSON and log files.
Talend gives the ability to pull data using WSDL/API and also to make data available as REST API. Talend jobs are platform independent and can be deployed easily. IDE is eclipse based.
VU
Verified User
Consultant in Information Technology (Computer Software company, 11-50 employees)
Talend is used to build a corporate data warehouse solution which centralizes all relevant company intel into a single repository. Talend is used for development only by the IT department (as expected) but the information it gathers is used for the whole company. The main problem which talend addresses is to unify different sources of intel by retrieving data from databases, files, web services, the internet, etc.
Pros
Reading for multiple sources: Any modern Database, Files, WebServices, etc.
Monitoring and scheduling task dependencies for data loading purposes.
Really useful to design a Data Warehouse, thanks to its built in components for design patterns like SCD, etc.
It's also useful to publish data interfaces via WebServices or REST.
Good and high qualified support team.
Connecting to various databases from classic Relational (MSSQL, Oracle, MySQL, etc.) to No-SQL Databases.
Well documented.
Community which provides plugins, etc.
Cons
Installation process of Integration Suite platform.
JAVA memory management. It's easy to get a memory overhead error, and you have to modify configuration files to increase memory manually.