TrustRadius Insights for Astera Data Pipeline Builder (Centerprise) are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
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.
Loading Reviews List....
Astera Data Pipeline Builder (Centerprise) Reviews
4 Reviews
Engineering
Search is temporarily unavailable. Filters are still applied.
We are using Astera Centerprise to build and maintain our DWH solution. Then data is used for various kinds of reporting. This tool is very helpful in the quick development of ETL flows, adding new tables in the DWH, and SCD implementation. Makes operations smooth with scheduling/restart ability, and ease of error handling.
Pros
Easy development of dataflows/workflows
Scheduling and restart-ability
SCD Implementation
Cons
Better control/options for the filter in the server monitor panel.
Improving re-running of the failed job by running only failed/pending jobs in sub-workflows, instead of triggering all the sub-workflows. This might not be as easy to implement as it looks but an area to look into.
[Push-down mode]: PD mode is very useful and super fast when the source and destination both are in the same database. Performance can be enhanced more by not adding extra subquery ( or the brackets() ) for lookup/insert/update operations
[Partitioning and parallelism] Diving data into some files and running parallel instances of each component to make run entire flow in a partitioned and parallel manner. This gives a super boost to workflow and huge sized data can be processed quickly.
Likelihood to Recommend
More appropriate - Ease of operations - in terms of scheduling, and re-running, - Ease of development - quick workflow development for simple or semi-complex solutions........ Less appropriate Unix/Linux/AIX-based Integration server installation.
We leverage the tool to perform ETL (Extraction, Transforming and Loading) of new customer data into our application's database. The problem it solved is providing the visibility to issues with moving the data from a legacy system database into our system. Plus, we can reuse the projects when implementing future customers from the same legacy system. Having this feature tremendously reduces the time and technical skills required to move the data.
Pros
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
Cons
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
Likelihood to Recommend
It absolutely will shine in areas where it is connecting the same systems together all the time. It will be a huge asset where people do not need to modify the flows very often, but when you do, it provides a lot of insight into any changes that will occur before actually moving any physical data. Some areas that it struggles, and this is the case for most ETL software, is when the source or destination changes or the requirements of the data change, it requires human intervention, which can lead to creating unexpected results.
We do use Astera Centerprise for integrations between Salesforce and various ERP systems. The UI is pretty self explaining, even when it's very special in some aspects (not saying it's bad, but different compared to other ETL tools). Overall it's a good tool when you need to exchange data between SF and other systems (either file-based or direct database interaction).
Pros
Interacting with Salesforce
Customer support (quick responses and very helpful)
Self-explaining UI
Good performance for our use-cases
Cons
Online documentation and training material
Better suited license offers (especially for cases with very little usage)
Likelihood to Recommend
As mentioned, we do use Astera Cenperprise for file-based interfaces between Salesforce and various ERP systems. It performs well, easy to install and update, you will have a good history for debugging purpose and it's reliable/stable. Overall it's recommended if you want to exchange data between Salesforce and other systems (ERP, databases, ...).
We have used the Astera software package to process existing data for one of the famous clients in Qatar. Several types of file e.g. EXCEL, PDF, WORD, TXT has been used as input to the Astera software. Once the report model and data flow diagram [have] been [designed] properly to analyze the non-structured data, we connected them to a SQL DB and also in an MS-Excel format for other software i.e. Aveva Engineering uses.
Pros
Designing report models and dataflow diagrams are very simple and understandable for users.
Various type of output could be generated from the Astera package.
Process thousands of files in a few second.
Very supportive team from Astera which are ready to help our users
Cons
We already communicated those issues which we believe could be useful for future development with your support team.
