Astera Centerprise

Astera Centerprise

Customer Verified
About TrustRadius Scoring
Score 8.9 out of 100
Astera Centerprise

Overview

Recent Reviews

Invest with Astera it will worth the price

8
November 08, 2021
Astera Centerprise is being used by different organizations here in our company. As a user or developer, it is really helps me to do a …
Read full review

Centerprise-10/10

9
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 …
Read full review

Astera Software

9
November 02, 2021
We have used the Astera software package to process existing data for one of the famous clients in Qatar. Several types of file e.g. …

Loving Cenerprise

9
November 01, 2021
We are currently using Centerprise to transform incoming files from vendors. The files are transformed and uploaded into our homegrown …
Read full review

Solid choice for mid-sized organizations

9
May 13, 2020
We use it primarily for publishing to a data warehouse. Another production application creates and exchanges XML files with a federal …
Read full review

Astera: ETL in the cloud

9
May 01, 2020
Astera streamlines our data integration process by doing all the work through a workflow. It enables our analysts to connect to virtually …
Read full review

Astera Review

10
April 30, 2020
It helps us in the massive storage of data and the resolution of intelligence problems of our business. It simplifies complex …
Read full review

Reviewer Sentiment

N/A
Positive ()
N/A
Negative ()
Learn how we calculate reviewer sentiment

Awards

TrustRadius Best of Award, Best Of Customer Support 2021
TrustRadius Award Top Rated 2020

Popular Features

View all 10 features

Simple transformations (25)

8.6
86%

Connect to traditional data sources (25)

8.6
86%

Business rules and workflow (23)

8.4
84%

Complex transformations (23)

7.9
79%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Astera Centerprise, and make your voice heard!

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

Features Scorecard

Data Source Connection

7.9
79%

Data Transformations

8.3
83%

Data Modeling

7.5
75%

Data Governance

8.2
82%

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

Centerprise features a highly intuitive UI that is designed to enable business users to work with data easily.Our ever-expanding library of Centerprise Connectors is preconfigured to provide a plethora of integration options.Centerprise's  data profiling feature ensures that you deliver only quality data to your en users.Choose from a variety of write strategies for your workflows.Easily define how you data moves and behaves with the workflow component

Astera Centerprise Video

Astera Centerprise Integrations

Astera Centerprise Competitors

  • Informatica
  • Adeptia
  • Talend

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%

Astera Centerprise Technical Details

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

Comparisons

View all alternatives

Frequently Asked Questions

What is Astera Centerprise?

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

What is Astera Centerprise's best feature?

Reviewers rate Connect to traditional data sources and Simple transformations and Data model creation highest, with a score of 8.6.

Who uses Astera Centerprise?

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

Reviews and Ratings

 (45)

Ratings

Reviews

(1-25 of 38)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Review Source
Historically we have built a number of integrations and small tasks manually through various languages and processes - having to track what we used, who built it, and what server it's running on. Astera Centerprise has been a breakthrough in this regard in a few ways. The first is that it required almost no training to use. I have given someone a 15-minute demo and left feeling confident they could do simple processes with it moving forward. The drag and drop GUI is generally very intuitive and while nothing is perfect, I rarely am fighting against it. The second is there is a wealth of data connections and functions to use. When I talk to peers about this product, I just ask how they are moving data - any data. Do you have an excel sheet that someone updates that need to join its data to a database and from an API and then write these as a CSV file that you import with a PowerShell command? This is literally a task I built in a few hours in Astera Centerprise. If I need to interact with disparate data, Astera Centerprise is the tool I move to first today.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Astera Centerprise is being used to map incoming pdf files that contain payroll data This tool allows us to automate certain payroll related processes. We are also re-writing SSIS jobs because it’s easier and faster when change request come in
Score 8 out of 10
Vetted Review
Verified User
Review Source
Astera Centerprise is being used by different organizations here in our company. As a user or developer, it is really helps me to do a back-end program a lot easier without using of numerous codes, just a logic. It has a big impact on our business problems especially on data automation moving forward to the systems. By introducing this application as one of the solutions on the issues we experienced before regarding the labor and time, in manual entry, it gives wholly keyboarding process in order to create and finish a record, but with the help of Astera it can make the keyboarding in just a click and it can only takes a second or a minute. When it comes in data quality, due to manual it can cause human errors and inconsistent of data, instead of adapting this error, Astera can resolve this by using transformations which fitted to captures the needed data from the files with correct and accurate values. This system can be used efficiently in many organizations that involves gathering and processing of a large number of data.
November 08, 2021

Centerprise-10/10

Score 9 out of 10
Vetted Review
Verified User
Review Source
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 would manually transcribe this data into excel sheets, saving time and money.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We are currently re-writing our organization's ETL processes using Astera Centerprise. Most of those processes were written using VB.net. We are also creating some new ETL processes using Astera Centerprise. Most of my current work involves extracting claim data from databases for each State, format it as per State requirement and FTP the data. Once State receives the data, it sends us acknowledgement files. We then extract the data from the acknowledgement files and load it into our database. We are using Astera Centerprise for this process. There are other IT teams at our organization using Astera for many other company's ETL processes.
November 04, 2021

Astera Centerprise Review

Score 9 out of 10
Vetted Review
Verified User
Review Source
Astera Centerprise is being used by the IT Application Department in Aspen Medical Products. It is being used to integrate the Magento eCommerce platform to host the company's website with ERP Application (IQMS). I've been using the Astera Centerprise for the last 5 years to create Integration Dataflows, Workflows, Scheduled jobs to integrate the Magento and IQMS APIs. These jobs run round the clock from 4 am till midnight 7 days a week to keep the data flowing between the applications. The data includes customers orders, customer's account setups, address information updates, Credit limit updates, Customer's product pricing updates, etc...
November 02, 2021

Astera Software

Hassan Gorgani, CEng | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have used the Astera software package to process existing data for one of the famous clients in Qatar. Several types of file e.g. EXCEL, PDF, WORD, TXT has been used as input to the Astera software. Once the report model and data flow diagram [have] been [designed] properly to analyze the non-structured data, we connected them to a SQL DB and also in an MS-Excel format for other software i.e. AVEVA Engineering uses.
November 01, 2021

Loving Cenerprise

Score 9 out of 10
Vetted Review
Verified User
Review Source
We are currently using Centerprise to transform incoming files from vendors. The files are transformed and uploaded into our homegrown application. The files are dropped on a shared drive and then is picked up by Centerprise for processing.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use it to transform data from legacy systems to newer systems. It addresses the problem of moving data across the enterprise. It also provides centralized management of the jobs created for the transportation of this data. We use the graphical interface to include the business in the design of solutions.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use it primarily for publishing to a data warehouse. Another production application creates and exchanges XML files with a federal regulatory agency, and as a 1-off, we are using Centerprise to validate an Oracle-to-SQLServer migration.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Astera Centerprise is being used by two teams that are responsible for onboarding data for new or existing customers. Those teams work in conjunction to ensure that proper workflows are set up to review and qualify the data prior to ingestion to our downstream systems. It has helped to centralize our data loading and transformation efforts, and provide visibility into data issues or patterns that we didn't have insight into before. Quality of data is key for our process, and we are TB scale, so performance and scalability were a factor as well.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Astera streamlines our data integration process by doing all the work through a workflow. It enables our analysts to connect to virtually any data source and combine, transform, and map data, including statistical and predictive tasks.
April 30, 2020

Astera Review

Score 10 out of 10
Vetted Review
Verified User
Review Source
It helps us in the massive storage of data and the resolution of intelligence problems of our business. It simplifies complex integrations: Apache Spark, Databricks, Qubole, AWS, Snowflake, Google Cloud Platform and NoSQL ..., and offers us integrated data quality to transform big data into reliable information. It provides us with clean and filtered data structures, which are exploited by the different end-user tools, increasing the quality and value of data, and allowing the optimization of our decisions.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We streamline the transfer of our business data in file formats, securely and at scale, from local and cloud sources (Amazon S3, Azure Blob and HDFS) to data warehouses and data warehouses. We extract and transfer massive volumes of changed data from transactional systems to relational databases, avoiding redundancies by leaving intact unchanged data and storing it in the cloud. We update our databases and host the data on the spot.

Score 9 out of 10
Vetted Review
Verified User
Review Source
We currently use the Astera Centprise and ReportMiner products to create automated scheduled tasks that: retrieve, extract, and process financial information for reports and data integration with other enterprise-level systems. We specifically use the ReportMiner product to extract data from a PDF format for easier integration with other systems. The Centprise product allows our business analyst to easily manage and create a custom workflow and models to automate the complex data integration between systems regardless of file formats.
April 29, 2020

Worth it!

Amanda Moede | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
It is used by our data reporting and solutions team to create solutions and complete corrections to EDI issues that arise when submitting healthcare EDI files to the Wisconsin State Medicaid program. We also use this tool to load data to our SQL data warehouse so that all company SQL users have access to the data received from the state and other outside vendors.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Astera allows us to monitor the database software at all times. It does not help to manage through data extraction, transformation and loading (ETL) tools. We monitor the disk usage of the database server. This allows us to track Big Data data at the moment and respond to our users and anticipate their needs.
April 29, 2020

Astera rocks!

Score 10 out of 10
Vetted Review
Reseller
Review Source
We are using it in Data Migration project to move data from legacy applications to state of the art applications. It is being used by projects under the Data Migration programs. Being used to migrate HR data, CRM data, ERP data, etc.
Data Sources: Oracle DB, SQL Server DB, XML, CSV.
Targets: Oracle DB, XML
May 24, 2018

Great data tool!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Centerprise is an integration tool we use for data manipulation and transfer. The tool makes it easy to transform database data from one endpoint and deliver it to another. This is an excellent tool that makes things like writing hard long SQL scripts into just a click and drag press the go button and done process. Centerprise saves us a huge amount of time when integrating legacy databases data into our application.
Andre Beaumont | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are a large federally qualified health center that serves approximately 70,000 patients per year. Recently we began implementing a data warehouse and analytics platform, and have started a project to integrate our electronic health record system into other systems. Centerprise Data Integrator has become an essential toolkit for us in translating and moving our data. We use this as our main ETL tool to load our data warehouse from a variety of sources. We also use the product to transfer semi-structure data from Citrix SecureForms into our electronic health record system. We are able to develop tablet-based electronic forms that a patient can fill out, and then use Centerprise Data Integrator to validate the data and load it directly into the patient's chart. This saves on the overhead involved in paper processes. Since the tool is so user-friendly, we have multiple teams and users that do not have a extensive SQL or SSIS training creating high quality solutions.