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 Data Pipeline Builder (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
Product Demos
Feature Demonstration Data Integration Tool | Astera Data Pipeline Builder Centerprise)
YouTube
Features
Return to navigation
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
- FAQs
What is Astera Data Pipeline Builder (Centerprise)?
Astera Data Pipeline Builder (Centerprise ) is a data integration solution that includes data integration, data transformation, data quality, and data profiling capabilities in a code-free environment, and enable business users to handle data with minimal IT support. Using built-in connectors, users can read and write data to a wide range of file formats, databases, and applications and transform the data based on their specific use case. Powered by an enterprise-grade parallel processing engine, users can create automated data pipelines for reporting and analytics in minute. Users
can also execute ETL and ELT data pipelines manually, schedule them for automated reruns, or
orchestrate them as part of a larger data management process.
Astera Data Pipeline Builder (Centerprise) Features
Data Source Connection Features
- Supported: Connect to traditional data sources
- Supported: Connecto to Big Data and NoSQL
Data Transformations Features
- Supported: Simple transformations
- Supported: Complex transformations
Data Modeling Features
- Supported: Data model creation
- Supported: Metadata management
- Supported: Business rules and workflow
- Supported: Collaboration
- Supported: Testing and debugging
Data Governance Features
- Supported: Integration with data quality tools
- Supported: Integration with MDM tools
Additional Features
- Supported: Integrated development environment
- Supported: Data quality and profiling
- Supported: Job flow, scheduling, and execution
- Supported: Performance and scalability
- Supported: Code-free user interface
- Supported: Pushdown mode
- Supported: Dynamic load balancing
- Supported: Parallel processing engine
- Supported: Real-time job monitoring
- Supported: Management of access and control
Astera Data Pipeline Builder (Centerprise) Screenshots
Astera Data Pipeline Builder (Centerprise) Videos
Cutting Data Integration Processes from 2 Weeks to 5 Minutes | Customer Testimonial
Breaking down ELT
Code-free Automated Data Integration I Astera Data Pipeline Builder (Centerprise)
Astera Data Pipeline Builder (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 Data Pipeline Builder (Centerprise) Competitors
Astera Data Pipeline Builder (Centerprise) Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows |
| Mobile Application | No |
| Supported Languages | English |
Astera Data Pipeline Builder (Centerprise) Downloadables
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 Data Pipeline Builder (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 Data Pipeline Builder (Centerprise) are from Mid-sized Companies (51-1,000 employees).
Astera Data Pipeline Builder (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
February 14, 2024
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 source to another based on the business rules. We also use this to read the data from the source, transform the data and then feed our application.
- 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
100%
10.0
100%
10.0
60%
6.0
N/A
N/A
- 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.
We first tried Informatica and think it is suitable for our company. However, the per license price is way too expensive, as we need to support multiple users at the same time. When compared to Astera, we found Astera can do most of the stuff that Informatica does. That's why we picked Astera.
10
They are doing the software development and ETL processing
4
They have the strong SQL and Oracle knowledge. They know our data model inside out.
- 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
Yes
We replaced one of our internal made software because of that software was made as single thread application. Astera made our application runs much faster. We also used Astera to replace one of our old application.
- Cloud Solutions
- Scalability
- Integration with Other Systems
- Ease of Use
I think the product feature is the most important factor for our decision. We love how Astera is easy to use and fast to transfer data.
If I can do it again, other than how easy to use and how fast to transfer the data. I think I will also evaluation how easy to debug the issues when they occur.
- Implemented in-house
Yes
There are two major implementation. 1. We are using that as the backend for the webservice. There was validation and data loading phases for it. 2. Complete ETL process. We did the extract and transform together as one phase and load for the second.
Change management was minimal
- 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
This is very easy to learn. But I will suggest Astera to provide some training for others as I need to provide the training to my co-workers for Astera right now.
Don't try to use the multi-thread loading for the foreign keys enabled tables
Yes - we have customized the interface extensively
We need to allow our clients to customize all there configuration based on our data model. Our development team created the application for it. They are only calling Astera api to do the job.
No - the product does not support adding custom code
no
I believe our company purchase that. I think we need that because we always need to have the fastest response to resolve our client issues.
Yes
Yes, they were resolved quick and I am satisfying for them.
There was our client security issue. I submitted the support ticket and request the same day meeting with our client. I got the response within an hour and have the meeting with our client to resolve the issue. This was quick turnaround and very helpful.
- Data transfer
- Data validation
- I think xml data transfer is a bit difficult
- SQL server
- Oracle
- Excel
- Xml
- Webservice
SQL, Oracle and Excel are very easy to use and we are using them in most of our products. We are using the webservice call feature for one of our application. It is easy to use as well. However, I found it is difficult to debug when there is any issue. XML is the most difficult one to use. We start to use that at the beginning and need to swap that out to use sql command instead.
- We are planning to use the Azure connector
Yes, we found couple of vendors provide this.
- File import/export
- Single Signon
- API (e.g. SOAP or REST)
- ETL tools
no
Learn what Astera can do first as I am still trying to explore what I can do with it.
I am not sure about this
No not at this moment
Yes
When we upgrade from Astera 7 to Astera 8, it took a long time as there are a lot of changes in both dataflow and workflow. We are planning to upgrade to Astera 10 in few months, I hope it is easier this time.
- Bugs fixes
- License server using port 443
- Able to connect to Azure database
- Better performance
- Less bug
No
No