The little tool that turn Salesforce into a relational database
DBAmp allows easy access to Salesforce CRM data through Linked Servers in SQL Server. DBAmp has built-in procedures that allow you to take …
CData DBAmp
CData DBAmp
CData DBAmp
Starting at $2,495 per user
View PricingOverview
What is CData DBAmp?
DBAmp is a Salesforce integration solution for any SQL DBA. With DBAmp, users can access Salesforce data in real-time using standard SQL. For many organizations, SQL Server plays a critical role in BI and operational reporting. Using DBAmp, users can...
Read moreRecent Reviews
Reviewer Pros & Cons
View all pros & cons
Pricing
View all pricingSingle Server License One-year Subscription
$2,495
On Premise
per user
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://www.cdata.com/dbamp/#purchase
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Product Details
- About
- Competitors
- Tech Details
What is CData DBAmp?
DBAmp is a Salesforce integration solution for any SQL DBA. With DBAmp, users can access Salesforce data in real-time using standard SQL. For many organizations, SQL Server plays a critical role in BI and operational reporting. Using DBAmp, users can extend the same SQL Server integrations they've built for BI, analytics, and reporting to Salesforce data.
Enable Salesforce BI, analytics, & reporting from any tool through SQL Server
Connect data from internal systems with Salesforce in real-time
Build reports that combine live data across SQL Server and Salesforce to deliver up-to-the-minute insights
Users can build integrations using T-SQL to perform real-time lookup and load operations. Access Salesforce data in real-time with SQL Select statements or make local copies of Salesforce data into a local SQL database.
With DBAmp, Salesforce data is accessible directly from SQL Server through a highly optimized SQL linked-server connection. Leverage universal support for SQL tools, real-time linked-server connectivity, and Salesforce APIs, including Bulk API operations. Back up Salesforce data with a single command and keep backups in sync with DBAmp's incremental refresh.
CData DBAmp Features
- Supported: Salesforce-to-SQL data connectivity
- Supported: Real-time bidirectional data access
- Supported: Unlimited technical support
- Supported: Unlimited sandbox orgs
- Supported: Help documentation
- Supported: Updates, upgrades, new releases
CData DBAmp Screenshots
CData DBAmp Video
This video offers a guide for Installing DB Amp and demonstrates how to connect Salesforce with SQL Server
CData DBAmp Technical Details
| Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Windows, Linux, Mac |
| Mobile Application | No |
Comparisons
View all alternativesCompare with
Reviews and Ratings
(1)
Reviews
(1-1 of 1)- Popular Filters
Companies can't remove reviews or game the system. Here's why
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.
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
- 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.