Adverity vs. CData DBAmp

If you're a marketing organization that wants to own your data architecture, get away from hours of manual excel work, and build a flexible and scalable BI practice for yourself and your clients, Adverity is your solution. Especially if you don't have a dedicated analytics team or current database solution. If you have access to a wide variety of API's and a fully staffed team to custom develop new connectors in under 30 days for no incremental cost, you're probably best in-housing

Incentivized

Well suited as an inexpensive tool as "middleware" between your on-prem or hosted SQL Server. Not sure how well it will translate to cloud-based SQL as a platform (Azure SQL) as it relies on linked servers. This tool only applies to Salesforce CRM - not Marketing Cloud. For writing back to Salesforce we did run into Salesforce resource limitations when extensive triggers existed on the objects.

Incentivized

• User-friendly report setup and ingestion
• Easy integration with multiple data endpoints, making it easy for users to drive value
• Incredible customer support, allowing users (regardless of technical background) to act like power-users

Incentivized

• Connects & Links to Salesforce CRM databases - including custom objects.
• Built in procedures to create copies of the database on SQL Server.
• Built in procedures to Add, Update, and Delete data within Salesforce CRM.
• Great Technical Support.

Incentivized

• I think it would have been more user friendly if there was more labelling capabilities, so that when you are sharing the dashboard they would explain what the data is - rather than depending on someone knowing how to use the dashboards or being there to explain it.
• Our teams found that some of the scheduling functionality could be a little big buggy, so this was something that needed extra care and attention, so therefore may be an area that needs to be improved (unless it was just our account and usage).

Incentivized

• Because it uses Linked Servers, not sure how this will work in Azure SQL.
• Replicated tables are based on user security - this means you have to pay for a license to set this up.
• There is no built-in function to skip tables or fields on secured tables. This has to be done on the CRM side for fields and we built a function to skip tables in the replication logic.

Incentivized

Previously I had never really used a tool like this, only using software such as GA to look at any insights and review performance. So I think that the combined view of having all of the data sets (Which in my role I wouldn't always particularly have access to), was really useful. As an individual who was optimising our clients websites it meant that I was really able to prioritise what was important, but also have a great view of absolutely all activity that was happening

Incentivized

• This tool has allowed us to be able to see areas for opportunities, when all of the data has been combined
• We were also able to better prioritise actions and where to focus our attention, when we had one view where all of the data was together. This allowed us to deliver better results for our clients, and also have a clearer roadmap of activity

Incentivized

• Enabled automated marketing segments which enabled automated email series.
• Helped us solicit donations for the right amount at the right time.
• Helped us take on new marketing and fundraising campaigns without adding staff.

Incentivized