UE

Verified User in Education Management

Mid-Market (51-1000 emp.)

6/7/2018

"Working Great for us"

3.5/5

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

The customer service when there's an issue is awesome! Review collected by and hosted on G2.com.

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

Sometimes the solution to what you need isn't readily discernible. Review collected by and hosted on G2.com.

AE

Verified User in Entertainment

Enterprise (> 1000 emp.)

9/3/2019

"Stellar - no problems so far. "

5/5

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

Ease of use and build data flows. Saves overall development cost. Review collected by and hosted on G2.com.

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

Live support could be improved. Don’t really get much out of it. Review collected by and hosted on G2.com.

UR

Verified User in Religious Institutions

Enterprise (> 1000 emp.)

11/22/2016

"Centerprise v6"

3.5/5

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

Over all this is a good application for data integration. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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

Over all Data integration. Review collected by and hosted on G2.com.

AE

Verified User in Education Management

Enterprise (> 1000 emp.)

3/20/2018

"User Friendly ETL"

4/5

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

Easy to use, Drag and drop functionality Review collected by and hosted on G2.com.

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

Documentation , but support will be able to create one once you asked Review collected by and hosted on G2.com.

UC

Verified User in Computer Networking

Enterprise (> 1000 emp.)

6/12/2018

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

2.5/5

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

The learning curve on Astera is a lot quicker than SSIS. Review collected by and hosted on G2.com.

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

The actual conversion time running thru Astera is slower than SSIS. Review collected by and hosted on G2.com.

AB

Andre B.

Senior Database Manager

Information Technology and Services

Mid-Market (51-1000 emp.)

5/23/2017

"Streamline Data Processes"

5/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

MS

Matt S.

Project Manager

Computer Software

Small-Business (50 or fewer emp.)

11/17/2016

"Using Centerprise has been transformative for our data migration processes"

5/5

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. Review collected by and hosted on G2.com.

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.

Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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.

Review collected by and hosted on G2.com.

MR

Mark R.

Systems Analyst

Hospital & Health Care

Small-Business (50 or fewer emp.)

11/18/2016

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

5/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

AI

Verified User in Investment Management

Small-Business (50 or fewer emp.)

11/22/2016

"User friendly ETL"

5/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

MF

Mario F.

BI / DW Architect

Computer Software

Mid-Market (51-1000 emp.)

11/17/2016

"Astera Centerprise is a very good product"

4.5/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.