Astera Centerprise vs Fivetran | TrustRadius

What users are saying about

Score 9.2 out of 10

Based on 34 reviews and ratings

Score 8.4 out of 10

Based on 17 reviews and ratings

Feature Rating Comparison

Astera Centerprise

Fivetran

Connect to traditional data sources

Connecto to Big Data and NoSQL

Astera Centerprise

Fivetran

Simple transformations

Complex transformations

Astera Centerprise

Fivetran

Data model creation

Business rules and workflow

Collaboration

Testing and debugging

Metadata management

feature 1

Astera Centerprise

Fivetran

Integration with data quality tools

Integration with MDM tools

Pros

The user friendly interface to develop integration packages means that you don't need to be highly trained in SQL code.
There is a huge variety of out-of-box functions, translations, and connectors. This means you can get up and running with using these different components right away.
Centerprise Data Integrator can mine data from unstructured and semi-structured data sources like pdf files and csv's. It means that virtually anything you have can be moved into a SQL database or fed into other systems.
Centerprise Support has been excellent and responsive to our needs.

Read full review

Senior Database Manager

Cherry HealthHealth, Wellness and Fitness, 501-1000 employees

View all 29 answers on this topic

Seamless connector for data requirements
Custom reports
Database Connection
Change Lod

Read full review

Sudarshan Kothari

Senior Data Scientist

iQuanti, Inc.Information Technology and Services, 201-500 employees

View all 4 answers on this topic

Cons

I have not upgraded to the latest version, but in the last version, could use better descriptions in error messages.
I have not upgraded to the latest version, but in the last version, it would be nice to have reports we could run or have emailed daily/weekly with success/failure of all jobs scheduled.

Read full review

Verified User

Manager in Information Technology

Insurance Company, 201-500 employees

View all 29 answers on this topic

Alerting and notification could be enhanced and be more timely in some cases
The error messages when there are connector setup issues could be more clear

Read full review

Verified User

Engineer in Information Technology

Health, Wellness and Fitness Company, 51-200 employees

View all 4 answers on this topic

Likelihood to Renew

Astera Centerprise 9.1

Based on 2 answers

Best product I have evaluated. No need to seek alternatives.

Read full review

Systems Analyst

Cognisight, LLCHospital & Health Care, 11-50 employees

View all 2 answers on this topic

No score

No answers yet

No answers on this topic

Usability

Astera Centerprise 8.0

Based on 5 answers

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

Principal

Leximantix LLCInformation Technology and Services, 1-10 employees

View all 5 answers on this topic

Fivetran 9.0

Based on 1 answer

Just need to input connection info.

Read full review

Head of Data Science

Couchsurfing InternationalInternet, 11-50 employees

View all 1 answers on this topic

Performance

No score

No answers yet

No answers on this topic

Fivetran 8.0

Based on 2 answers

It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.

Read full review

Head of Data Science

Couchsurfing InternationalInternet, 11-50 employees

View all 2 answers on this topic

Support Rating

Astera Centerprise 8.4

Based on 22 answers

Astera support team is one of the key ingredients that makes using Astera products a very wise choice. The support team is quick to respond, helpful, understands our requirements/needs and customizes the outcome to match that. The readiness to help us out with activities that typically would fall into our realm like software install, workflow config (even in simple straightforward cases), upgrades, etc, is what makes this one of the best support teams we have worked with.

Read full review

Verified User

Director in Information Technology

Accounting Company, 10,001+ employees

View all 22 answers on this topic

No score

No answers yet

No answers on this topic

Implementation Rating

Astera Centerprise 9.1

Based on 6 answers

Think outside the box because Centerprise can take on more than just data integration.

Read full review

Verified User

Manager in Information Technology

Insurance Company, 201-500 employees

View all 6 answers on this topic

No score

No answers yet

No answers on this topic

Alternatives Considered

After the purchase of the new company, we were required to go with their software choices until after TSA. The ETL product they had in use was Informatica. I'm sure Informatica has some great benefits for huge companies, but I am having a hard time adjusting to their style. Centerprise has Dataflows (Informatica has Mappings). You can run a Dataflow all by itself (Informatica you cannot run a Mapping by itself therefore requiring a workflow to run which doubles up your objects and maintenance). With Centerprise you can preview your data in every object in the Dataflow saving development time (with Informatica you cannot). Centerprise has a very nice scheduler to use (An Informatica consultant suggested not using the scheduler in Informatica because it wasn't very good thus, requiring a 3rd party purchase | we are using JAMS). Centerprise is a stand-alone product (Informatica had to be put on an Unix Box--thus requiring unix knowledge). Centerprise can pass variables quick easily between Flows (Informatica has to read parameter files from a stored/LAN location). Both products have the exact same project set up for the Government file transmissions: Centerprise had a total of 112 objects (DataFlows and Workflows). Informatica has 651. The once nice thing about Informatica is that you can call unix jobs to run (not sure if this was available in Centerprise)

Read full review

Software Developer II

Farmers Mutual Hail InsuranceInsurance, 501-1000 employees

View all 29 answers on this topic

Fivetran came well with the connectors' availability and updates with the source changes. We had an idea on data requirements in our case which helped us to work out on cost implication and take a decision for Fivetran as a data provider for our organization. These were 2 places where Fivetran out-performed, other vendors.

Read full review

Sudarshan Kothari

Senior Data Scientist

iQuanti, Inc.Information Technology and Services, 201-500 employees

View all 4 answers on this topic

Return on Investment

We have seen that the use of this package saved us 2 hours per conversion but now since the templates are already developed it is saving us more. This reduces our lead time for conversions, and increases our efficiencies as a conversion team.
We have four licenses and in one conversion this year it allowed us to do a conversion that would not have been done. This conversion generated more than enough money to cover the cost of these four licenses for the entire year. The customer is ecstatic about the information that we were able to pull out of their reports and most of all the upper management of our company had their socks shocked off of them. Since the supplier of the software for this customer would not provide data to us for a conversion our upper management was going to cancel the sale to this customer, unless the customer was going to build our system from scratch. We were able to provide nearly a complete accounting and payroll conversion to this customer all from the data on their reports thanks to centerprise.

Read full review

Senior Software Implementation Specialist

Software Solutions IncInformation Technology and Services, 11-50 employees

View all 29 answers on this topic

Fivetran has allowed us to dramatically improve our time to insight
It allows us to focus on business value as opposed to engineering
Reduced the amount of engineering resources we need to make data available

Read full review

Verified User

Engineer in Information Technology

Health, Wellness and Fitness Company, 51-200 employees

View all 4 answers on this topic

Screenshots

See All (5) Astera Centerprise Screenshots

—

Pricing Details

General

Free Trial

Yes

Free/Freemium Version

—

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

No

Astera Centerprise Editions & Modules

Edition

Centerprise Enterprise	Contact rep¹

Lifetime License per Seat

Additional Pricing Details

Discounts are provided for 10 pack, 20 pack, 50 pack, and enterprise wide Centerprise Professional licenses.

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Fivetran Editions & Modules

Edition

Starter	$1.00¹
Standard	$1.50¹
Enterprise	$2.00¹

per credit

Additional Pricing Details

—

Rating Summary

Astera Centerprise

Fivetran

Astera Centerprise

Fivetran

Astera Centerprise

Fivetran

Astera Centerprise

Fivetran

Astera Centerprise

Fivetran

Astera Centerprise

Fivetran

Add comparison