Astera Data Pipeline Builder (Centerprise) vs. Domo

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.

Incentivized

I believe that companies that record large amounts of data about their product, service employers KPIs, etc, can make the best out of Domo for reporting and data analysis, but if a company handles little data and is not recording this consistently, it will not be of much use.

• 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

• Exceptional Transform area of the platform - any/all raw data can be manipulated and combined to create datasources that are very useful for our departments.
• Visualization layer is clean and is very business presentable. Its simple but includes depth. Visuals can be created/used by all roles throughout our firm, its not limited to analysts.
• Ability to communicate and talk about insights in the data - the communication tool is exceptional. I can @ mention specific users to bring attention to a discovery. I can start a private chat. I can annotate and communicate what I am seeing. I love it.
• Mobile experience is excellent. When I am on the road i can actively monitor and engage with my team due to my Domo dashboard on my mobile device. Its amazing to run the business and not worry while away from the office.

Incentivized

• 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.

• Copying Reports - In Excel or Google Sheets, I like to make copies of similar reports and modify them as necessary for users. In Domo, makes copies of reports (called cards) but all copies are connected. So if you adjust the copy, it changes the original. This means a user has to recreate the report from scratch and then adjust it.
• Unforgiving SQL - Domo does allow users to write their own SQL codes, which is great. However, Domo's SQL code is pickier than the other SQL database I've used (Metabase).
• Text Alerts - Domo's alerts aren't always the smartest. Some of my dashboards are about the sales teams monthly performance and I get notified when there is a change of more than 20%. I always get notified at the start of the month that reports have changed from 'x' number to zero. This is expected because it's a monthly report and I hate getting texts about it. The only reason I don't term them off so I can be aware if something breaks in the middle of the month.

Incentivized

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.

Domo is a great up-and-coming product. There are many fantastic features that are extremely compelling to our end users, which makes Domo a great fit for our organization. As with many BI tools, there are items on the wish list that could make implementation, administration and usage easier, but I believe these will be addressed over time as the product matures and evolves. The overall concept and approach of this solution has definitely raised the bar in this area of expertise and I would like to see things advance in giving the enterprise tools that will make decision making easier and more robust in the future.

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.

The built-in user support and intuitive design of Domo makes it simple to learn and use. I find I can spend hours drilling deep, or else quickly gain an overview in just a few minutes. This is a great advantage since the flexibility fits well with the demands of my role. I enjoy using Domo since I know it will give me comparative data across almost every variable I might want to explore - I look forward to it!

Incentivized

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.

Incentivized

I think the performance for Astera is great when compare with other similar software.

Incentivized

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).

Incentivized

Pretty responsive. It took a while to get a response in selecting data points for our particular cards. Might have taken about a month? I am not sure if this was something on our end or Domo's end. But haven't had any other issues yet that required additional support from Domo.

Incentivized

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

It is a true web-based application so implementation is much easier and smoother compared to other non-web based BI solutions. Also, they offered consulting services during the implementation process, which was helpful. Also, they provided lots of on-demand training courses and videos, which I liked.

Incentivized

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.

At the end of the day, end-user adoption and taking the burden of IT to build reports was my goal. Demoing and testing many BI tools, DOMO is the one that allowed both to happen.

Incentivized

I was helping on purchase this product but I am not sure about the term and pricing for it. But based on what I understand that the term of the licenses are good.

Incentivized

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.

Incentivized

Centerprise is very easy to use and can transfer the data quickly

Incentivized

• 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.

• I mentioned a "previously un-analyzable" dataset that we were able to visualize in Domo - the result was business re-alignment for increased productivity, cost savings and ROI.
• It's tough to quantify the ability to provide insights that have been desired for years but not possible - we continue to amaze our executives and product managers with the analysis we can provide.

Incentivized