CData Software Acquires forceAmp | FAQ

We are excited to announce the acquisition of forceAmp, a popular solutions provider for Salesforce-SQL Server integration. What follows is a brief FAQ designed to provide some answers to questions you may have about the acquisition. If you have additional questions that are not covered in this list, please contact us at, and a member of our sales team will assist you.

 Who is CData Software?

CData Software ( is a leading provider of data access and connectivity. Our standards-based solutions streamline data access and insulate customers from the complexities of integration. Leading applications across SaaS, data management, integration, analytics & BI, data science, data testing, AI & machine learning, and data governance depend on CData to solve their data access, data fragmentation, and data integration challenges.

Ultimately, at CData we simplify connectivity between all of the applications and data sources that power business operations, making it easier to unlock the strategic value of your data.

 What is forceAmp?

forceAmp ( is a connectivity company that specializes in integration between Salesforce and SQL Server. Their flagship product, DBAmp, is a popular solution for real-time integration. DBAmp creates a real-time, bi-directional link between SQL Server and Salesforce that allows customers to access Salesforce data directly from SQL Server. A long-time Salesforce partner solution, DBAmp is trusted by hundreds of organizations to power back-office data movement and analytics processes.

 Why Did CData Acquire forceAmp?

The integration technologies from forceAmp are strongly aligned with those of CData. Both companies share a common technical vision: a SQL-centric approach to data connectivity. The acquisition of forceAmp further extends CData's presence in the Salesforce ecosystem and provides additional technical flexibility in data management and integration.

 How and Where is DBAmp used?

Organizations leverage DBAmp's simple data connectivity to support a wide variety of enterprise data scenarios, such as running reports on Salesforce data, writing complex stored procedures for two-way integrations, replicating Salesforce data in bulk to SQL Server with a single stored SSIS procedure, and more. Common use cases for DBAmp include:

  • Replication from Salesforce to SQL Server to support BI, analytics and reporting
  • Replication to SQL Server to reduce customer license requirements for Salesforce (data stored and accessed locally to support infrequent users)
  • Data Synchronization - updates made to records in SQL Server pushed to Salesforce.

 What is the Future of forceAmp & DBAmp?

CData is committed to forceAmp technologies and the critical role they play in CRM integration. As such, forceAmp will continue development as a separate brand extension of CData.

The forceAmp team, including forceAmp Founder Bill Emerson, will join CData Software and continue to maintain and extend forceAmp's data connectivity and integration technologies. By joining forces with CData Software, forceAmp will become part of the world's most comprehensive suite of standards-based integration solutions. For forceAmp customers, the CData acquisition brings access to enhanced support services and greater integration possibilities.

 How Does This Acquisition Benefit DBAmp Customers?

For forceAmp customers, the CData acquisition brings access to all new support services and an enhanced roadmap of integration possibilities. With the growing industry shift to cloud, multi-cloud, and hybrid-cloud, CData will provide forceAmp customers with a straightforward migration path to leverage cloud infrastructure for data warehousing and data pipeline integration.

In addition, CData technologies expand integration for forceAmp users beyond the Salesforce ecosystem to integration with a broad range of CRM systems, ERPs, marketing automation tools, accounting platforms, and other applications and databases.

 How Will This Affect Licensing?

Rest assured that forceAmp products like DBAmp will continue to retain premium value pricing for years to come. At the same time, we plan to release all new technology and subscription bundles that dramatically extend the capabilities for Salesforce customers, providing ETL and live integration with dozens of new data sources and warehousing destinations.

 How do CData's Products Align with DBAmp?

DBAmp works through the Linked Server capability of Microsoft SQL Server. DBAmp is installed on SQL Server, and customers can access Salesforce through SQL scripts or through stored procedures kept on SQL Server. The functionality is similar to the capability available across CData ODBC Drivers via the SQL Gateway technology ( DBAmp customers should feel right at home using CData ODBC Drivers to expand their SQL Server data connectivity.

 As a DBAmp Customer, What Other CData Products Would be Helpful?

At CData, we offer all types of data connectivity and integration solutions. The CData products that will be of interest to you will be largely dependent on how you use DBAmp today, and the connectivity needs of our organization. The following use-cases outline the most common opportunities:

  • Do you currently connect with Salesforce from SQL Server using SQL queries and scripts?
    Take a look at the CData ODBC Drivers with embedded SQL Gateway capabilities. Our ODBC Drivers will provide seamless data connectivity to more than 250 enterprise SaaS, NoSQL, and Big Data sources, in the same way that you connect with Salesforce today.

  • Are you currently replicating data to SQL Server but interested in migration to a new database or cloud data warehouse like Snowflake, Redshift, Azure or BigQuery?
    Take a look at CData Sync. Sync is an easy-to-use tool that replicates data from Salesforce, as well as more than 250 other data sources, with any database or data warehouse.
    • Automated continuous data replication between Salesforce and any database or data warehouse.
    • Run data replication on-premise or in the cloud via AWS, Azure, and Oracle OCI.
    • Build data pipelines that aggregate data from other data sources.
    • Straightforward data transformation capabilities can alter data in flight to conform to destination schema.
  • Are you currently building integrations with DBAmp and SQL Server Integration Services (SSIS)?
    The CData SSIS Components include everything needed to extend SSIS packages with universal access to hundreds of different applications, services, databases, and APIs.
    • Use data flow components like 'lookup' as part of workflow processes.
    • Move SSIS workflow to the cloud (ADF).
    • Gain bi-directional data connectivity with 250+ data sources and destinations, including Salesforce and SQL Server.