Likelihood to Recommend I have only been using Astera Centerprise for about 6 months and I am still learning the ins and out of it. A scenario where it seems to do well is in generating reports from SQL queries that we already had and no longer have to run the reports manually. The SQL Query Source object has been the most useful tool for me thus far. I have yet to fully stress test the server side of Astera Centerprise, but currently there have been some version updates that required me to re-set up all the scheduled jobs that we have. We only have 8 jobs thus far but have plans to expand this into the hundreds and those same updates would require exponential amounts of work.
Read full review We just need to refresh our data once a day for our unique use case, which allows the complete online system to run on extracts. For us, this is critical because our daylight hours are spent focusing on new updates and implementations rather than worrying about excessive database traffic (which would be required with a direct connection to the online system). The process of importing extracts is straightforward and sturdy enough to handle massive amounts of data.
Read full review Pros 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 Read full review Tableau Online is completely cloud based and that's why the reports and dashboards are accessible even on the go. One doesn't always need to access the office laptop to access the reports. The visualizations are interactive and one can quickly change the level at which they want to view the information. For example, one person might be more interested in looking at the country level performances rather than client level. This is intuitive and one doesn't need to create multiple reports for the same. The feature to ask questions in plain vanilla English language is great and helpful. For quick adhoc fact checks one can simply type what they are looking for and the Natural Language Programming algorithms under the hood parse the query, interpret it and then fetch the results accordingly in a visual form. Read full review Cons 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. Read full review Can be a steep learning curve for new users Modeling and building algorithms aren't always intuitive and take some testing/retesting to ensure it's working as it should Inability to integrate easily with our HRIS platform. Reports are pulled from HRIS at various intervals and uploaded into Tableau Read full review Likelihood to Renew We've been using Astera Centerprise application for the last 6 years and we've already added EDI connect to it. Both applications are working really well for our enterprise needs so far with no issues, so we'll continue renewing the licenses.
Read full review Usability Centerprise is highly usable; however the version we are currently using could be a little more intuitive in some areas though by no means unworkable. I think some of the issues we have have been addressed and solved in the latest version.
Read full review From an end user perspective Tableau Online is overall very easy to navigate once you get used to it, my only complaint is that when expanding or contracting a graph, the "plus" and "minus" on the bottom left is sometimes hidden, and should always be visible. From a builder perspective, it can take some getting used to but the sheer depth of customization makes it all worthwhile.
Read full review Reliability and Availability In most cases Astera is stable. However, our client experiences the error from time to time. Mostly they are related to cdc file and ServerAdminConfig.xml file.
Read full review Performance I think the performance for Astera is great when compare with other similar software.
Read full review Support Rating Support is great! No matter if you need technical assistance or you have general questions about the tool - the support is very responsive and provides solutions quickly. They are available via various channels, which makes it very convenient to get in touch with them (Support portal, direct email contact, LinkedIn).
Read full review In times where the system is down, support has always been quick to notify and keep us apprised of the latest developments. It's crucial for our system to always be available, but when emergencies have arisen, I don't recall a time where the Tableau Online Support hasn't been able to address our concerns in a timely manner.
Read full review Implementation Rating Astera support provided us implementation/installation tutorial and we were able to perform all the activities. Also one of the support was there to shadow us to make sure the process was smooth with no issues
Read full review Alternatives Considered We looked at continuing to use SSIS as an alternative. Although we own SSIS as part of our SQL licensing, we found that it takes a much higher skill level to create solutions. It also does not have the ability to parse unstructured data the way that Centerprise Data Integrator can. We also looked at
Datawatch Monarch as a possibility but found it over-all to be cost-prohibitive. We also looked at a cheaper alternative called SimX but did not have a strong confidence in the product as we evaluated it. We landed on Centerprise Data Integrator as it met all of our business requirements and we know we could leverage it for many uses across our enterprise.
Read full review Googles dashboard suite is very user-friendly and anyone can edit and make changes with very little knowledge or practice. But nothing I’ve worked with compares to the customization and multi streams of data in a user-friendly package like tableau does. It’s a really cool piece of software and I would choose that again.
Read full review Scalability I think Astera can do multiple things. However, we are not sure what it can do. We only know the basic features. If they can give us some kind of training, then we maybe able to benefit for it. We are planning to use their Azure connection in the future. If they can provide the training for it, it will be wonderful.
Read full review Return on Investment It is tough to say on how Centerprise would have helped us with ROI. Unfortunately our project (after 3 years) was scrapped (put on hold) due to the impromptu purchase of another Crop Insurance company. But with that, Centerprise was huge in getting our warehouse loaded for our BI Team to make important decisions about our policies. Read full review When we release new products, we are now able to quickly see data and toggle between current periods and previous to see performance Generating new reports requires less IT time to build Data can be shared across many different device types We now have integration where our customers can extract data from our software more easily-this was a big ask from our customers Read full review ScreenShots Astera Centerprise Screenshots