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-1 of 1)Companies can't remove reviews or game the system. Here's why
August 03, 2015
Make Centerprise your data toolkit's center prize!
Centerprise is used as a key ETL and data integration component bringing together several different financial data sources to compile a single view of our client's corporate finance group. It delivers a single integrated view of their 'cash register' systems and solves the problem of the manual integration of the separate system's data and reports.
- The links to many different data sources made it real easy to gain access to the key data elements and integrate the data across many different systems.
- The graphical approach is self documenting and permits the rapid assimilation of existing work by new team members.
- It makes it VERY easy to build source/destination data reconciliations.
- The ability to incrementally see the data transformation results at any point in a data flow is invaluable.
- The XML processors make it real easy to process and integrate XML data. We've even used Centerprise on its own data logs to pull out and report on the XML job log data for custom reporting.
- Centerprise is an invaluable tool for addressing data integration particularly dealing with 'Shadow IT' Excel spreadsheets.
- The dataflow architecture will take some getting used to as you have to understand the various data flow objects and THINK about how a data flow will work to accomplish what you want.
- The scheduler and job monitor are areas where the product can be improved. We would like to see an independent job monitor as a separate read only component so that a client use license is not not needed to see the working jobs.
- The job scheduler interface is not that intuitive and adding jobs, particularly in 100's, is VERY time consuming using the interface.
- The mapping between UTC and local times need work and the scheduler needs to handle switching back and forth between day light savings.
- Our client has a quicker, clearer and trustworthy business financial view enabling them to make well informed financial decisions.
- The ETL development group is twice as productive and handing work out for support is much quicker and more simple.
- User adoption of the systems was quick and painless.
We looked at Adeptia, Informatica, Jitterbit, and Adaptive. All of these products had their specific strengths. We compared many factors which included but was not limited to price, product capability, product maturity and stability, what comes in the box for the purchase price, the ability to connect across a wide data landscape, ease of use, and product support. We chose Centerprise because of what was delivered for the purchase price. Other products required additional module purchases while others did not provide the data integration level we where seeking.
No
Support is part of the product annual maintenance particularly if there are errors/failures resulting in product error codes. The data flow architecture posses challenges in that the Centerprise Server tries to optimize the operations which in some VERY rare cases is not what you want it to do. Working with the support team you can figure out data flow adjustments or realignment so that the server doesn't optimize away the result you are seeking.
Yes
When you start pushing the envelope of any product you find bugs. Over the course of using Centerprise we've run across bugs and they have been isolated and addressed by Astera as either a patch work around or corrections in future product releases.
We had an issue where some of our nightly production jobs where intermittently raising missing data source errors when the server was under heavy load. The errors happened intermittently and at different times in the night cycle. We alerted the support team and sent them our data flows and job schedule. Mike and his support team worked major overtime and into the weekend on the problem to isolate it. They were able to recreate the issue but only on certain machines with certain OS patch revisions. Needless to say, they figured out what was happening and come up with a patch. We applied the patch and the problem disappeared.
- Everything is data flow architecture. Building flows that grab data from one source to transform it and place into a destination is a piece of cake. You will however need to understand the data flow objects and how to link them together to build very complicated ETL flows.
- Grabbing data from the 'Shadow IT' Excel explosion and putting back under database control is one place where Centerprise shines.
- We literally generated custom status reports by using Centerprise on it's own job log to pull out the XML, prepare a report and email it to the support teams.
- This is a VERY valid questions and I'm NOT knocking it, just trying to draw an analogy...I could almost say that this questions is akin to asking...'What functions are particularly easy or elegant to perform with a programming language compiler?' I guess it's based on your imagination, creativity, and of course data volume.
- Improvements can be made in daily job monitoring. When you have over 5000 jobs running in a night cycle it can get difficult to isolate that one job that didn't behave using the job monitor embedded in the client.
- Moving over 100 million records nightly. However, I believe that to be a difficult task for ANY product running on the same platform as Centerprise.
- Not so much a product issue but a developer issue is getting out of a typical iterative programming thought process and moving into an object based data flow thought process.
- Synchronizing data flows and workflows that have cross dependencies.
No