DBAmp
DBAmp
CData DBAmp seamlessly integrates Salesforce with Microsoft SQL Server, allowing you to manage data in real time by using familiar SQL syntax. By treating Salesforce objects as local tables, DBAmp enables you to query, replicate, and sync data without leaving the SQL Server environment.
Key Features
DBamp features include the following:
-
real-time access to Salesforce data in the cloud
-
stored procedures for controlling data
-
replication of Salesforce data for local use
-
seamless integration with Microsoft SQL Server Manager
-
bi-directional connectivity
-
optimized and efficient data connectivity
Common Tasks
DBAmp enables you to perform the following tasks:
-
select and modify Salesforce objects without writing custom code
-
run reports that join local SQL Server tables with Salesforce data
-
create stored procedures for bidirectional integration between SQL Server and Salesforce
-
replicate Salesforce data to SQL Server with a single command
-
perform bulk inserts and updates from SQL Server tables to Salesforce
For more information about features and specifications, see the CData DBAmp website.