TrustRadius: an HG Insights company

Informatica PowerCenter (legacy) vs. SAP Data Intelligence

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Informatica PowerCenter (legacy)

    Score9.3 out of 10
    N/AInformatica PowerCenter was data integration technology designed to form the foundation for data integration initiatives, application migration, or analytics. It is a legacy product.N/A

    SAP Data Intelligence

    Score7.6 out of 10
    N/ASAP Data Intelligence is presented by the vendor as a single solution to innovate with data. It provides data-driven innovation in the cloud, on premise, and through BYOL deployments. It is described by the vendor as the new evolution of the company's data orchestration and management solution running on Kubernetes, released by SAP in 2017 to deal with big data and complex data orchestration working across distributed landscapes and processing engine.N/A
    Pricing
    Informatica PowerCenter (legacy)SAP Data Intelligence
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Informatica PowerCenter (legacy)SAP Data Intelligence
    Free Trial
    NoYes
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoYes
    Entry-level Setup FeeNo setup feeOptional
    Additional Details——
    More Pricing Information
    Community Pulse
    Informatica PowerCenter (legacy)SAP Data Intelligence
    Considered Both Products
    Discontinued Products
    No answer on this topic
    SAP
    Chose SAP Data Intelligence
    Very high speed in database connection and fast analysis of big data as well as import of all types of information and databases.‌ I am satisfied with SAP products and their simplicity and its many benefits, and this SAP Data Intelligence software is one of the best.
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    98%
    Would buy again
    51 Answers
    Delivers good value for the price
    No answers on this topic
    90%
    Delivers good value for the price
    36 Answers
    Happy with the feature set
    No answers on this topic
    98%
    Happy with the feature set
    52 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    88%
    Lived up to sales and marketing promises
    28 Answers
    Implementation went as expected
    No answers on this topic
    86%
    Implementation went as expected
    32 Answers
    Features
    Informatica PowerCenter (legacy)SAP Data Intelligence
    Data Source Connection
    Comparison of Data Source Connection features of Informatica PowerCenter (legacy) and SAP Data Intelligence
    Feature
    Informatica PowerCenter (legacy)
    8.5
    18 Ratings
    1% above category average
    SAP Data Intelligence
    -
    Ratings
    Connect to traditional data sources9.018 Ratings00 Ratings
    Connecto to Big Data and NoSQL8.014 Ratings00 Ratings
    Data Transformations
    Comparison of Data Transformations features of Informatica PowerCenter (legacy) and SAP Data Intelligence
    Feature
    Informatica PowerCenter (legacy)
    7.5
    18 Ratings
    8% below category average
    SAP Data Intelligence
    -
    Ratings
    Simple transformations8.018 Ratings00 Ratings
    Complex transformations7.018 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of Informatica PowerCenter (legacy) and SAP Data Intelligence
    Feature
    Informatica PowerCenter (legacy)
    8.2
    18 Ratings
    3% above category average
    SAP Data Intelligence
    -
    Ratings
    Data model creation9.015 Ratings00 Ratings
    Metadata management8.016 Ratings00 Ratings
    Business rules and workflow9.018 Ratings00 Ratings
    Collaboration6.116 Ratings00 Ratings
    Testing and debugging9.017 Ratings00 Ratings
    Data Governance
    Comparison of Data Governance features of Informatica PowerCenter (legacy) and SAP Data Intelligence
    Feature
    Informatica PowerCenter (legacy)
    9.0
    15 Ratings
    11% above category average
    SAP Data Intelligence
    -
    Ratings
    Integration with data quality tools9.015 Ratings00 Ratings
    Integration with MDM tools9.013 Ratings00 Ratings
    Best Alternatives
    Informatica PowerCenter (legacy)SAP Data Intelligence
    Small Businesses
    Skyvia
    Score10 out of 10
    No answers on this topic
    Medium-sized Companies
    IBM InfoSphere Information Server
    Score10 out of 10
    SAP Datasphere
    Score8.6 out of 10
    Enterprises
    SolarWinds Task Factory
    Score8.3 out of 10
    Talend Data Fabric
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Informatica PowerCenter (legacy)SAP Data Intelligence
    Likelihood to Recommend
    8.0
    (21 ratings)
    8.1
    (55 ratings)
    Likelihood to Renew
    10.0
    (4 ratings)
    8.2
    (2 ratings)
    Usability
    9.0
    (3 ratings)
    8.2
    (50 ratings)
    Performance
    9.4
    (2 ratings)
    -
    (0 ratings)
    Support Rating
    9.0
    (2 ratings)
    7.0
    (47 ratings)
    Configurability
    -
    (0 ratings)
    8.2
    (1 ratings)
    Vendor post-sale
    -
    (0 ratings)
    9.1
    (1 ratings)
    Vendor pre-sale
    -
    (0 ratings)
    9.1
    (1 ratings)
    User Testimonials
    Informatica PowerCenter (legacy)SAP Data Intelligence
    Likelihood to Recommend
    Discontinued Products
    1.- Scenaries with poor sources of data is not recomended (Very bad ROI). The solution is for medium-big enterprises with a lot of sources of data and users. 2.- Bank and finance enviroment to integrate differente data form trading, Regulatory reports, decisions makers, fraud and financial crimes because in this kind of scenary the quality of data is the base of the business. 3.- Departments of development and test of applications in enterprises because you can design enviroments, out of the production systems, to development and test the new API's or updateds made.
    Incentivized
    Read full review
    SAP
    If you have an SAP products ecosystem in your IT landscape, it becomes a no-brainer to go ahead with an SAP Data Intelligence product for your data orchestration, data management, and advanced data analytics needs, such as data preparation for your AI/ML processes. It provides a seamless integration with other SAP products.
    Incentivized
    Read full review
    Pros
    Discontinued Products
    • Informatica Powercenter is an innovative software that works with ETL-type data integration. Connectivity to almost all the database systems.
    • Great documentation and customer support.
    • It has a various solution to address data quality issues. data masking, data virtualization. It has various supporting tools or MDM, IDQ, Analyst, BigData which can be used to analyze data and correct it.
    Incentivized
    Read full review
    SAP
    • It integrates well with our current ecosystem of SAP products, like HANA.
    • It provides end-to-end machine learning operations, with tools for the complete model life cycle.
    • It has a simple user interface for novice users, with complex tools also available for power users.
    • It builds on SAP Data Hub, providing all the ETL functions of that tool with additional machine learning functionality.
    • It can run in the cloud, no on-premise software management needed.
    • Many programming languages are supported, it provides a sandbox environment for the user to develop in whichever style they prefer.
    • SAP is very actively developing and improving it.
    Incentivized
    Read full review
    Cons
    Discontinued Products
    • There are too many ways to perform the same or similar functions which in turn makes it challenging to trace what a workflow is doing and at which point (ex. sessions can be designed as static or re-usable and the override can occur at the session or workflow, or both which can be counter productive and confusing when troubleshooting).
    • The power in structured design is a double edged sword. Simple tasks for a POC can become cumbersome. Ex. if you want to move some data to test a process, you first have to create your sources by importing them which means an ODBC connection or similar will need to be configured, you in turn have to develop your targets and all of the essential building blocks before being able to begin actual development. While I am on sources and targets, I think of a table definition as just that and find it counter intuitive to have to design a table as both a source and target and manage them as different objects. It would be more intuitive to have a table definition and its source/target properties defined by where you drag and drop it in the mapping.
    • There are no checkpoints or data viewer type functions without designing an entire mapping and workflow. If you would like to simply run a job up to a point and check the throughput, an entire mapping needs to be completed and you would workaround this by creating a flat file target.
    Incentivized
    Read full review
    SAP
    • Data transfer speed tends to be slow when there is poor internet connection since SAP Data Intelligence don’t synchronize data while offline. However, this is not vendor fault, that’s why we have implemented robust wireless technology internet connection in our organization.
    Incentivized
    Read full review
    Likelihood to Renew
    Discontinued Products
    Our team enjoys using Informatica and feels that it is one of the best ETL tools on the market.
    Read full review
    SAP
    Allow collaborations among various personas
    with insights as ratings and comments on the
    datasets Reuse knowledges on the datasets for new users Next-Gen Data Management and Artificial Intelligence
    Incentivized
    Read full review
    Usability
    Discontinued Products
    Positives; - Multi User Development Environment - Speed of transformation - Seamless integration between other Informatica products. Negatives; - There should be less windows to maintain developers' focus while using. You probably need 2 big monitors when you start development with Informatica Power Center. - Oracle Analytical functions should be natively used. - E-LT support as well as ETL support.
    Incentivized
    Read full review
    SAP
    I think the troubleshooting process might be streamlined with improved error recording and tracing. A lot of information about issues and how to fix them is hidden away in the Kubernetes pods themselves. I'm not sure whether SAP Data Intelligence can fix this problem it may be connected to Kubernetes's design, in which case fixing it could need modifications inside Kubernetes itself.
    Incentivized
    Read full review
    Performance
    Discontinued Products
    PowerCenter is robust and fast, and it does a great job meeting all the needs, not just the most commercially vocal needs. In the hands of an expert power user, you can accomplish almost anything with your data. It is not for new users or intermittent users-- for that the Cloud version is a better fit. Be prepared for costly connectors (priced differently for each source or destination you are working with), and just be planful of your projects so you are not paying for connectors you no longer need or want
    Incentivized
    Read full review
    SAP
    No answers on this topic
    Support Rating
    Discontinued Products
    Informatica power center is a leader of the pack of ETL tools and has some great abilities that make it stand out from other ETL tools. It has been a great partner to its clients over a long time so it's definitely dependable. With all the great things about Informatica, it has a bit of tech burden that should be addressed to make it more nimble, reduce the learning curve for new developers, provide better connectivity with visualization tools.
    Incentivized
    Read full review
    SAP
    Initially we struggle to get help from SAP but then dedicated Dev angel was assigned to us and that simplify the overall support scenario. There is still room of improvement in documentation around SAP Data intelligence. We struggle a lot to initially understand the feature and required help around performance improvement area,
    Incentivized
    Read full review
    Alternatives Considered
    Discontinued Products
    While Talend offers a much more comfortable interface to work with, Informatica's forte is performance. And on that front, Informatica Enterprise Data Integration certainly leaves Talend in the dust. For a more back-end-centric use case, Informatica is certainly the ETL tool of choice. On the other hand, if business users would be using the tool, then Talend would be the preferred tool.
    Incentivized
    Read full review
    SAP
    One of the reasons to pick SAP Data Intelligence is the speed and security it provides, in addition to the excellent support it provides. It is also compatible with all popular databases, which is another reason to choose it.
    Incentivized
    Read full review
    Return on Investment
    Discontinued Products
    • The data pipeline automation capability of Informatica means that few resources are needed to pre-process the data that ultimately resides in a Data Warehouse. Once a workflow is implemented, manual intervention is not needed.
    • PowerCenter did require more resources and time for installation and configuration than was expected/planned for.
    • The lack of or minimal support of unstructured data means that newer sources of dynamic/changing data cannot be easily processed/transformed through PowerCenter workflows.
    Incentivized
    Read full review
    SAP
    • Automation of data management slashed tasks by over 60% in most departments for the first 8 months.
    • Metadata catalogs have enabled us to categorize data from disjointed sources in one place.
    • It runs multiple ML models which enhances flexibility when managing data.
    Incentivized
    Read full review
    ScreenShots

    SAP Data Intelligence Screenshots

    Screenshot of Business GlossaryScreenshot of Example of data quality operatorsScreenshot of Data profiling fact sheetScreenshot of SAP Data Intelligence Jupyter lab notebook for machine learningScreenshot of SAP Data Intelligence data pipeline using PythonScreenshot of SAP Data Intelligence example ata quality dashboard