Skip to main content
TrustRadius
CData DBAmp

CData DBAmp

Overview

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 more
Recent Reviews
Read all reviews
Return to navigation

Pricing

View all pricing

Single 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
Return to navigation

Product 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

Screenshot of Screenshot of

CData DBAmp Video

This video offers a guide for Installing DB Amp and demonstrates how to connect Salesforce with SQL Server

CData DBAmp Competitors

CData DBAmp Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, Mac
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(1)

Reviews

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
Beth Follenweider | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
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.
Data Source Connection
N/A
N/A
Data Transformations
N/A
N/A
Data Modeling
N/A
N/A
Data Governance
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.
Return to navigation