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
Microsoft SQL Server
Score 8.7 out of 10
N/A
Microsoft SQL Server is a relational database.
$1,418
Per License
Pricing
Astera Data Pipeline Builder (Centerprise)
Microsoft 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 Data Pipeline Builder (Centerprise)
Microsoft SQL Server
Free Trial
Yes
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
Discounts 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)
Microsoft SQL Server
Considered Both Products
Astera Data Pipeline Builder (Centerprise)
Verified User
Employee
Chose Astera Data Pipeline Builder (Centerprise)
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 …
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 …
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.
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!
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
Features
Astera Data Pipeline Builder (Centerprise)
Microsoft SQL Server
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Astera Data Pipeline Builder (Centerprise)
8.2
32 Ratings
0% below category average
Microsoft SQL Server
-
Ratings
Connect to traditional data sources
9.132 Ratings
00 Ratings
Connecto to Big Data and NoSQL
7.31 Ratings
00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Astera Data Pipeline Builder (Centerprise)
6.9
33 Ratings
16% below category average
Microsoft SQL Server
-
Ratings
Simple transformations
9.233 Ratings
00 Ratings
Complex transformations
4.631 Ratings
00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Astera Data Pipeline Builder (Centerprise)
7.1
31 Ratings
10% below category average
Microsoft SQL Server
-
Ratings
Data model creation
9.220 Ratings
00 Ratings
Business rules and workflow
9.928 Ratings
00 Ratings
Collaboration
6.41 Ratings
00 Ratings
Testing and debugging
2.828 Ratings
00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
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.
Microsoft SQL is ubiquitous, while MySQL runs under the hood all over the place. Microsoft SQL is the platform taught in colleges and certification courses and is the one most likely to be used by businesses because it is backed by Microsoft. Its interface is friendly (well, as pleasant as SQL can be) and has been used by so many for so long that resources are freely available if you encounter any issues.
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.
Microsoft SQL Server Enterprise edition has a high cost but is the only edition which supports SQL Always On Availability Groups. It would be nice to include this feature in the Standard version.
Licensing of Microsoft SQL Server is a quite complex matter, it would be good to simplify licensing in the future. For example, per core vs per user CAL licensing, as well as complex licensing scenarios in the Cloud and on Edge locations.
It would be good to include native tools for converting Oracle, DB2, Postgresql and MySQL/MariaDB databases (schema and data) for import into Microsoft SQL Server.
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.
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.
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.
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.
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.
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).
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.
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
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.
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.
[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.
I was helping on purchase this product but I am not sure about the term and pricing for it. But based on what I understand that the term of the licenses are good.
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.
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.
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.
