TrustRadius: an HG Insights company

Astera Data Pipeline Builder (Centerprise) vs. SQL Server Integration Services

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Astera Data Pipeline Builder (Centerprise)

    Score8.7 out of 10
    Mid-Size Companies (51-1,000 employees)
    Astera Data Pipeline Builder is a no-code solution for designing and automating data pipelines. It allows users to read and write data across various file formats, databases, and applications. Users can execute ETL and ELT pipelines manually, schedule automated reruns, or integrate them into broader data management processes.N/A

    SSIS

    Score6.5 out of 10
    N/AMicrosoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A
    Pricing
    Astera Data Pipeline Builder (Centerprise)SSIS
    Editions & Modules
    Centerprise Enterprise
    Contact rep
    Lifetime License per Seat
    No answers on this topic
    Offerings
    Pricing Offerings
    Astera Data Pipeline Builder (Centerprise)SSIS
    Free Trial
    YesNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional DetailsDiscounts are provided for 10 pack, 20 pack, 50 pack, and enterprise wide Centerprise Professional licenses.—
    More Pricing Information
    Community Pulse
    Astera Data Pipeline Builder (Centerprise)SSIS
    Considered Both Products
    Astera Software
    Chose Astera Data Pipeline Builder (Centerprise)
    The biggest difference is with Astera Centerprise I could just start using it. Almost every other tool required me to write SQL or in another language... and if I'm writing SQL already, why not just use SSIS or raw SQL? There wasn't a tremendous amount of time savings being …
    Incentivized
    Chose Astera Data Pipeline Builder (Centerprise)
    Centerprise is easier for everything except the most demanding jobs. Centerprise is not for full blown enterprise data warehouses.
    Incentivized
    Chose Astera Data Pipeline Builder (Centerprise)
    We looked at continuing to use SSIS as an alternative. Although we own SSIS as part of our SQL licensing, we found that it takes a much higher skill level to create solutions. It also does not have the ability to parse unstructured data the way that Centerprise Data …
    Incentivized
    Chose Astera Data Pipeline Builder (Centerprise)
    By magnitudes...the time to implement a map. I was up an running in under an hour. The interface is extremely well designed and simple to use. Logging is very robust. Transformations and functions are much easier to use than other vendors I have tried.
    Microsoft
    Chose SSIS
    When looking to evaluate different options, we looked first to the experience and software we had in-house that would accomplish the job. When assessing alternatives outside we were looking for the tool that would offer the most flexibility.

    SSIS provided the most robust set of …
    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
    Astera Data Pipeline Builder (Centerprise)SSIS
    Data Source Connection
    Comparison of Data Source Connection features of Astera Data Pipeline Builder (Centerprise) and SQL Server Integration Services
    Feature
    Astera Data Pipeline Builder (Centerprise)
    8.2
    32 Ratings
    SQL Server Integration Services
    7.5
    53 Ratings
    Connect to traditional data sources9.132 Ratings8.853 Ratings
    Connecto to Big Data and NoSQL7.31 Ratings6.240 Ratings
    Data Transformations
    Comparison of Data Transformations features of Astera Data Pipeline Builder (Centerprise) and SQL Server Integration Services
    Feature
    Astera Data Pipeline Builder (Centerprise)
    6.9
    33 Ratings
    SQL Server Integration Services
    8.1
    53 Ratings
    Simple transformations9.233 Ratings8.553 Ratings
    Complex transformations4.631 Ratings7.752 Ratings
    Data Modeling
    Comparison of Data Modeling features of Astera Data Pipeline Builder (Centerprise) and SQL Server Integration Services
    Feature
    Astera Data Pipeline Builder (Centerprise)
    7.0
    31 Ratings
    SQL Server Integration Services
    7.4
    51 Ratings
    Data model creation9.220 Ratings8.627 Ratings
    Business rules and workflow9.928 Ratings8.242 Ratings
    Collaboration6.41 Ratings7.338 Ratings
    Testing and debugging2.828 Ratings6.148 Ratings
    Metadata management00 Ratings7.133 Ratings
    Data Governance
    Comparison of Data Governance features of Astera Data Pipeline Builder (Centerprise) and SQL Server Integration Services
    Feature
    Astera Data Pipeline Builder (Centerprise)
    8.2
    1 Ratings
    SQL Server Integration Services
    6.9
    41 Ratings
    Integration with data quality tools8.21 Ratings7.436 Ratings
    Integration with MDM tools8.21 Ratings6.436 Ratings
    User Ratings
    Astera Data Pipeline Builder (Centerprise)SSIS
    Likelihood to Recommend
    8.7
    (46 ratings)
    8.0
    (53 ratings)
    Likelihood to Renew
    9.2
    (7 ratings)
    10.0
    (3 ratings)
    Usability
    7.3
    (10 ratings)
    9.3
    (8 ratings)
    Availability
    9.0
    (2 ratings)
    -
    (0 ratings)
    Performance
    8.6
    (2 ratings)
    8.8
    (6 ratings)
    Support Rating
    8.4
    (21 ratings)
    8.2
    (7 ratings)
    Implementation Rating
    8.2
    (4 ratings)
    10.0
    (1 ratings)
    Configurability
    9.1
    (1 ratings)
    -
    (0 ratings)
    Contract Terms and Pricing Model
    7.3
    (2 ratings)
    -
    (0 ratings)
    Ease of integration
    9.0
    (2 ratings)
    -
    (0 ratings)
    Product Scalability
    7.6
    (2 ratings)
    -
    (0 ratings)
    Professional Services
    8.2
    (2 ratings)
    -
    (0 ratings)
    Vendor post-sale
    9.0
    (2 ratings)
    -
    (0 ratings)
    Vendor pre-sale
    9.0
    (2 ratings)
    -
    (0 ratings)