My Astera experience
It is used by the software development department. We are using this for the ETL process to move and transform the data from one data …
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.
Recent 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
- Business rules and workflow (28)9.999%
- Simple transformations (32)9.999%
- Connect to traditional data sources (31)9.090%
- Complex transformations (30)7.373%
Reviewer Pros & Cons
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
Product Demos
Feature Demonstration Data Integration Tool | Astera Centerprise
YouTube
Features
Return to navigation
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
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
Astera Centerprise Integrations
- Microsoft SQL Server
- SAP Adaptive Server Enterprise (ASE), legacy
- ReadyAPI
- SAP CRM discontinued
- Salesforce Sales Cloud
- MySQL
- Microsoft Dynamics 365
- Salesforce
- Oracle
- Netezza
- Teradata
- XML
- Excel
- X12
- PRN
- IBM DB2
- REST
- ODBC
- Ole DB
- Delimited
- flat
- fixed length files
- COBOL
- HIPAA
- JSON
Astera Centerprise Competitors
Astera Centerprise Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows |
| Mobile Application | No |
| Supported Countries | USA |
| Supported Languages | English |
Frequently Asked Questions
Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.
Informatica Intelligent Cloud Integration Services, Adeptia Connect, and Talend Data Integration are common alternatives for Astera Centerprise.
Reviewers rate Simple transformations and Data model creation and 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
| Consumers | 0% |
|---|---|
| Small Businesses (1-50 employees) | 11% |
| Mid-Size Companies (51-500 employees) | 47% |
| Enterprises (more than 500 employees) | 42% |
Comparisons
Compare with
Reviews and Ratings
(54)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Pros
- Cons
Astera Centerprise is a versatile and affordable data integration tool that has proven to be highly valuable in various use cases. Users have found that the software is commonly used to generate files from a data warehouse in proprietary formats and send them to vendors. It is also utilized for automated report generation, inventory alerts, and scheduled email tasks. Additionally, Astera Centerprise is often employed for ETL processes, allowing for seamless movement and transformation of data between different sources based on specific business rules.
One of the key use cases of Astera Centerprise is syncing a legacy database to a more web-friendly database, which requires the creation of a custom database driver. Users have successfully leveraged the software for this purpose. Another significant use case is integrating Salesforce with various ERP systems, providing an intuitive user interface for exchanging data between these platforms. Furthermore, Astera Centerprise has been instrumental in providing visibility into issues with moving data from legacy systems to the application's database, reducing both time and technical skills required.
The software simplifies the process of building integrations and small tasks through its drag-and-drop GUI and wide range of data connections and functions. For instance, it is widely used for importing data into Microsoft Dynamics AX, Salesforce, and other in-house built applications, making it easier to map and integrate the data. Moreover, Astera Centerprise streamlines data integration processes by enabling analysts to connect to various data sources and perform complex transformations seamlessly.
The software finds application in diverse domains such as finance, healthcare, agriculture, and manufacturing. For example, it serves as a key component for consolidating financial data from different sources into a single view for corporate finance groups. It also plays a critical role in integrating electronic health record systems with other systems in the healthcare sector. Across organizations, Astera Centerprise is widely used for importing and exporting data from application databases efficiently, saving significant time. Additionally, the software is valued for its ability to manipulate and map data based on client requirements, enabling users to synchronize data between ecommerce solutions and ERP systems effectively.
Intuitive Interface: Multiple users have praised the intuitive interface of Centerprise, stating that it is easy to understand and navigate. They have mentioned that after becoming familiar with the interface, they were able to quickly start using the tool.
Self-Documenting Graphical Approach: Many reviewers appreciate Centerprise's self-documenting graphical approach for building data flows. This feature allows new team members to easily understand existing work, saving time and promoting collaboration.
Data Preview Capability: The ability to preview data on each object within Centerprise has been highly valued by users. Being able to immediately see transformation results at any point in a data flow has not only saved them time but also facilitated data reconciliation processes.
Confusing User Interface: Several users have found the user interface of the software to be confusing and difficult to follow, making tasks more challenging. They have expressed frustration with navigating through the different features and options, resulting in a steep learning curve.
Issues with Software Updates: Users have encountered various issues during software updates, including bugs and changes to existing functionality. Some reviewers mentioned that these updates were not seamless and caused disruptions in their workflows. They had to spend time troubleshooting and adapting to the changes, which was inconvenient for them.
Performance Issues with Large Datasets: Some users have experienced performance issues when working with large datasets. They reported slowdowns and delays while processing extensive amounts of data. However, they were able to find workarounds by optimizing their workflows or breaking down the datasets into smaller chunks for better performance.
Attribute Ratings
Reviews
(1-25 of 31)Companies can't remove reviews or game the system. Here's why
February 14, 2024
My Astera experience
We first tried Informatica and think it is suitable for our company. However, the per license price is way too expensive, as we need to support multiple users at the same time. When compared to Astera, we found Astera can do most of the stuff that Informatica does. That's why we picked Astera.
January 23, 2024
Astera Centerprise Review
Score 9 out of 10
Vetted Review
Verified User
For us Astera Centerprise is a better tool as it helps in solving 2 problems. We use it as both an ETL tool as well as API integration tool. MuleSoft Anypoint Platform is used for API integration only. So we chose Astera Centerprise over MuleSoft. We're now using to EDI integration also.
March 29, 2023
Astera Centerprise for Every Enterprise
Suitable for the environment.
March 15, 2023
Excellent Tool
We evaluated both Monarch and Astera Centerprise and ended up purchasing Astera Centerprise due to ease of use and the wide range of available functions.
March 07, 2023
A back office gem whose power is in the simplicity
GoldenGate is not really designed for "interactive reusasbility" situations. Centerprise is perfect for the concept of reusing previous work for new projects! Plus, the cost difference is so huge!
January 23, 2023
Great to exchange data between Salesforce and other systems
- TIBCO Cloud Integration (including BusinessWorks and Scribe)
I was not involved in the vendor selection process.
January 20, 2023
Astera Works for Us
Comparing the license cost, affordability and the training which was provided by the company to get to the speed of development and support
January 18, 2023
Fast and easy-to-manage ETL software
Score 10 out of 10
Vetted Review
Verified User
Much easier and faster development time, better interface.
January 16, 2023
Solid ETL solutions
I have not had the chance to evaluate or trial any other products like Astera Centerprise. The decision to enter a license agreement with Astera Centerprise was made before my employment at my current employer.
Score 9 out of 10
Vetted Review
Verified User
- SQL Server Integration Services, Talend Open Studio, Pentaho, Fivetran, Stitch, from Talend and Airbyte
The biggest difference is with Astera Centerprise I could just start using it. Almost every other tool required me to write SQL or in another language... and if I'm writing SQL already, why not just use SSIS or raw SQL? There wasn't a tremendous amount of time savings being seen with the other products in getting the work done and that was the primary reason to go with Astera Centerprise. I watched someone use it in a demo for 30 minutes and thought, "Ok, let me have it, I can use this right now."
March 23, 2022
Centerprise is great for automating workflows.
Score 7 out of 10
Vetted Review
Verified User
Primary reason was native support for HIPAA 834 format.
November 05, 2021
Astera Centerprise A Complete Data Integration Solution
Score 10 out of 10
Vetted Review
Verified User
November 02, 2021
Astera Software
We spend lots of time to find a good software package and then finally this package has been accepted technically and then commercially by our management team.
October 20, 2021
Centerprise can transform your data management
Score 8 out of 10
Vetted Review
Verified User
Centerprise is easier for everything except the most demanding jobs. Centerprise is not for full blown enterprise data warehouses.
May 13, 2020
Solid choice for mid-sized organizations
Score 9 out of 10
Vetted Review
Verified User
From honing the web I made a long-list of about 25 products, leaving off the big (and expensive) 4 as well as clearly inferior products. Then, due to the nature of our organization, I excluded cloud-specific solutions. That got us to about 15. I read reviews and was persuaded to reduce the shortlist to eight, which somewhat unfairly I arbitrarily cut to six because eight was just too much to deep-dive. I took a deep dive including vendor product demo with all six. From that study, two emerged, and I recommended both to my management as excellent choices. My management preferred Centerprise because it is not Java-based, and we are not a Java organization.
May 01, 2020
Astera Centerprise simplified our on-boarding process and was a great fit for our needs.
Stacks up well against competitors and overall provided the best fit for our needs while also meetings all of our requirements. No tool was perfect in our evaluation or from past experience even, but Astera proved to be a great fit after going through various reviews, demos, proof of concepts, and so on.
April 29, 2020
Astera rocks!
SSIS and Informatica.
April 17, 2020
One of the easiest ETL tools out there
- TIBCO Cloud Integration (including BusinessWorks and Scribe) and Azure Logic Apps
Astera wins on simplicity of building and maintaining the data flows. I am afraid that the two above-mentioned tools (and especially LogicApps) actually have more power under the hood. However, as mentioned before - Astera is way simpler to understand and maintain. Astera can be easily mastered by anyone.
May 23, 2017
Centerprise Data Integrator is an excellent toolset for multiple uses in a healthcare agency
Score 9 out of 10
Vetted Review
Verified User
We looked at continuing to use SSIS as an alternative. Although we own SSIS as part of our SQL licensing, we found that it takes a much higher skill level to create solutions. It also does not have the ability to parse unstructured data the way that Centerprise Data Integrator can. We also looked at Datawatch Monarch as a possibility but found it over-all to be cost-prohibitive. We also looked at a cheaper alternative called SimX but did not have a strong confidence in the product as we evaluated it. We landed on Centerprise Data Integrator as it met all of our business requirements and we know we could leverage it for many uses across our enterprise.
August 21, 2015
Centerprise makes data integration easy
Score 10 out of 10
Vetted Review
Verified User
- Microsoft SQL Server,Adeptia BPM Suite
Centerprise has many more tools built in so you do not have to build from scratch than SSIS. Centerprise is much more cost effective than Adeptia.
August 21, 2015
First impressions of Centerprise
Score 8 out of 10
Vetted Review
Verified User
I looked at a few other options. But honestly, do not remember their names. They were excluded quickly when they came up short on functionality.
Before this tool, we used VBscript, VB.net and Excel to parse reports. These methods were much more time consuming.
Before this tool, we used VBscript, VB.net and Excel to parse reports. These methods were much more time consuming.
August 18, 2015
Centerprise at its best!
Score 10 out of 10
Vetted Review
Verified User
I can not disclose.
August 17, 2015
Fast and Simple. All-in-one package
Score 10 out of 10
Vetted Review
Verified User
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)
August 13, 2015
Test drive the product in your environment before buying
Score 5 out of 10
Vetted Review
Verified User
We are currently looking at Mulesoft as a replacement.
August 13, 2015
Like peeling an onion, there is so much more to it!
Score 9 out of 10
Vetted Review
Verified User
We looked at some similar data integration tools, but reading the fine print of one revealed its need to scan our network - which automatically removed itself from our consideration. We will never compromise our customer's data for any reason, especially that of a suspect third-party software provider. The others lost out to Centerprise because their combination of value and ability vs cost didn't make sense.