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.
Astera Centerprise Review
TrustRadius Insights
Astera Centerprise for Every Enterprise
Excellent Tool
A back office gem whose power is in the simplicity
Great Automated Tool for ETL
Great to exchange data between Salesforce and other systems
Astera Works for Us
Fast and easy-to-manage ETL software
Solid ETL solutions
Astera Centerprise a solid centerpiece of your data stack
Centerprise is great for automating workflows.
Honest review of Centerprise after one year of use
Invest with Astera it will worth the price
Centerprise-10/10
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
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
Feature Demonstration Data Integration Tool | Astera Centerprise
Features
Data Source Connection
Ability to connect to multiple data sources
- 9Connect to traditional data sources(31) Ratings
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
- 7.3Connecto to Big Data and NoSQL(1) Ratings
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Data Transformations
Data transformations include calculations, search and replace, data normalization and data parsing
- 9.9Simple transformations(32) Ratings
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
- 7.3Complex transformations(30) Ratings
Complex data transformations are data normalization, advanced data parsing, etc.
Data Modeling
A data model is a diagram or flowchart that illustrates the relationships between data
- 9.9Data model creation(19) Ratings
Ability to create and maintain data models using a graphical tool to define relationships between data
- 9.9Business rules and workflow(28) Ratings
Ability to define and manage business rules and workflows
- 6.4Collaboration(1) Ratings
Collaboration is enabled by a shared repository of project information and metadata
- 7.9Testing and debugging(27) Ratings
Tool to debug and tune for optimal performance
Data Governance
Data governance is the practise of implementing policies defining effective use of an organization's data assets
- 8.2Integration with data quality tools(1) Ratings
Integration with tools for cleansing, parsing and normalizing data according to business rules
- 8.2Integration with MDM tools(1) Ratings
Integration with master data management tools to ensure data consistency across the organization
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
What is Astera Centerprise?
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
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
- 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
- 9.2Likelihood to Renew7 ratings
- 8.7Availability2 ratings
- 8.5Performance2 ratings
- 8.7Usability9 ratings
- 8.6Support Rating21 ratings
- 8.6Implementation Rating4 ratings
- 9.1Configurability1 rating
- 7.7Product Scalability2 ratings
- 9Ease of integration2 ratings
- 9Vendor pre-sale2 ratings
- 9Vendor post-sale2 ratings
- 9Professional Services1 rating
- 8Contract Terms and Pricing Model1 rating
Reviews
(1-21 of 21)Astera Centerprise Review
- 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.
2) Data preview feature is really good which helps in debugging of dataflow easier and faster. Per my knowledge, Astera Centerprise is not very well suited for very large data loads.
3) The new combined CDI+ Edi Connect tool gives the best of both worlds where you can consume the source 850 EDI files and also generate the outbound EDI files like 940, 810, 856 etc. and also use all CDI transformations to massage the data as needed.
Excellent Tool
We initially purchased Astera Centerprise for us to automatically capture and load data from PDF documents to improve our data quality. With all the available functions in Centerprise, we expanded to different areas and continue to grow in terms of application. We also continue to work with Astera support group on possible improvements and functionalities.
- 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)
Astera is also good for data integration or data exchange between different systems.
Astera is not suited for front end processing similar to how RPA works but it would be good if it will include this functionality.
A back office gem whose power is in the simplicity
- 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
Solid ETL solutions
- 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
- ETL, ELT - moving and integrating data
- easy UX/Gui for interacting with the application
- Installation and setup
- Data Source Choices
- Complex Transformations
- Occasional Bugs
- Documentation could be better, more clear
- A premium priced product
Invest with Astera it will worth the price
- Codeless
- Data Automation
- Data Integration
- Easy to Manipulate
- Good User Interface
- Additional formulas in expression
- Set maximum number of emails per run
Astera Centerprise A Complete Data Integration Solution
- 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.
Centerprise can transform your data management
- 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.
Solid choice for mid-sized organizations
- 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.)
Astera Centerprise simplified our on-boarding process and was a great fit for our needs.
- 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.
Astera: ETL in the cloud
- 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.
Worth it!
- Astera's customer service and help team are quick to respond and have always found solutions to my questions or problems. They also follow up after completing a support request to make sure everything was working correctly. If it's not something the current version allows, as far as functionality, they develop a solution for the next version because they assume if one company has that need that others will as well.
- I've never lost touch with our sales representative. She checks in at least twice a year, if not more, to make sure that we are happy with their product and to see if we need anything. I've rarely needed anything, but when I did she made sure to have the correct person contact me regarding what I asked for and she followed up to make sure the request was resolved.
- EDI is a very complex language and making any changes can cause errors in other areas that you aren't aware of. Astera Centerprise creates an environment that is much easier to understand than looking at a raw data file. The functionality allows us to make changes to each transaction within a file in under a minute with no errors created. Making these changes before we had Astera Centerprise took a week for one file. We can now get to more files to create clean data for the state and have reached 97% acceptance.
- Centerprise's functionality can be applied at any level. It can be a broad change to an entire segment, or it can be a single digit that is changed. You can program the system to look for specific items within a file and change only the records that need to be changed. It can sequence items, it can remove items and it can add items when specifically programmed to. And if you run into a wall creating the program, Astera's help desk will help you get past it. And the program language used is easy to understand as well. If you understand functions in Microsoft Excel or SQL statements, you will be able to use this product.
- When purchasing Astera Centerprise you are given options on how you would like to be trained and each option comes with a different price tag. We chose to be trained using online meetings over several days. The training went too fast and it was not always easy to understand until I started using the product.
- I am a person that wants to learn how and why something works so that I can use the knowledge in the future. When contacting the support team they take the problem, create a solution for you and send it back. The solutions always work, but when I get the solution I have to review every field and function to understand how it works so that I can re-create it for another solution I need. I would much rather have the support team explain what I had done incorrectly and what they changed or I would like to find a solution with them instead of having it handed to me.
- Astera uses license keys to allow their customers rights to only the functionality that was purchased. Each user and server has its own key and each key is only good for one year. There have been 2 different times that we received keys that had less functionality that we purchased. It wasn't until it created problems that we noticed and had to request new keys. This year our sales representative made sure she was available when we updated our keys so that if there was a problem she could fix it right away; however, there were not issues this year. I believe this is something they pay closer attention to now.
Astera Centerprise
- EDI integration.
- API integration.
- ETL batch updates.
- No issues encountered so far.
Astera rocks!
Data Sources: Oracle DB, SQL Server DB, XML, CSV.
Targets: Oracle DB, XML
- Very simple installation and configuration.
- Easy to learn.
- User Interface (UI) is very intuitive.
- Simple licensing.
- Expert product support services.
- Performance with large dataset (50 million+ rows) can cause some issues. But there are ways to work around that.
- Generating XML using CSV source - adding additional header elements in the XML was not available in the product. Needed to do some post processing. Should be included in the product feature.
- Data Accuracy - 38 decimal places (i.e NUMBER data type in Oracle type) not supported by Astera in the version we used. Newer version may have addressed this issue
- Needs more pre-built connectors for well-known cloud apps (Dynamics, SFDC etc.).
However, Astera may not best suited for real-time, API-based integration. One can make it work (it has REST/SOAP client), but it may not be as good as Mulesoft, etc.
Centerprise makes data integration easy
- Allows for integration of custom functions.
- Allows us to easily migrate data to and from any data source. Our department has become the go-to for automated data extracts.
- We use emails from jobs we run in Centerprise to ensure all jobs run successfully.
- I have not upgraded to the latest version, but in the last version, could use better descriptions in error messages.
- I have not upgraded to the latest version, but in the last version, it would be nice to have reports we could run or have emailed daily/weekly with success/failure of all jobs scheduled.
Fast and Simple. All-in-one package
- Once you get the feel around the interface, Centerprise is a real easy and fast tool to get up and running. You can have a Dataflow up and running in mere minutes compared to some other tools on the market. The interface is simple and pretty much everything is all in once place and easy to understand.
- The Preview data on each object is a lifesaver. To be able to set up a Dataflow and preview it's data immediately without having to run or set up a workflow is a very time-saving benefit.
- You can run Dataflows. They do not need to be incorporated into a Workflow in order to run.
- You have the ability to pass in and out parameters to Dataflows. Very handy if you need specific information about a Dataflow (or data in that flow) in order to continue on processing the next step.
- The scheduler is extremely nice and easy.
- Centerprise is an all in one package. Everything is together. You do not need a separate scheduler or bits and pieces of other products in order to get full use of Centerprise. You can Read, write and parse files. You can send emails and/or FTP to government (any) sites. You can schedule your jobs or have your System (we had .NET) call and trigger a job for you.
- Our main concern is backward compatibility with QA testing. We had a few releases of new code, changes or fixed that broke existing code which took us over 90 hours to run thru and refresh all our flows. We like the enhancements, but we don't have time to back thru everything, everytime there is a release to retest and refresh all the Flows. It's not feasible for us.
- Help documentation. There needs to be a lot more with a lot of examples (so we aren't calling and bugging support all the time). Although, they were extremely helpful, but I'm sure they have other things to do than teach us how to use the product.
- Pretty much any enhancement we needed at the time (or asked for) was given to us in a pretty timely manner. The Cobol objects were fixed/enhanced. The out variables were added. The only thing we didn't get to use that we asked for was the REST service calls. We had a lot more we wanted to do with the product.
Test drive the product in your environment before buying
- The mapping interface is easy to use.
- It works well with our code repository.
- It does not work well in an environment where you run a lot of small jobs. The queue processor leaves much to be desired.
- Jobs fail for no apparent reason and do not automatically restart. We have to come in every morning and manually restart jobs that have failed overnight.
Astera Centerprise Data Integrator
- Centerprise Data Integrator makes it very easy for non-technical people to create and maintain data mappings from one data source type to another. This is beneficial to allow developers and engineers to focus on other parts of the business needs and not be bogged down with constant work flow changes desired by the customers.
- Centerprise Data Integrator is very good at moving and translating large blocks of data efficiently.
- Our biggest problem is with updates. We feel we have to thoroughly test each and every update with complete regression testing before we can apply that update to our production environment. This is due to previous updates often containing bugs or changing existing functionality.
- Centerprise Data Integrator could do a much better job at moving a lot of small sets of data instead of a few large sets.
- Web services connection could be much better. It is difficult to get some web services to work properly.
- Could really benefit from allowing 32-bit integers instead of only 64-bit integers.
WOW Why did we wait soooo long?
- Because the standard reports from one system to another are not always compatible - Centerprise allows us to create a reusable template to standardize the information that we use to validate conversions. Standardizing the reporting data from two systems is an awesome strength that can be developed out of Centerprise.
- We have had several instances that the supplier of software to a customer will not provide data out of their system for conversion. Sometimes it is a timing issue (you will need to wait 6 months for this) and other times it is a cost issue. We have been able to convert accounting and payroll information into our system just based on reports out of the legacy system. Because we can save the template we can now convert anyone on that legacy system without the involvement of the legacy system's software provider.
- We have several support calls that have been labeled as to be done in the future. One is the reading of the File Definition in AcuCobol with the sign trailing in a numeric field. The handling of this would help us in several areas but we have been able to develop a work around at this point.
- Some of the child/overlap configuration for the "RMD" seems awkward.
Astera Centerprise rules!
- It's incredibly easy to use. The YouTube videos Astera provides are enough to get you started. People with no previous ETL experience can start building simple mappings very quickly.
- It's incredibly easy to install and maintain. After I first installed Centerprise, I was able to start working in just a few minutes, and the maintenance releases are pretty straightforward.
- I am particularly impressed with how much Centerprise simplifies transformations that require more work in other ETL tools. The perfect example is the SCD transformation, which handles all the logic in an Slowly Changing Dimension. Even with a market leader like Informatica, the SCD logic has to be manually built. With Centerprise this can be built in just a few minutes, and it impacts every mapping.
- Performance is definitely an area to work on. My own benchmarking shows a notable difference when introducing simple transformations into a jobflow.
- The tool lacks debugging capabilities
- I would like to see more jobflow stats than the ones provided
- It is Windows-based. Many companies (including ours) are UNIX shops, and try to avoid Windows servers as much as possible, so it would be nice to have a non-Windows version.
Our data volumes are relatively small (~200Gb). I wonder how it would perform with terabytes of data. I know it has partitioning capabilities but I haven't had the chance to use them, so I wonder if performance will be reasonable.
Make Centerprise your data toolkit's center prize!
- 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.