Coming October 25: PeerSpot Awards will be announced! Learn more

Informatica Cloud Data Integration vs Talend Open Studio comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Informatica Cloud Data Integration and Talend Open Studio based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Informatica Cloud Data Integration vs. Talend Open Studio report (Updated: August 2022).
635,987 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It has all the advantages of the Cloud in that you can use it without worrying about infrastructure, upkeep, or upgrades.""The product is scalable and excellent for enterprise-level organizations.""It has a more UI-based tool, and the scripting is good.""Informatica Cloud Data Integration is stable.""We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors.""The mass ingestion functionality and the elasticity of the solution are great.""Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors.""The solution's initial setup is quite straightforward."

More Informatica Cloud Data Integration Pros →

"Talend is safe to use because it is very restrictive. It is easy to use when one learns how to manipulate data with SQL.""The most valuable features of Talend Open Studio are customization and integration.""The best thing I have found with Talend Open Studio is their major support for the lookups.""The most valuable features are definitely data integration, data preparation, and data stewardship.""Talend can connect to multiple data sources, including relational data sources, ERP, CRM, and others.""Talend lets you do everything — mapping, workflow, and orchestration — in a single place.""The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily.""I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields. It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool."

More Talend Open Studio Pros →

Cons
"I have received feedback from certain teams and there is a steep learning curve to use this solution.""The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration.""Its pricing model can be improved. The response time from technical support can also be improved.""There may be some types of limitations with the performance.""Informatica Cloud Data Integration could improve the price by making it less expensive.""The current features are a bit complicated, and we need to write big scripts and test.""The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions.""The price modeling could be more flexible."

More Informatica Cloud Data Integration Cons →

"The server-side should be completely revamped.""Multiple products are there within the product suite. That can be actually trimmed down.""We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features.""Talend should improve the log and error handling to better track the errors you find during development. Sometimes it's challenging to see what's causing an issue, and tracking that on Talend is complicated.""The pricing could be lower. They should work to make it more affordable.""Talent consumes a lot of resources on my PC.""Talend Open Studio has a lot of capabilities, but there is some restriction. For example, if we want to connect to an SAP system, Open Studio cannot do it. We need to go with an enterprise version. Additionally, the monitoring features could improve.""In the next release, Open Studio should include cloud storage as an input."

More Talend Open Studio Cons →

Pricing and Cost Advice
  • "Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor."
  • "Its pricing model can be improved."
  • "I'm not sure about the most recent pricing trends, but I don't believe it's significantly different from PowerCenter. I believe it is nearly the same."
  • "The price of Informatica Cloud Data Integration could be reduced."
  • More Informatica Cloud Data Integration Pricing and Cost Advice →

  • "There are many versions available and one is open-sourced which is free."
  • "The cost for one year for the ETL tools, not for the big data, is 6K per year. It is a good price."
  • "It does the job well for nothing — without cost. That's the advantage of this product."
  • "Talend Open Studio is priced too high."
  • "Open Studio has a basic license and additional costs for services, including customer support and technical assistance."
  • More Talend Open Studio Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    635,987 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power… more »
    Top Answer:Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge… more »
    Top Answer:It has a more UI-based tool, and the scripting is good.
    Top Answer:We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in… more »
    Top Answer:Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement.
    Top Answer:Open Studio has a basic license and additional costs for services, including customer support and technical assistance.
    Ranking
    4th
    Views
    16,075
    Comparisons
    13,024
    Reviews
    9
    Average Words per Review
    389
    Rating
    8.0
    5th
    Views
    21,296
    Comparisons
    17,152
    Reviews
    13
    Average Words per Review
    549
    Rating
    7.6
    Comparisons
    Also Known As
    Open Studio
    Learn More
    Overview
    Informatica Cloud Data Integration is a unified and modern user experience across all iPaaS patterns, supported by a meta-data driven, modular, artificial intelligence-based microservices architecture tailored for IT, developers, and business users. It help delivers accessible, trusted, and secure data to facilitate more valuable business decisions and identify competitive advantages. Informatica Cloud Data Integration can help to distribute data warehouse and analytics projects. Features include the following: Deliver integrated and relevant data, Scale with data synchronization and replication, Integrate asset management, Support high-volume workloads, Design cloud mappings and Execute visual data integration flows.

    Talend Open Studio is a free, open source ETL tool for data integration and Big Data. The solution enables you to extract diverse datasets and normalize and transform them into a consistent format which can be loaded into a number of third-party databases and applications.

    Talend Open Studio Features

    Talend Open Studio has many valuable key features. Some of the most useful ones include:

    • Automatic identification of data types and potential errors
    • tMap module
    • Graphical conversion tools
    • Charts
    • Database SCD Tools
    • Business intelligence formats (Jasper, OLAP, SPSS, Splunk)
    • ETL and ELT support
    • Eclipse-based development tooling
    • Versioning
    • Large library of connectors
    • Data flow orchestration
    • File management without scripting
    • Data transformations

    Talend Open Studio Benefits

    There are several benefits to implementing Talend Open Studio. Some of the biggest advantages the solution offers include:

    • Reduces the time taken to develop the integration.
    • Provides a wide selection of source and target connectors.
    • Monitor and manage problematic deployments with ease.
    • Allows developers to have the lowest cost of ownership for any solution.
    • Improves collaboration between different teams who need access to data.
    • Automated data integration process synchronizes the data and eases real time and periodic reporting, which would be time-consuming if done manually.
    • Achieve better data quality because data matures and improves over time.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Talend Open Studio solution.

    Elio B., Data Integration Specialist/CTO at Asset messages, says, "The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."

    A Practice Head, Analytics at a tech services company mentions, “The data integration aspect of the solution is excellent. The product's data preparation features are very good. There's very useful data stewardship within the product. From a technical standpoint, the solution itself is pretty good. There are very good pre-built connectors in Talend, which is good for many clients or businesses, as, in most cases, companies are dealing with multiple data sources from multiple technologies. That is where a tool like Talend is extremely helpful.”

    Prerna T., Senior System Executive at a tech services company, comments, “The best thing I have found with Talend Open Studio is their major support for the lookups. With Salesforce, when we want to relate our child objects to their parent object, we need to create them via IDs. Then the upsert operation, which will allow you to relate a child object to the event, will have an external ID. That is the best thing which keeps it very sorted. I like that.”

    An Implementation Specialist, Individual Contributor at a computer software company, states, “I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields.” He also adds, “It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool.”

    PeerSpot user Badrakh V., Information System Architect at Astvision, explains, "The most valuable features are the ETL tools."

    Offer
    Learn more about Informatica Cloud Data Integration
    Learn more about Talend Open Studio
    Sample Customers
    Chicago Cubs, Telegraph Media Group
    Almerys, BF&M, Findus
    Top Industries
    REVIEWERS
    Computer Software Company47%
    Pharma/Biotech Company13%
    Individual & Family Service7%
    Manufacturing Company7%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Financial Services Firm12%
    Energy/Utilities Company8%
    Insurance Company8%
    REVIEWERS
    Computer Software Company30%
    Insurance Company20%
    Energy/Utilities Company10%
    Integrator10%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Comms Service Provider13%
    Financial Services Firm11%
    Energy/Utilities Company6%
    Company Size
    REVIEWERS
    Small Business21%
    Midsize Enterprise25%
    Large Enterprise54%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise11%
    Large Enterprise75%
    REVIEWERS
    Small Business39%
    Midsize Enterprise28%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    Buyer's Guide
    Informatica Cloud Data Integration vs. Talend Open Studio
    August 2022
    Find out what your peers are saying about Informatica Cloud Data Integration vs. Talend Open Studio and other solutions. Updated: August 2022.
    635,987 professionals have used our research since 2012.

    Informatica Cloud Data Integration is ranked 4th in Cloud Data Integration with 10 reviews while Talend Open Studio is ranked 5th in Data Integration Tools with 15 reviews. Informatica Cloud Data Integration is rated 8.0, while Talend Open Studio is rated 7.6. The top reviewer of Informatica Cloud Data Integration writes "A UI-based tool with great scripting ". On the other hand, the top reviewer of Talend Open Studio writes "Popular open-source ETL tool in Singapore/ South East Asia; Connects to Big Data; Easy to spot errors with generated Java code". Informatica Cloud Data Integration is most compared with Informatica PowerCenter, Azure Data Factory, AWS Glue, Mule Anypoint Platform and SAP Data Services, whereas Talend Open Studio is most compared with SSIS, AWS Glue, Azure Data Factory, Talend Data Fabric and Confluent. See our Informatica Cloud Data Integration vs. Talend Open Studio report.

    We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.