A data integration software designed to connect Salesforce to SQL servers for BI, analytics, and reporting.
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.
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.
DBAmp is one of the most useful tools I have found in my experience within the Salesforce.com ecosystem.
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.
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.
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.