TrustRadius: an HG Insights company

Informatica PowerCenter (legacy) vs. SQL Server Integration Services

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Informatica PowerCenter (legacy)

    Score7.9 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

    SSIS

    Score6.5 out of 10
    N/AMicrosoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A
    Pricing
    Informatica PowerCenter (legacy)SSIS
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Informatica PowerCenter (legacy)SSIS
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Informatica PowerCenter (legacy)SSIS
    Considered Both Products
    Discontinued Products
    Chose Informatica PowerCenter (legacy)
    SSIS is a good entry into ETL, for smaller organizations or Microsoft-centric companies. It's strengths lie in its ease-of-use, quick turnaround, and simplicity. Its weaknesses lie in scalability and re-usability (you can achieve re-usability, however segmentation is at the …
    Incentivized
    Chose Informatica PowerCenter (legacy)
    PowerCenter can be run from different types of OSs and can integrate with multiple types of databases and applications compared to SSIS. PowerCenter performs better with any type of database due to its ability to use native drivers to read as well as load data. Due to its seam …
    Incentivized
    Microsoft
    Chose SSIS
    SSIS is similar to Alteryx and Informatica PowerCenter in a way because these are all drag-and-drop ETL tools with similar functionality. Alteryx is a step ahead because it has some advanced ETL functionalities including statistical calculations etc. and a better ability to set …
    Incentivized
    Chose SSIS
    I personally prefer SSIS. There are items that each do better than the others, but the ease of use of SSIS, along with its extensibility to 3rd party, ability to write any code required in the tool, and uses the same IDE for the MS BI suite (more of an issue if you're not a …
    Incentivized
    Chose SSIS
    SQL Server is already in our wheelhouse so it only made sense to utilize the tools we already had available to us--SSIS, SSAS, & SSRS. Other non-technical users seem to be more comfortable using alternatives to SSIS. However, these alternatives are not as good as SSIS at …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Informatica PowerCenter (legacy)SSIS
    Data Source Connection
    Comparison of Data Source Connection features of Informatica PowerCenter (legacy) and SQL Server Integration Services
    Feature
    Informatica PowerCenter (legacy)
    8.5
    18 Ratings
    SQL Server Integration Services
    7.5
    53 Ratings
    Connect to traditional data sources9.018 Ratings8.853 Ratings
    Connecto to Big Data and NoSQL8.014 Ratings6.240 Ratings
    Data Transformations
    Comparison of Data Transformations features of Informatica PowerCenter (legacy) and SQL Server Integration Services
    Feature
    Informatica PowerCenter (legacy)
    7.5
    18 Ratings
    SQL Server Integration Services
    8.1
    53 Ratings
    Simple transformations8.018 Ratings8.553 Ratings
    Complex transformations7.018 Ratings7.752 Ratings
    Data Modeling
    Comparison of Data Modeling features of Informatica PowerCenter (legacy) and SQL Server Integration Services
    Feature
    Informatica PowerCenter (legacy)
    8.2
    18 Ratings
    SQL Server Integration Services
    7.4
    51 Ratings
    Data model creation9.015 Ratings8.627 Ratings
    Metadata management8.016 Ratings7.133 Ratings
    Business rules and workflow9.018 Ratings8.242 Ratings
    Collaboration6.116 Ratings7.338 Ratings
    Testing and debugging9.017 Ratings6.148 Ratings
    Data Governance
    Comparison of Data Governance features of Informatica PowerCenter (legacy) and SQL Server Integration Services
    Feature
    Informatica PowerCenter (legacy)
    9.0
    15 Ratings
    SQL Server Integration Services
    6.9
    41 Ratings
    Integration with data quality tools9.015 Ratings7.436 Ratings
    Integration with MDM tools9.013 Ratings6.436 Ratings
    User Ratings
    Informatica PowerCenter (legacy)SSIS
    Likelihood to Recommend
    8.0
    (21 ratings)
    8.0
    (53 ratings)
    Likelihood to Renew
    10.0
    (4 ratings)
    10.0
    (3 ratings)
    Usability
    9.0
    (3 ratings)
    9.3
    (8 ratings)
    Performance
    9.4
    (2 ratings)
    8.8
    (6 ratings)
    Support Rating
    9.0
    (2 ratings)
    8.2
    (7 ratings)
    Implementation Rating
    -
    (0 ratings)
    10.0
    (1 ratings)