# Astera Data Pipeline Builder (Centerprise) Reviews
**Vendor:** Astera Software  
**Category:** [On-Premise Data Integration Software](https://www.g2.com/categories/on-premise-data-integration)  
**Average Rating:** 4.3/5.0  
**Total Reviews:** 31
## About Astera Data Pipeline Builder (Centerprise)
Astera Data Pipeline Builder (Centerprise) provides a no-code, scalable, high-performance, and affordable integration platform designed for technical and non-technical users to connect, transform, and move data from diverse sources to preferred destinations. With Astera&#39;s industrial strength ETL/ELT engine, 200+ transformations, and scheduling capabilities, users can build automated data pipelines in a matter of a few clicks. Users can also execute ETL and ELT data pipelines manually, schedule them for automated reruns, or orchestrate them as part of a larger data management process. Whether it&#39;s data extraction, transformation, cleansing, or loading, Astera Data Pipeline Builder excels at ensuring data accuracy and reliability. It offers comprehensive data validation capabilities, enabling users to enforce data quality and consistency. It is also a go-to solution for data migration, data warehousing, and business intelligence.




## Astera Data Pipeline Builder (Centerprise) Reviews
  ### 1. Astera Centerprise Data Integrator Review

**Rating:** 4.0/5.0 stars

**Reviewed by:** Rahul S. | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 09, 2023

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

I've been using CDI + EDI tool for the last 6+ years and has been working perfectly fine for me. Their support system along with their response time is also good. I've been using this tool for REST API Integration along with EDI integration with ERP & Ecommerce applications.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

There is nothing to dislike. They have been very accomodative to our unique requests for time to time.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Integrating Ecommerce and ERP applications via REST API calls and DB source and look up queries. Also, using it for generating and parsing EDI files coming from our customers and vice versa.

  ### 2. Great experience working with Astera ETL tool and support team

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Broadcast Media | Enterprise (> 1000 emp.)

**Reviewed Date:** November 28, 2023

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Astera is a great ETL tool with lot of features and great user experience overall. The support team are friendly and easy to access. Their turn around time to resolve issue is second to none.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

The Scheduler in the Centerprise client can be buggy sometimes, and there is no dark theme feature available.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

1. Recently we contacted Astera for loading a complex nested json file into one of our SQL table, raised a ticket with the support team and they provided a working solution in a quick time frame.
2. We contacted them again for snowflake integration with Astera ETL and once again their support team is exceptional in providing us fast solutions.

  ### 3. Easy to use and learn ETL tool

**Rating:** 4.5/5.0 stars

**Reviewed by:** Daniel C. | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 16, 2023

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

It allows me to easily to extract and transform the data from most of the data sources.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

It does not support spatial data set. So we need write our own code to extract the spatial data before using Astera.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Astera allows us to create one general workflows/dataflows for all clients. With the minor changes in the flows we can easliy to satisfy our clients' needs.

  ### 4. Great Tool for Data Imports

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 28, 2023

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Being able to import data without having a ton of prior knowledge of SQL or other query languages, plus a very responsive and helpful support teams.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

There is still a level of knowledge you have to have to write expressions, so a builder would be nice that showed you how to enter variables, etc. Sometimes it takes a bit to figure that out, but that's where the support team is very helpful.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Importing of data without havign dedicated SQL-specific resources ready to write custom scripts

  ### 5. Efficient Data Mapping Made Easy

**Rating:** 5.0/5.0 stars

**Reviewed by:** Simone S. | Marketing consultant, Mid-Market (51-1000 emp.)

**Reviewed Date:** February 20, 2023

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

I like that it is a user-friendly and code-free visual interface, which allows for easy drag-and-drop actions for complex data conversions and mappings. It also provides rich profiling, validation, and correction capabilities, which ensures the reliability of data. The tool's intelligent techniques that automatically match source and destination entities while providing the user with the option to control manual maps and write expressions is another feature users appreciate.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Potential drawbacks of Astera's Data Mapping Tool include a steep learning curve for some users due to its advanced features and functionality, and the need for technical expertise to fully leverage the tool's capabilities.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

The Astera Data Mapping Tool solves the problem of complex data conversions and mappings with its drag-and-drop actions and visual environment. It helps in transforming data from one format to another, whether for importing data from another source, translating it from one format to another, or transforming it to a different output format. It's also solving the problem of tedious and error-prone data mapping and conversion. By providing a visual, code-free environment for mapping data, it simplifies the process and makes it accessible to users with varying levels of technical expertise.

  ### 6. Powerful Software

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Non-Profit Organization Management | Mid-Market (51-1000 emp.)

**Reviewed Date:** August 27, 2019

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

The flexibility that the Centerprise platform has given us allows us to spin up new integrations, or modify older ones, as quickly and efficiently as possible.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Sometimes, there's a function or feature that I might like to use, but does not currently exist in the tool, so I have to build a way to handle it as I need it to.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

A variety of data issues have been automated to be cleaned up. Various data migrations, data cleanup, and other integrations. We've been able to expeditiously deploy integrations, and saved time from having to handle it in any other way.

  ### 7. Centerprise

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Management Consulting | Small-Business (50 or fewer emp.)

**Reviewed Date:** August 31, 2019

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

What used to take days, now takes hours. This program is the game changer.  Programming now becomes flowchart creation.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

The training videos start as if everyone has a moderate knowledge of your product.  You should create a few videos that explain each icon, and their uses.  Make a real introductory set of videos.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Our company has used it to integrate Oracle into systems that were using outdated systems.

  ### 8. Centreprise software Review 

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.)

**Reviewed Date:** August 27, 2019

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Best in ETL process  .
No coding experience required. 
It's a drag and drop process with customer support. 

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

There's need to develop online read me document for users to visit for problem solving. 

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

Try it out

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

We're using centreprise for etl and reports generation for business. 

  ### 9. Intuitive, yet tricky ETL tool

**Rating:** 3.5/5.0 stars

**Reviewed by:** Janis C. | Microsoft Dynamics AX developer, Enterprise (> 1000 emp.)

**Reviewed Date:** August 27, 2019

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Simplicity, the visual designer, reliability.  Ease of use.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Limited debugging options, few bugs in shared connection elements. Limited documentation.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Integration between different systems like SalesForce and Microsoft Dynamics AX. Some integrations are running since years practically untouched.

  ### 10. Useful data integration tool

**Rating:** 3.0/5.0 stars

**Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.)

**Reviewed Date:** August 27, 2019

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Allows us to create custom data flows, training is very good. Interface is user-friendly.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

some releases have been buggy, the price is extremely high and they are inflexible with reducing costs for a QA environment

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Ability to create custom data flows for 800+ clients

  ### 11. Working Great for us

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Education Management | Mid-Market (51-1000 emp.)

**Reviewed Date:** June 07, 2018

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

The customer service when there's an issue is awesome!

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Sometimes the solution to what you need isn't readily discernible.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

For smaller applications this software is exceptional.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Integrating data from 4 different sources to create a Data Warehouse.

  ### 12. Stellar - no problems so far. 

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Entertainment | Enterprise (> 1000 emp.)

**Reviewed Date:** September 03, 2019

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Ease of use and build data flows. Saves overall development cost. 

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

 Live support could be improved. Don’t really get much out of it. 

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Continue to build our enterprise data warehouse. 

  ### 13. Centerprise v6

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Religious Institutions | Enterprise (> 1000 emp.)

**Reviewed Date:** November 22, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Over all this is a good application for data integration. 

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Multiple bugs in the software make it so that you need to work more imaginative to get the desired results at times.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

Make sure to update to the latest version and know that there are still some bugs but over all it does a good job.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Over all Data integration.

  ### 14. User Friendly ETL

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Education Management | Enterprise (> 1000 emp.)

**Reviewed Date:** March 20, 2018

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Easy to use, Drag and drop functionality

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Documentation , but support will be able to create one once you asked

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Many data file format that we need to be able to extract and load

  ### 15. Not as fast as SSIS but it is easer for a new person to pick up.

**Rating:** 2.5/5.0 stars

**Reviewed by:** Verified User in Computer Networking | Enterprise (> 1000 emp.)

**Reviewed Date:** June 12, 2018

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

The learning curve on Astera is a lot quicker than SSIS. 

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

The actual conversion time running thru Astera is slower than SSIS.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

It is great for quick on the fly one off ETL processes..

  ### 16. Streamline Data Processes

**Rating:** 5.0/5.0 stars

**Reviewed by:** Andre B. | Senior Database Manager, Information Technology and Services, Mid-Market (51-1000 emp.)

**Reviewed Date:** May 23, 2017

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

We need to pull data from a wide variety of sources, including text, reports, log files, PDF, Excel, and various databases.  There are a number of products on the market which can do this, but we went with Astera because it’s interface is very user friendly.  You can drag and drop components to pull data from any source and then manipulate either all of the data or individual fields the same way.  This flexibility was obtained without any programming, and since the interface is similar to Microsoft products, there was not much of a learning curve.  I love that I don't have to have someone fully trained in SQL code and SSIS in order to develop high quality solutions.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

We had some issues getting it setup initially in time for the training course and were unable to run it from our Citrix Desktop at first.  Both the trainer and support team were excellent at adapting to the situation and they eventually got us the help we needed to get it moving.  As with any product that integrates into SQL, we are skeptical of how it will perform and whether or not is will optimize the code in a way that we are comfortable with.  So far this has not been an issue.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

If you have a lot of semi-structured or unstructured data, this tool may be your best bet on the market.  Additionally it can replace much of your SQL Server Integration Services (SSIS) as well.  

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

We use Data Integrator for two main tasks in our environment.  Creating ETL loads to our Data Warehouse and moving data from electronic forms via Citrix SecureForms into our Electronic Health Record system.  The benefit that Astera gives us in both of these areas, are quick turnaround time and the low barrier of entry to get these projects started.  In the future we plan to also use this to mine unstructured or semi-structured data for analytic purposes.

  ### 17. Using Centerprise has been transformative for our data migration processes

**Rating:** 5.0/5.0 stars

**Reviewed by:** Matt S. | Project Manager, Computer Software, Small-Business (50 or fewer emp.)

**Reviewed Date:** November 17, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

The software is very powerful, intuitive to use, and support has been responsive. One of the best features is the ability to preview the input or output of any step in the data flow.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Primary complaint would be I haven't seen much by way of events or community outreach. It would be great to have access to other users, or training/networking events.

Most of my dislikes are tactical and more of a wish-list. For example, refreshing the project tree view causes the tree to collapse, so you lose your place in the tree. As another example, sometimes we write UPDATE statements into SQL Query Source objects - it would be nice to be able to control whether these were executed when previewing the results of a data flow.



**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

Try it out using some real-world data. Find a way to get training or advice - the available documentation is moderately extensive but also only moderately useful.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

The main benefits are time saved and quality increased.

We are conducting data migrations as part of new software implementations. Most of the work is around migrating a client's data from their existing system's data model into ours. Using Centerprise, we've been able to build out a "baseline" migration process that incorporates our business logic and a lot of logging and error-catching. Having this reusable baseline has saved us time as well as increased the quality and capability of our migrations.

Our migrations encounter plenty of client-specific issues, of course, and we also deal with smaller one-off migrations outside of our baseline. We're able to use Centerprise, and in some cases portions of our baseline process to flexibly deal with these quickly and in a high-quality way.



  ### 18. Data Integrator - Amazing product, easy to use, flexible and fantastic support.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Mark R. | Systems Analyst, Hospital & Health Care, Small-Business (50 or fewer emp.)

**Reviewed Date:** November 18, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Solution stand-up time is very fast. Our company's extremely rapid development needs were easily met using The product. Out of the box to a working solution took only days, where some of the other products that were sampled would have taken far longer.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

I can't really find anything I dislike, but there was an issue handling very large XML files. The fix took a bit longer than I would have like. However, the issue did not prevent our company from meeting the aggressive deadlines we faced.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

The problem we faced was using SSIS to translate the complex XML schemas, which proved to be disastrous. Data Integrator allowed us to easily, and very quickly, stand up a solution at a VERY reasonable cost.

  ### 19. User friendly ETL

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Investment Management | Small-Business (50 or fewer emp.)

**Reviewed Date:** November 22, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

I unexpectedly inherited an ETL process that was integrated with Centerprise with very little transition time.  It is user friendly enough that I am able to maintain the system with minimal experience.  For most data flows I am able to make adjustments as needed.  The prior admin set up alerts when there are errors which is helpful for me.  Centerprise has been very reliable.

My score of 10 is based on my limited experience of inheriting and maintaining a fully implemented process -- I've never used or evaluated any competitors.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Certain data flows sources have many fields and exceptions. When the files are so complex the visual map is hard to follow.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

My understanding is the decision to go with Centerprise was in part to ensure users with non technical backgrounds would be able to maintain Centerprise.  I believe the product has lived up to those expectations.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Financial market information. Taking disparate data sources; standardizing, adding information and loading into internal internal SQL-based platform.

  ### 20. Astera Centerprise is a very good product

**Rating:** 4.5/5.0 stars

**Reviewed by:** Mario F. | BI / DW Architect, Computer Software, Mid-Market (51-1000 emp.)

**Reviewed Date:** November 17, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Ease of use, clever transformations and in general Centerprise has a library of transformations that even heavy duty tools like Informatica doesn't offer, such as SCD.
You can literally be up and running in a few seconds, with a very low learning curve.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

When you have to move millions of records, the tool doesn't perform too well. In fact we discovered that the more transformations you have, the slower it becomes. Because o this we replaced many of our transformations with source SQL. Either you do this, or you use their Push down optimization (PDO) capabilities, but this only works within the same database type.
I also don't like their licensing model. They seem fixated on charging per customer, instead of having some sort of server-based license with unlimited users, like Informatica, Yes, they will give you bigger discounts if you buy more, but this is an ETL tool, not a reporting tool.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

This tool is incredibly easy to deploy, learn and use, but be prepared to fine tune the heck out of it to get decent performance if you have huge data volumes, Use PDO when possible.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Our nightly ETL warehouse load now relies on Centerprise. We also use it to generate and distribute files easily.

  ### 21. I have been using Centerprise for 5 years

**Rating:** 5.0/5.0 stars

**Reviewed by:** Alex S. | Senior Data Scientist, Investment Management, Small-Business (50 or fewer emp.)

**Reviewed Date:** December 21, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Wide functionality, visual capabilities, great support, easy to learn, excellent reliability, actively developed and great price 

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

We had some issues at the beginning of implementation, but they were all resolved

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

Great functionality and way cheaper than Informatica

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

I am responsible for ETL process of Vanderbilt Office of Investments.  On daily basis I have to process files with portfolio data and load pricing data from different financial databases. It is all very easy to do with Centerprise.

  ### 22. User Friendly and Easy to Learn

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Insurance | Mid-Market (51-1000 emp.)

**Reviewed Date:** December 21, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

It is easy to use and fairly intuitive. Making connections between disparate systems is easy.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

There are many really good methods available that aren't necessarily documented, so documentation could be more complete. Also, exporting from results grids has vary limited options.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

There are many different ways to achieve the same goal, but one is usually far more efficient than the rest, so don't be afraid to use trial and error to find the best solution.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Moving bulk data from one database structure to a highly disparate database structure.

  ### 23. Makes Data Transformation Easy

**Rating:** 4.5/5.0 stars

**Reviewed by:** Bill P. | Director of Implementations, Computer Software, Small-Business (50 or fewer emp.)

**Reviewed Date:** December 21, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

The ability to use drag and drop functionality with connector-based rules.  Provides an easy-to-use platform for non-SQL proficient users to successfully map/move data which turns into huge cost savings.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Reusing workflows for slightly different data conditions (data values are slightly different) but is essentially the same fundamental source can be difficult since in-workflow documentation and/or customized-indicators are not available thus forcing out-of-band documentation.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

Great product and value.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Efficiency of transforming data from external sources.  Realized huge gains in cost savings and time through ease of use and re-usability.

  ### 24. Centerprise

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.)

**Reviewed Date:** December 20, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

I like that the tool is intuitive, in most cases.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

We can't add comment on the main pane.  Although, the comment text box in some objects exists, it would be nice to have to be able to insert text/comment on the main pane where you can see the flow.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

Centerprise is a very good data integration tool, but you should understand your team's expertise and understand what tools they may want to use.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Data integration.

  ### 25. Centerprise Training

**Rating:** 4.0/5.0 stars

**Reviewed by:** Sherry G. | Programmer, Chemicals, Mid-Market (51-1000 emp.)

**Reviewed Date:** February 27, 2017

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Easy to use.  Training was well put together.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

A manual with examples would be helpful.  I would have liked to do more real uses that we will use it for.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

We are useing the tool to migrate to a new system.

  ### 26. Meets the needs short term. Need Improvement.

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.)

**Reviewed Date:** November 29, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

easily apply SQL database functionality within a user interface,

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

its abstract or difficult to apply high level sql functions for a dataflow. Must create multi step and indepth thought when trying to apply row number functionality. If Centerprise added these as draggable items it would make life easier. 

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Solving problems like moving legacy systems to our current software platform. The benefit is that we can create a workflow that is reusable when converting new client from the same legacy software.

  ### 27. Helpful tool but contains bugs

**Rating:** 3.0/5.0 stars

**Reviewed by:** Verified User in Non-Profit Organization Management | Small-Business (50 or fewer emp.)

**Reviewed Date:** December 22, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Wide variety of options in toolbox.  Allows regional users flexibility on data sources and option to write own SQL code to populate source.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Each new additions seems to contains bugs

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Transferring data from regional offices to main database.  For simple jobs at regional offices, tool is simple to setup and start data transfers.  

  ### 28. Centerprise Data Integrator

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Higher Education | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 18, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

This application is very easy to install and upgrade.  The user interface is good.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Sometimes trying to find the way to do things is confusing.

**Recommendations to others considering Astera Data Pipeline Builder (Centerprise):**

This company has an awesome Customer Support Team.  They could do better with tutorials and online help.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

We are building a Data Warehouse and this tool has been what we're using.

  ### 29. Overall gccd

**Rating:** 4.5/5.0 stars

**Reviewed by:** Michael C. | Chief Information Officer, Information Technology and Services, Enterprise (> 1000 emp.)

**Reviewed Date:** December 21, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Support is really quality support and very informative.


**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

i have been disappointed with the new release parts not working properly i think the new features are really good.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Centralized data before is is obsolete.

  ### 30. ASTERA CENTERPIECE DATA INTEGRATOR

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.)

**Reviewed Date:** December 21, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Transfer data into relational database and scheduler within Centerpoint to process.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Nothing currently that I dislike, but the scheduler to process the data should have better log files explaining problem more when error occurs. 

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Transfer old data in relational database so the data could be used with other applications. 

  ### 31. It's greatly simplified sharing and synchronizing our data.

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Religious Institutions | Small-Business (50 or fewer emp.)

**Reviewed Date:** November 17, 2016

**What do you like best about Astera Data Pipeline Builder (Centerprise)?**

Easy to use interface, and automated process just runs.

**What do you dislike about Astera Data Pipeline Builder (Centerprise)?**

Occasionally quirky, best to not update versions unless you need to.

**What problems is Astera Data Pipeline Builder (Centerprise) solving and how is that benefiting you?**

Distributing data to business partners


## Astera Data Pipeline Builder (Centerprise) Discussions
  - [What are your system requirements?](https://www.g2.com/discussions/what-are-your-system-requirements) - 1 upvote
  - [How does your subscription pricing work?](https://www.g2.com/discussions/how-does-your-subscription-pricing-work) - 1 upvote

- [View Astera Data Pipeline Builder (Centerprise) pricing details and edition comparison](https://www.g2.com/products/astera-data-pipeline-builder-centerprise/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-16+11%3A24%3A24+-0500&secure%5Bsession_id%5D=eab54b99-3647-42b2-a376-cb4be17ebd8c&secure%5Btoken%5D=8ecdc7ec10caa47978569e01085e445c30f909dedccdf10b657bf6c14fb219a1&format=llm_user)

## Astera Data Pipeline Builder (Centerprise) Features
**Data Integration**
- 1st-Party Data Integration
- 3rd-Party Data Integration
- Offline Data Integration
- Data Export Tools

**Management**
- Reporting
- Auditing

**Functionality**
- Data visualisation
- Data transformation
- Data migration
- Process various formats
- No-code functionality
- Data manipulation
- Reporting

**Agentic AI - Data Management Platform (DMP)**
- Autonomous Task Execution
- Multi-step Planning
- Cross-system Integration
- Adaptive Learning
- Proactive Assistance
- Decision Making

**Data Analysis & Optimization**
- Audience Segmentation
- Recommendations
- Standard Dashboards
- Custom Reports

**Functionality**
- Extraction
- Transformation
- Loading
- Automation
- Scalability

**Platform**
- Data Permissions
- User, Role, and Access Management
- Performance and Reliability
- Enterprise Scalability
- Internationalization

**Functionality**
- Identification
- Correction
- Normalization
- Preventative Cleaning

**Management**
- Reporting
- Automation
- Quality Audits
- Dashboard
- Governance

**Generative AI**
- AI Text Generation
- AI Text Summarization

## Top Astera Data Pipeline Builder (Centerprise) Alternatives
  - [Boomi](https://www.g2.com/products/boomi/reviews) - 4.4/5.0 (451 reviews)
  - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,112 reviews)
  - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (744 reviews)

