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
January 23, 2024
Astera Centerprise Review
Score 9 out of 10
Vetted Review
Verified User
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...
- 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.
- REST API client, Rest Connection to generate refresh API tokens
- EDI Connect features like EDI message parser, source, destination.
- Loop feature to loop the records in the workflows
- Sending Outbound EDi files like 940, 855, 856, 810 etc..
90%
9.0
85%
8.5
86.66666666666666%
8.7
N/A
N/A
- Instead of using Mulesoft which was very costly tool, we chose Astera Centerprise which helped in saving thousands of dollars in licensing fees per year.
- Last year we were looking for EDI tools for our needs to consume EDI files like 850 and also generate the outbound EDI files like 810, 856 etc. but after comparing others in the market, Astera's EDI Connect was the best choice for us as it was much cheaper and Integrating with our existing Astera CDI tool was easier.
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.
4
They represent the same business functions like me IT applications.
2
Skilles required are IT applications skills, ETL methodology, EDI knowledge.
- REST API connection
- ETL data sync
- EDI inbound and outbounds
- REST API client
- EDI files consumption and generation for Inbound and Outbound
- Not sure for now
Yes
Last year we were planning to buy new tool for EDI connections and instead of buying new one we approached Astera and they provided us the EDI Connect which was added to Centerprise stack and working really well for us so far.
- Price
- Product Features
- Product Usability
- Product Reputation
- Prior Experience with the Product
Product Usability
It will be same selection process.
- Implemented in-house
No
Change management was minimal
- None. It was smooth using the installation tutorials provided by Astera support
- No Training
I had a previous experience of working on ETL and datawarehousing tools like Informatica and SSIS, so it was quite easy for me to work on Astera CDI.
No premium support
Yes
Yes it was resolved in a timely manner.
Yes, last year I was stuck to design a solution to generate the outbound EDI 810 (Invoice) file using my Integration dataflow. Their support really helped me to find the solution and i was able to implement it.
- REST API client
- EDI connections
- Loop through the records
- None
- Ecommerce application - Magento by Adobe
- ERP application - IQMS
- ERP application - IFS
- SQL server
- Oracle databases
- File import/export
- API (e.g. SOAP or REST)
- ETL tools
Astera Centerprise Data Integrator is an easy hands on ETL+API+EDI integartion tool which I've been using for the last 7 years and it is quite productive.
No terms as such.
No tips. just keep your business requirements straight.
Yes
It was good.
- Helped in more EDI and recent API integrations
- New EDI outbound requirements for 940 and 856 files
Yes
We're already in Enterprise Edition of Astera CDI.
Yes
We're already in Enterprise edition of Astera CDI.