Skip to main content
TrustRadius
Astera Centerprise

Astera Centerprise

Overview

What is Astera Centerprise?

Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.

Read more
Recent Reviews

TrustRadius Insights

Astera Centerprise is a versatile and affordable data integration tool that has proven to be highly valuable in various use cases. Users …
Continue reading

Astera Works for Us

9 out of 10
January 20, 2023
Incentivized
We are using this vendor product in our daily test environment to extract data from Master database and based on business rules transform …
Continue reading

Solid ETL solutions

7 out of 10
January 16, 2023
Incentivized
We use Astera Centerprise for many various projects. Examples would include automated report generation, inventory alerts and scheduled …
Continue reading

Centerprise-10/10

9 out of 10
November 08, 2021
We use it in part of our automation process to extract data from PDF's and deliver to our clients. It allows us to utilize time we …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 10 features
  • Business rules and workflow (28)
    9.9
    99%
  • Simple transformations (32)
    9.8
    98%
  • Connect to traditional data sources (31)
    9.0
    90%
  • Complex transformations (30)
    7.3
    73%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing

Centerprise Enterprise

Contact rep

On Premise
Lifetime License per Seat

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttp://www.astera.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Demos

Feature Demonstration Data Integration Tool | Astera Centerprise

YouTube
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

8.1
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

8.6
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

8.5
Avg 8.2

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

8.2
Avg 8.2
Return to navigation

Product Details

What is Astera Centerprise?

Astera Centerprise is a complete data integration solution that includes data integration, data transformation, data quality, and data profiling capabilities in a code-free environment, and promises to enable business users to handle data with minimal IT support. Centerprise enables users to exchange data with a wide range of supported applications, databases, and formats.

Astera Centerprise Features

Data Source Connection Features

  • Supported: Connect to traditional data sources

Data Transformations Features

  • Supported: Simple transformations
  • Supported: Complex transformations

Data Modeling Features

  • Supported: Data model creation
  • Supported: Business rules and workflow
  • Supported: Testing and debugging

Additional Features

  • Supported: Integrated development environment
  • Supported: Data quality and profiling
  • Supported: Job flow, scheduling, and execution
  • Supported: Extensibility and openness
  • Supported: Performance and scalability
  • Supported: Ease of use for business users

Astera Centerprise Screenshots

Screenshot of Centerprise's UI that is designed to enable business users to work with data easily.Screenshot of the library of Centerprise Connectors, which is preconfigured to provide a plethora of integration options.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 where the user defines how data moves and behaves with the workflow component.

Astera Centerprise Integrations

Astera Centerprise Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo
Supported CountriesUSA
Supported LanguagesEnglish

Frequently Asked Questions

Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.

Reviewers rate Business rules and workflow highest, with a score of 9.9.

The most common users of Astera Centerprise are from Mid-sized Companies (51-1,000 employees).

Astera Centerprise Customer Size Distribution

Consumers0%
Small Businesses (1-50 employees)11%
Mid-Size Companies (51-500 employees)47%
Enterprises (more than 500 employees)42%
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(54)
Loading...

Attribute Ratings

Reviews

(1-25 of 45)
Companies can't remove reviews or game the system. Here's why
February 14, 2024

My Astera experience

Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • It is easy to use. Does not required too much technical background to learn.
  • It can quickly transfer the data across different data sources as it supports the multi-thread processes.
  • It supports many different data sources.
  • It supports Azure connection
  • Better support for SQLite, as it is only partially support it.
  • Supporting the spatial functions. For example, connection SDE or geo databases.
  • More user-friendly error message reporting.
  • Move the ServerAdminConfig.Xml into cluster database as the file access always caused the issue
Score 9 out of 10
Vetted Review
Verified User
  • 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
  • I would say Server Monitor is not very user-friendly. Astera [Centerprise] can add sorting features on different columns to make it more intuitive
  • The search box in server monitor doesn't display the the way I expect.
  • Astera CDI can add Temp tables object to store staging/temporary data instead of using excel or data files.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Easy development of dataflows/workflows
  • Scheduling and restart-ability
  • SCD Implementation
  • Better control/options for the filter in the server monitor panel.
  • Improving re-running of the failed job by running only failed/pending jobs in sub-workflows, instead of triggering all the sub-workflows. This might not be as easy to implement as it looks but an area to look into.
  • [Push-down mode]: PD mode is very useful and super fast when the source and destination both are in the same database. Performance can be enhanced more by not adding extra subquery ( or the brackets() ) for lookup/insert/update operations
  • [Partitioning and parallelism] Diving data into some files and running parallel instances of each component to make run entire flow in a partitioned and parallel manner. This gives a super boost to workflow and huge sized data can be processed quickly.
March 15, 2023

Excellent Tool

JONATHAN ANTHONY AC-AC | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Data parsing from PDF
  • Data transformation
  • Data loading
  • Data validation
  • Data migration/ transfer of data between systems
  • Data Comparison
  • Extraction of data from HTML
  • Data extraction from websites
  • Can you look at front end handling similar to RPA
  • Allow generation of formatted output files in PDF or MS word
  • Allow formatting of MS excel output files (highlighting of cells, underlining of values)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Option to copy an entire project to reuse it for similar but new situations
  • Option to "write SQL" when it really is simply easier
  • Ability to Preview the data before actually pushing it
  • Ability to implement rules or honor database-level rules
  • Ability to quickly get exports of data snippets for 3rd party review of the data
  • The ability to use AI to "connect" the data through
  • The ability to have teams working on the same project at the same time
  • Having more "undo" options
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Great visual for mapping data from datafile to database talbes.
  • ability to program and alter data upon extraction or ingestion.
  • Very intuitive interface
  • Better online documentation or forum
  • Job scheduling could be better
  • Error handling improvements
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Interacting with Salesforce
  • Customer support (quick responses and very helpful)
  • Self-explaining UI
  • Good performance for our use-cases
  • Online documentation and training material
  • Better suited license offers (especially for cases with very little usage)
January 20, 2023

Astera Works for Us

Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • User interface is designed very well and easy to use
  • define rules and the use of car files
  • ease of administration of the server & clients
  • Enterprise application requires multiple environments and this feature need to be added to the server to support
  • extending roles to more than 3 basics
  • Multiplatform support
January 16, 2023

Solid ETL solutions

Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Easily creates Excel files
  • REST API integration
  • Job Scheduling
  • Knowledgeable Support Team
  • No automatic updates. Must manually install each new version
  • Job scheduling can be cumbersome
  • Documentation is lacking
Score 9 out of 10
Vetted Review
Verified User
  • Easily create and map to many incoming data sources
  • Centerprise had an array of connectors
  • Transforming data is very graphical UI based and requires little if any programming
  • We’d love to see a share point connector.
  • I’m not sure if a users group exists but would join if so.
November 08, 2021

Centerprise-10/10

Score 9 out of 10
Vetted Review
Verified User
  • Versatile
  • Scalable
  • Outstanding Customer Service
  • Continued improvement/updating on Reportminer documentation
  • Window management on smaller screens can be very difficult. I often have to rescale the the tool windows to use.
  • Sometimes the data preview will glitch out and not display anything but I'm able to generate a .csv.
Score 10 out of 10
Vetted Review
Verified User
  • Astera support team is very knowledgeable, helpful and very prompt to answer any question.
  • Their product is very simple to use.
  • Astera Centerprise Help documentation/training videos are very detailed.
  • Astera Centerprise rolled out new version 8 recently. During our conversion from version 7 to version 8, we encountered couple of issues with new Astera version. Once notified, they fixed the issue and sent us the patch within days.
  • I think Centerprise Server register feature in version 7 was much simpler than version 8.
November 02, 2021

Astera Software

Hassan Gorgani, CEng | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Designing report models and dataflow diagrams are very simple and understandable for users.
  • Various type of output could be generated from the Astera package.
  • Process thousands of files in a few second.
  • Very supportive team from Astera which are ready to help our users
  • We already communicated those issues which we believe could be useful for future development with your support team.
Score 8 out of 10
Vetted Review
Verified User
  • Makes designing ETL jobs quick
  • Able to include business users in the design
  • Centralized job management
  • Job management interface could use some work
  • Some procedural functionality would help in certain situations
  • It would be nice for the complied package to detect the environment in which it's running; Prod, Test, Development, and use those parameters accordingly.
Score 9 out of 10
Vetted Review
Verified User
  • Of the six mid-tier ETL/DI tools I studied, Centerprise is the most intuitive to use.
  • Customer support is email-centric, but nonetheless solid. Astera happily does conference calls when the need arises.
  • Wide range of features.
  • Expression transformation uses SQL-ish (as opposed to Java-ish or MS-ish) commands. Simple to use, and select/paste helps.
  • Love the PowerCenter-style expression transformation.
  • Documentation explanations are in video and text format. While most explanations are relatively clear (or even very clear), in my opinion, the documentation is a bit haphazardly-organized. It takes me longer than I'd like to find something, although I usually do.
  • Look-ups transformation certainly works, but it could be more robust. (There are ways around that.)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Handles large volumes of data well!
  • Centralizes and simplifies data management loading!
  • Provides insight into data anomalies and patterns that weren't previously visible!
  • Like any tool, it has a learning curve and is somewhat proprietary in how they approach things.
  • It can be clunky to train others who aren't familiar with such tools or concepts, not so intuitive that it can be picked up by any engineer.
Score 9 out of 10
Vetted Review
Verified User
  • Supports numerous data sources.
  • Integration with AWS services.
  • Individual statistics per record.
  • Visualization intended for debugging.
  • Attractive user interface.
  • Streaming facilities.
  • There is no reusable JDBC configuration.
  • Processor configuration changes require stopping all data flow.
April 30, 2020

Astera Review

Score 10 out of 10
Vetted Review
Verified User
  • Ease of managing large volumes of data.
  • Good integration with Mainframe platforms.
  • The Data Stream Programming Concept is straightforward.
  • Good integration with Data Provenance and auditing.
  • Possibility of handling binary data.
  • Simple user interface.
  • Lack of statistics per processed record.
  • High resource consumption.
Score 9 out of 10
Vetted Review
Verified User
  • Astera allows us to use connectors that support any type of data (structured, unstructured and complex), any pattern (between batches, ETL, ELT, real-time, Big Data processing, APIs, events and transmissions) and advanced functions such as optimization pushdown, data change capture, advanced search, partitioning and error handling.
  • We create very simple and complex data integration loads in a mapping designer with time-consuming advanced data integration as standard.
  • The software is available at all times and from virtually anywhere.
  • Using the built-in task wizards to replicate and synchronize batch data at scale we occasionally encounter design flaws.
Score 9 out of 10
Vetted Review
Verified User
  • Centerprise simplifies data modeling and workflow creation. The product has a very user-friendly UI, business users with no technical background need very little training.
  • Extracting data from a PDF and other proprietary formats.
  • The Centerprise product is very scalable and can handle robust volumes.
  • I would like to have integrated source control and better change management tools. Often workflows and data models are updated or modified and the history or original files are not tracked or easy to follow in the history.
  • Licensing a new instance can be difficult.
Return to navigation