Astera Data Pipeline Builder (Centerprise) vs. DemandTools

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

DemandTools is perfect for any system that constantly adds new records to its database. For example, in higher education, we are constantly purchasing search names from various vendors and DemandTools allows us to make sure we are not doubling up on the same records. It saves us money in the long run as we are not mailing out multiple copies of our brochures to the same person.

• 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

• PowerGrid can review and make the updates simultaneously.
• Single Table Dedupe makes merg[ing] the records easy and can make updates at the same time.
• BulkBackup [is] just one click, majority data got updated.
• Scenarios save a lot of time for similar working load.

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.

• I wish I could make changes to my existing scenarios using save rather than having to create a whole new scenario. Maybe you can, I just haven't been able to.
• Some features aren't user intuitive and it takes a while to learn.

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.

It's a great product. The only thing that holds us back is it was frustrating working with their sales team. We also don't like that when Validity purchased DemandTools they immediately started charging us quite a bit while it had been free for non-profit users when CRMFusion owned it. They also don't let you buy it for just 1 or 2 seats, you have to pay, I believe, in batches of 100 seats.

Incentivized

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.

Allows for control in uploading lists, saved processes for checking duplicate records.

Allows for backup files and quick reverts if something goes wrong.

Extends reporting when Salesforce.com cannot support specific pieces of info being put together in a report.

Automated processes for set and forget hygiene tasks

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

There has not been a time since I started 9 months ago that I've encountered any kind of downtime.

Incentivized

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

Incentivized

DemandTools is a bit clunky and slow at times

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

Support can be slow so do not expect quick turn for urgent issues.
Help for specific queries not not there. Product tech support is offered. It would be great if query support, even if paid, was offered
The training webinars help with the basics but not much if you need advanced functionality.

The trainings are free live webinars that give you a solid base for getting started with the program. The only weakness is they don't have any advanced classes.

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

I had just started using Salesforce about 3 months before I did the implementation myself, and it was easy to do just following their step-by-step instructions.

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.

Though RingLead has much more to offer in terms of automation (and it is in Salesforce rather than a separate program), DemandTools still has our heart. DemandTools is very cost-friendly and we were able to increase the value of DemandTools by programming in additional saved scenarios. I decreased admin time in the DemandTools suite by approximately 25% after implementing saved scenarios for every reoccurring update or list upload.

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

It's done everything we've needed it to do.

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.

• It is a tremendous time saver. It does things Salesforce doesn't even have the capability to do. Tasks that would take hours to manually complete.
• We can process a tremendous amount of data daily through one person, vs. weeks for the data to be cleaned, reviewed, routed and input.
• Saves on headcount by allowing a dedicated user to set up batches and jobs for other teams to ensure their data integrity.
• The return on investment isn't easily quantifiable but it is FELT in our department.

Incentivized