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
- 8Testing 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-4 of 4)My Astera experience
- It is easy to use. Does not required too much technical background to learn.
- It can quickly transfer the data across different data sources as it supports the multi-thread processes.
- It supports many different data sources.
- It supports Azure connection
- Better support for SQLite, as it is only partially support it.
- Supporting the spatial functions. For example, connection SDE or geo databases.
- More user-friendly error message reporting.
- Move the ServerAdminConfig.Xml into cluster database as the file access always caused the issue
- The ability to exchange and valid the data between different data sources
- Connect to traditional data sources
- 100%10.0
- Simple transformations
- 100%10.0
- Complex transformations
- 100%10.0
- Data model creation
- N/AN/A
- Business rules and workflow
- 100%10.0
- Testing and debugging
- 80%8.0
- It is quickly adapted by many of my co-workers and easy to learn. That saved a lot of training time.
- As I am dealing with a big data set, it helps us to move and verify the data quickly.
- It took me some time to get used to the error message, as it is a bit too technical. This has also caused some issues as other users may need more support on it.
- The cdc file caused the issue a lot. We have to remove that from our design.
- Astera provides a fast response for support.
- Transfer data from one data source to another
- Validate the data and provide the report to the user
- Trying to use it to connect to Azure
- We used Astera as the backend of some of our webservices
- We are trying to use Astera to move data between Azure and local databases
- Cloud Solutions
- Scalability
- Integration with Other Systems
- Ease of Use
- Implemented in-house
- When there is issue occur, it is very hard to debug as the error message did not give me enough information
- When using the webservice component, it always gives me the generic error message.
- No Training
- Data transfer
- Data validation
- I think xml data transfer is a bit difficult
- SQL server
- Oracle
- Excel
- Xml
- Webservice
- We are planning to use the Azure connector
- File import/export
- Single Signon
- API (e.g. SOAP or REST)
- ETL tools
- Bugs fixes
- License server using port 443
- Able to connect to Azure database
- Better performance
- Less bug
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.
- 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..
- Connect to traditional data sources
- 90%9.0
- Simple transformations
- 90%9.0
- Complex transformations
- 80%8.0
- Data model creation
- 80%8.0
- Business rules and workflow
- 90%9.0
- Testing and debugging
- 90%9.0
- 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.
- 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
- Price
- Product Features
- Product Usability
- Product Reputation
- Prior Experience with the Product
- Implemented in-house
- None. It was smooth using the installation tutorials provided by Astera support
- No Training
- 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
- Helped in more EDI and recent API integrations
- New EDI outbound requirements for 940 and 856 files
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.
- Increased employee efficiency
- Allowed us to take more on as a department without added head count
- Better turnaround time for data conversions.
- Microsoft SQL Server,Adeptia BPM Suite
IT Manager
- EDIs to private and government entities
- scheduled data extracts or reports
- quick and clean data conversions
- Scheduled Crystal Reports
- Automatic PGP encryption of data extract
- Proprietary encryption and decryption of data
- automatic SFTP
- Transfer of documents into our document management system
- Price
- Product Features
- Product Usability
- Positive Sales Experience with the Vendor
- Third-party Reviews
- Implemented in-house
- Just the learning curve, but once you understand the basics, it is a rather intuitive product.
- Straight source to new destination type conversion
- custom functions
- data transformation
- scheduling jobs
- Using parameters sometimes needs single quotes around it when used in a SQL statement
- Dynamic file name
Centerprise Data Integrator - XML the easy way
- Maps XML data exceptionally well
- Integrates flawlessly with SQL 2012
- Extremely robust set of transformations and functions which allows a huge amount of flexibility with ETL
- The help functionality. Needs better search and more examples.
- Definitely increased our data processing efficiency
- Allowed the company to penetrate a new health care maket space
- data migrator,talend,pervasive,cloveretl,liquid data mapper
- XML mapping
- have not had a chance to evaluate how this product will support other areas of our business yet.
- converting some of our very old SSIS packages
- Product Features
- Product Usability
- Third-party Reviews
- Implemented in-house
2nd phase - optimization of integrator data/sub flows
3rd phase - automation, which probably requires upgrade
- due to the ease of use, there were no significant issues encountered. I did identify a bug, which was confirmed by Centerprise, but it did not prevent me from loading data.
- Due to the very large XML schemas the government utilizes for health care, some limitations of the GUI created some lag when developing maps. These GUI issues have been relayed to Centerprise
- built in functions provide a nearly limitless way of handling data
- love the data preview feature. beneficial when mapping xml data
- when dealing with large xml schemas and having to make a change (like converting an xml source to a transformation) you sometimes have to remap, which in my case, can be hundreds of data points
- the GUI contains several areas there the display does not show the entire element/field name. The government schemas all contain field names that are very long. The GUI cuts off the ends of these field names, which makes it difficult to select the correct one.