A data integration software designed to connect Salesforce to SQL servers for BI, analytics, and reporting.

Product Overview

DBAmp, developed by CData Software, is a data integration software designed to provide seamless access to Salesforce data using SQL select statements. It allows users to make local copies of Salesforce data into SQL databases and supports bidirectional integration between SQL Server and Salesforce.

Users can leverage DBAmp for data integration using T-SQL for real-time lookup and load operations. The software is particularly useful for integrating Salesforce solutions with SQL DBA, enabling the modification and selection of objects without programming, and facilitating the generation and running of reports.

Pros

  • Links to Salesforce CRM databases
  • Built-in procedures for making database copies

Cons

  • Requires a custom quote for dedicated support

Target Market

Organizations that require robust integration between Salesforce CRM and SQL Server, particularly those needing to access, modify, and report on Salesforce data using SQL.

Video Overview

Features

  • 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
  • Use SQL to select and modify objects in Salesforce without programming
  • Run reports that join local tables with Salesforce
  • Write stored procedures for bi-directional integration from SQL Server to Salesforce
  • Replicate all your Salesforce data into SQL Server with one command
  • Bulk insert and update data from SQL Server tables into Salesforce
  • The world’s best Salesforce-to-SQL data connectivity
  • Real-time bidirectional data access
  • Unlimited world-class technical support and sandbox orgs included
  • Comprehensive help documentation
  • Updates, upgrades, new releases included

Pricing

DBAmp software as a service is subscription-based per user per year. A single server license with a one-year subscription is $4,999 and includes free updates, upgrades, and new releases. There is a FREE trial available.

Starting Price
$4,999 /user/year
Price Range Learn More
   $     $     $     $     $   
   $     $     $     $     $   

Product Overview

Related Products

  • Prophix
    A budgeting, planning & forecasting application designed by PROPHIX Software.
  • Microsoft Power BI
    A business intelligence reporting system.
  • Sisense
    A business analytics platform designed by Sisense.
  • Domo
    An optimization software that provides analytics and reporting.
  • ClicData
    A business intelligence platform for data warehousing and dashboards.

User Reviews of DBAmp

★★★★★
★★★★★
Submitted on May 20th, 2021 by Anonymous

DBAmp is one of the most useful tools I have found in my experience within the Salesforce.com ecosystem.

★★★★★
★★★★★
Submitted on May 19th, 2021 by Anonymous

I’ve used DBAmp for a few years now, and I don’t know what we would do without it. DBAmp makes accessing Salesforce data a breeze via SQL Server. Using DBAmp, I created stored procedures so that users within our organization could upload data on the fly from a Microsoft Access Database to Salesforce. This allowed us to easily sync data between SQL and Salesforce.

★★★★★
★★★★★
Submitted on May 18th, 2021 by Anonymous

We are currently working to transition many home-grown SQL Server-based applications to a SalesForce environment. In doing this we need to be able to sync our current data in almost real-time during many months of transition. DBAmp has worked perfectly to meet our needs. It simply sets up your SalesForce tables as a linked database in SQL Server.

★★★★★
★★★★★
Submitted on May 17th, 2021 by Anonymous

We have been a SF.com customer for 8 years now (Enterprise). My first purchase was dbAMP. I have been a dbAMP customer for 7 years. It is an ESSENTIAL PART of our organization. If you are using SQL in the enterprise, this is all you need. Sync back-end data. Reporting. Backups. dbAMP is the key to making SF.com work for you.