The little tool that turn Salesforce into a relational database
June 02, 2022
The little tool that turn Salesforce into a relational database
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with CData DBAmp
DBAmp allows easy access to Salesforce CRM data through Linked Servers in SQL Server. DBAmp has built-in procedures that allow you to take and refresh snapshots of your data into a SQL database. We used SQL to build out our segmentation logic and used DBAmp to bring in the raw data for those calculations. We then used DBAmp to write the data back into Salesforce CRM on a nightly basis. We also used the data to build out our constituent data warehouse.
- 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.
- 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.
- 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.
Do you think CData DBAmp delivers good value for the price?
Yes
Are you happy with CData DBAmp's feature set?
Yes
Did CData DBAmp live up to sales and marketing promises?
Yes
Did implementation of CData DBAmp go as expected?
Yes
Would you buy CData DBAmp again?
Yes