Skip to main content
TrustRadius
Talend Data Integration

Talend Data Integration

Overview

What is Talend Data Integration?

The Talend Integration Suite, from Talend, is a set of tools for data integration.

Read more
Recent Reviews

TrustRadius Insights

Talend has been widely used in various industries for a range of data-related tasks. In the Telecom industry, Talend has been instrumental …
Continue reading

Talend is a great tool

9 out of 10
January 08, 2022
Incentivized
Talend Data is used to load data from different data sources such as SAP HANA, APIs, MS SQL, Excel sheets, etc. The aim is to extract the …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 11 features
  • Connect to traditional data sources (9)
    8.9
    89%
  • Simple transformations (9)
    8.9
    89%
  • Complex transformations (9)
    8.9
    89%
  • Testing and debugging (9)
    8.8
    88%
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Talend Data Integration?

The Talend Integration Suite, from Talend, is a set of tools for data integration.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

22 people also want pricing

Alternatives Pricing

What is COZYROC?

COZYROC SSIS+ is a suite of 240+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. The vendor states that COZYROC is an easy-to-use, code-free library of tasks, components and reusable scripts that aim to significantly cut development time and improve…

What is Clear Analytics?

Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.

Return to navigation

Product Demos

3. Talend Data Integration demo for Error Handling

YouTube

Talend ETL Tool Tutorial For Beginners and Advanced | Online Training | Venkat| +91-9538160185

YouTube

Talend Training | Talend Real Time Projects #TalendTechSolutions #TalendDi

YouTube
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

8.2
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

8.9
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

7.9
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

7.8
Avg 8.2
Return to navigation

Product Details

What is Talend Data Integration?

Talend Data Integration Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

The Talend Integration Suite, from Talend, is a set of tools for data integration.

Reviewers rate Connect to traditional data sources and Simple transformations and Complex transformations highest, with a score of 8.9.

The most common users of Talend Data Integration are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(74)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

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.

Users commonly recommend the following when using Talend integration software:

  • Users suggest going through the documentation and designing the job themselves for any scenario. This recommendation emphasizes the importance of understanding the software's capabilities and tailoring it to specific data management needs.

  • Users recommend using Talend with TAC (Talend Administration Center) for optimal utilization. This recommendation highlights the benefits of integrating Talend's management and monitoring features to enhance workflow efficiency.

  • Users believe that Talend is a top consideration when searching for options in data integration software. This recommendation acknowledges Talend's reputation as a reliable tool that meets users' needs without requiring them to explore more expensive alternatives.

Attribute Ratings

Reviews

(1-18 of 18)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Its super important to know and understand how a product is performing, after its release, with the consumers who get their hands on it. This is where Talend Product Intelligence comes in. It provides data for analytics. With metrics like active users, most used features etc, this is exactly what was needed.
  • Analytics on the consumers and their usage habits
  • Also helps understand what part of the product is working for the customer and what isnt
  • Understanding the product from the consumers perspective helps build a company that grows exponentially
  • With things like analytics, theres always room for improvement. The goalposts are ever shifting.
  • A deeper dive into the analytics can be provided with reports and graphs and what not as possibilities
You make a product. You’re not sure how the market will react to it. Talend Product Intelligence enters the picture.Suddenly you know your consumers likes, dislikes, how they use your product, what gravitates then or what pushes them away. Its great research into however you can tweak and fix your products to grow as a company.
Silvia Guardini | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We used Talend to implement an Enterprise Data Warehouse (EDW) that could contain all Supply Chain information in order to create an evolved reporting system. Moreover, we needed a flexible tool to extract and elaborate data, but also run external processes like data science algorithms that had to predict selling forecasts and raw materials supply to create some new KPIs for the production office.
  • Extract from source systems
  • Elaborate data
  • Run external processes
  • Can be used in a cloud solution
  • Support not as strong as other vendors.
  • If you want to use it in the best way you need to be able to do some programming.
  • With ETL component you cannot join tables from different schemas.
Talend is a complete tool with a lot of flexibility for the development and execution of complex tasks. Before we did not trust it so much as it did not have an enterprise solution, while now we feel free to propose it to customers. The graphic view is a little old, and it seems a tool more indicated to be programmed by a data engineer as you need to be able to write some code as well if you want to obtain complex results, while an easy approach as ETL could be managed by a developer.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Being robust
  • Versatile
  • Usability
  • User Interface
  • Speed
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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We are basically bringing data from multiple places to the EDW using Talend. We are stitching data from multiple places to have a unified business view so that we can understand the overall business performance.We primarily use it to consolidate data from several different databases. E.g. we used Oracle Database, Salesforce, Sugar CRM, SQL DB, MQ, FTP, Netezza, and Files using Talend Data Integration. We also migrate a lot of data between the system on a one-time basis.
  • We used Talend to ETLing the data from myriad sources such Oracle Database, Clarify, Salesforce, Sugar CRM, SQL DB, MQ, Stibo Step, FTP, Netezza, and Files.
  • We leverage Talend transformation capabilities for stitching the data , unions and join
  • We successfully created the final unified set that can be used by business
  • We were able to produce Good visualization by created curated data sets but it takes lot of time.
  • Talend has a ok user experience but there is ample scope of improvement in documentation and CX.
  • Talend can help uses by providing better error messages
Talend is a top quality product when it comes to below
  1. Transforming the data from one form to another
  2. Ingesting the data from multiple places
  3. Joining or unionizing the data
  4. Building destination data set
Talend is not well suited when it comes to below
  1. Custom coding to do wrangle data
Shishir Chadha | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Talend is helping us in getting the data extracted from mediation (Telecom) and transforming it into reports like Prepaid recharge master and credit limit enhancement. Products are also configured and used as a lookup for charging. We have also integrated Talend Product Intelligence with Tableau for region-wise revenue dashboards. For senior management.
  • Helps data transformation for dashboard creations.
  • Helps in decision making.
  • Helps detecting revenue leakage.
  • Pricing for sure can be the area for improvement.
  • Real time processing is slow as compared to other tools like Abinitio.
  • While developing batches, it crashes a lot. It may be the issue with me, but I wanted to highlight it.
I would not suggest it for real-time processing as it seems slow to me, however, processing bath files or product mapping, it's a good tool to use.
Anjum Arora | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Talend is used at EWS to integrate data between our MS SQL Reporting Server (ERP & Exact Global) and Cloud Apps like Cropin & Salesforce. We implemented it in 2018 and it’s proved to be highly efficient & reliable while working on large datasets replacing the custom (.NET coded) solution. It is used as a middleware to pass data of Farmers/Growers, Contracts & Fields from Reporting Server (ERP) to Cropin and Yield Estimations, Sowing, Transplanting & First Receiving Dates from Cropin to Reporting Server. In other Use cases, it integrates Reporting Server & Exact Global with Salesforce to pass Customer's Information and credit limits, Products & Price List, Accounts & Inventory information.
  • Highly efficient
  • Reliable while handling large datasets
  • Integrates on-Prem systems with Cloud systems seamlessly
  • More intuitive UX
  • Increased visibility would serve the product well too
It’s a great middleware integration suite product to integrate on-prem with Cloud-native apps e2e seamlessly and with high efficiency and reliability while handling large datasets, interfacing data instead of manual interventions, thereby replacing clunky custom-coded solutions. It’s a critical connector for business operations at EWS and hence super important as a solution.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Compatibility with and conversion among data formats
  • Compatibility with BI solutions
  • Community support
  • Lack of documentation on some part of the product
  • Could be resource-light, needs more processing power
  • Pricing can be improved
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.
January 08, 2022

Talend is a great tool

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Talend Data is used to load data from different data sources such as SAP HANA, APIs, MS SQL, Excel sheets, etc. The aim is to extract the data from one/multiple sources, transform the same and then load it into the target data source. Talend is a very efficient tool for data preparation.
  • Extract data from different type of sources - Great connectivity options available.
  • Transform the data using multiple functions/components within Talend Data.
  • Load the data into different types of target tables.
  • One can also customize the code for specific use cases.
  • Scheduling options are limited.
  • Using Machine Learning is not very easy.
  • Documentation provided by Talend can be better.
Talend is a great tool for data preparation as wells as integration. One can connect to multiple databases such as Oracle, MS SQL, SAP HANA, etc., and can transform/prepare the data as per the business requirements. Further, data can be easily loaded into a different database as per the requirement. The machine learning feature is not very easy to use.
Score 8 out of 10
Vetted Review
Verified User
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.
  • 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.
  • 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.
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.
Rodrigo Pérez Romero | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Data Transformation
  • Integration of various sources
  • It can use multiple type of data
  • More modules to integrate to more sources
  • Help from [the] Community
To develop ETL processes it is great if you want to have almost complete control on what happens to your data.
Jay Padhya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Talend Cloud is our one stop shop for all our data marts. You cant find a better data integration tool than this. This comes with cloud extension and helps data migration so easily. We create the ELK stack service and Talend Cloud is best by far. The better part is data pipeline visualization
  • The simplicity of the ETL process
  • Drag and drop on tool pallet
  • Visualization
  • Great community on slack
  • Slowdown on Java code generation
  • Implantation after the solution isn't intuitive.
  • Version management
Pros
- Large pallet of components
- Web service generation
- A great time-saving tool rather than writing bash scripts for automation
- No need to write Unix codes and had comments to do miscellaneous tasks

Cons
- For advance coding projects - you need to know Java a great deal
- Big Data integration is complex to understand and has less community support online
- Version updates are not that easy to understand

Malcolm O'Callaghan | TrustRadius Reviewer
Score 1 out of 10
Vetted Review
Verified User
The free version of this software is infuriating to use for anything but the most simple projects. There is no good way to implement source control without paying for the software which is outrageously expensive per seat. Talend uses the Eclipse environment but disables any useful functionality for development. They insert keys into every text file - these key values change constantly so using a source control system like Git is next to impossible. With some difficulty, you can set the application up so you can compare versions of your project side-by-side, but you can not copy Talend objects across instances of Talend and it is not possible to open two projects up at the same time in one instance.

Additionally, projects open in new versions of Talend - even minor updates - are completely incompatible with older versions. As a result, you get stuck on the lowest common version. In our case, that version was discontinued without notification from the open-source repository. Totally unacceptable.

Yes, the open-source version is free, but it is little more than a demo if you are going to do anything complex or mission critical. If you can not compare versions of projects with one another this tool is useless and they are really only using open source as a sales tool.
  • Data Transformation
  • Version Control
  • Search
  • Pricing
  • Logging
I am currently looking for a more flexible tool which fits into a more traditional software development environment.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Talend Data Integration is used across our organization. We perform Extract, Transform, and Load using Talend. We integrate various systems such as Oracle Database, Clarify, Salesforce, Sugar CRM, SQL DB, MQ, Stibo Step, FTP, Netezza, and Files using Talend Data Integration. We also migrate a lot of data between the system on a one-time basis.
  • The speed of migration is very good for a Free ETL tool.
  • The amount of components or connectors we have is impressive.
  • Talend Data Integration is not high available in the free version.
  • Talend support for sub-7 version on the latest MacBooks is not good.
Talend Data Integration is easy to use and learn. Talend Data Integration can perform bulk data migrations of up to a few million records without any issues. We have not tried it or had use case which required more than a few million records at a time. It works particularly well with databases and CRM software.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Talend Data Integration is primarily used by the data warehousing team. While the management of data warehousing in handled by a single team, they work with data sourced from and sent to all departments across the entire organisation - this makes Talend Data Integration a critical software component for our use cases.
  • Easy to use interface
  • Designing jobs is very straightforward
  • Allows the use of custom components to suit specific needs
  • Syncing with Git should be made easier
  • Can face issues with certain big data spaces
  • Support find it difficult to resolve complex issues
If your organisation or department works regularly with ETL jobs or sources data from multiple locations and needs to integrate them to provide for better data compatibility, then Talend Data Integration is a great tool and I would strongly recommend it. This mostly applies to established corporations, and not startups as the licensing fee is quite high.
December 19, 2017

Talented Talend

Sanket Bharaswadkar | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have a high amount of excel files coming in from different departments. They all have a different data structure. It was very difficult integrating all the types of data, with different data sizes. We used Talend to integrate data in one format. We had to perform data analysis, pattern recognition. It had a big impact on overall efficiency. We also found several bottlenecks, and narrowed our focus area.
  • data integration
  • support for different data sources
  • documentation
  • memory management
  • too technical for business users
  • IDE is slow
It is very useful for disparate data sources like Excel, Microsoft Access, SQL server or any relational database. Also, cases where you need data transformation, a lot of pre-processing, Talend is very good. Its tMap is very useful. It also has various transformers, and we can add custom logic for various data fields.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • The Talend Administration Console TAC is a great place to schedule and monitor your jobs. Probably the interface can be improved.
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.
Josep Coves Barreiro | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
  • Migration process.
It's perfect for data warehouse implementation.
December 14, 2015

Talend DI Suite Review

Score 7 out of 10
Vetted Review
Verified User
Incentivized
Talend Integration Suite has been chosen as the enterprise data integration tool for our client. We were using Informatica Power Center before that. Currently we are recreating the existing power center mapping in Talend to decommission Informatica. All new projects are using Talend DI. Talend has data integration, big data integration, data profiling and master data management components which are widely used in our projects based upon the data requirements.
  • Its an open source tool.
  • Developers can add new customized components to Talend for specific needs.
  • It has low cost as compared to commercial data integration tools.
  • The enterprise version has an option for integrating a variety of data platforms and connects to variety of data sources.
  • To run a job, a developer need not upload it to the server, jobs can be run locally.
  • Data loading components for different databases can be improved further. Currently Greenplum target compenents or postgre data target components are not yielding high throughput,
  • Transformation components can be made visually more attractive and informative.
  • Syntax used in data transformation can be simplified.
Talend Integration is a complete data integration suite which can cater to departmental as well as enterprise data integration needs.
Return to navigation