Astera Data Pipeline Builder (Centerprise) vs. SoftwareONE PowerConnect

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Astera Data Pipeline Builder (Centerprise)
Score 8.8 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
SoftwareONE PowerConnect
Score 7.2 out of 10
N/A
BNW Consulting, a SAP consultancy agency, provides PowerConnect for Splunk as a data integration tool for SAP enterprises, and is designed to send important information about what’s going on inside SAP systems, in near real time to Splunk allowing enterprises to meet security compliance requirements, reduce P1 issues by 30% and reduce MTTR by 70% on your mission critical applications and systems.N/A
Pricing
Astera Data Pipeline Builder (Centerprise)SoftwareONE PowerConnect
Editions & Modules
Centerprise Enterprise
Contact rep
Lifetime License per Seat
No answers on this topic
Offerings
Pricing Offerings
Astera Data Pipeline Builder (Centerprise)SoftwareONE PowerConnect
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
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)SoftwareONE PowerConnect
Features
Astera Data Pipeline Builder (Centerprise)SoftwareONE PowerConnect
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Astera Data Pipeline Builder (Centerprise)
8.2
Ratings
2% below category average
SoftwareONE PowerConnect
-
Ratings
Connect to traditional data sources9.10 Ratings00 Ratings
Connecto to Big Data and NoSQL7.30 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Astera Data Pipeline Builder (Centerprise)
6.9
Ratings
17% below category average
SoftwareONE PowerConnect
-
Ratings
Simple transformations9.20 Ratings00 Ratings
Complex transformations4.60 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Astera Data Pipeline Builder (Centerprise)
7.1
Ratings
12% below category average
SoftwareONE PowerConnect
-
Ratings
Data model creation9.20 Ratings00 Ratings
Business rules and workflow9.90 Ratings00 Ratings
Collaboration6.40 Ratings00 Ratings
Testing and debugging2.80 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Astera Data Pipeline Builder (Centerprise)
8.2
Ratings
1% above category average
SoftwareONE PowerConnect
-
Ratings
Integration with data quality tools8.20 Ratings00 Ratings
Integration with MDM tools8.20 Ratings00 Ratings
User Ratings
Astera Data Pipeline Builder (Centerprise)SoftwareONE PowerConnect
Likelihood to Recommend
8.8
(0 ratings)
-
(0 ratings)
Likelihood to Renew
9.2
(0 ratings)
-
(0 ratings)
Usability
7.3
(0 ratings)
-
(0 ratings)
Availability
9.0
(0 ratings)
-
(0 ratings)
Performance
8.5
(0 ratings)
-
(0 ratings)
Support Rating
8.4
(0 ratings)
-
(0 ratings)
Implementation Rating
8.2
(0 ratings)
-
(0 ratings)
Configurability
9.1
(0 ratings)
-
(0 ratings)
Ease of integration
9.0
(0 ratings)
-
(0 ratings)
Product Scalability
7.6
(0 ratings)
-
(0 ratings)
Vendor post-sale
9.0
(0 ratings)
-
(0 ratings)
Vendor pre-sale
9.0
(0 ratings)
-
(0 ratings)
User Testimonials
Astera Data Pipeline Builder (Centerprise)SoftwareONE PowerConnect
Likelihood to Recommend
Astera Centerprise is specific to EDI files. From what I've seen it can be used on EDI files across multiple industries. We use it specifically for healthcare EDI files. We do not create any files using this software because we do not have that need at CCHP, but I know the software could be used for that. CCHP uses the software to correct EDI errors and to import EDI data to our SQL data warehouse. EDI files have a layered structure so they need to be broken down in order to be loaded into the data warehouse. Without this tool we would not be able to import the files. Also, with the layered structure, fields, segments, dependencies and hierarchy, making changes manually is both risky and time consuming. Centerprise reduces the amount of time used to correct files and removes the possibility of creating other errors.
Read full review
No answers on this topic
Pros
  • Allows for integration of custom functions.
  • Allows us to easily migrate data to and from any data source. Our department has become the go-to for automated data extracts.
  • We use emails from jobs we run in Centerprise to ensure all jobs run successfully.
Read full review
No answers on this topic
Cons
  • We have several support calls that have been labeled as to be done in the future. One is the reading of the File Definition in AcuCobol with the sign trailing in a numeric field. The handling of this would help us in several areas but we have been able to develop a work around at this point.
  • Some of the child/overlap configuration for the "RMD" seems awkward.
Read full review
No answers on this topic
Likelihood to Renew
We've been using Astera Centerprise application for the last 6 years and we've already added EDI connect to it. Both applications are working really well for our enterprise needs so far with no issues, so we'll continue renewing the licenses.
Read full review
No answers on this topic
Usability
It's very intuitive and visually descriptive. The interface is standard windows drag and drop although cut and paste are not universally available depending upon what function you're trying to do. You see the ETL and what it's doing. You can inspect the data elements the transformations and perform data previews incrementally along the data flow. You actually SEE what the results are and you can make adjustments without black box testing
Read full review
No answers on this topic
Reliability and Availability
In most cases Astera is stable. However, our client experiences the error from time to time. Mostly they are related to cdc file and ServerAdminConfig.xml file.
Read full review
No answers on this topic
Performance
I think the performance for Astera is great when compare with other similar software.
Read full review
No answers on this topic
Support Rating
Support is great! No matter if you need technical assistance or you have general questions about the tool - the support is very responsive and provides solutions quickly. They are available via various channels, which makes it very convenient to get in touch with them (Support portal, direct email contact, LinkedIn).
Read full review
No answers on this topic
Implementation Rating
Astera support provided us implementation/installation tutorial and we were able to perform all the activities. Also one of the support was there to shadow us to make sure the process was smooth with no issues
Read full review
No answers on this topic
Alternatives Considered
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 Integrator can. We also looked at Datawatch Monarch as a possibility but found it over-all to be cost-prohibitive. We also looked at a cheaper alternative called SimX but did not have a strong confidence in the product as we evaluated it. We landed on Centerprise Data Integrator as it met all of our business requirements and we know we could leverage it for many uses across our enterprise.
Read full review
No answers on this topic
Scalability
I think Astera can do multiple things. However, we are not sure what it can do. We only know the basic features. If they can give us some kind of training, then we maybe able to benefit for it. We are planning to use their Azure connection in the future. If they can provide the training for it, it will be wonderful.
Read full review
No answers on this topic
Return on Investment
  • It is tough to say on how Centerprise would have helped us with ROI. Unfortunately our project (after 3 years) was scrapped (put on hold) due to the impromptu purchase of another Crop Insurance company. But with that, Centerprise was huge in getting our warehouse loaded for our BI Team to make important decisions about our policies.
Read full review
No answers on this topic
ScreenShots

Astera Data Pipeline Builder (Centerprise) Screenshots

Screenshot of Centerprise's data profiling feature, that ensures that only quality data is delivered to end users.Screenshot of a variety of write strategies available for workflows.Screenshot of the built-in scheduler used to automate most tasks. Triggers can be based on time, event or even a file or mail drop.Screenshot of the AI-powered mapping that allows users to automate the mapping process from source to destination. The tool also supports The Dynamic Layout/Template Mapping feature in Astera Centerprise that allows users to create a template dataflow that can be used to process multiple files and generate copies of the same dataflow, without changing the mapping links individually for each source dataset. Upon execution, Centerprise replaces the values dynamically and generates a new dataflow automatically for all source files.Screenshot of the two types of transformations supported by Astera Centerprise: record level and set level transformation. Record level transformations are used to create derived values by applying a Lookup, Function, or Expression to fields from a single record. Set level transformations, on the other hand, operate on a group of records and may result in the Joining, Reordering, Eliminating, or aggregating of records.