Astera Centerprise Data Pipeline Builder vs. Microsoft SQL Server

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Astera Centerprise Data Pipeline Builder
Score 8.8 out of 10
Mid-Size Companies (51-1,000 employees)
Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.N/A
Microsoft SQL Server
Score 8.7 out of 10
N/A
Microsoft SQL Server is a relational database.
$1,418
Per License
Pricing
Astera Centerprise Data Pipeline BuilderMicrosoft SQL Server
Editions & Modules
Centerprise Enterprise
Contact rep
Lifetime License per Seat
Subscription
$1,418.00
Per License
Enterprise
$13,748.00
Per License
Offerings
Pricing Offerings
Astera Centerprise Data Pipeline BuilderMicrosoft SQL Server
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 Centerprise Data Pipeline BuilderMicrosoft SQL Server
Considered Both Products
Astera Centerprise Data Pipeline Builder
Chose Astera Centerprise Data Pipeline Builder
We first tried Informatica and think it is suitable for our company. However, the per license price is way too expensive, as we need to support multiple users at the same time. When compared to Astera, we found Astera can do most of the stuff that Informatica does. That's why …
Chose Astera Centerprise Data Pipeline Builder
For us Astera Centerprise is a better tool as it helps in solving 2 problems. We use it as both an ETL tool as well as API integration tool. MuleSoft Anypoint Platform is used for API integration only. So we chose Astera Centerprise over MuleSoft. We're now using to EDI …
Chose Astera Centerprise Data Pipeline Builder
We evaluated both Monarch and Astera Centerprise and ended up purchasing Astera Centerprise due to ease of use and the wide range of available functions.
Chose Astera Centerprise Data Pipeline Builder
GoldenGate is not really designed for "interactive reusasbility" situations. Centerprise is perfect for the concept of reusing previous work for new projects! Plus, the cost difference is so huge!
Chose Astera Centerprise Data Pipeline Builder
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 …
Microsoft SQL Server

No answer on this topic

Top Pros
Top Cons
Features
Astera Centerprise Data Pipeline BuilderMicrosoft SQL Server
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Astera Centerprise Data Pipeline Builder
8.1
31 Ratings
3% below category average
Microsoft SQL Server
-
Ratings
Connect to traditional data sources9.031 Ratings00 Ratings
Connecto to Big Data and NoSQL7.31 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Astera Centerprise Data Pipeline Builder
8.6
32 Ratings
5% above category average
Microsoft SQL Server
-
Ratings
Simple transformations9.932 Ratings00 Ratings
Complex transformations7.330 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Astera Centerprise Data Pipeline Builder
8.5
30 Ratings
5% above category average
Microsoft SQL Server
-
Ratings
Data model creation9.919 Ratings00 Ratings
Business rules and workflow9.928 Ratings00 Ratings
Collaboration6.41 Ratings00 Ratings
Testing and debugging8.027 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Astera Centerprise Data Pipeline Builder
8.2
1 Ratings
1% below category average
Microsoft SQL Server
-
Ratings
Integration with data quality tools8.21 Ratings00 Ratings
Integration with MDM tools8.21 Ratings00 Ratings
Best Alternatives
Astera Centerprise Data Pipeline BuilderMicrosoft SQL Server
Small Businesses
Skyvia
Skyvia
Score 9.7 out of 10
SingleStore
SingleStore
Score 9.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
Snowflake
Snowflake
Score 9.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
SAP IQ
SAP IQ
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Astera Centerprise Data Pipeline BuilderMicrosoft SQL Server
Likelihood to Recommend
9.0
(45 ratings)
9.7
(96 ratings)
Likelihood to Renew
9.2
(7 ratings)
9.0
(6 ratings)
Usability
8.7
(9 ratings)
9.9
(10 ratings)
Availability
8.7
(2 ratings)
10.0
(1 ratings)
Performance
8.5
(2 ratings)
9.0
(1 ratings)
Support Rating
8.6
(21 ratings)
7.9
(25 ratings)
In-Person Training
-
(0 ratings)
9.0
(1 ratings)
Online Training
-
(0 ratings)
9.0
(1 ratings)
Implementation Rating
8.6
(4 ratings)
9.0
(5 ratings)
Configurability
9.1
(1 ratings)
10.0
(1 ratings)
Contract Terms and Pricing Model
8.0
(1 ratings)
-
(0 ratings)
Ease of integration
9.0
(2 ratings)
9.0
(1 ratings)
Product Scalability
7.7
(2 ratings)
9.0
(1 ratings)
Professional Services
9.0
(1 ratings)
-
(0 ratings)
Vendor post-sale
9.0
(2 ratings)
9.0
(1 ratings)
Vendor pre-sale
9.0
(2 ratings)
9.0
(1 ratings)
User Testimonials
Astera Centerprise Data Pipeline BuilderMicrosoft SQL Server
Likelihood to Recommend
Astera Software
I have only been using Astera Centerprise for about 6 months and I am still learning the ins and out of it. A scenario where it seems to do well is in generating reports from SQL queries that we already had and no longer have to run the reports manually. The SQL Query Source object has been the most useful tool for me thus far. I have yet to fully stress test the server side of Astera Centerprise, but currently there have been some version updates that required me to re-set up all the scheduled jobs that we have. We only have 8 jobs thus far but have plans to expand this into the hundreds and those same updates would require exponential amounts of work.
Read full review
Microsoft
Microsoft SQL Server is a great RDBMS and meets all of our requirements. If you need a stable DB platform to support your line of a business application you'll be well served. Licensing costs are far cheaper, more portable and a lot more user friendly than Oracle. Product support and security patches from Microsoft are strong.
Read full review
Pros
Astera Software
  • API integrations vis REST Web Service transformation
  • Stored Procedure integration via SQL statement Lookup transformation
  • Bulk imports and exports to and from tables
  • Data dumps from SQL tables to excel, csv, text files etc...
  • EDI Integrations like 810, 856, 940, 945 etc.. via Astera Centerprise Data Integrator plus EDI Connect
Read full review
Microsoft
  • Easy to configure and use with Visual Studio and Dot Net
  • Easy integration with MSBI to perform data analysis
  • Data Security
  • Easy to understand and use
  • Very easy to export database and tables in the form of SQL query or a script
Read full review
Cons
Astera Software
  • When purchasing Astera Centerprise you are given options on how you would like to be trained and each option comes with a different price tag. We chose to be trained using online meetings over several days. The training went too fast and it was not always easy to understand until I started using the product.
  • I am a person that wants to learn how and why something works so that I can use the knowledge in the future. When contacting the support team they take the problem, create a solution for you and send it back. The solutions always work, but when I get the solution I have to review every field and function to understand how it works so that I can re-create it for another solution I need. I would much rather have the support team explain what I had done incorrectly and what they changed or I would like to find a solution with them instead of having it handed to me.
  • Astera uses license keys to allow their customers rights to only the functionality that was purchased. Each user and server has its own key and each key is only good for one year. There have been 2 different times that we received keys that had less functionality that we purchased. It wasn't until it created problems that we noticed and had to request new keys. This year our sales representative made sure she was available when we updated our keys so that if there was a problem she could fix it right away; however, there were not issues this year. I believe this is something they pay closer attention to now.
Read full review
Microsoft
  • The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
  • Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
  • The documentation is not great and again it's generally better to obtain help elsewhere if needed
Read full review
Likelihood to Renew
Astera Software
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
Microsoft
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
Read full review
Usability
Astera Software
Centerprise is highly usable; however the version we are currently using could be a little more intuitive in some areas though by no means unworkable. I think some of the issues we have have been addressed and solved in the latest version.
Read full review
Microsoft
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
Read full review
Reliability and Availability
Astera Software
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
Microsoft
Its does not have outages.
Read full review
Performance
Astera Software
I think the performance for Astera is great when compare with other similar software.
Read full review
Microsoft
SSAS data cubes may some time slow down your Excel reports.
Read full review
Support Rating
Astera Software
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
Microsoft
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
Read full review
In-Person Training
Astera Software
No answers on this topic
Microsoft
It was good
Read full review
Online Training
Astera Software
No answers on this topic
Microsoft
very hands on and detailed training
Read full review
Implementation Rating
Astera Software
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
Microsoft
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
Read full review
Alternatives Considered
Astera Software
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
Microsoft
[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.
Read full review
Scalability
Astera Software
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
Microsoft
SQL server does handle growing demands of a mid sized company.
Read full review
Return on Investment
Astera Software
  • 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
Microsoft
  • Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
  • Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
  • Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.
Read full review
ScreenShots

Astera Centerprise Data Pipeline Builder 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 In Astera, you can automate most of your tasks using the built-in scheduler. You can set a trigger based on time, event or even a file or mail drop.Screenshot of Astera supports 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 Astera Centerprise supports two types of transformations: 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.