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-25 of 45)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.
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...
March 29, 2023
Astera Centerprise for Every Enterprise
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.
March 15, 2023
Excellent Tool
We are using Astera Centerprise for automatically capturing data from PDF files and uploading to different databases. We are also using this for integration of different systems, data comparison, data validation, data extraction, and data transformation.
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.
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.
March 07, 2023
A back office gem whose power is in the simplicity
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.
February 07, 2023
Great Automated Tool for ETL
We use Astera Centerprise to import and export data in and out of application databases. We needed to manipulate the Data, upon ingesting or extraction, to be mapped and sometimes coded based on client data and mapping recommendations. There was also a need to programmatically alter the data upon extraction or ingestion.
January 23, 2023
Great to exchange data between Salesforce and other systems
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).
January 20, 2023
Astera Works for Us
We are using this vendor product in our daily test environment to extract data from Master database and based on business rules transform and load/export to test database
January 18, 2023
Fast and easy-to-manage ETL software
Score 10 out of 10
Vetted Review
Verified User
Our business intelligence group uses it to run our ETLs to pull data from over 10 source systems to our enterprise data warehouse. We also use it to generate data feeds to other systems from EDW.
January 16, 2023
Solid ETL solutions
We use Astera Centerprise for many various projects. Examples would include automated report generation, inventory alerts and scheduled email tasks. The main project we chose Astera Centerprise for was to sync what we hope will be a legacy database (SQL Anywhere by SAP) to a more web friendly database (MYSQL). Astera Centerprise currently did not have a database driver to connect to SQL Anywhere databases and we commissioned them to create that as part of our purchase agreement. We are still actively working through that process and troubleshooting any bugs that arise.
Score 9 out of 10
Vetted Review
Verified User
Historically we have built a number of integrations and small tasks manually through various languages and processes - having to track what we used, who built it, and what server it's running on. Astera Centerprise has been a breakthrough in this regard in a few ways. The first is that it required almost no training to use. I have given someone a 15-minute demo and left feeling confident they could do simple processes with it moving forward. The drag and drop GUI is generally very intuitive and while nothing is perfect, I rarely am fighting against it. The second is there is a wealth of data connections and functions to use. When I talk to peers about this product, I just ask how they are moving data - any data. Do you have an excel sheet that someone updates that need to join its data to a database and from an API and then write these as a CSV file that you import with a PowerShell command? This is literally a task I built in a few hours in Astera Centerprise. If I need to interact with disparate data, Astera Centerprise is the tool I move to first today.
March 23, 2022
Centerprise is great for automating workflows.
Score 7 out of 10
Vetted Review
Verified User
Use it to transform data to replace current manual processes. Also, use it to generate files from a data warehouse to send to vendors in proprietary formats.
November 09, 2021
Honest review of Centerprise after one year of use
Score 9 out of 10
Vetted Review
Verified User
Astera Centerprise is being used to map incoming pdf files that contain payroll data This tool allows us to automate certain payroll related processes. We are also re-writing SSIS jobs because it’s easier and faster when change request come in
November 08, 2021
Invest with Astera it will worth the price
Astera Centerprise is being used by different organizations here in our company. As a user or developer, it is really helps me to do a back-end program a lot easier without using of numerous codes, just a logic. It has a big impact on our business problems especially on data automation moving forward to the systems. By introducing this application as one of the solutions on the issues we experienced before regarding the labor and time, in manual entry, it gives wholly keyboarding process in order to create and finish a record, but with the help of Astera it can make the keyboarding in just a click and it can only takes a second or a minute. When it comes in data quality, due to manual it can cause human errors and inconsistent of data, instead of adapting this error, Astera can resolve this by using transformations which fitted to captures the needed data from the files with correct and accurate values. This system can be used efficiently in many organizations that involves gathering and processing of a large number of data.
November 08, 2021
Centerprise-10/10
Score 9 out of 10
Vetted Review
Verified User
We use it in part of our automation process to extract data from PDF's and deliver to our clients. It allows us to utilize time we would manually transcribe this data into excel sheets, saving time and money.
November 05, 2021
Astera Centerprise A Complete Data Integration Solution
Score 10 out of 10
Vetted Review
Verified User
We are currently re-writing our organization's ETL processes using Astera Centerprise. Most of those processes were written using VB.net. We are also creating some new ETL processes using Astera Centerprise. Most of my current work involves extracting claim data from databases for each State, format it as per State requirement and FTP the data. Once State receives the data, it sends us acknowledgement files. We then extract the data from the acknowledgement files and load it into our database. We are using Astera Centerprise for this process. There are other IT teams at our organization using Astera for many other company's ETL processes.
November 02, 2021
Astera Software
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.
November 01, 2021
Loving Cenerprise
Score 9 out of 10
Vetted Review
Verified User
We are currently using Centerprise to transform incoming files from vendors. The files are transformed and uploaded into our homegrown application. The files are dropped on a shared drive and then is picked up by Centerprise for processing.
October 20, 2021
Centerprise can transform your data management
Score 8 out of 10
Vetted Review
Verified User
We use it to transform data from legacy systems to newer systems. It addresses the problem of moving data across the enterprise. It also provides centralized management of the jobs created for the transportation of this data. We use the graphical interface to include the business in the design of solutions.
May 13, 2020
Solid choice for mid-sized organizations
Score 9 out of 10
Vetted Review
Verified User
We use it primarily for publishing to a data warehouse. Another production application creates and exchanges XML files with a federal regulatory agency, and as a 1-off, we are using Centerprise to validate an Oracle-to-SQLServer migration.
May 01, 2020
Astera Centerprise simplified our on-boarding process and was a great fit for our needs.
Astera Centerprise is being used by two teams that are responsible for onboarding data for new or existing customers. Those teams work in conjunction to ensure that proper workflows are set up to review and qualify the data prior to ingestion to our downstream systems. It has helped to centralize our data loading and transformation efforts, and provide visibility into data issues or patterns that we didn't have insight into before. Quality of data is key for our process, and we are TB scale, so performance and scalability were a factor as well.
May 01, 2020
Astera: ETL in the cloud
Score 9 out of 10
Vetted Review
Verified User
Astera streamlines our data integration process by doing all the work through a workflow. It enables our analysts to connect to virtually any data source and combine, transform, and map data, including statistical and predictive tasks.
April 30, 2020
Astera Review
Score 10 out of 10
Vetted Review
Verified User
It helps us in the massive storage of data and the resolution of intelligence problems of our business. It simplifies complex integrations: Apache Spark, Databricks, Qubole, AWS, Snowflake, Google Cloud Platform and NoSQL ..., and offers us integrated data quality to transform big data into reliable information. It provides us with clean and filtered data structures, which are exploited by the different end-user tools, increasing the quality and value of data, and allowing the optimization of our decisions.
April 30, 2020
Astera cloud, a successful choice for companies
Score 9 out of 10
Vetted Review
Verified User
We streamline the transfer of our business data in file formats, securely and at scale, from local and cloud sources (Amazon S3, Azure Blob and HDFS) to data warehouses and data warehouses. We extract and transfer massive volumes of changed data from transactional systems to relational databases, avoiding redundancies by leaving intact unchanged data and storing it in the cloud. We update our databases and host the data on the spot.
Score 9 out of 10
Vetted Review
Verified User
We currently use the Astera Centprise and ReportMiner products to create automated scheduled tasks that: retrieve, extract, and process financial information for reports and data integration with other enterprise-level systems. We specifically use the ReportMiner product to extract data from a PDF format for easier integration with other systems. The Centprise product allows our business analyst to easily manage and create a custom workflow and models to automate the complex data integration between systems regardless of file formats.